Baselight
Sign In

Surface Water - 2018 California Water Quality Status Report

State of California

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16

Loading...
Loading...

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.998494
Tags: impaired-waters, surface-water, water, watershed

Tables

Fig. 1. Mortality And Pyrethroid Toxic Units (2008-2016)

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16.fig_1_mortality_and_pyrethroid_toxic_units_2008_2016
  • 16.42 KB
  • 1800 rows
  • 9 columns
Loading... 

CREATE TABLE fig_1_mortality_and_pyrethroid_toxic_units_2008_2016 (
  "land_use" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "measure" VARCHAR,
  "stationid1" VARCHAR,
  "station_id" VARCHAR,
  "station_name" VARCHAR,
  "value" DOUBLE,
  "year" TIMESTAMP
);

Fig. 2. Median Sum Pyrethroids (2008-2016)

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16.fig_2_median_sum_pyrethroids_2008_2016
  • 5.01 KB
  • 9 rows
  • 6 columns
Loading... 

CREATE TABLE fig_2_median_sum_pyrethroids_2008_2016 (
  "agriculture" DOUBLE,
  "other" DOUBLE,
  "statewide" DOUBLE,
  "unit" VARCHAR,
  "urban" DOUBLE,
  "year" BIGINT
);

Fig. 3. Median Sum Metals (2008-2016)

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16.fig_3_median_sum_metals_2008_2016
  • 5.08 KB
  • 8 rows
  • 6 columns
Loading... 

CREATE TABLE fig_3_median_sum_metals_2008_2016 (
  "agriculture" DOUBLE,
  "other" DOUBLE,
  "statewide" DOUBLE,
  "unit" VARCHAR,
  "urban" DOUBLE,
  "year" TIMESTAMP
);

Fig. 4. Irrigated Lands Toxicity

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16.fig_4_irrigated_lands_toxicity
  • 103.22 KB
  • 3478 rows
  • 39 columns
Loading... 

CREATE TABLE fig_4_irrigated_lands_toxicity (
  "alphalevel" DOUBLE,
  "analyte" VARCHAR,
  "average_hightoxicity_thresholds" DOUBLE,
  "averagepctcontorganisms_1" DOUBLE,
  "averagepctcontorganisms" DOUBLE,
  "average_percent_control" DOUBLE,
  "compliance_code" VARCHAR,
  "data_quality_indicator" VARCHAR,
  "data_quality" VARCHAR,
  "eval_threshold" DOUBLE,
  "high_toxicity_threshold" BIGINT,
  "lab_replicate" BIGINT,
  "msd" BIGINT,
  "sample_magnitude_of_tox_samples" VARCHAR,
  "matrix_name" VARCHAR,
  "mean" DOUBLE,
  "multiplesamplemagnitudetoxicity" VARCHAR,
  "organism_name" VARCHAR,
  "parent_project" VARCHAR,
  "pct_control" BIGINT,
  "pct_controlrecal" BIGINT,
  "pctcontrolrecal_1" BIGINT,
  "program" VARCHAR,
  "project" VARCHAR,
  "rep_count" BIGINT,
  "result" BIGINT,
  "sample_date" TIMESTAMP,
  "sig_effect_code" VARCHAR,
  "site_magnitude_of_toxicity" VARCHAR,
  "spatial_datum" VARCHAR,
  "stat_method" VARCHAR,
  "station_code" VARCHAR,
  "station_name" VARCHAR,
  "std_dev" DOUBLE,
  "target_latitude" DOUBLE,
  "target_longitude" DOUBLE,
  "tox_test_dur_code" VARCHAR,
  "unit" VARCHAR,
  "site_toxicity" VARCHAR
);

Fig. 6. 2017-2018 Post-Fire Water Quality Monitoring

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16.fig_6_2017_2018_post_fire_water_quality_monitoring
  • 25.53 KB
  • 3139 rows
  • 19 columns
Loading... 

CREATE TABLE fig_6_2017_2018_post_fire_water_quality_monitoring (
  "analyte_exceeding" VARCHAR,
  "analyte" VARCHAR,
  "latitude_calc" DOUBLE,
  "longitude_calc" DOUBLE,
  "description_october_2017_kml" VARCHAR,
  "description" VARCHAR,
  "evaluation_guideline" VARCHAR,
  "exceedance" VARCHAR,
  "geometry_october_2017_kml" VARCHAR,
  "geometry" VARCHAR,
  "group" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "name_october_2017_kml" VARCHAR,
  "name" VARCHAR,
  "result" DOUBLE,
  "sampling_event" VARCHAR,
  "source" VARCHAR,
  "station_code" VARCHAR
);

Fig. 7. Bioassessment Regional Snapshots

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16.fig_7_bioassessment_regional_snapshots
  • 1.01 MB
  • 2845 rows
  • 153 columns
Loading... 

CREATE TABLE fig_7_bioassessment_regional_snapshots (
  "wgtcode" VARCHAR,
  "stationcode" VARCHAR,
  "stream_name" VARCHAR,
  "project" VARCHAR,
  "sampledate" VARCHAR,
  "group" VARCHAR,
  "psa_evalcode" VARCHAR,
  "psa_evalcode2" VARCHAR,
  "poststratum" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "psa8" VARCHAR,
  "psa_lu2" VARCHAR,
  "smc_lu" VARCHAR,
  "smc_shed" VARCHAR,
  "adjwgt_km" DOUBLE,
  "year_alias" VARCHAR,
  "sampleid" VARCHAR,
  "bugcode" VARCHAR,
  "sampledate_1" VARCHAR,
  "collectionmethodcode" VARCHAR,
  "replicate" DOUBLE,
  "invasives" VARCHAR,
  "count" BIGINT,
  "countotu" DOUBLE,
  "percentunambiguous" DOUBLE,
  "adequacy" VARCHAR,
  "selectedsamples" VARCHAR,
  "siteset" VARCHAR,
  "sitestatus" VARCHAR,
  "psaregion" VARCHAR,
  "psa9c_1987" VARCHAR,
  "psa6c" VARCHAR,
  "psa9c" VARCHAR,
  "psa10c" VARCHAR,
  "eco_iii_1987" DOUBLE,
  "eco_iii_2010" DOUBLE,
  "new_lat" DOUBLE,
  "new_long" DOUBLE,
  "ppt_00_09" DOUBLE,
  "temp_00_09" DOUBLE,
  "area_sqkm" DOUBLE,
  "site_elev" DOUBLE,
  "elev_range" DOUBLE,
  "bdh_ave" DOUBLE,
  "kfct_ave" DOUBLE,
  "p_mean" DOUBLE,
  "sumave_p" DOUBLE,
  "ag_2000_1k" DOUBLE,
  "ag_2000_5k" DOUBLE,
  "ag_2000_ws" DOUBLE,
  "code_21_2000_1k" DOUBLE,
  "code_21_2000_5k" DOUBLE,
  "code_21_2000_ws" DOUBLE,
  "urban_2000_1k" DOUBLE,
  "urban_2000_5k" DOUBLE,
  "urban_2000_ws" DOUBLE,
  "roaddens_1k" DOUBLE,
  "roaddens_5k" DOUBLE,
  "roaddens_ws" DOUBLE,
  "paved_int_1k" BIGINT,
  "paved_int_5k" BIGINT,
  "paved_int_ws" BIGINT,
  "permanmade_ws" DOUBLE,
  "invdamdist" DOUBLE,
  "mines_5k" BIGINT,
  "mines_ws" DOUBLE,
  "gravelminedensl_r5k" VARCHAR,
  "maxofcond" VARCHAR,
  "maxofw1_hall" VARCHAR,
  "bpj_nonref" VARCHAR,
  "active" VARCHAR,
  "finalcaty5" VARCHAR,
  "final_wgt5" VARCHAR,
  "logwsa" DOUBLE,
  "w1_hall_screening" DOUBLE,
  "condqr01" DOUBLE,
  "condqr50" DOUBLE,
  "condqr99" DOUBLE,
  "condqr99c" DOUBLE,
  "w1hallpf" VARCHAR,
  "condpf" VARCHAR,
  "agpf" VARCHAR,
  "urbpf" VARCHAR,
  "agurbpf" VARCHAR,
  "cd21pf" VARCHAR,
  "roaddenspf" VARCHAR,
  "intersectionspf" VARCHAR,
  "damspf" VARCHAR,
  "manmadepf" VARCHAR,
  "minespf" VARCHAR,
  "regionalstrata" VARCHAR,
  "developmentset" VARCHAR,
  "nsamp" DOUBLE,
  "sitestatus2" VARCHAR,
  "sitestatus2detail" VARCHAR,
  "developmentset2" VARCHAR,
  "siteset2" VARCHAR,
  "o" DOUBLE,
  "e" DOUBLE
);

Fig. 9. Aquatic Life Index Site Condition Score

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16.fig_9_aquatic_life_index_site_condition_score
  • 18.02 KB
  • 241 rows
  • 6 columns
Loading... 

CREATE TABLE fig_9_aquatic_life_index_site_condition_score (
  "sitetag" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "site_name" VARCHAR,
  "index_aquatic_life_wq" DOUBLE,
  "aq_grade" VARCHAR
);

Fig. 10. CCAMP Aquatic Life Index (Pesticides - H2O)

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16.fig_10_ccamp_aquatic_life_index_pesticides_h2o
  • 9.22 KB
  • 132 rows
  • 6 columns
Loading... 

CREATE TABLE fig_10_ccamp_aquatic_life_index_pesticides_h2o (
  "site_tag" VARCHAR,
  "analyte_name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "index_org_aquatic_life_h2o" DOUBLE,
  "aq_grade_h2o" VARCHAR
);

Fig. 11. CCAMP Nitrate

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16.fig_11_ccamp_nitrate
  • 13.17 KB
  • 252 rows
  • 6 columns
Loading... 

CREATE TABLE fig_11_ccamp_nitrate (
  "sitetag" VARCHAR,
  "analytename" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "humanhealthscore" DOUBLE,
  "hh_grade" VARCHAR
);

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.75 MB
  • 66022 rows
  • 76 columns
Loading... 

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
);

Fig. 14. Most Recent Mercury Concentration In Largemouth Bass (2007-2014)

@usgov.ca_gov_surface_water_2018_california_water_quality_sta_787f1b16.fig_14_most_recent_mercury_concentration_in_largemouth_f6b7434f
  • 92.07 KB
  • 3619 rows
  • 26 columns
Loading... 

CREATE TABLE fig_14_most_recent_mercury_concentration_in_largemouth_f6b7434f (
  "step_download_before_using_this_please_view_metadata_a_e727af5c" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR
);

Share link

Anyone who has the link will be able to view this.