Surface Water - Indicator Bacteria Results by US Government | Environmental and Climate Sciences

About this Dataset

Surface Water - Indicator Bacteria Results

Indicator bacteria data from the California Environmental Data Exchange Network (CEDEN) and BeachWatch databases. Results include E. coli, enterococci, fecal coliforms, and total coliforms. There is some overlap with the CEDEN Water Chemistry dataset (https://data.ca.gov/dataset/surface-water-chemistry-results). Both datasets draw from the same source, but the resources here are updated more frequently to support the Safe to Swim map on the Water Boards My Water Quality portal (https://mywaterquality.ca.gov/safe_to_swim/index.html).
Organization: State of California
Last updated: 2024-11-26T22:07:42.586998
Tags: ceden

Tables

Data Dictionary - Safe To Swim 2020-present

@usgov.ca_gov_surface_water_fecal_indicator_bacteria_results.data_dictionary_safe_to_swim_2020_present

4.14 KB
82 rows
4 columns


CREATE TABLE data_dictionary_safe_to_swim_2020_present (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Safe To Swim 2010-2020

@usgov.ca_gov_surface_water_fecal_indicator_bacteria_results.safe_to_swim_2010_2020

22.01 MB
1693229 rows
75 columns


CREATE TABLE safe_to_swim_2010_2020 (
  "analysisdate" TIMESTAMP,
  "analyte" VARCHAR,
  "batchcomments" VARCHAR,
  "batchverification" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "channelwidth" VARCHAR,
  "collectioncomments" VARCHAR,
  "collectiondepth" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "collectionmethodname" VARCHAR,
  "collectionreplicate" BIGINT,
  "collectiontime" TIMESTAMP,
  "compliancecode" VARCHAR,
  "dw_analytename" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "dilutionfactor" DOUBLE,
  "distancefrombank" DOUBLE,
  "downstreamlength" VARCHAR,
  "eventcode" VARCHAR,
  "expectedvalue" VARCHAR,
  "groupsamples" VARCHAR,
  "hydromod" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod_2b6b48" VARCHAR,
  "hydromodloc_8338a4" VARCHAR,
  "labagency" VARCHAR,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "locationcode" VARCHAR,
  "locationdetailbacomments" VARCHAR,
  "locationdetailwqcomments" VARCHAR,
  "mdl" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "observation" VARCHAR,
  "occupationmethod" VARCHAR,
  "parentproject" VARCHAR,
  "positionwatercolumn" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "preppreservationname" VARCHAR,
  "program" VARCHAR,
  "project" VARCHAR,
  "protocolcode" VARCHAR,
  "qacode" VARCHAR,
  "rl" DOUBLE,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "resultscomments" VARCHAR,
  "resultsreplicate" BIGINT,
  "sampleagency" VARCHAR,
  "samplecomments" VARCHAR,
  "sampledate" TIMESTAMP,
  "sampleid" VARCHAR,
  "sampletypecode" VARCHAR,
  "startingbank" VARCHAR,
  "stationcode" VARCHAR,
  "stationname" VARCHAR,
  "stationwaterdepth" DOUBLE,
  "streamwidth" DOUBLE,
  "submissioncode" VARCHAR,
  "submittingagency" VARCHAR,
  "targetlatitude" VARCHAR,
  "targetlongitude" VARCHAR,
  "totalreach" VARCHAR,
  "unit" VARCHAR,
  "unitcollectiondepth" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "upstreamlength" VARCHAR,
  "isqa" VARCHAR,
  "datum" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR
);

Safe To Swim 1969-2010

@usgov.ca_gov_surface_water_fecal_indicator_bacteria_results.safe_to_swim_1969_2010

36.98 MB
3120959 rows
75 columns


CREATE TABLE safe_to_swim_1969_2010 (
  "analysisdate" TIMESTAMP,
  "analyte" VARCHAR,
  "batchcomments" VARCHAR,
  "batchverification" VARCHAR,
  "calibrationdate" VARCHAR,
  "channelwidth" VARCHAR,
  "collectioncomments" VARCHAR,
  "collectiondepth" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "collectionmethodname" VARCHAR,
  "collectionreplicate" BIGINT,
  "collectiontime" TIMESTAMP,
  "compliancecode" VARCHAR,
  "dw_analytename" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "dilutionfactor" DOUBLE,
  "distancefrombank" DOUBLE,
  "downstreamlength" VARCHAR,
  "eventcode" VARCHAR,
  "expectedvalue" DOUBLE,
  "groupsamples" VARCHAR,
  "hydromod" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod_2b6b48" VARCHAR,
  "hydromodloc_8338a4" VARCHAR,
  "labagency" VARCHAR,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "locationcode" VARCHAR,
  "locationdetailbacomments" VARCHAR,
  "locationdetailwqcomments" VARCHAR,
  "mdl" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "observation" VARCHAR,
  "occupationmethod" VARCHAR,
  "parentproject" VARCHAR,
  "positionwatercolumn" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "preppreservationname" VARCHAR,
  "program" VARCHAR,
  "project" VARCHAR,
  "protocolcode" VARCHAR,
  "qacode" VARCHAR,
  "rl" DOUBLE,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "resultscomments" VARCHAR,
  "resultsreplicate" BIGINT,
  "sampleagency" VARCHAR,
  "samplecomments" VARCHAR,
  "sampledate" TIMESTAMP,
  "sampleid" VARCHAR,
  "sampletypecode" VARCHAR,
  "startingbank" VARCHAR,
  "stationcode" VARCHAR,
  "stationname" VARCHAR,
  "stationwaterdepth" DOUBLE,
  "streamwidth" DOUBLE,
  "submissioncode" VARCHAR,
  "submittingagency" VARCHAR,
  "targetlatitude" VARCHAR,
  "targetlongitude" VARCHAR,
  "totalreach" VARCHAR,
  "unit" VARCHAR,
  "unitcollectiondepth" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "upstreamlength" VARCHAR,
  "isqa" VARCHAR,
  "datum" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR
);

Data Dictionary - Monitoring Sites For Safe To Swim

@usgov.ca_gov_surface_water_fecal_indicator_bacteria_results.data_dictionary_monitoring_sites_for_safe_to_swim

3.26 KB
6 rows
4 columns


CREATE TABLE data_dictionary_monitoring_sites_for_safe_to_swim (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);