Monitoring of Indicator Bacteria in Drinking Water

Public Utilities Updated Apr 17, 2026 Daily

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

Data Downloads

File name Download actions File Format File size
Latest Drinking Water Tests (Bacteria) Download

Copy URL

CSV

2.59 KB

All Drinking Water Tests (Bacteria) Download

Copy URL

CSV

5.69 MB

View a data sample

Showing 1 transposed sample row. Download the full dataset or a view to get the data.

Data Sample

Data preview - first row of dataset transposed
Field Sample Value
date_sampled2026-04-16
source185 SYS
sample_idW1904450
t_coliform
cl2_total3.1
e_coli
temperature20.4
ph8.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 dictionary

Data Dictionary

Data dictionary - field definitions for this dataset
FieldDescriptionPossible_values
sample_dateDate sample was taken
site_IDUnique identifier for the sample site
temp_celsiusTemperature in Celsius
chlorineChlorine in mg/l or ppm
pHpH of water sample0-14
coliformPresence of Coliform indicator bacteriaA-Absent, P-Present
E.coliPresence of E.coli indicator bacteriaA-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