Baselight
Sign In

SWAMP Data Dashboard

State of California

@usgov.ca_gov_surface_water_ambient_monitoring_program

Loading...
Loading...

About this Dataset

SWAMP Data Dashboard

This dataset supports the SWAMP Data Dashboard, a public-facing tool developed by the Surface Water Ambient Monitoring Program (SWAMP) to provide accessible, user-friendly access to water quality monitoring data across California. The dashboard and its associated datasets are designed to help the public, researchers, and decision-makers explore and download monitoring data collected from California’s surface waters.

This dataset includes five distinct resources:

  • SWAMP Stations – Geospatial and descriptive information about SWAMP monitoring sites.
  • Water Quality Results – Field and lab analysis results for chemical and physical parameters measured in water samples.
  • Toxicity Summary Results – Summarized results from aquatic toxicity tests. Summary records are entries in the database that summarize the results from multiple replicate toxicity tests of the same sample water.
  • Habitat Results – Data on physical habitat conditions typically collected alongside biological monitoring to provide context for interpreting water quality conditions. Includes scores for the California Stream Condition Index (CSCI) and Algal Stream Condition Index (ASCI).
  • Tissue Summary Results – Annual summary statistics of contaminant concentrations in aquatic organism tissue samples. The data are derived from raw individual and composite tissue sample results.

These data are collected by SWAMP and its partners to support water quality assessments, identify trends, and inform water resource management. The SWAMP Data Dashboard provides interactive visualizations and filtering tools to explore this data by region, parameter, and more.

The SWAMP dataset is sourced from the California Environmental Data Exchange Network (CEDEN), which serves as the central repository for water quality data collected by various monitoring programs throughout the state. As such, there is some overlap between this dataset and the broader CEDEN datasets also published on the California Open Data Portal (see Related Resources). This SWAMP dataset represents a curated subset of CEDEN data, specifically tailored for use in the SWAMP Data Dashboard.

Access the SWAMP Data Dashboard: https://gispublic.waterboards.ca.gov/swamp-data/

*This dataset is provisional and subject to revision. It should not be used for regulatory purposes.
Organization: State of California
Last updated: 2025-10-23T12:41:29.382833
Tags: surface-water, water-quality

Tables

Data Dictionary - SWAMP Habitat Results

@usgov.ca_gov_surface_water_ambient_monitoring_program.data_dictionary_swamp_habitat_results
  • 4 kB
  • 64 rows
  • 4 columns
Loading... 
CREATE TABLE data_dictionary_swamp_habitat_results (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - SWAMP Stations

@usgov.ca_gov_surface_water_ambient_monitoring_program.data_dictionary_swamp_stations
  • 3.38 kB
  • 7 rows
  • 4 columns
Loading... 
CREATE TABLE data_dictionary_swamp_stations (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - SWAMP Tissue Summary Results

@usgov.ca_gov_surface_water_ambient_monitoring_program.data_dictionary_swamp_tissue_summary_results
  • 3.67 kB
  • 37 rows
  • 4 columns
Loading... 
CREATE TABLE data_dictionary_swamp_tissue_summary_results (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - SWAMP Toxicity Summary Results

@usgov.ca_gov_surface_water_ambient_monitoring_program.data_dictionary_swamp_toxicity_summary_results
  • 4.57 kB
  • 110 rows
  • 4 columns
Loading... 
CREATE TABLE data_dictionary_swamp_toxicity_summary_results (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - SWAMP Water Quality Results

@usgov.ca_gov_surface_water_ambient_monitoring_program.data_dictionary_swamp_water_quality_results
  • 4.38 kB
  • 94 rows
  • 4 columns
Loading... 
CREATE TABLE data_dictionary_swamp_water_quality_results (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

SWAMP Habitat Results

@usgov.ca_gov_surface_water_ambient_monitoring_program.swamp_habitat_results
  • 749.24 kB
  • 13,194 rows
  • 64 columns
Loading... 
CREATE TABLE swamp_habitat_results (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" BIGINT,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "targetlatitude" DOUBLE,
  "targetlongitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" DOUBLE,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" DOUBLE,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" DOUBLE,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "isqa" BOOLEAN,
  "programcode" VARCHAR,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" BIGINT,
  "analytecode" BIGINT,
  "fractionname" VARCHAR,
  "fractioncode" BIGINT,
  "datum" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "censored" BOOLEAN,
  "resultdisplay" DOUBLE,
  "displaytext" VARCHAR,
  "analytedisplay" VARCHAR,
  "analytegroup1" VARCHAR,
  "analytegroup2" VARCHAR,
  "analytegroup3" VARCHAR,
  "matrixdisplay" VARCHAR,
  "region" BIGINT,
  "bioassessment" BOOLEAN,
  "bioaccumulation" BOOLEAN,
  "fhab" BOOLEAN,
  "spot" BOOLEAN,
  "stationcategory" VARCHAR
);

SWAMP Stations

@usgov.ca_gov_surface_water_ambient_monitoring_program.swamp_stations
  • 366.82 kB
  • 6,911 rows
  • 7 columns
Loading... 
CREATE TABLE swamp_stations (
  "stationcode" VARCHAR,
  "stationname" VARCHAR,
  "targetlatitude" DOUBLE,
  "targetlongitude" DOUBLE,
  "lastsampledate" TIMESTAMP,
  "region" BIGINT,
  "stationcategory" VARCHAR
);

SWAMP Tissue Summary Results

@usgov.ca_gov_surface_water_ambient_monitoring_program.swamp_tissue_summary_results
  • 939.84 kB
  • 130,763 rows
  • 37 columns
Loading... 
CREATE TABLE swamp_tissue_summary_results (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "projectcode" VARCHAR,
  "project" VARCHAR,
  "stationcode" VARCHAR,
  "stationname" VARCHAR,
  "locationcode" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissuename" VARCHAR,
  "tissueprep" VARCHAR,
  "analyte" VARCHAR,
  "result" DOUBLE,
  "unit" VARCHAR,
  "resulttype" VARCHAR,
  "nd_in_avg" BIGINT,
  "n_in_avg" BIGINT,
  "displaytext" VARCHAR,
  "censored" BOOLEAN,
  "tlavglength_mm" DOUBLE,
  "avgtotallength" DOUBLE,
  "lastsampledate" TIMESTAMP,
  "sampleyear" BIGINT,
  "targetlatitude" DOUBLE,
  "targetlongitude" DOUBLE,
  "datum" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "analytedisplay" VARCHAR,
  "analytegroup1" VARCHAR,
  "matrixdisplay" VARCHAR,
  "region" BIGINT,
  "bioaccumulation" BOOLEAN,
  "bioassessment" BOOLEAN,
  "fhab" BOOLEAN,
  "spot" BOOLEAN,
  "stationcategory" VARCHAR
);

SWAMP Toxicity Summary Results

@usgov.ca_gov_surface_water_ambient_monitoring_program.swamp_toxicity_summary_results
  • 992.83 kB
  • 15,290 rows
  • 110 columns
Loading... 
CREATE TABLE swamp_toxicity_summary_results (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" BIGINT,
  "labreplicate" BIGINT,
  "toxbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "toxtestdurcode" VARCHAR,
  "organismname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "wqsource" VARCHAR,
  "timepointname" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "toxresultqacode" VARCHAR,
  "qacode" VARCHAR,
  "batchverificationcode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "toxtestcomments" VARCHAR,
  "timepointcomments" VARCHAR,
  "toxresultcomments" VARCHAR,
  "toxbatchcomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "groupsamples" VARCHAR,
  "collectionmethodname" VARCHAR,
  "targetlatitude" DOUBLE,
  "targetlongitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "positionwatercolumn" VARCHAR,
  "tienarrative" VARCHAR,
  "dilution" DOUBLE,
  "toxpointmethod" VARCHAR,
  "treatment" VARCHAR,
  "unittreatment" VARCHAR,
  "treatmentconcentration" DOUBLE,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "toxbatchstartdate" TIMESTAMP,
  "reftoxbatch" VARCHAR,
  "organismageatteststart" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" DOUBLE,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" DOUBLE,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" DOUBLE,
  "unitstationwaterdepth" VARCHAR,
  "hydromod" VARCHAR,
  "hydromodloc" VARCHAR,
  "locationdetailwqcomments" VARCHAR,
  "pctcontrol" DOUBLE,
  "repcount" BIGINT,
  "mean" DOUBLE,
  "stddev" DOUBLE,
  "statmethod" VARCHAR,
  "probability" VARCHAR,
  "alphalevel" DOUBLE,
  "evalthreshold" DOUBLE,
  "msd" DOUBLE,
  "sigeffectcode" VARCHAR,
  "channelwidth" VARCHAR,
  "upstreamlength" VARCHAR,
  "downstreamlength" VARCHAR,
  "totalreach" VARCHAR,
  "calculatedvalue" DOUBLE,
  "percenteffect" DOUBLE,
  "sampleid" VARCHAR,
  "dw_analytename" VARCHAR,
  "isqa" BOOLEAN,
  "programcode" VARCHAR,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" BIGINT,
  "analytecode" BIGINT,
  "fractionname" VARCHAR,
  "fractioncode" BIGINT,
  "datum" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "meandisplay" DOUBLE,
  "displaytext" VARCHAR,
  "censored" BOOLEAN,
  "analytedisplay" VARCHAR
);

SWAMP Water Quality Results

@usgov.ca_gov_surface_water_ambient_monitoring_program.swamp_water_quality_results
  • 36.22 MB
  • 906,828 rows
  • 94 columns
Loading... 
CREATE TABLE swamp_water_quality_results (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" BIGINT,
  "resultsreplicate" BIGINT,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "observation" VARCHAR,
  "mdl" DOUBLE,
  "rl" DOUBLE,
  "resultqualcode" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "batchcomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "groupsamples" VARCHAR,
  "collectionmethodname" VARCHAR,
  "targetlatitude" DOUBLE,
  "targetlongitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" DOUBLE,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" DOUBLE,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" DOUBLE,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" DOUBLE,
  "unitstationwaterdepth" VARCHAR,
  "hydromod" VARCHAR,
  "hydromodloc" VARCHAR,
  "locationdetailwqcomments" VARCHAR,
  "channelwidth" VARCHAR,
  "upstreamlength" VARCHAR,
  "downstreamlength" VARCHAR,
  "totalreach" VARCHAR,
  "locationdetailbacomments" VARCHAR,
  "sampleid" VARCHAR,
  "dw_analytename" VARCHAR,
  "isqa" BOOLEAN,
  "programcode" VARCHAR,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" BIGINT,
  "analytecode" BIGINT,
  "fractionname" VARCHAR,
  "fractioncode" BIGINT,
  "datum" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "resultdisplay" DOUBLE,
  "displaytext" VARCHAR,
  "censored" BOOLEAN,
  "analytedisplay" VARCHAR,
  "analytegroup1" VARCHAR,
  "analytegroup2" VARCHAR,
  "analytegroup3" VARCHAR,
  "matrixdisplay" VARCHAR,
  "region" BIGINT,
  "bioassessment" BOOLEAN,
  "bioaccumulation" BOOLEAN,
  "fhab" BOOLEAN,
  "spot" BOOLEAN,
  "stationcategory" VARCHAR
);

Share link

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