Energy, Air & Climate Impacts of City-Owned Buildings in Kansas City, MO (2015)

This dataset provides information on large city-owned buildings, including 2015 environmental impacts (energy, water, greenhouse gas emissions) and energy costs, and property characteristics (square feet, year built, property use type). The data was collected and published per the Energy Empowerment Ordinance.

Energy data is reported in thousand British Thermal Units (kBTU), normalizing all fuel types into a common energy unit.

Read more at http://kcmo.gov/kcgreen/benchmarking/. An annual report with data analysis will be published each December beginning in 2016.

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/energy-air-climate-impacts-of-cityowned-buildings-ri7d-shs3\".\"energy_air_climate_impacts_of_cityowned_buildings\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.