Surface Water Database (SURF)
Access to the Data
Pesticide monitoring results from the Department of Pesticide Regulation's (DPR) Surface Water Database (SURF) are available through on-line query/export or as downloadable comma delimited (.csv) files. All the chemical analysis results from DPR's SURF as of December 31, 2019 are available. SURF data presented here contain a selected set of data fields from DPR's internal database. For more detailed information such as analytical method, sampling method and the lab conducting the analysis, please submit an inquiry to Xuyang.Zhang@cdpr.ca.gov.
Information on DPR's Surface Water Database
Accessing the Data
NOTE: Google will no longer support Google Fusion Tables on December 3, 2019. Google Fusion Tables and all embedded visualizations – maps, charts, tables and cards - will become unavailable on that date. DPR is currently working to provide a suitable alternative with similar functionality as the Google Fusion Tables interface. During this time, result from SURF will continue to be available for download as comma-delimited files for import into spreadsheet and database programs.
Two files are available: one with all available surface water data (water_December2019) and one with all available sediment data (sed_December2019). The files will automatically open with the proper formatting in newer versions of spreadsheet programs. Note that the surface water data file contains over 760,000 records and will not import properly into older versions of spreadsheet programs which are limited to a maximum of 65,000 records.
A map file of all the surface water monitoring sites in the Database can be downloaded. The .kmz file can be opened in the Google Earth free program by Google, Inc. If you do not have Google Earth in your computer, you can download it.
Once loaded into Google Earth, zoom to your area of interest. Clicking on a site point will give a pop-up box containing information about the site, including the DPR site code, the county where the site is located, a brief description of the site, as well as the latitude and longitude of the sampling site.
For DPR monitoring sites, more information regarding the sampling locations are available. You can download a table of all DPR sampling sites.
For content questions, contact:
Xuyang Zhang, Ph.D.
1001 I Street, P.O. Box 4015
Sacramento, CA 95812-4015
Phone: (650) 493-1082