About this Dataset

Surface Water - Habitat Results

This data provides results from field analyses, from the California Environmental Data Exchange Network (CEDEN). The data set contains two provisionally assigned values (“DataQuality” and “DataQualityIndicator”) to help users interpret the data quality metadata provided with the associated result.

Due to file size limitations, the data has been split into individual resources by year. The entire dataset can also be downloaded in bulk using the zip files on this page (in csv format or parquet format), and developers can also use the API associated with each year's dataset 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-07-23T14:47:30.412228
Tags: ceden, physical-habitat, water

Tables

2022 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2022_ceden_habitat_data

7.83 MB
795,337 rows
49 columns

CREATE TABLE n_2022_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "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,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2023 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2023_ceden_habitat_data

7.7 MB
722,936 rows
49 columns

CREATE TABLE n_2023_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2024 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2024_ceden_habitat_data

7.74 MB
755,241 rows
49 columns

CREATE TABLE n_2024_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "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,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);