# Boston BERDO building energy and emissions disclosure, 2015 to 2024

## Facts

- 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: public, readable without an account
- Category: Environmental Science
- Source: https://data.boston.gov/dataset/building-emissions-reduction-and-disclosure-ordinance
- Page: https://scigantic.com/archive/1f14dfd7-9d9b-5280-8ddd-5ec001c76bdb
- Keywords: Environmental Science, Parquet, AWS Open Data

## About

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.

## Load the data

```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:

```python
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

Example file: `berdo/parquet/2015-reported-energy-and-water-metrics.parquet`

## Open it

- In a hosted notebook with the data mounted: https://scigantic.com/archive/1f14dfd7-9d9b-5280-8ddd-5ec001c76bdb
- Full record as JSON (schema card included): https://api.scigantic.com/api/archives/1f14dfd7-9d9b-5280-8ddd-5ec001c76bdb
- Over MCP: `get_schema_card` with id `1f14dfd7-9d9b-5280-8ddd-5ec001c76bdb` at https://api.scigantic.com/mcp

## Related topics

- [Parquet datasets](https://scigantic.com/topics/parquet)
- [Environmental Science datasets](https://scigantic.com/topics/environmental-science)
