Detection-Detail Table
Back to Well Inventory Database
Detection-Detail Table interface
This table lists the details for each reported detection by well and pesticide. Each detection will have a code for the status DPR has assigned to the detection and any memos or studies DPR has done in response to the report. It also lists all pesticides that have been reported in the well and the number of different samples that have shown pesticide residues.
Data Field | Definition |
---|---|
RandLAT,RandLONG | Assigned latitude/longitude based on the CMTRS. Not the actual well location. |
CMTRS | County-Township-Range-Section where the well is located. This system is based on the Public Lands Survey System. |
COUNTY_NAME | Name of the California county where the well is located. |
WELL_KEY | Unique identifying number assigned by DPR to each well. |
NCHEM | DPR's numerical code for the pesticide. |
CHEM_NAME | Name of the pesticide. |
CONC | The reported concentration in parts-per-billion (ppb). |
RL | The Reporting Limit (ppb) listed for the test in ppb. |
WELL_TYPE | Description of well type. |
DEPTH | Reported well depth. Not reported for most wells. |
DTW | Measured depth-to- water in feet. Not reported for most wells. |
SDATE | Date sample was taken. |
RPT_YR | The year the data was added to the WIDB. |
STATUS, PDF (59 kb) | Code indicating whether the report is confirmed by a second test or verified by an approved unequivocal analysis method. |
NorP, PDF (59 kb) | Code indicating if the source of a detection is under investigation (I), from non-point source pesticide use (N) or from a point source individual well contamination (P). |
AGENCY | Number Code for the agency doing the well sampling. |
AGENCY_NAME | Agency reporting the well sampling. |
APFILE | Study name for which the sampling was done. Usually assigned by DPR. |
DPR_STAT, PDF (86 kb) | Status of the detection as evaluated by DPR. |
In GWPA? | Does the detection fall within an existing Groundwater Protection Area. |
DPR_Response | The field study or memo done by DPR in response to the detection. |
Unique_CHEMS_Detected | Number of pesticides reported detected in the well. |
Total CHEMS_Detected | Number of times pesticides have been reported in the well. |
All CHEMS Detected in this WELL | List of pesticides reported in the well. |
DNI | Indicates a record containing a likely Data Error. Normally blank. |
ADD_YEAR | Year the detection was added to this table. |
For content questions, contact:
Craig Nordmark
1001 I Street, P.O. Box 4015
Sacramento, CA 95812-4015
Phone: (916) 445-5393
E-mail: Craig.Nordmark@cdpr.ca.gov