Energy Used in Civic Operations per Capita

This data set provides the total amount of energy used (in MW) by all departments of the City of Edmonton, per person. It includes vehicle fuels (i.e. gasoline, diesel, propane and natural gas), natural gas heating for buildings, and electricity use for lighting, running the LRT, cooling buildings, etc.

Per capita energy use is gradually declining as LED street lights are installed, vehicle fuel efficiency improves and building energy retrofits are completed.

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/energy-used-in-civic-operations-per-capita-3zvg-77mq\".\"energy_used_in_civic_operations_per_capita\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.