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

CEDEN Habitat Data Prior To 2000

@usgov.ca_gov_surface_water_habitat_results.ceden_habitat_data_prior_to_2000

1.03 MB
122,039 rows
49 columns

CREATE TABLE ceden_habitat_data_prior_to_2000 (
  "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
);

Data Dictionary - 2000 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2000_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2001 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2001_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2002 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2002_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2003 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2003_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2004 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2004_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2005 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2005_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2006 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2006_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2007 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2007_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2008 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2008_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2009 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2009_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2010 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2010_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2011 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2011_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2012 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2012_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2013 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2013_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2014 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2014_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2015 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2015_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2016 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2016_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2017 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2017_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2018 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2018_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2019 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2019_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2020 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2020_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2021 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2021_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2022 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2022_ceden_habitat_data

10.55 kB
49 rows
4 columns

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

Data Dictionary - 2023 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2023_ceden_habitat_data

10.55 kB
49 rows
4 columns

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