2019 Kansas City Energy and Water Consumption Benchmarking for City-Owned Buildings

2019 Energy and Water consumption of City-Owned buildings 10,000 SQFT or greater, required by the Energy Empowerment Ordinance, using the Energy Star Portfolio Manager tool. The City provided some buildings below this threshold when available. The data were collected in 2020.

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 \"kcmo/2019-kansas-city-energy-and-water-consumption-iy94-ug87\".\"2019_kansas_city_energy_and_water_consumption\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.