Beach Lab Data
City of Chicago
@usgov.city_of_chicago_beach_lab_data
City of Chicago
@usgov.city_of_chicago_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.
CREATE TABLE table_1 (
"dna_test_id" DOUBLE,
"dna_sample_timestamp" VARCHAR,
"beach" VARCHAR,
"dna_sample_1_reading" DOUBLE,
"dna_sample_2_reading" DOUBLE,
"dna_reading_mean" DOUBLE,
"culture_test_id" DOUBLE,
"culture_sample_1_timestamp" VARCHAR,
"culture_sample_1_reading" DOUBLE,
"culture_sample_2_reading" DOUBLE,
"culture_reading_mean" DOUBLE,
"culture_note" VARCHAR,
"culture_sample_interval" DOUBLE,
"culture_sample_2_timestamp" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"location" VARCHAR
);Anyone who has the link will be able to view this.