cityofchicago/beach-lab-data-2ivx-z93u
 
Readme
Updated 5 months ago
Indexed 15 minutes ago

Beach Lab Data

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)

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
DNA Test IDdna_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 2 Readingdna_sample_2_readingdna_sample_2_readingNumberEnterococci calibrator cell equivalents (CCE) per 100 ml of water
LongitudelongitudelongitudeNumber
LocationlocationlocationPoint
Culture Sample 2 Timestampculture_sample_2_timestampculture_sample_2_timestampCalendar dateDate and time when the second water sample for culture was taken.
Culture Noteculture_noteculture_noteTextNotes on the culture tests.
Culture Reading Meanculture_reading_meanculture_reading_meanNumberThe geometric mean of Culture Sample 1 Reading and Culture Sample 2 Reading (if any).
DNA Reading Meandna_reading_meandna_reading_meanNumberThe geometric mean of the DNA Sample 1 Reading and the DNA Sample 2 Reading (if any).
Culture Sample 1 Timestampculture_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.
DNA Sample Timestampdna_sample_timestampdna_sample_timestampCalendar dateDate and time when the water sample for DNA testing was taken.
Culture Sample Intervalculture_sample_intervalculture_sample_intervalNumberTime in minutes between collection of the two samples for culture testing.
Culture Sample 2 Readingculture_sample_2_readingculture_sample_2_readingNumberColony Forming Units (CFU) per 100 ml of water
Zip Codes:@computed_region_6mkv_f3dw:@computed_region_6mkv_f3dwNumber
Boundaries - ZIP Codes:@computed_region_rpca_8um6:@computed_region_rpca_8um6Number
Wards:@computed_region_43wa_7qmu:@computed_region_43wa_7qmuNumber
Location (zip)location_ziplocation_zipText
Community Areas:@computed_region_vrxf_vc4k:@computed_region_vrxf_vc4kNumber
Census Tracts:@computed_region_bdys_3d7i:@computed_region_bdys_3d7iNumber
LatitudelatitudelatitudeNumber
DNA Sample 1 Readingdna_sample_1_readingdna_sample_1_readingNumberEnterococci calibrator cell equivalents (CCE) per 100 ml of water
Location (address)location_addresslocation_addressText
Location (city)location_citylocation_cityText
Location (state)location_statelocation_stateText
Culture Sample 1 Readingculture_sample_1_readingculture_sample_1_readingNumberColony Forming Units (CFU) per 100 ml of water
Culture Test IDculture_test_idculture_test_idTextUnique ID for a culture test on one or two water samples taken from the same beach on the same day.
BeachbeachbeachText
Upstream Metadata