Baselight
Sign In

Surface Water - Chemistry Results

State of California

@usgov.ca_gov_surface_water_chemistry_results

Loading...
Loading...

About this Dataset

Surface Water - Chemistry Results

This data provides results from the California Environmental Data Exchange Network (CEDEN) for field and lab chemistry analyses. 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.

NOTE: Some of the field and lab chemistry data that has been submitted to CEDEN since 2020 has not been loaded into the CEDEN database. That data is not included in this data set (and is also not available via the CEDEN query tool described above), but is available as a supplemental data set available here: Surface Water - Chemistry Results - CEDEN Augmentation. For consistency, many of the conditions applied to the data in this dataset and in the CEDEN query tool are also applied to that supplemental dataset (e.g., no rejected data or replicates are included), but that supplemental data is provisional and may not reflect all of the QA/QC controls applied to the regular CEDEN data available here.
Organization: State of California
Last updated: 2025-10-23T12:52:21.365815
Tags: assessment, benthic, bioassessment, bivalves, ceden, contaminant, fish, monitoring, organisms, pollutant, sediment, surface-water, taxonomy, water-quality, water-quality-monitoring

Tables

CEDEN Water Chemistry Data Prior To 2000

@usgov.ca_gov_surface_water_chemistry_results.ceden_water_chemistry_data_prior_to_2000
  • 22.41 MB
  • 1,334,873 rows
  • 79 columns
Loading... 
CREATE TABLE ceden_water_chemistry_data_prior_to_2000 (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2000 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2000_ceden_water_chemistry_data
  • 3.05 MB
  • 204,877 rows
  • 79 columns
Loading... 
CREATE TABLE n_2000_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2001 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2001_ceden_water_chemistry_data
  • 4.76 MB
  • 277,868 rows
  • 79 columns
Loading... 
CREATE TABLE n_2001_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2002 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2002_ceden_water_chemistry_data
  • 8.08 MB
  • 401,629 rows
  • 79 columns
Loading... 
CREATE TABLE n_2002_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2003 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2003_ceden_water_chemistry_data
  • 9.21 MB
  • 454,310 rows
  • 79 columns
Loading... 
CREATE TABLE n_2003_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2004 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2004_ceden_water_chemistry_data
  • 8.66 MB
  • 428,691 rows
  • 79 columns
Loading... 
CREATE TABLE n_2004_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2005 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2005_ceden_water_chemistry_data
  • 12.03 MB
  • 564,397 rows
  • 79 columns
Loading... 
CREATE TABLE n_2005_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2006 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2006_ceden_water_chemistry_data
  • 10.4 MB
  • 522,557 rows
  • 79 columns
Loading... 
CREATE TABLE n_2006_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2007 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2007_ceden_water_chemistry_data
  • 11.86 MB
  • 578,951 rows
  • 79 columns
Loading... 
CREATE TABLE n_2007_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2008 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2008_ceden_water_chemistry_data
  • 16.14 MB
  • 822,983 rows
  • 79 columns
Loading... 
CREATE TABLE n_2008_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2009 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2009_ceden_water_chemistry_data
  • 12.21 MB
  • 512,112 rows
  • 79 columns
Loading... 
CREATE TABLE n_2009_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2010 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2010_ceden_water_chemistry_data
  • 15.25 MB
  • 603,024 rows
  • 79 columns
Loading... 
CREATE TABLE n_2010_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2011 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2011_ceden_water_chemistry_data
  • 16.64 MB
  • 642,356 rows
  • 79 columns
Loading... 
CREATE TABLE n_2011_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2012 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2012_ceden_water_chemistry_data
  • 19.92 MB
  • 944,897 rows
  • 79 columns
Loading... 
CREATE TABLE n_2012_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2013 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2013_ceden_water_chemistry_data
  • 21.66 MB
  • 1,044,884 rows
  • 79 columns
Loading... 
CREATE TABLE n_2013_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2014 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2014_ceden_water_chemistry_data
  • 21.12 MB
  • 949,522 rows
  • 79 columns
Loading... 
CREATE TABLE n_2014_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2015 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2015_ceden_water_chemistry_data
  • 18.93 MB
  • 997,893 rows
  • 79 columns
Loading... 
CREATE TABLE n_2015_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2016 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2016_ceden_water_chemistry_data
  • 22.15 MB
  • 1,195,250 rows
  • 79 columns
Loading... 
CREATE TABLE n_2016_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2017 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2017_ceden_water_chemistry_data
  • 23.02 MB
  • 898,346 rows
  • 79 columns
Loading... 
CREATE TABLE n_2017_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2018 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2018_ceden_water_chemistry_data
  • 22.31 MB
  • 762,879 rows
  • 79 columns
Loading... 
CREATE TABLE n_2018_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2019 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2019_ceden_water_chemistry_data
  • 17.95 MB
  • 605,151 rows
  • 79 columns
Loading... 
CREATE TABLE n_2019_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2020 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2020_ceden_water_chemistry_data
  • 8.38 MB
  • 286,017 rows
  • 79 columns
Loading... 
CREATE TABLE n_2020_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2021 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2021_ceden_water_chemistry_data
  • 10.95 MB
  • 516,836 rows
  • 79 columns
Loading... 
CREATE TABLE n_2021_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" VARCHAR,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2022 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2022_ceden_water_chemistry_data
  • 9.93 MB
  • 479,916 rows
  • 79 columns
Loading... 
CREATE TABLE n_2022_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2023 CEDEN Water Chemistry Data

@usgov.ca_gov_surface_water_chemistry_results.n_2023_ceden_water_chemistry_data
  • 11.15 MB
  • 538,847 rows
  • 79 columns
Loading... 
CREATE TABLE n_2023_ceden_water_chemistry_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "collectiondepth" DOUBLE,
  "unitcollectiondepth" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "resultsreplicate" DOUBLE,
  "labbatch" VARCHAR,
  "labsampleid" VARCHAR,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "observation" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "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" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "positionwatercolumn" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "dilutionfactor" VARCHAR,
  "expectedvalue" VARCHAR,
  "labagency" VARCHAR,
  "submittingagency" VARCHAR,
  "submissioncode" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "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,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

Share link

Anyone who has the link will be able to view this.