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.