Edmonton's Citizen Dashboard

Close
Author
General Section Email
Description
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.
Category
Dashboard
Tags
watershed, contaminant, index, reduction
Rating
Current value: 0 out of 5
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

ID
id
DateTime
datetime
MONTH
month
YEAR
year
WATERSHED_CONTAMINANT_REDUCTION_INDEX
watershed_contaminant_reduction_index
2018_TARGET
_2018_target

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.