edmonton-ca/average-monthly-residential-water-consumption-by-iu66-3h7p
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 4 years ago
Indexed 1 month ago

Average Monthly Residential Water Consumption by Neighbourhood 2017

This dataset provides the average (annual, winter, summer) residential metered water consumption (2017) 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

Note:

For 2017, there were no areas where the consumption was 60 m3/month and up - thus, the maroon colour would not appear in the legend.

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 \"edmonton-ca/average-monthly-residential-water-consumption-by-iu66-3h7p\".\"average_monthly_residential_water_consumption_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • average_monthly_residential_water_consumption_by
     
     
     
     
     
Upstream Metadata