Beach Lab Data
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.cityofchicago.org |
| Id | 2ivx-z93u |
| Name | Beach Lab Data |
| Attribution | Chicago Park District |
| Category | Parks & Recreation |
| Tags | beaches, parks, chicago park district, open spaces, parks & recreation, recreation, water |
| Created | 2016-05-04T17:34:00Z |
| Publication Date | 2017-02-16T21:49:40Z |
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.
Columns
| Included | Schema Type | Field Name | Name | Data Type | Render Type |
| ======== | ============== | ========================== | ========================== | ============= | ============= |
| Yes | series tag | culture_test_id | Culture Test ID | text | text |
| Yes | time | culture_sample_1_timestamp | Culture Sample 1 Timestamp | calendar_date | calendar_date |
| Yes | series tag | beach | Beach | text | text |
| Yes | numeric metric | culture_sample_1_reading | Culture Sample 1 Reading | number | number |
| Yes | numeric metric | culture_sample_2_reading | Culture Sample 2 Reading | number | number |
| Yes | numeric metric | culture_reading_mean | Culture Reading Mean | number | number |
| Yes | series tag | culture_note | Culture Note | text | text |
| Yes | numeric metric | culture_sample_interval | Culture Sample Interval | number | number |
| No | | culture_sample_2_timestamp | Culture Sample 2 Timestamp | calendar_date | calendar_date |
| Yes | series tag | dna_test_id | DNA Test ID | text | text |
| No | | dna_sample_timestamp | DNA Sample Timestamp | calendar_date | calendar_date |
| Yes | numeric metric | dna_sample_1_reading | DNA Sample 1 Reading | number | number |
| Yes | numeric metric | dna_sample_2_reading | DNA Sample 2 Reading | number | number |
| Yes | numeric metric | dna_reading_mean | DNA Reading Mean | number | number |
| No | | latitude | Latitude | number | number |
| No | | longitude | Longitude | number | number |
Time Field
Value = culture_sample_1_timestamp
Format & Zone = yyyy-MM-dd'T'HH:mm:ss
Series Fields
Excluded Fields = culture_sample_2_timestamp,dna_sample_timestamp,latitude,longitude
Data Commands
series e:2ivx-z93u d:2013-08-15T00:00:00.000Z t:culture_test_id=107973 t:beach=NA m:culture_sample_2_reading=248 m:culture_reading_mean=239.3491174 m:culture_sample_1_reading=231
series e:2ivx-z93u d:2014-08-27T00:00:00.000Z t:culture_test_id=93598 t:beach=NA m:culture_sample_2_reading=4 m:culture_reading_mean=6.92820323 m:culture_sample_1_reading=12
series e:2ivx-z93u d:2012-07-05T00:00:00.000Z t:culture_test_id=108593 t:beach=NA m:culture_sample_2_reading=2 m:culture_reading_mean=2 m:culture_sample_1_reading=2
Meta Commands
metric m:culture_sample_1_reading p:float l:"Culture Sample 1 Reading" d:"Colony Forming Units (CFU) per 100 ml of water" t:dataTypeName=number
metric m:culture_sample_2_reading p:double l:"Culture Sample 2 Reading" d:"Colony Forming Units (CFU) per 100 ml of water" t:dataTypeName=number
metric m:culture_reading_mean p:double l:"Culture Reading Mean" d:"The geometric mean of Culture Sample 1 Reading and Culture Sample 2 Reading (if any)." t:dataTypeName=number
metric m:culture_sample_interval p:integer l:"Culture Sample Interval" d:"Time in minutes between collection of the two samples for culture testing." t:dataTypeName=number
metric m:dna_sample_1_reading p:integer l:"DNA Sample 1 Reading" d:"Enterococci calibrator cell equivalents (CCE) per 100 ml of water" t:dataTypeName=number
metric m:dna_sample_2_reading p:double l:"DNA Sample 2 Reading" d:"Enterococci calibrator cell equivalents (CCE) per 100 ml of water" t:dataTypeName=number
metric m:dna_reading_mean p:double l:"DNA Reading Mean" d:"The geometric mean of the DNA Sample 1 Reading and the DNA Sample 2 Reading (if any)." t:dataTypeName=number
entity e:2ivx-z93u l:"Beach Lab Data" t:attribution="Chicago Park District" t:url=https://data.cityofchicago.org/api/views/2ivx-z93u
property e:2ivx-z93u t:meta.view v:id=2ivx-z93u v:category="Parks & Recreation" v:attributionLink=http://www.chicagoparkdistrict.com/ v:averageRating=0 v:name="Beach Lab Data" v:attribution="Chicago Park District"
property e:2ivx-z93u t:meta.view.owner v:id=vewm-vupz v:screenName="Jonathan Levy" v:displayName="Jonathan Levy"
property e:2ivx-z93u t:meta.view.tableauthor v:id=vewm-vupz v:screenName="Jonathan Levy" v:roleName=administrator v:displayName="Jonathan Levy"
Top Records
| culture_test_id | culture_sample_1_timestamp | beach | culture_sample_1_reading | culture_sample_2_reading | culture_reading_mean | culture_note | culture_sample_interval | culture_sample_2_timestamp | dna_test_id | dna_sample_timestamp | dna_sample_1_reading | dna_sample_2_reading | dna_reading_mean | latitude | longitude |
| =============== | ========================== | ===== | ======================== | ======================== | ==================== | ============ | ======================= | ========================== | =========== | ==================== | ==================== | ==================== | ================ | ======== | ========= |
| 107973 | 2013-08-15T00:00:00 | NA | 231 | 248 | 239.3491174 | | | | | | | | | | |
| 93598 | 2014-08-27T00:00:00 | NA | 12 | 4 | 6.92820323 | | | | | | | | | | |
| 108593 | 2012-07-05T00:00:00 | NA | 2 | 2 | 2 | | | | | | | | | | |
| 105618 | 2013-07-02T00:00:00 | NA | 1 | 1 | 1 | | | | | | | | | | |
| 98229 | 2006-07-18T00:00:00 | NA | 104.6 | 86 | 94.845136934 | | | | | | | | | | |
| 104762 | 2006-07-03T00:00:00 | NA | 2 | 3.1 | 2.48997992 | | | | | | | | | | |
| 92980 | 2014-08-14T00:00:00 | NA | 67 | 58 | 62.337789502 | | | | | | | | | | |
| 106097 | 2013-07-23T00:00:00 | NA | 6 | 17 | 10.099504938 | | | | | | | | | | |
| 97761 | 2006-07-12T00:00:00 | NA | 19.9 | 19.9 | 19.9 | | | | | | | | | | |
| 96646 | 2011-07-19T00:00:00 | NA | 81.3 | 60.5 | 70.133087769 | | | | | | | | | | |