About this Dataset

Surface Water - 2018 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 second 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 2018 California Water Quality Status Report.

Data for Fig. 8 Landscape Constraints on Stream Biological Integrity in the San Gabriel River Watershed can be downloaded from Zenodo.
Data for Fig. 13 HAB Incident Reports Map can be downloaded from the California Open Data Portal.

For more information please contact the Office of Information Management and Analysis (OIMA).
Organization: State of California
Last updated: 2021-09-08T16:15:25.998536
Tags: impaired-waters, surface-water, water, watershed

Tables

Fig. 12. Status Of Nutrients In California Waterways

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16.fig_12_status_of_nutrients_in_california_waterways

2.9 MB
66,022 rows
76 columns

CREATE TABLE fig_12_status_of_nutrients_in_california_waterways (
  "analysis_date" VARCHAR,
  "analytes" VARCHAR,
  "analyte" VARCHAR,
  "batch_comments" VARCHAR,
  "batch_verification" VARCHAR,
  "calibration_date" VARCHAR,
  "channel_width" VARCHAR,
  "collection_comments" VARCHAR,
  "collection_depth" DOUBLE,
  "collection_device_description" VARCHAR,
  "collection_method_name" VARCHAR,
  "collection_replicate" BIGINT,
  "collection_time" VARCHAR,
  "compliance_code" VARCHAR,
  "dw_analytename" VARCHAR,
  "data_quality_indicator" VARCHAR,
  "data_quality" VARCHAR,
  "datum" VARCHAR,
  "digest_extract_date" VARCHAR,
  "digest_extract_method" VARCHAR,
  "dilution_factor" BIGINT,
  "distance_from_bank" DOUBLE,
  "down_stream_length" VARCHAR,
  "event_code" VARCHAR,
  "expected_value" DOUBLE,
  "group_samples" VARCHAR,
  "hydro_mod_loc" VARCHAR,
  "hydro_mod" VARCHAR,
  "lab_agency" VARCHAR,
  "lab_batch" VARCHAR,
  "lab_sample_id" VARCHAR,
  "latitude" DOUBLE,
  "location_code" VARCHAR,
  "location_detail_ba_comments" VARCHAR,
  "location_detail_wq_comments" VARCHAR,
  "longitude" DOUBLE,
  "mdl" DOUBLE,
  "matrix_name" VARCHAR,
  "method_name" VARCHAR,
  "number_of_records" BIGINT,
  "observation" VARCHAR,
  "occupation_method" VARCHAR,
  "parent_project" VARCHAR,
  "position_water_column" VARCHAR,
  "prep_preservation_date" VARCHAR,
  "prep_preservation_name" VARCHAR,
  "program" VARCHAR,
  "project" VARCHAR,
  "protocol_code" VARCHAR,
  "qa_code" VARCHAR,
  "rl" DOUBLE,
  "result_qual_code" VARCHAR,
  "result" DOUBLE,
  "results_comments" VARCHAR,
  "results_replicate" BIGINT,
  "sample_agency" VARCHAR,
  "sample_comments" VARCHAR,
  "sample_date" TIMESTAMP,
  "sample_id" VARCHAR,
  "sample_type_code" VARCHAR,
  "starting_bank" VARCHAR,
  "station_code" VARCHAR,
  "station_name" VARCHAR,
  "station_water_depth" DOUBLE,
  "station" VARCHAR,
  "status" VARCHAR,
  "stream_width" DOUBLE,
  "submission_code" VARCHAR,
  "submitting_agency" VARCHAR,
  "total_reach" VARCHAR,
  "unit_collection_depth" VARCHAR,
  "unit_distance_from_bank" VARCHAR,
  "unit_station_water_depth" VARCHAR,
  "unit_stream_width" VARCHAR,
  "unit" VARCHAR,
  "upstream_length" VARCHAR
);