Beach Lab Data

data.cityofchicago.org | Last Updated 19 Nov 2018

The Chicago Park District collects and analyzes water samples from beaches along Chicago’s Lake Michigan lakefront. The Chicago Park District partners with the University of Illinois at Chicago Department of Public Health Laboratory to analyze water samples using a new DNA testing method called Rapid Testing Method (qPCR analysis) which tests for Enterococci in order to monitor swimming safety. The rapid testing method (qPCR analysis) is a new method that measures levels of pathogenic DNA in beach water. Unlike the culture based test that requires up to 24 hours of processing, the new rapid testing method requires a 4-5 hours for results. The Chicago Park District can use results of the rapid test to notify the public when levels exceed UPEPA recommended levels, which is 1000* CCE. When DNA bacteria levels exceed 1000 CCE, a yellow swim advisory flag is implemented. For more information please refer to the USEPA Recreational Water Quality Criteria (http://water.epa.gov/scitech/swguidance/standards/criteria/health/recreation). Historically, the Chicago Park District used the culture based analysis method and statistical prediction models to monitor beach water quality. The culture based method tests for Escherichia coli (E. coli) bacteria which is an indicator species for the presence of disease-causing bacteria, viruses, and protozoans that may pose health risks to the public. This method requires 18-24 hours of processing to receive results. The Chicago Park District would use results of the culture based method to notify the public when levels exceed UPEPA recommended levels, which is 235* CFU. When bacteria levels exceed 235 CFU, a yellow swim advisory flag was implemented. This standard is still used at most beaches throughout the Great Lakes region. For more information please refer to the USEPA Recreational Water Quality Criteria. The statistical prediction model forecasted real-time Escherichia coli (E. coli) bacteria levels present in the water. The Chicago Park District (CPD) in partnership with the US Geological Survey, developed statistical prediction models by using weather data pulled from CPD buoys (https://data.cityofchicago.org/d/qmqz-2xku) and weather stations (https://data.cityofchicago.org/d/k7hf-8y75). The Chicago Park District would use results of the predictive model to notify the public when bacteria levels would exceed 235 CFU. When bacteria levels exceed 235 CFU, a yellow swim advisory flag was implemented. * The unit of measurement for Escherichia coli is Colony Forming Units (CFU) per 100 milliliters of water. (Culture Based Method / Statistical Prediction Model) *The unit of measuring DNA is Enterococci Calibrator Cell Equivalents (CCE) per 100 milliliters of water. (Rapid Testing Analysis)

Tags: beaches, parks, chicago park district, open spaces, parks & recreation, recreation, water

This dataset has the following 17 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
DNA Test IDdna_test_idtextUnique ID for a DNA test on one or two water samples taken from the same beach on the same day.
DNA Sample Timestampdna_sample_timestampcalendar_dateDate and time when the water sample for DNA testing was taken.
Beachbeachtext
DNA Sample 1 Readingdna_sample_1_readingnumberEnterococci calibrator cell equivalents (CCE) per 100 ml of water
DNA Sample 2 Readingdna_sample_2_readingnumberEnterococci calibrator cell equivalents (CCE) per 100 ml of water
DNA Reading Meandna_reading_meannumberThe geometric mean of the DNA Sample 1 Reading and the DNA Sample 2 Reading (if any).
Culture Test IDculture_test_idtextUnique ID for a culture test on one or two water samples taken from the same beach on the same day.
Culture Sample 1 Timestampculture_sample_1_timestampcalendar_dateDate and time when the first water sample for culture was taken. Prior to 2016, the time is not available.
Culture Sample 1 Readingculture_sample_1_readingnumberColony Forming Units (CFU) per 100 ml of water
Culture Sample 2 Readingculture_sample_2_readingnumberColony Forming Units (CFU) per 100 ml of water
Culture Reading Meanculture_reading_meannumberThe geometric mean of Culture Sample 1 Reading and Culture Sample 2 Reading (if any).
Culture Noteculture_notetextNotes on the culture tests.
Culture Sample Intervalculture_sample_intervalnumberTime in minutes between collection of the two samples for culture testing.
Culture Sample 2 Timestampculture_sample_2_timestampcalendar_dateDate and time when the second water sample for culture was taken.
Latitudelatitudenumber
Longitudelongitudenumber
Locationlocationlocation