Building Energy Benchmarking - City of Calgary

“This dataset contains building energy and greenhouse gas emission performance information for a subset of properties owned and operated by the City of Calgary. All energy and greenhouse gas emission metrics are calculated by ENERGY STAR Portfolio Manager using monthly, whole-building energy consumption data billed between January 1st and December 31st.

All blank cells in the dataset correspond to data points that are "not available" because they do not exist or cannot be calculated.”

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 \"calgary-ca/building-energy-benchmarking-city-of-calgary-8twd-upbv\".\"building_energy_benchmarking_city_of_calgary\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.