Surface Water - Toxicity Results
Surface water toxicity data from the California Environmental Data Exchange Network (CEDEN). CEDEN is the California State Water Board's data system for surface water quality in California, and seeks to include all available statewide data (such as that produced by research and volunteer organizations). Data in CEDEN include field, sediment and water column data collected from freshwater, estuarine, and marine environments. Examples of data in CEDEN come from laboratory, physical and biological analyses and include data types associated with chemical, toxicological, field, bio-assessment, invertebrate, fish, and bacteriological assay assessments. The data resource "Surface Water Toxicity" contains two provisionally assigned values (“DataQuality” and “DataQualityIndicator”) to help users interpret the data quality metadata provided with the associated result. Zip files are provided for bulk data downloads (in csv or parquet file format), and developers can use the API associated with the "Surface Water Toxicity" (csv) resource to access the data. Example R code using the API to access the data can be found [here](https://gist.github.com/daltare/6185457d3d81ea59fe7c1730a7e40318). Users who want to manually download more specific subsets of the data can also use the CEDEN query tool, at: https://ceden.waterboards.ca.gov/AdvancedQueryTool
Data files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
Surface Water Toxicity | Download | CSV 1.20 GB | 08/10/19 |
Surface Water Toxicity - Summary Results <p>This resource is a subset of records from the CEDEN Toxicity database, filtered to contain only summary records. Summary records are entries in the database that summarize the results from multiple replicate toxicity tests of the same sample water. The replicate results are available in the <a href="https://data.ca.gov/dataset/surface-water-toxicity-results/resource/ad4d81fa-61d4-4660-8b70-cbbb3ddaa9b1">Surface Water Toxicity - Replicate Results</a> resource.</p> <p>The date appended to the end of the filename (YYYY-MM-DD) indicates when the data were last refreshed from the CEDEN database.</p> | Download | CSV 78.20 MB | 08/10/19 |
Surface Water Toxicity - Replicate Results <p>This resource is a subset of records from the CEDEN Toxicity database, filtered to contain only replicate records. Replicate records are entries in the database that indicate the result of a single toxicity test for a water sample, and each water sample typically includes several replicate records. The replicate records for a particular water sample are then assessed and reported in a single summary record, and these summary records are available in the <a href="https://data.ca.gov/dataset/surface-water-toxicity-results/resource/2b8215bb-2b6e-4d1c-8234-f50edfe487ee">Surface Water Toxicity - Summary Results</a> resource.</p> <p>The date appended to the end of this filename (YYYY-MM-DD) indicates when the data were last refreshed from the CEDEN database.</p> | Download | CSV 961.41 MB | 08/10/19 |
Surface Water Toxicity (Zipped CSV) Zipped CSV file containing all toxicity data from the California Environmental Data Exchange Network (CEDEN). | Download | ZIP 55.60 MB | 01/13/21 |
CEDEN Toxicity Data (Parquet File Format) This resource contains all toxicity data available from the CEDEN database, in the [Apache Parquet file format]((https://parquet.apache.org/)). The data is partitioned by year. Parquet is a free and open source data storage format that allows for fast and efficient processing of large datasets. It is compatible with a variety of data analysis platforms, including the R and Python programming languages, through the [Apache Arrow platform](https://arrow.apache.org/). An example showing how to use this data with the R programming language is available [here](https://gist.github.com/daltare/209acf0789b4f1bdec272c323ba45315). | Download | ZIP 35.91 MB | 02/09/21 |