Boston BERDO building energy and emissions disclosure, 2015 to 2024
- Provider
- City of Boston (Environment Department)
- License
- Open Data Commons Public Domain Dedication and License (PDDL) 1.0
- Format
- Parquet (in sampled files)
- Stored at
- Amazon S3, s3://scigantic-boston-open-data/berdo (us-east-1)
- Access
- Free and public. No account with the data provider is needed.
- Category
- Environmental Science
- Source
- https://data.boston.gov/dataset/building-emissions-reduction-and-disclosure-ordinance
About Boston BERDO building energy and emissions disclosure, 2015 to 2024
Annual energy, water and greenhouse gas reporting filed under Boston's Building Emissions Reduction and Disclosure Ordinance (BERDO), covering reporting years 2015 through 2024: 29,197 rows across 17 DataStore-loaded resources, including the per-year data dictionaries the city publishes alongside each disclosure. BERDO, amended in 2021, requires residential buildings with 15 or more units and non-residential buildings of 20,000 square feet or more to report annually and sets declining emissions standards that reach net zero by 2050. One row is one building (or campus) in one reporting year, and the modern schema carries about 40 columns: a stable BERDO ID and the tax parcel id, the property owner name, building and parcel addresses, reported gross floor area and enclosed parking area, the largest property type and the full list of property types, site energy use intensity in kBtu per square foot, the ENERGY STAR score, total site energy use, and a full fuel breakdown in kBtu covering natural gas, electricity, onsite renewable generation, district hot water, chilled water and steam, fuel oils 1, 2, 4, 5 and 6, propane, diesel and kerosene, plus water use intensity, estimated total greenhouse gas emissions in kgCO2e, compliance status, report status, and flags for community choice electricity participation, power purchase agreements, renewable energy certificate purchases, backup generators, battery storage and EV charging. Because the reporting universe is the large-building stock that drives most of Boston's building-sector emissions, this is the primary dataset for measuring decarbonisation progress, benchmarking energy intensity by property type, identifying electrification and fuel-switching, and studying which buildings comply and which do not. The schema card documents the parts a model cannot infer: the schema and file format changed across the ordinance amendment, so the pre-2021 files (2015 to 2019) are narrower and use different column names from the 2021-onward files, and reporting year 2017 appears as two separate 24-column resources holding 1,914 and 1,800 rows, which must not be concatenated; the tax parcel id joins to the Property Assessment rolls and the 2025 parcel geometry, which is how a building's reported emissions get linked to its assessed value and location; every column including the numeric ones is typed text with values such as '236688.0'; the emissions figure is estimated from reported energy use rather than metered at the stack; and the 2025 reporting-year file is present in the package but not loaded into the DataStore, so it must be read as a spreadsheet download rather than queried. Published by the Environment Department under PDDL 1.0. This archive is served from a Scigantic mirror rather than live from the portal: BERDO publishes one reporting-year file annually and does not revise it, so s3://scigantic-boston-open-data/berdo/ carries a byte-verbatim copy under raw/, including every per-year data dictionary and the 2025 file the DataStore never loaded, alongside a Snappy Parquet copy under parquet/, FUSE-mounted read-only at ~/archive. Mirroring is what makes reporting year 2025 queryable at all.
How to load Boston BERDO building energy and emissions disclosure, 2015 to 2024 in Python
import os
import pyarrow.parquet as pq
pf = pq.ParquetFile(os.path.join(os.environ['SCIGANTIC_MOUNT_PATH'], 'parquet/2015-reported-energy-and-water-metrics.parquet'))
print(pf.metadata)
df = pf.read_row_group(0).to_pandas()
df.head()Run in a Scigantic notebook on 2026-10-29 against parquet/2015-reported-energy-and-water-metrics.parquet: Parquet 1,380 rows, 22 columns, 1 row groups; columns ['Property Name:large_string', 'Reported:large_string', 'Property Type:large_string', 'Address:large_string', 'ZIP:large_string', 'Gross Area (sq ft):large_string', 'Site EUI (kBTU/sf):large_string', 'Energy Star Score:large_string', 'Energy Star.
From any machine
import boto3
from botocore import UNSIGNED
from botocore.client import Config
s3 = boto3.client('s3', region_name='us-east-1', config=Config(signature_version=UNSIGNED))
s3.list_objects_v2(Bucket='scigantic-boston-open-data', Prefix='berdo/', Delimiter='/')Lists the files with anonymous access. Runs on any machine, with no cloud account.
Data structure
File types in sampled files: Parquet
Files
Example file: berdo/parquet/2015-reported-energy-and-water-metrics.parquet
Sample notebook
Sample notebook for Boston BERDO building energy and emissions disclosure, 2015 to 2024: worked code with the output it printed.
Analyze this dataset without downloading it
On Scigantic, Boston BERDO building energy and emissions disclosure, 2015 to 2024 opens in a hosted JupyterLab notebook with the data already mounted, so you can read files where they are stored instead of copying them first. Each notebook includes an AI assistant that can see the mounted files and write and run analysis code. Open the dataset page to launch a notebook, or browse the full catalog.
This page is also available as Markdown and as JSON.
Related Environmental Science datasets
- FEDZ Laboratory Fish Stomach Content Database: Prey of Salmon, Herring and Forage Fish from Alaska Surveys, 1997-2018
- North American Camera Trap Images (NACTI)
- NREL MOIS Measurements of the NWEI Azura Wave Energy Converter at the Hawaii Wave Energy Test Site (WETS), 2015-2018
- Rocky Mountain Snowpack: Snow Crystal, Profile and Core Imagery from Colorado Snowpits
- Carbon and Permafrost Vulnerability to Wildfire v1.0
- Non-Floodplain Wetlands
- WWF Terrestrial Ecoregions of the World (2017)
- DEA Burnt Area Characteristic Layers (Sentinel-2 Near Real-Time, Provisional, Australia)