Water Quality Test Results

The City of Winnipeg tests Winnipeg drinking water (https://winnipeg.ca/waterandwaste/water/testResults/default.stm) to ensure compliance with our Operating Licence (https://winnipeg.ca/waterandwaste/water/operatingLicenceAudit.stm), the regulations and Guidelines for Canadian Drinking Water Quality, these guidelines apply to treated water only. If you would like more information on water quality, visit Health Canada.

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 \"winnipeg-ca/water-quality-test-results-a5ix-gnny\".\"water_quality_test_results\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.