New York State Government Building Energy Use Intensity Data: Beginning State Fiscal Year 2010

The Build Smart NY Program aims to increase energy efficiency of New York State government buildings. Build Smart NY was established by Executive Order 88 and mandates a reduction in energy consumption by 20% in government owned and operated buildings by 2020. Site utility data has been collected for all government buildings larger than 20,000 square feet and this has been converted to Source Energy Use Intensity (EUI) which is a ratio of Source Energy Use to gross square footage. The Source EUI will be used as a performance metric to achieve the 20% reduction targets. The dataset represents a baseline of Source EUI for New York State government buildings at the baseline year of SFI 2010/2011; subsequent reports will demonstrate a progression to achieving a 20% energy reduction target.

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 \"ny-gov/new-york-state-government-building-energy-use-nfvi-5nt4\".\"new_york_state_government_building_energy_use\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.