About this Dataset

Surface Water - Chemistry Results - CEDEN Augmentation

This dataset includes field and lab chemistry data that has been submitted to the California Environmental Data Exchange Network (CEDEN), but has not been loaded into the CEDEN database. It is a subset of the chemistry data that has been submitted to CEDEN since approximately December 2020, and supplements the data found in both the main Surface Water - Chemistry Results dataset and the CEDEN Query Tool (i.e., this augmentation data is not included in the data available from either of those sources). For consistency, many of the conditions applied to the other CEDEN data found on this portal and in the CEDEN query tool are also applied to this supplemental dataset (e.g., no rejected data or replicates are included). However, this supplemental data is provisional and may not reflect all of the QA/QC controls applied to the regular CEDEN data.

This dataset also contains two provisionally assigned values (“DataQuality” and “DataQualityIndicator”) to help users interpret the data quality metadata provided with the associated result (like the main Surface Water - Chemistry Results dataset referenced above).
Organization: State of California
Last updated: 2025-09-23T12:38:30.967037
Tags: assessment, benthic, bioassessment, ceden, contaminant, fish, organisms, pollutant, sediment, surface-water, taxonomy, water-quality

Tables

CEDEN Augmentation - Field & Lab Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results_ceden_augmentation_adbd6.ceden_augmentation_field_lab_chemistry_data

16.99 MB
1,777,955 rows
72 columns

CREATE TABLE ceden_augmentation_field_lab_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "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,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" DOUBLE,
  "expectedvalue" DOUBLE,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" BIGINT,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "hydromod" VARCHAR,
  "hydromodloc" VARCHAR,
  "locationdetailwqcomments" VARCHAR,
  "channelwidth" VARCHAR,
  "upstreamlength" VARCHAR,
  "downstreamlength" VARCHAR,
  "totalreach" VARCHAR,
  "locationdetailbacomments" VARCHAR,
  "sampleid" VARCHAR,
  "dw_analytename" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

Data Dictionary - CEDEN Augmentation - Field & Lab Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results_ceden_augmentation_adbd6.n__dictionary_ceden_augmentation_field_lab_chemistry

15.55 kB
72 rows
4 columns

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