Table · dataset · 2019
Surface Water - Fecal Indicator Bacteria Monitoring Results
Listed in California Open Data
This dataset contains fecal indicator bacteria (FIB) monitoring results collected from surface waters across California.
Description
It includes results for _Escherichia coli_ (E. coli), enterococci, fecal coliforms, and total coliforms - key indicators used to assess microbial water quality and potential health risks associated with recreational water use. The data has been cleaned and standardized to ensure consistency and usability.
For each valid data point, the dataset also includes calculated 6-week and 30-day geometric means, which are commonly used to evaluate long-term water quality trends and compliance with bacteria water quality objectives. Some records are excluded from the final dataset during processing. These typically include duplicate or replicate results, records with missing or invalid result values, or any data that cannot be used to calculate a geometric mean.
Read the rest (2 more)
These records are saved to the "Excluded Records" data resource. This dataset serves as the primary data source for the Water Boards My Water Quality Portal Safe to Swim Map, which provides the public with timely information about potential health risks associated with water contact recreation at monitored sites. Data is sourced from the California Environmental Data Exchange Network (CEDEN) database, BeachWatch database, and the Central Valley Water Board Lower American River Recreational Water Quality Map.
There is some overlap with the CEDEN Water Chemistry dataset. Both portal datasets draw from the same source, but the resources here are updated more frequently to support the Safe to Swim map.
Links
Get the data
- data.ca.gov /dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/15a63495… ↗
Fecal Indicator Bacteria Monitoring Results - 2020 to present
download · from data ca gov
- data.ca.gov /dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/04d98c22… ↗
Fecal Indicator Bacteria Monitoring Results - 2010-2020
download · from data ca gov
- data.ca.gov /dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/1d333989… ↗
Fecal Indicator Bacteria Monitoring Results - before 2010
download · from data ca gov
- data.ca.gov /dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/81dd9a2f… ↗
Fecal Indicator Bacteria Monitoring Results - Excluded Records
download · from data ca gov
- data.ca.gov /dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/5e8e1314… ↗
Fecal Indicator Bacteria Monitoring Results - Data Dictionary
download · from data ca gov
- data.ca.gov /dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/848d2e3f… ↗
Monitoring sites for Safe to Swim (no longer updated)
download · from data ca gov
- Safe to Swim 2020-present (no longer updated) data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/1987c159… ↗
download · from data ca gov
- Safe to Swim 2010-2020 (no longer updated) data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/7639446f… ↗
download · from data ca gov
- Safe to Swim 1969-2010 (no longer updated) data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/18c57345… ↗
download · from data ca gov
Where it is published
- California Open Data dataset page data.ca.gov/dataset/surface-water-fecal-indicator-bacteria-results ↗
landing page · from data ca gov
Catalogue records · 1
- CKAN API data.ca.gov/api/3/action/package_show?id=6723ab78-4530-4e97-ba5e-6ffd17a4c… ↗
metadata API · from data ca gov
Topics
- Stated by source
- Water
- From keywords
- Earth & Environmental Science
Provenance · 1 source records, 7 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| California Open Data | 6723ab78-4530-4e97-ba5e-6ffd17a4c139 | 9 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| concepts[field].local:field:earth-environmental | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[topic].ckan_group:data_ca_gov:water | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| created_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| description | source · data ca gov | connector:data_ca_gov@1.0.0 | /notes |
| publication_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| title | source · data ca gov | connector:data_ca_gov@1.0.0 | /title |
| updated_date | source · data ca gov | connector:data_ca_gov@1.0.0 |