About this Dataset

Surface Water - Benthic Macroinvertebrate Results

Data collected for marine benthic infauna, freshwater benthic macroinvertebrate (BMI), algae, bacteria and diatom taxonomic analyses, from the California Environmental Data Exchange Network (CEDEN). Note bacteria single species concentrations are stored within the chemistry template, whereas abundance bacteria are stored within this set. Each record represents a result from a specific event location for a single organism in a single sample.

The data set 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 "CEDEN Benthic Data" (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-08-23T12:57:59.949863
Tags: assessment, benthic, bioaccumulation, bioassessment, ceden, contaminant, organisms, pollutant, sediment, surface-water, taxonomy, water-quality

Tables

CEDEN Benthic Data

@usgov.ca_gov_surface_water_benthic_macroinvertebrate_results.ceden_benthic_data

74.32 MB
1,056,376 rows
67 columns


CREATE TABLE ceden_benthic_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "datum" VARCHAR,
  "geometryshape" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "samplingagency" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "sampletype" VARCHAR,
  "personnelcode" VARCHAR,
  "samplecomments" VARCHAR,
  "bacollectioncomments" VARCHAR,
  "collectiondevicename" VARCHAR,
  "labsampleid" VARCHAR,
  "finalid" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "orders" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "lifestagename" VARCHAR,
  "distinctorganism" DOUBLE,
  "counts" VARCHAR,
  "baresult" DOUBLE,
  "unit" VARCHAR,
  "taxonomicqualifier" VARCHAR,
  "excludedtaxa" VARCHAR,
  "comments" VARCHAR,
  "sievesize" VARCHAR,
  "sievesizeunit" VARCHAR,
  "collectiondepth" VARCHAR,
  "unitcollectiondepth" VARCHAR,
  "grabsize" VARCHAR,
  "unitgrabsize" VARCHAR,
  "resqualcode" VARCHAR,
  "compliancecode" VARCHAR,
  "benthicresultrowid" VARCHAR,
  "sampleid" VARCHAR,
  "effortqacode" VARCHAR,
  "benthiclabeffortcomments" VARCHAR,
  "percentsamplecounted" VARCHAR,
  "totalgrids" VARCHAR,
  "gridsanalyzed" VARCHAR,
  "gridsvolumeanalyzed" VARCHAR,
  "targetorganismcount" VARCHAR,
  "actualorganismcount" VARCHAR,
  "extraorganismcount" VARCHAR,
  "qcorganismcount" VARCHAR,
  "discardedorganismcount" VARCHAR,
  "qacode" VARCHAR,
  "benthiclabeffort_agencycode" BOOLEAN,
  "programcode" VARCHAR,
  "parentprojectcode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR
);

Data Dictionary - CEDEN Benthic Data

@usgov.ca_gov_surface_water_benthic_macroinvertebrate_results.data_dictionary_ceden_benthic_data

12.51 kB
67 rows
4 columns


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