About this Dataset

Surface Water - Toxicity Results

Surface water toxicity data from the California Environmental Data Exchange Network (CEDEN). CEDEN is the California State Water Board's data system for surface water quality in California, and seeks to include all available statewide data (such as that produced by research and volunteer organizations). Data in CEDEN include field, sediment and water column data collected from freshwater, estuarine, and marine environments. Examples of data in CEDEN come from laboratory, physical and biological analyses and include data types associated with chemical, toxicological, field, bio-assessment, invertebrate, fish, and bacteriological assay assessments.

The data resource "Surface Water Toxicity" contains two provisionally assigned values (“DataQuality” and “DataQualityIndicator”) to help users interpret the data quality metadata provided with the associated result.

Zip files are provided for bulk data downloads (in csv or parquet file format), and developers can use the API associated with the "Surface Water Toxicity" (csv) resource to access the data.

Users who want to manually download more specific subsets of the data can also use the CEDEN Query Tool, which provides access to the same data presented here, but allows for interactive data filtering.
Organization: State of California
Last updated: 2025-10-23T12:45:38.058099
Tags: bioassessment, ceden, fish, invertebrate, monitoring, sediment, sediment-toxicity, surface-water, toxicity, toxicity-test, toxicology, water-quality, water-quality-monitoring

Tables

Surface Water Toxicity

@usgov.ca_gov_surface_water_toxicity_results.surface_water_toxicity

50.44 MB
1,647,568 rows
95 columns

CREATE TABLE surface_water_toxicity (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "labreplicate" VARCHAR,
  "toxbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "toxtestdurcode" VARCHAR,
  "organismname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "wqsource" VARCHAR,
  "timepointname" VARCHAR,
  "result" VARCHAR,
  "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,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "positionwatercolumn" VARCHAR,
  "tienarrative" VARCHAR,
  "dilution" VARCHAR,
  "toxpointmethod" VARCHAR,
  "treatment" VARCHAR,
  "unittreatment" VARCHAR,
  "treatmentconcentration" DOUBLE,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "toxbatchstartdate" VARCHAR,
  "reftoxbatch" VARCHAR,
  "organismageatteststart" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "hydromod" VARCHAR,
  "hydromodloc" VARCHAR,
  "locationdetailwqcomments" VARCHAR,
  "pctcontrol" VARCHAR,
  "repcount" VARCHAR,
  "mean" VARCHAR,
  "stddev" VARCHAR,
  "statmethod" VARCHAR,
  "probability" VARCHAR,
  "alphalevel" VARCHAR,
  "evalthreshold" VARCHAR,
  "msd" VARCHAR,
  "sigeffectcode" VARCHAR,
  "channelwidth" VARCHAR,
  "upstreamlength" VARCHAR,
  "downstreamlength" VARCHAR,
  "totalreach" VARCHAR,
  "calculatedvalue" VARCHAR,
  "percenteffect" VARCHAR,
  "sampleid" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" DOUBLE,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

Surface Water Toxicity - Replicate Results

@usgov.ca_gov_surface_water_toxicity_results.surface_water_toxicity_replicate_results

40.06 MB
1,514,174 rows
59 columns

CREATE TABLE surface_water_toxicity_replicate_results (
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "projectcode" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "agencycode" VARCHAR,
  "samplecomments" VARCHAR,
  "locationcode" VARCHAR,
  "geometryshape" VARCHAR,
  "collectiontime" VARCHAR,
  "collectionmethodcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "replicate" BIGINT,
  "collectiondevicename" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "positionwatercolumn" VARCHAR,
  "labcollectioncomments" VARCHAR,
  "toxbatch" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "testduration" VARCHAR,
  "organismname" VARCHAR,
  "testexposuretype" VARCHAR,
  "qacontrolid" VARCHAR,
  "sampleid" VARCHAR,
  "labsampleid" VARCHAR,
  "toxtestcomments" VARCHAR,
  "treatment" VARCHAR,
  "concentration" DOUBLE,
  "unittreatment" VARCHAR,
  "dilution" DOUBLE,
  "wqsource" VARCHAR,
  "toxpointmethod" VARCHAR,
  "analytename" VARCHAR,
  "fractionname" VARCHAR,
  "unitanalyte" VARCHAR,
  "timepoint" VARCHAR,
  "labreplicate" BIGINT,
  "organismperrep" BIGINT,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "toxresultqacode" VARCHAR,
  "compliancecode" VARCHAR,
  "toxresultcomments" VARCHAR,
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "datum" VARCHAR,
  "startdate" TIMESTAMP,
  "labagencycode" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "batchverificationcode" VARCHAR,
  "reftoxbatch" VARCHAR,
  "organismageatteststart" VARCHAR,
  "submittingagencycode" VARCHAR,
  "organismsupplier" VARCHAR,
  "toxbatchcomments" VARCHAR
);

Surface Water Toxicity - Summary Results

@usgov.ca_gov_surface_water_toxicity_results.surface_water_toxicity_summary_results

5.67 MB
109,949 rows
70 columns

CREATE TABLE surface_water_toxicity_summary_results (
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "projectcode" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "agencycode" VARCHAR,
  "samplecomments" VARCHAR,
  "locationcode" VARCHAR,
  "geometryshape" VARCHAR,
  "collectiontime" VARCHAR,
  "collectionmethodcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "replicate" BIGINT,
  "collectiondevicename" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "positionwatercolumn" VARCHAR,
  "labcollectioncomments" VARCHAR,
  "toxbatch" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "testduration" VARCHAR,
  "organismname" VARCHAR,
  "testexposuretype" VARCHAR,
  "qacontrolid" VARCHAR,
  "sampleid" VARCHAR,
  "labsampleid" VARCHAR,
  "toxtestcomments" VARCHAR,
  "treatment" VARCHAR,
  "concentration" DOUBLE,
  "unittreatment" VARCHAR,
  "dilution" DOUBLE,
  "wqsource" VARCHAR,
  "toxpointmethod" VARCHAR,
  "analytename" VARCHAR,
  "fractionname" VARCHAR,
  "unitanalyte" VARCHAR,
  "timepoint" VARCHAR,
  "repcount" BIGINT,
  "mean" DOUBLE,
  "stddev" DOUBLE,
  "statisticalmethod" VARCHAR,
  "alphavalue" DOUBLE,
  "bvalue" VARCHAR,
  "calcvaluetype" VARCHAR,
  "calculatedvalue" DOUBLE,
  "criticalvalue" DOUBLE,
  "percenteffect" VARCHAR,
  "msd" VARCHAR,
  "evalthreshold" DOUBLE,
  "sigeffect" VARCHAR,
  "testqacode" VARCHAR,
  "compliancecode" VARCHAR,
  "toxpointsummarycomments" VARCHAR,
  "tienarrative" VARCHAR,
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "datum" VARCHAR,
  "percentcontrol" DOUBLE,
  "startdate" TIMESTAMP,
  "labagencycode" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "batchverificationcode" VARCHAR,
  "reftoxbatch" VARCHAR,
  "organismageatteststart" VARCHAR,
  "submittingagencycode" VARCHAR,
  "organismsupplier" VARCHAR,
  "toxbatchcomments" VARCHAR
);