cityofchicago/beach-swim-advisories-t62e-8nvc
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 11 hours ago
Indexed 2 hours ago

Beach Swim Advisories

This dataset is historical-only. A similar dataset starting in 2017 can be found at https://data.cityofchicago.org/d/xvsz-3xcj -- The Chicago Park District issues swim advisories at beaches along Chicago's Lake Michigan lakefront based on predicted E. coli levels. This dataset shows the predictions and whether a swim advisory was issued due to the predicted E. coli level being at least 235 Colony Forming Units (CFU) per 100 ml of water.

The data used to make the predictions can be found in https://data.cityofchicago.org/d/qmqz-2xku and https://data.cityofchicago.org/d/k7hf-8y75. The measured E. coli levels determined later can be found in https://data.cityofchicago.org/d/2ivx-z93u.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofchicago/beach-swim-advisories-t62e-8nvc\".\"beach_swim_advisories\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • beach_swim_advisories
     
     
     
     
     
Upstream Metadata