Baselight
Sign In

Surface Water - Indicator Bacteria Results

State of California

@usgov.ca_gov_surface_water_fecal_indicator_bacteria_results

Loading...
Loading...

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: 2025-07-23T14:30:33.289643
Tags: ceden

Tables

Safe To Swim 1969-2010 (no Longer Updated)

@usgov.ca_gov_surface_water_fecal_indicator_bacteria_results.safe_to_swim_1969_2010_no_longer_updated
  • 40.9 MB
  • 3,120,959 rows
  • 75 columns
Loading... 
CREATE TABLE safe_to_swim_1969_2010_no_longer_updated (
  "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  -- Hydromod,
  "hydromodloc_8338a4" VARCHAR  -- HydromodLoc,
  "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 2010-2020 (no Longer Updated)

@usgov.ca_gov_surface_water_fecal_indicator_bacteria_results.safe_to_swim_2010_2020_no_longer_updated
  • 24.17 MB
  • 1,693,229 rows
  • 75 columns
Loading... 
CREATE TABLE safe_to_swim_2010_2020_no_longer_updated (
  "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  -- Hydromod,
  "hydromodloc_8338a4" VARCHAR  -- HydromodLoc,
  "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 2020-present (no Longer Updated)

@usgov.ca_gov_surface_water_fecal_indicator_bacteria_results.safe_to_swim_2020_present_no_longer_updated
  • 6.12 MB
  • 491,809 rows
  • 82 columns
Loading... 
CREATE TABLE safe_to_swim_2020_present_no_longer_updated (
  "analysisdate" TIMESTAMP,
  "analyte" VARCHAR,
  "analytecode" DOUBLE,
  "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,
  "fractioncode" DOUBLE,
  "fractionname" VARCHAR,
  "groupsamples" VARCHAR,
  "hydromod" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod_2b6b48" VARCHAR  -- Hydromod,
  "hydromodloc_8338a4" VARCHAR  -- HydromodLoc,
  "labagency" VARCHAR,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "locationcode" VARCHAR,
  "locationdetailbacomments" VARCHAR,
  "locationdetailwqcomments" VARCHAR,
  "mdl" DOUBLE,
  "matrixcode" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "observation" VARCHAR,
  "occupationmethod" VARCHAR,
  "parentproject" VARCHAR,
  "parentprojectcode" VARCHAR,
  "positionwatercolumn" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "preppreservationname" VARCHAR,
  "program" VARCHAR,
  "programcode" VARCHAR,
  "project" VARCHAR,
  "projectcode" 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
);

Share link

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