Cambridge Building Energy and Water Use Data Disclosure 2016-2022

This dataset contains compliance status and energy and water use data gathered through the Building Energy Use Disclosure Ordinance (BEUDO). Property details, energy use and water use data are submitted by property owners or managers whose properties are subject to BEUDO through an online energy and water use benchmarking tool called ENERGY STAR Portfolio Manager. Parcel level property information is obtained from the City of Cambridge Property Database.

Energy and water use information submitted by property owners and managers is shown for properties that first began reporting in the 2015 BEUDO reporting cycle. These include nonresidential properties 50,000 square feet or more, residential properties with 50 or more units and municipal properties 10,000 square feet or more. In 2016, nonresidential properties 25,000 square feet or more began submitting reports for the first time and their data was disclosed beginning in 2017.

Please note that the “Property Type” column distinguishes reports based on whether they contain information about a single building or multiple buildings. If you are running summary statistics on this dataset, make sure to avoid duplicating data by filtering for “single” reports and “parent” reports. Child properties are buildings also included in parent reports. The “Buildings Included” column details what buildings are included in parent reports, with the first building ID indicating the parent property.

Note that the reporting year is the year data was submitted for the property, which represents energy use for the prior calendar year. For example, rows with reporting year 2021 represent energy use for calendar year 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 \"cambridgema-gov/cambridge-building-energy-and-water-use-data-72g6-j7aq\".\"cambridge_building_energy_and_water_use_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.