Icon for Socrata external plugin
Open repository in Console
Updated over 2 years ago
Indexed 4 hours ago

Average Monthly Residential Water Consumption by Neighbourhood 2016

This dataset provides the average (annual, winter, summer) residential metered water consumption (2016) within residential neighbourhoods provided in m3/month for the City of Edmonton. Average monthly residential winter water consumption is the average consumption of the following months: January, February, March, April, October, November and December. Average monthly residential summer water consumption is the average consumption of the following months: May, June, July, August and September.

Only those residential neighbourhoods with at least ten accounts are illustrated to ensure customer privacy.

Residential consumption refers to water used primarily for domestic purposes, where no more than four separate dwelling units are metered by a single water meter.

Thematic mapping is based on the following ranges:

0-10 m3/month – orange

10-20 m3/month – green

20-30 m3/month – purple

30-35 m3/month – blue

35-60 m3/month – red

60 m3/month and up – maroon

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 \"edmonton-ca/average-monthly-residential-water-consumption-by-az6i-h9uv\".\"average_monthly_residential_water_consumption_by\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • average_monthly_residential_water_consumption_by
Upstream Metadata