Monitoring of Indicator Bacteria in Drinking Water
About this dataset
Results of tests on drinking water for indicator bacteria, including fecal coliform and E. coli
Public Utilities currently has 160 sample sites for the City of San Diego drinking water system and is required to test 85 sites per week. Temperature, chlorine and pH are measured on site, and then a sample is brought to a lab to test for the presence of the indicator bacteria coliform and E.coli. Coliform and the strains of E.coli tested serve as indicators of the presence of potentially harmful bacteria.
A positive result for coliform from one single test is not enough to constitute an MCL (Maximum Contaminant Level) violation. An acute violation occurs when a site that initially tested positive is repeat tested and either the initial sample or one of the repeat samples is positive for E. coli. A monthly MCL violation occurs if more than 5 percent of all routine and repeat tests are coliform positive. A positive coliform result from a single routine test may be due to sampling error or bacteria in the testing mechanism but not in the drinking water pipes.
Get the data
Browse the table below for all files available for this dataset
View a data sample
Showing 1 transposed sample row. Download the full dataset or a view to get the data.
Data Sample
| Field | Sample Value |
|---|---|
| date_sampled | 2026-04-16 |
| source | 185 SYS |
| sample_id | W1904450 |
| t_coliform | |
| cl2_total | 3.1 |
| e_coli | |
| temperature | 20.4 |
| ph | 8.26 |
Understand the data
Each field in the data is defined in the table below. Use this information to inform usage of the data.
Download dictionaryData Dictionary
| Field | Description | Possible_values |
|---|---|---|
| sample_date | Date sample was taken | |
| site_ID | Unique identifier for the sample site | |
| temp_celsius | Temperature in Celsius | |
| chlorine | Chlorine in mg/l or ppm | |
| pH | pH of water sample | 0-14 |
| coliform | Presence of Coliform indicator bacteria | A-Absent, P-Present |
| E.coli | Presence of E.coli indicator bacteria | A-Absent, P-Present |
- PublisherPublic Utilities
- Last Updated Apr 17, 2026
- Update Frequency Daily
- Date Issued May 11, 2016
- Available Formats .CSV
- License View License
Data & Analytics
data@sandiego.gov