ramseycounty-us/comprehensive-beach-water-quality-data-2yt3-vdb6
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 months ago
Indexed 1 month ago

Comprehensive Beach Water Quality Data

Ramsey County regularly tests beaches for water quality during beach season, from June through August each year. Ramsey County uses the state E. coli water quality standard to identify water bodies that may be contaminated with fecal waste. Higher levels of E. coli in the water may or may not be accompanied by higher levels and an increased risk of harmful bacteria; varying survival rates of bacteria make is impossible to definitively state when these harmful bacteria are present. Two samples are taken from each Ramsey County beach weekly to test E. coli levels.

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 \"ramseycounty-us/comprehensive-beach-water-quality-data-2yt3-vdb6\".\"comprehensive_beach_water_quality_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • comprehensive_beach_water_quality_data
     
     
     
     
     
Upstream Metadata