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
8 safetoswim_sites_2024-04-26.csv https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/848d2e3f-2846-449c-90e0-9aaf5c45853e/download/safetoswim_sites_2024-04-26.csv
8 This data resource will no longer be updated. Please use "Safe to Swim Results/Geomeans 2010-2020" resource instead. https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/7639446f-8c62-43d9-a526-8bc7952dd8bd/download/safetoswim_2010-2020_2024-03-12.csv
8 safetoswim_2020-present_2024-04-26.csv https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/1987c159-ce07-47c6-8d4f-4483db6e6460/download/safetoswim_2020-present_2024-04-26.csv
8 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 https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/270c628e-e0cd-42ab-b694-3f01c9b29559/download/safetoswim_before2010_2022-02-22.csv
33 data-dictionary-of-ceden-water-chemistry-data.pdf https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/5e8e1314-6511-4447-a392-5be07c821e92/download/data-dictionary-of-ceden-water-chemistry-data.pdf
8 safetoswim_2020-present_2024-11-26.csv https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/1987c159-ce07-47c6-8d4f-4483db6e6460/download/safetoswim_2020-present_2024-11-26.csv
8 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 https://data.ca.gov/datastore/dictionary_download/1987c159-ce07-47c6-8d4f-4483db6e6460
8 safetoswim_sites_2024-11-26.csv https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/848d2e3f-2846-449c-90e0-9aaf5c45853e/download/safetoswim_sites_2024-11-26.csv
8 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 https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/4f41c529-a33f-4006-9cfc-71b6944cb951/download/sites_for_safetoswim_2022-02-22.csv
8 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 https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/442a2628-92bd-4d83-aab6-6fde5eeeb56c/download/safetoswim_after2010_2022-02-22.csv
8 This data resource will no longer be updated. Please use "Safe to Swim Results/Geomeans before 2010" resource instead. https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/18c57345-bf87-4c46-b358-b634d36be4d2/download/safetoswim_1969-2010_2024-03-12.csv
8 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 https://data.ca.gov/datastore/dictionary_download/848d2e3f-2846-449c-90e0-9aaf5c45853e
8 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 https://data.ca.gov/datastore/dictionary_download/15a63495-8d9f-4a49-b43a-3092ef3106b9
8 safetoswim_geomeans_2010-2020.csv https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/04d98c22-5523-4cc1-86e7-3a6abf40bb60/download/safetoswim_geomeans_2010-2020.csv
8 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 https://data.ca.gov/datastore/dictionary_download/04d98c22-5523-4cc1-86e7-3a6abf40bb60
8 safetoswim_geomeans_before-2010.csv https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/1d333989-559a-433f-b93f-bb43d21da2b9/download/safetoswim_geomeans_before-2010.csv
8 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 https://data.ca.gov/datastore/dictionary_download/1d333989-559a-433f-b93f-bb43d21da2b9
8 This data resource will no longer be updated. https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/848d2e3f-2846-449c-90e0-9aaf5c45853e/download/safetoswim_sites_2025-03-25.csv
8 This data resource will no longer be updated. Please use "Safe to Swim Results/Geomeans 2020 to present" resource instead. https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/1987c159-ce07-47c6-8d4f-4483db6e6460/download/safetoswim_2020-present_2025-03-25.csv
8 safetoswim_geomeans_2020-present.csv https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/15a63495-8d9f-4a49-b43a-3092ef3106b9/download/safetoswim_geomeans_2020-present.csv
8 safetoswim_geomeans_2010-2020.csv https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/04d98c22-5523-4cc1-86e7-3a6abf40bb60/download/safetoswim_geomeans_2010-2020.csv
8 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. https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/81dd9a2f-0f19-4e7d-bd74-7fff848f5aa4/download/safetoswim_excluded_records.csv
33 safe-to-swim_data-dictionary_2025-11-06.pdf https://data.ca.gov/dataset/6723ab78-4530-4e97-ba5e-6ffd17a4c139/resource/5e8e1314-6511-4447-a392-5be07c821e92/download/safe-to-swim_data-dictionary_2025-11-06.pdf

Tags

  • ceden

Topics

Categories