Pesticide-Summary Table
Back to Well Inventory Database
Pesticide-Summary Table North interface
Pesticide-Summary Table Central interface
Pesticide-Summary Table South interface
These three regional tables provide one record for each pesticide or pesticide degradate for which the well has been tested. Summary counts apply only to tests for the chemical and include: the number of times the well has been tested, the concentration range, sampling date range, and the agencies doing the sampling. The Total_CHEM_TESTED and Total_CHEM_DET totals apply to all chemicals tested in the well.
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. |
DEPTH | Reported well depth. Not reported for most wells. |
WELLTYPE | Description of well type. |
NCHEM | DPR's numerical code for the pesticide. |
CHEM_NAME | Name of the pesticide. |
# SAMPLES | Number of records reported for the well. Each analysis is a new record. |
# POS SAMP | Number of records reporting a pesticide detection. |
MIN(CONC) | Minimum concentration in parts-per-billion (ppb) reported above zero. "–" indicates no detections were reported. |
MAX(CONC) | Maximum concentration (ppb) reported. "–" indicates no detections were reported. |
MIN(RL) | Minimum Reporting Limit (ppb) (value below which a detection is not considered reliable for a specific analysis) |
MAX(RL) | Maximum Reporting Limit (ppb)(value below which a detection is not considered reliable for a specific analysis) |
MIN(SDATE) | Earliest sample date in the WIDB for the well. |
MAX(SDATE) | Last sample date in the WIDB for the well. |
Total_CHEM_TESTED | The total number unique pesticides tested in the well. |
Total_CHEM_DET | The total number of unique pesticides detected in the well. |
AGENCIES_REPORTING, PDF | The agencies that have tested the well for the selected analyte. |
REGION | The Pesticide-Summary-Table Region where the well data by pesticide can be found. |
DNI | Indicates a record containing a likely Data Error. Normally blank. |
EXCL_Reason | Letter Code for the reason a Data Error value was excluded. |
All CHEMS Detected in this WELL | List of pesticides reported in the well. |
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