Surface Water - Benthic Macroinvertebrate Results
Data collected for marine benthic infauna, freshwater benthic macroinvertebrate (BMI), algae, bacteria and diatom taxonomic analyses, from the California Environmental Data Exchange Network (CEDEN). Note bacteria single species concentrations are stored within the chemistry template, whereas abundance bacteria are stored within this set. Each record represents a result from a specific event location for a single organism in a single sample. The data set 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 "CEDEN Benthic Data" (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 |
|---|---|---|---|
CEDEN Benthic Data | Download | CSV 592.76 MB | 08/10/19 |
CEDEN Benthic Data (Zipped CSV) Zipped CSV file containing all benthic data from the California Environmental Data Exchange Network (CEDEN). | Download | ZIP 59.01 MB | 01/13/21 |
CEDEN Benthic Data (Parquet File Format) This resource contains all benthic macroinvertebrate 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 56.74 MB | 02/09/21 |
Supporting files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
CEDEN Benthic Data Dictionary | Download | PDF | 08/10/19 |