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

2021 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. This data was collected was collected in 2022.

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/2021-kansas-city-energy-and-water-consumption-9xwa-2b59\".\"2021_kansas_city_energy_and_water_consumption\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.