Surface Water Database (SURF)
Access to the Data

Back to Surface Water Database (SURF)

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, 2018 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

General Description of the Database

Metadata for studies in the Database (102 kb)

Accessing the Data

The data can be queried on-line. Query results can be viewed on-line, or exported and saved to your own computer.

Note: Google Fusion Table will not be available after December 3, 2019. DPR is working on an alternative online platform for publishing SURF. If the application does not work for you, you may download the data directly as described in the section below.

The data can be downloaded as comma-delimited files for import into spreadsheet and database programs. Two files are available: one with all available surface water data (water_December2018) and one with all available sediment data (sed_December2018). 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.

  • water_December2018 (135 mb)
  • sed_December2018 (26.2 mb)
  • 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, the number of water column and sediment records in the database for the site and the maximum concentrations of water and sediment samples taken at the site. The latitude and longitude are also provided.


For content questions, contact:
Xuyang Zhang, Ph.D.
1001 I Street, P.O. Box 4015
Sacramento, CA 95812-4015
Phone: (650) 493-1082
E-mail: Xuyang.Zhang@cdpr.ca.gov