About this Dataset

Environmental Monitoring Program: Discrete Water Quality Data

The Interagency Ecological Program’s (IEP) Environmental Monitoring Program (EMP) was initiated in compliance with the Water Right Decision D-1379 (now mandated by Water Right Decision D-1641) and has monitored discrete water quality and nutrients in the upper San Francisco Estuary since 1975. The objectives of the EMP are to obtain consistent and accurate monthly data at established monitoring stations, provide and document information necessary to achieve compliance with salinity, flow, and dissolved oxygen standards, and to report this information for the purpose of management and conservation of the upper San Francisco Estuary. While the EMP also collects biological data, this dataset only includes the discrete water quality and nutrient data collected by the EMP from 1975-2021. Links to other EMP datasets can be found here.

Data is also accessible via the Environmental Data Initiative.
Organization: State of California
Last updated: 2025-07-23T19:55:06.710598
Tags: california-department-of-water-resources, monitoring, sacramento-san-joquin-delta, water-quality

Tables

EMP DWQ 1975-2023

@usgov.ca_gov_environmental_monitoring_program_discrete_water_quality.emp_dwq_1975_2023

782.79 kB
17,677 rows
71 columns

CREATE TABLE emp_dwq_1975_2023 (
  "station" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "sampledescription" VARCHAR,
  "flag" VARCHAR,
  "flagdescription" VARCHAR,
  "fieldnotes" VARCHAR,
  "weather" VARCHAR,
  "airtemp" DOUBLE,
  "windvelocity" DOUBLE,
  "winddirection" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "chla_sign" VARCHAR,
  "chla" DOUBLE,
  "pheoa_sign" VARCHAR,
  "pheoa" DOUBLE,
  "totalkalinity_sign" VARCHAR,
  "totalkalinity" DOUBLE,
  "totammonia_sign" VARCHAR,
  "totammonia" DOUBLE,
  "dissammonia_sign" VARCHAR,
  "dissammonia" DOUBLE,
  "dissbromide_sign" VARCHAR,
  "dissbromide" DOUBLE,
  "disscalcium_sign" VARCHAR,
  "disscalcium" DOUBLE,
  "totchloride_sign" VARCHAR,
  "totchloride" DOUBLE,
  "disschloride_sign" VARCHAR,
  "disschloride" DOUBLE,
  "dissnitratenitrite_sign" VARCHAR,
  "dissnitratenitrite" DOUBLE,
  "doc_sign" VARCHAR,
  "doc" DOUBLE,
  "toc_sign" VARCHAR,
  "toc" DOUBLE,
  "don_sign" VARCHAR,
  "don" DOUBLE,
  "ton_sign" VARCHAR,
  "ton" DOUBLE,
  "dissorthophos_sign" VARCHAR,
  "dissorthophos" DOUBLE,
  "totphos_sign" VARCHAR,
  "totphos" DOUBLE,
  "disssilica_sign" VARCHAR,
  "disssilica" DOUBLE,
  "tds_sign" VARCHAR,
  "tds" DOUBLE,
  "tss_sign" VARCHAR,
  "tss" DOUBLE,
  "vss_sign" VARCHAR,
  "vss" DOUBLE,
  "tkn_sign" VARCHAR,
  "tkn" DOUBLE,
  "waterdepth" DOUBLE,
  "secchi" DOUBLE,
  "microcystis" DOUBLE,
  "lightextinction" DOUBLE,
  "spcndsurface" DOUBLE,
  "dosurface" DOUBLE,
  "dopercentsurface" DOUBLE,
  "watertempsurface" DOUBLE,
  "turbiditysurface" DOUBLE,
  "phsurface" DOUBLE,
  "spcndbottom" DOUBLE,
  "dobottom" DOUBLE,
  "dopercentbottom" DOUBLE,
  "watertempbottom" DOUBLE,
  "turbiditybottom" DOUBLE,
  "phbottom" DOUBLE
);

EMP DWQ FlagCodes

@usgov.ca_gov_environmental_monitoring_program_discrete_water_quality.emp_dwq_flagcodes

2.59 kB
5 rows
2 columns

CREATE TABLE emp_dwq_flagcodes (
  "flag_code" BIGINT,
  "description" VARCHAR
);

EMP DWQ Stations 1975-2023

@usgov.ca_gov_environmental_monitoring_program_discrete_water_quality.emp_dwq_stations_1975_2023

10.11 kB
48 rows
10 columns

CREATE TABLE emp_dwq_stations_1975_2023 (
  "station" VARCHAR,
  "stationid" VARCHAR,
  "location" VARCHAR,
  "stationtype" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "status" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" VARCHAR,
  "stationpaused" BOOLEAN
);