Surface Water - Fecal Indicator Bacteria Monitoring Results

Description

This dataset contains fecal indicator bacteria (FIB) monitoring results collected from surface waters across California. 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. 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](https://mywaterquality.ca.gov/safe-to-swim/content/interactive_map/index.html), 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](https://ceden.org/) (CEDEN) database, BeachWatch database, and the Central Valley Water Board [Lower American River Recreational Water Quality Map](https://experience.arcgis.com/experience/47e27f245e044ac2a8e15083307e75f6/?draft=true&org=waterboards). There is some overlap with the [CEDEN Water Chemistry dataset](https://data.ca.gov/dataset/surface-water-chemistry-results). Both portal datasets draw from the same source, but the resources here are updated more frequently to support the Safe to Swim map.

Resources

Name Format Description Link
Fecal Indicator Bacteria Monitoring Results - 2010-2020 CSV safetoswim_geomeans_2010-2020.csv Open resource
Safe to Swim Results/Geomeans 2010-2020 CSV safetoswim_geomeans_2010-2020.csv Open resource
Fecal Indicator Bacteria Monitoring Results - 2020 to present CSV safetoswim_geomeans_2020-present.csv Open resource
Safe to Swim 1969-2010 (no longer updated) CSV This data resource will no longer be updated. Please use "Safe to Swim Results/Geomeans before 2010" resource instead. Open resource
Safe to Swim 2020-present CSV safetoswim_2020-present_2024-04-26.csv Open resource
Safe to Swim 2020-present CSV safetoswim_2020-present_2024-11-26.csv Open resource
Safe to Swim 2020-present (no longer updated) CSV This data resource will no longer be updated. Please use "Safe to Swim Results/Geomeans 2020 to present" resource instead. Open resource
Fecal Indicator Bacteria Monitoring Results - before 2010 CSV safetoswim_geomeans_before-2010.csv Open resource
Safe to Swim prior to 2010 (No longer updated) CSV This resource is no longer being updated. Please use this resource instead: https://data.ca.gov/dataset/surface-water-fecal-indicator-bacteria-results/resource/18c57345-bf87-4c46-b358-b634d36be4d2 Open resource
Safe to Swim 2010-present (No longer updated) CSV This resource is no longer being updated. Please use the following resources instead: 1. https://data.ca.gov/dataset/surface-water-fecal-indicator-bacteria-results/resource/7639446f-8c62-43d9-a526-8bc7952dd8bd, 2. https://data.ca.gov/dataset/surface-water-fecal-indicator-bacteria-results/resource/1987c159-ce07-47c6-8d4f-4483db6e6460 Open resource
Sites for Safe to Swim (No longer updated) CSV This resource is no longer being updated. Please use this resource instead: https://data.ca.gov/dataset/surface-water-fecal-indicator-bacteria-results/resource/848d2e3f-2846-449c-90e0-9aaf5c45853e Open resource
Data Dictionary of CEDEN Water Chemistry Data PDF data-dictionary-of-ceden-water-chemistry-data.pdf Open resource
Fecal Indicator Bacteria Monitoring Results - Data Dictionary PDF safe-to-swim_data-dictionary_2025-11-06.pdf Open resource
Safe to Swim 2010-2020 (no longer updated) CSV This data resource will no longer be updated. Please use "Safe to Swim Results/Geomeans 2010-2020" resource instead. Open resource
Fecal Indicator Bacteria Monitoring Results - Excluded Records CSV This dataset contains monitoring records that were excluded during the data processing workflow for the [Safe to Swim map](https://mywaterquality.ca.gov/safe-to-swim/content/interactive_map/). These records 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. The purpose of publishing this dataset is to promote transparency in how data is handled and to provide users with access to the full context of the data processing decisions. Each record includes a value in the "Comments" column that explains the reason for exclusion. If you believe a record was excluded in error and should be reconsidered for inclusion, please contact us for review. Open resource
Monitoring sites for Safe to Swim CSV safetoswim_sites_2024-04-26.csv Open resource
Monitoring sites for Safe to Swim CSV safetoswim_sites_2024-11-26.csv Open resource
Monitoring sites for Safe to Swim (no longer updated) CSV This data resource will no longer be updated. Open resource
Data Dictionary - Safe to Swim Results/Geomeans 2010-2020 CSV Data Dictionary for https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/04d98c22-5523-4cc1-86e7-3a6abf40bb60/download/safetoswim_geomeans_2010-2020.csv Open resource
Data Dictionary - Fecal Indicator Bacteria Monitoring Results - 2020 to present CSV Data Dictionary for https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/15a63495-8d9f-4a49-b43a-3092ef3106b9/download/safetoswim_geomeans_2020-present.csv Open resource
Data Dictionary - Safe to Swim 2020-present CSV Data Dictionary for https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/1987c159-ce07-47c6-8d4f-4483db6e6460/download/safetoswim_2020-present_2024-11-26.csv Open resource
Data Dictionary - Safe to Swim Results/Geomeans before 2010 CSV Data Dictionary for https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/1d333989-559a-433f-b93f-bb43d21da2b9/download/safetoswim_geomeans_before-2010.csv Open resource
Data Dictionary - Monitoring sites for Safe to Swim CSV Data Dictionary for https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/848d2e3f-2846-449c-90e0-9aaf5c45853e/download/safetoswim_sites_2024-11-26.csv Open resource

Tags

Topics

Categories