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 | data-dictionary-of-ceden-water-chemistry-data.pdf | Open resource | |
| Fecal Indicator Bacteria Monitoring Results - Data Dictionary | 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 |