Pesticide-Summary Table

Back to Well Inventory Database


Pesticide-Summary Table North interface
Pesticide-Summary Table Central interface
Pesticide-Summary Table South interface

Map of the different regions


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 and definitions
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