Dataset: 2019 California Water Quality Status Report

About this Dataset

2019 California Water Quality Status Report

The California Water Quality Status Report is an annual data-driven snapshot of the Water Board’s water quality and ecosystem data. This third edition of the report is organized around the watershed from land to sea. Each theme-specific story includes a brief background, a data analysis summary, an overview of management actions, and access to the raw data.

View the 2019 California Water Quality Status Report.

Data for Fig. 2 1,2,3,-Trichloropropane is provided as a download below. The data can also be downloaded from the State Water Resources Control Board (SWRCB) website.
Data for Fig. 6 Statewide Water Bodies Toxicity can be downloaded from the California Open Data Portal.
Sediment load data for Fig. 7 Elk River is provided as a download below. Landslide susceptibility data is available on the California Geological Survey GIS server.
Data for Fig. 8 Central Valley Water Board E. coli Monitoring Results can be downloaded from Google Sheets.
Data for Fig. 9 Harmful Algal Bloom Incident Reports Map can be downloaded from the California Open Data Portal.
Data for Fig. 19 Industrial Stormwater Assessment Tool can be downloaded from the California Open Data Portal (Monitoring Data, Facility Information), Office of Environmental Health Hazard Assessment CalEnviroScreen 3.0 webpage, and the SWRCB 2012 Integrated Report webpage.
Data for Fig. 20 is provided as a download below and is also available on the Stream Quality Index dashboard. Download the file from the dashboard for the most current data.
Organization: State of California
Last updated: 2021-09-08T16:15:49.249719
Tags: groundwater, harmful-algal-bloom, surface-water, toxicity, water, watershed

Tables

Fig. 3. Toxicity And Urban Land Use

@usgov.ca_gov_2019_california_water_quality_status_report.fig_3_toxicity_and_urban_land_use

3.07 KB
8 rows
3 columns


CREATE TABLE fig_3_toxicity_and_urban_land_use (
  "landusecategory" VARCHAR,
  "toxicitycategory" VARCHAR,
  "percent" DOUBLE
);

Fig. 4-5. Sum Pyrethroid Toxic Units

@usgov.ca_gov_2019_california_water_quality_status_report.fig_4_5_sum_pyrethroid_toxic_units

16.22 KB
807 rows
6 columns


CREATE TABLE fig_4_5_sum_pyrethroid_toxic_units (
  "stationcode" VARCHAR,
  "landuse" VARCHAR,
  "percenturbanlanduse" VARCHAR,
  "year" BIGINT,
  "sampledate" TIMESTAMP,
  "sumpyrethroid_toxicunits" DOUBLE
);

Fig. 18. Mayfly Occurrence Data

@usgov.ca_gov_2019_california_water_quality_status_report.fig_18_mayfly_occurrence_data

44.48 KB
1964 rows
8 columns


CREATE TABLE fig_18_mayfly_occurrence_data (
  "name" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "provider" VARCHAR,
  "date" TIMESTAMP,
  "key" BIGINT,
  "dtime" TIMESTAMP,
  "month" VARCHAR
);

Fig. 20. Stream Quality Index Map

@usgov.ca_gov_2019_california_water_quality_status_report.fig_20_stream_quality_index_map

70.8 KB
267 rows
47 columns


CREATE TABLE fig_20_stream_quality_index_map (
  "masterid" VARCHAR,
  "yr" BIGINT,
  "comid" VARCHAR,
  "pchem" DOUBLE,
  "phab" DOUBLE,
  "poverall" DOUBLE,
  "biological_condition" VARCHAR,
  "stress_condition" VARCHAR,
  "sqi" VARCHAR,
  "county" VARCHAR,
  "smc_region" VARCHAR,
  "regional_board" VARCHAR,
  "constraint_class" VARCHAR,
  "asci" DOUBLE,
  "blc" DOUBLE,
  "bs" DOUBLE,
  "cond" DOUBLE,
  "csci" DOUBLE,
  "ev_flowhab" DOUBLE,
  "h_aqhab" DOUBLE,
  "h_subnat" DOUBLE,
  "hy" DOUBLE,
  "cram" BIGINT,
  "ipi" DOUBLE,
  "pct_safn" DOUBLE,
  "ps" DOUBLE,
  "tn" DOUBLE,
  "tp" DOUBLE,
  "xcmg" DOUBLE,
  "lon" DOUBLE,
  "lat" DOUBLE,
  "asci_ptile" DOUBLE,
  "blc_ptile" DOUBLE,
  "bs_ptile" DOUBLE,
  "cond_ptile" DOUBLE,
  "cram_ptile" DOUBLE,
  "csci_ptile" DOUBLE,
  "ev_flowhab_ptile" DOUBLE,
  "h_aqhab_ptile" DOUBLE,
  "h_subnat_ptile" DOUBLE,
  "hy_ptile" DOUBLE,
  "ipi_ptile" DOUBLE,
  "pct_safn_ptile" DOUBLE,
  "ps_ptile" DOUBLE,
  "tn_ptile" DOUBLE,
  "tp_ptile" DOUBLE,
  "xcmg_ptile" DOUBLE
);