NYC Building Energy and Water Data Disclosure for Local Law 84 (2023-Present)

Local Law 84 of 2009 (LL84) requires annual energy and water benchmarking data to be submitted by owners of buildings with more than 50,000 square feet. This data is collected via the Environmental Protection Agency's (EPA) <a href="https://www.energystar.gov/buildings/tools-and-resources/portfolio-manager-0">Portfolio Manager website</a>

Each property is identified by it's EPA assigned property ID, and can contain one or more tax lots identified by one or more BBLs (Borough, Block, Lot) or one or more buildings identified by one or more building identification numbers (BIN)

Please visit <a href="https://www1.nyc.gov/site/buildings/codes/benchmarking.page">DOB's Benchmarking and Energy Efficiency Rating page</a>

for additional information.

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 \"cityofnewyork-us/nyc-building-energy-and-water-data-disclosure-for-5zyy-y8am\".\"nyc_building_energy_and_water_data_disclosure_for\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.