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 as downloadable comma delimited (.csv) files. All the chemical analysis results from DPR's SURF as of May 2024 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, CSV

Accessing the Data

SURF in CSV file format

SURF is currently only 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 (SURF water 2024) and one with all available sediment data (SURF sediment 2024). The files will automatically open with the proper formatting in newer versions of spreadsheet programs. Note that the surface water data file contains over one million 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, 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 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: (916) 603-7830
E-mail: Xuyang.Zhang@cdpr.ca.gov