Icon for Socrata external plugin
Open repository in Console
Updated 7 months ago
Indexed 3 hours ago

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" \
{"sql": "
    SELECT *
    FROM \"dashboard-edmonton-ca/watershed-contaminant-reduction-index-q53d-p9ac\".\"watershed_contaminant_reduction_index\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • watershed_contaminant_reduction_index
Upstream Metadata