Baselight
Sign In

Surface Water - Aquatic Organism Tissue Sample Results

State of California

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results

Loading...
Loading...

About this Dataset

Surface Water - Aquatic Organism Tissue Sample Results

This data set provides results of tissue from organisms found in surface waters, from the California Environmental Data Exchange Network (CEDEN). The data are of tissue from individual organisms and of composite samples where tissue samples from multiple organisms are combined and then analyzed. Both the individual samples and the composite sample results may be given so for individual samples, there will be a row for the individual sample and a row for the composite where the number per composite is one.

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-09-23T12:44:04.200106
Tags: assessment, benthic, bioaccumulation, bioassessment, bivalves, ceden, containment, fish, organisms, pollutant, sediment, surface-water, taxonomy, tissue, water-quality

Tables

CEDEN Tissue Data Prior To 2000

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.ceden_tissue_data_prior_to_2000
  • 27.59 MB
  • 612,656 rows
  • 124 columns
Loading... 
CREATE TABLE ceden_tissue_data_prior_to_2000 (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2000 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2000_ceden_tissue_data
  • 2.4 MB
  • 59,263 rows
  • 124 columns
Loading... 
CREATE TABLE n_2000_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2001 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2001_ceden_tissue_data
  • 2.18 MB
  • 106,042 rows
  • 124 columns
Loading... 
CREATE TABLE n_2001_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2002 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2002_ceden_tissue_data
  • 2.01 MB
  • 82,805 rows
  • 124 columns
Loading... 
CREATE TABLE n_2002_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2003 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2003_ceden_tissue_data
  • 2.29 MB
  • 125,808 rows
  • 124 columns
Loading... 
CREATE TABLE n_2003_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2004 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2004_ceden_tissue_data
  • 1.65 MB
  • 95,281 rows
  • 124 columns
Loading... 
CREATE TABLE n_2004_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" DOUBLE,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2005 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2005_ceden_tissue_data
  • 2.7 MB
  • 55,998 rows
  • 124 columns
Loading... 
CREATE TABLE n_2005_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" DOUBLE,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2006 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2006_ceden_tissue_data
  • 3.21 MB
  • 129,001 rows
  • 124 columns
Loading... 
CREATE TABLE n_2006_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2007 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2007_ceden_tissue_data
  • 6.02 MB
  • 240,747 rows
  • 124 columns
Loading... 
CREATE TABLE n_2007_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" VARCHAR,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2008 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2008_ceden_tissue_data
  • 2.68 MB
  • 147,613 rows
  • 124 columns
Loading... 
CREATE TABLE n_2008_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" VARCHAR,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2009 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2009_ceden_tissue_data
  • 3.96 MB
  • 259,338 rows
  • 124 columns
Loading... 
CREATE TABLE n_2009_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2010 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2010_ceden_tissue_data
  • 3.18 MB
  • 146,465 rows
  • 124 columns
Loading... 
CREATE TABLE n_2010_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" VARCHAR,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" VARCHAR,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2011 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2011_ceden_tissue_data
  • 1.63 MB
  • 93,256 rows
  • 124 columns
Loading... 
CREATE TABLE n_2011_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2012 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2012_ceden_tissue_data
  • 1.34 MB
  • 55,925 rows
  • 124 columns
Loading... 
CREATE TABLE n_2012_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2014 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2014_ceden_tissue_data
  • 2.11 MB
  • 139,073 rows
  • 124 columns
Loading... 
CREATE TABLE n_2014_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" VARCHAR,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" VARCHAR,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" VARCHAR,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2015 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2015_ceden_tissue_data
  • 992.95 kB
  • 39,463 rows
  • 124 columns
Loading... 
CREATE TABLE n_2015_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" VARCHAR,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" VARCHAR,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2016 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2016_ceden_tissue_data
  • 1.78 MB
  • 123,557 rows
  • 124 columns
Loading... 
CREATE TABLE n_2016_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" VARCHAR,
  "compositelongitude" VARCHAR,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" VARCHAR,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2018 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2018_ceden_tissue_data
  • 1.73 MB
  • 62,793 rows
  • 124 columns
Loading... 
CREATE TABLE n_2018_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" VARCHAR,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" VARCHAR,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2020 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2020_ceden_tissue_data
  • 1.63 MB
  • 68,880 rows
  • 124 columns
Loading... 
CREATE TABLE n_2020_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2021 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2021_ceden_tissue_data
  • 1.65 MB
  • 91,908 rows
  • 124 columns
Loading... 
CREATE TABLE n_2021_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2022 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2022_ceden_tissue_data
  • 1.86 MB
  • 86,766 rows
  • 124 columns
Loading... 
CREATE TABLE n_2022_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR  -- WeightAvg(g),
  "tlmax_mm" VARCHAR  -- TLMax(mm),
  "tlavglength_mm" VARCHAR  -- TLAvgLength(mm),
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

2023 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.n_2023_ceden_tissue_data
  • 962.87 kB
  • 41,509 rows
  • 124 columns
Loading... 
CREATE TABLE n_2023_ceden_tissue_data (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" DOUBLE  -- WeightAvg(g),
  "tlmax_mm" DOUBLE  -- TLMax(mm),
  "tlavglength_mm" DOUBLE  -- TLAvgLength(mm),
  "compsizecheck" DOUBLE,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE  -- SampleDateRange(Days),
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" DOUBLE,
  "totallength" DOUBLE,
  "lengthsource" VARCHAR,
  "organismweight" DOUBLE,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

Share link

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