Chicago

Close
Author
Jonathan Levy
Description
The Chicago Park District tests water samples at beaches along Chicago's Lake Michigan lakefront, which it tests for E. coli in order to monitor swimming safety. Multiple samples may be taken from a beach and samples may be tested by culture, DNA testing, or both. What do these numbers mean? The modeling prediction numbers forecast real-time Escherichia coli (E. coli) bacteria levels present in the water. The Chicago Park District (CPD) in partnership with the US Geological Survey, has 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). E. coli is an indicator species for the presence of disease-causing bacteria, viruses, and protozoans that may pose health risks to the public. The culture based testing numbers indicate E. coli levels present in the water. This method requires 18-24 hours of processing to receive results. US Environmental Protection Agency (USEPA) recommends notifying the public when E. coli bacteria levels are above the federal water quality Beach Action Value (BAV), which is 235*CFU. When bacteria levels exceed 235 CFU, a yellow or red flag will be implemented. This standard is used at beaches throughout the Great Lakes region. For more information please refer to the USEPA Recreational Water Quality Criteria. 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 few hours for results. The Chicago Park District can use results of the rapid test to notify the public when levels exceed UPEPA recommended levels. US Environmental Protection Agency (USEPA) recommends notifying the public when DNA bacteria levels are above the federal water quality Beach Action Value (BAV), which is 1000*CCE. When DNA bacteria levels exceed 1000 CCE, a yellow or red flag will be implemented. For more information please refer to the USEPA Recreational Water Quality Criteria (http://water.epa.gov/scitech/swguidance/standards/criteria/health/recreation). * The unit of measurement for Escherichia coli is Colony Forming Units (CFU) per 100 milliliters of water. *The unit of measuring DNA is Enterococci Calibrator Cell Equivalents (CCE) per 100 milliliters of water.
Category
Parks & Recreation
Tags
beaches, parks, chicago park district, open spaces, parks & recreation, recreation, water
Rating
Current value: 0 out of 5
Data Provided By
Chicago Park District
Source Link
http://www.chicagoparkdistrict.com/
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

DNA Test ID
dna_test_id
DNA Sample Timestamp
dna_sample_timestamp
Beach
beach
DNA Sample 1 Reading
dna_sample_1_reading
DNA Sample 2 Reading
dna_sample_2_reading
DNA Reading Mean
dna_reading_mean
Culture Test ID
culture_test_id
Culture Sample 1 Timestamp
culture_sample_1_timestamp
Culture Sample 1 Reading
culture_sample_1_reading
Culture Sample 2 Reading
culture_sample_2_reading
Culture Reading Mean
culture_reading_mean
Culture Note
culture_note
Culture Sample Interval
culture_sample_interval
Culture Sample 2 Timestamp
culture_sample_2_timestamp
Latitude
latitude
Longitude
longitude
Location
location
Community Areas
:@computed_region_vrxf_vc4k
Zip Codes
:@computed_region_6mkv_f3dw
Boundaries - ZIP Codes
:@computed_region_rpca_8um6
Census Tracts
:@computed_region_bdys_3d7i
Wards
:@computed_region_43wa_7qmu

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.