Watershed Contaminant Reduction Index

The Watershed Contaminant Reduction Index measures contaminants released into the North Saskatchewan River from the City of Edmonton, adjusted for population. The index is calculated annually using measured and estimated amounts of sediments, nutrients (ammonia and phosphorus) and bacteria released into the river, referenced to a baseline. Contaminant sources from the City of Edmonton include

the wastewater treatment plant, combined sewer overflow sites and storm water outfalls. An increase in the index is good and means less contaminants are released to the river. A five-year running average is used to smooth out fluctuations due to weather.

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 \"dashboard-edmonton-ca/watershed-contaminant-reduction-index-q53d-p9ac\".\"watershed_contaminant_reduction_index\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.