{"success":true,"data":{"author":"City of Boston (Environment Department)","bucketAccessType":"public","bucketListable":true,"bucketName":"scigantic-boston-open-data","bucketPrefix":"berdo/","category":"Environmental Science","cloudProvider":"aws","createdAt":"2026-08-15T00:00:00.000Z","description":"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.","displayTitle":"Boston BERDO building energy and emissions disclosure, 2015 to 2024","dockerImageUrl":"531775725781.dkr.ecr.us-east-1.amazonaws.com/scigantic-notebook-minimal:latest","id":"1f14dfd7-9d9b-5280-8ddd-5ec001c76bdb","license":"Open Data Commons Public Domain Dedication and License (PDDL) 1.0","objectCountEstimate":2,"probeStatus":"ok","referenceUrl":"https://data.boston.gov/dataset/building-emissions-reduction-and-disclosure-ordinance","region":"us-east-1","schemaCard":{"accessHints":[{"language":"python-anonymous","snippet":"import boto3\nfrom botocore import UNSIGNED\nfrom botocore.client import Config\ns3 = boto3.client('s3', region_name='us-east-1', config=Config(signature_version=UNSIGNED))\ns3.list_objects_v2(Bucket='scigantic-boston-open-data', Prefix='berdo/', Delimiter='/')"},{"language":"python-local","snippet":"open('/mnt/archive/parquet/2015-reported-energy-and-water-metrics.parquet', 'rb')"}],"caveats":["Files are binary — use a domain-specific parser (e.g. metpy / pynexrad / pydicom) rather than text I/O."],"format":"binary","generatedAt":"2026-08-31T02:04:53.511Z","layout":{"pattern":"{id}/{seg1}/{filename}","example":"berdo/parquet/2015-reported-energy-and-water-metrics.parquet"},"mountPath":"/mnt/archive","sampleHeaders":[{"bytes":"50415231150415fefd0315fab3024c15c6151500120000fffe01f06d0e0000004d454549202d4c6f6e67776f6f64110000005072696d65204d6f746f722047726f7570280000004e657720456e676c616e642043656e74657220666f7220486f6d656c657373205665746572616e731600000044656e74616c204865616c7468204275696c64696e670b015b246f736e65722048616c6c017c1c5361636b6c6572200951d81d000000312050616c6163652052642d636f6c6c656765556e697665727369747912000000313020436f76656e74727920537472656574014934313430205468652046656e77617901b00c3137372011d5242041766520446f726d7346540000220175043739322c0046260044150000003333372048756e74696e67746f6e0154246e7565240000003636323a19004641004c2e00000041646d696e697374726174696f6e20422d183c2f57696c6b656e7320536369656e63652d0e000c0132146c756d6e61652530000b011010726e6f6c64050f001a010f607369616e2c4b656e6e6564792c536d6974682043616d707573012d14426172746f6c052d01e5684361686e6572732c43757368696e672c6b6572722c4d656c76696e0d35214924436f6c756d627573205021865813000000446176656e706f727420436f6d6d6f6e732041561700044208012e0469780572200a0000004576616e","key":"berdo/parquet/2015-reported-energy-and-water-metrics.parquet","truncatedAt":512,"encoding":"hex"},{"bytes":"504152311504159ea8041594bf024c15b21715001200008f9402b016000000233236373920536f757468204261792f426f73746f6e0f0000003030303420526f736c696e64616c65091334313820446f7263686573746572110526043533113f053b00120515403735204a616d6169636120506c61696e0c051614383920416c6c0161001701100c312d312d09352c2048656164204f6666696365052b2c34313220526f78627572790e012b303431332048796465205061726b058b083432391d8b002405255835202d20486f6c6964617920496e6e20457870726573731d28095d043539115d05380c363633300d895c2c204d41202850727564656e7469616c2043656e7465722905eb24373530382d456173742009b60014017548373537322d4272696768746f6e204d696c6c73056528373537362d46656e776179251320373537372d57657374117b05c610373537392d15d9001309514038372d4d6f72726973657920426c76640d0d1704382d2d3e09790c3630322d1daa084e6577255610373630342d39a54820427572676572070000003120477565737406050b104d696c6b1d050a6450616c6163652052642d636f6c6c656765556e6976657273697405a438313020427569636b2053747265657401cd28313020436f76656e7472790d16000b014a003009600820537421b404313005640d2121142c313020","truncatedAt":512,"encoding":"hex","key":"berdo/parquet/2016-reported-energy-and-water-metrics.parquet"}],"sampleObjects":["berdo/parquet/2015-reported-energy-and-water-metrics.parquet","berdo/parquet/2016-reported-energy-and-water-metrics.parquet","berdo/parquet/2021-detailed-data-dictionary-.parquet","berdo/parquet/2021-reported-energy-and-water-metrics.parquet","berdo/parquet/2022-detailed-data-dictionary.parquet"],"sidecars":[{"encoding":"utf8","size":2894,"bytes":"# Building Emissions Reduction and Disclosure Ordinance (BERDO)\n\nVerbatim mirror of City of Boston open data, taken from data.boston.gov.\nUpstream cadence: annual; one reporting-year file plus its data dictionary.\nLicense: Open Data Commons Public Domain Dedication and License (PDDL). PDDL is a public-domain dedication, so this\nredistribution is explicitly permitted; the city remains the source of record.\n\n- `raw/` is byte-identical to what data.boston.gov serves.\n- `parquet/` holds the same rows as Snappy Parquet, every column a string\n  (zero-padded ids like ward `06` and ZIP `02128` would be destroyed by type\n  inference). Cast explicitly when you need numbers.\n\nSee MANIFEST.json at the bucket root for source URLs, CKAN resource ids,\nsha256 digests and row counts.\n\n| file | format | rows | raw | parquet |\n| --- | --- | --- | --- | --- |\n| 2025-reported-energy-and-water-metrics.xlsx | XLSX | 6,198 | 1.6M | 2025-reported-energy-and-water-metrics__summary.parquet 0.8M |\n| 2024-reported-energy-and-water-metrics-1.xlsx | XLSX | 5,638 | 1.7M | 2024-reported-energy-and-water-metrics-1.parquet 0.6M |\n| 2024-detailed-data-dictionary.xlsx | XLSX | 54 | 0.0M | 2024-detailed-data-dictionary.parquet 0.0M |\n| 2023-reported-energy-and-water-metrics.xlsx | XLSX | 5,981 | 1.6M | 2023-reported-energy-and-water-metrics.parquet 0.5M |\n| 2023-detailed-data-dictionary.xlsx | XLSX | 41 | 0.0M | 2023-detailed-data-dictionary.parquet 0.0M |\n| 2022-reported-energy-and-water-metrics_new.xlsx | XLSX | 5,041 | 1.2M | 2022-reported-energy-and-water-metrics_new.parquet 0.4M |\n| 2022-detailed-data-dictionary.xlsx | XLSX | 40 | 0.0M | 2022-detailed-data-dictionary.parquet 0.0M |\n| 2021-reported-energy-and-water-metrics.xlsx | XLSX | 2,483 | 0.5M | 2021-reported-energy-and-water-metrics.parquet 0.2M |\n| 2021-detailed-data-dictionary-.xlsx | XLSX | 26 | 0.0M | 2021-detailed-data-dictionary-.parquet 0.0M |\n| berdo-disclosure-for-calendar-year-2019-final.xlsx | XLSX | 2,427 | 0.4M | berdo-disclosure-for-calendar-year-2019-final.parquet 0.3M |\n| berdo-data-definitions-2020.xlsx | XLSX | 39 | 0.0M | berdo-data-definitions-2020.parquet 0.0M |\n| berdo-data-for-disclosure-calendar-year-2018.xlsx | XLSX | 1,753 | 0.4M | berdo-data-for-disclosure-calendar-year-2018.parquet 0.3M |\n| berdodefinitions2019.xlsx | XLSX | 36 | 0.0M | berdodefinitions2019.parquet 0.0M |\n| berdo-data-for-disclosure-calendar-year-2017.csv | CSV | 1,914 | 0.5M | berdo-data-for-disclosure-calendar-year-2017.parquet 0.2M |\n| berdodefinitions2017.csv | CSV | 23 | 0.0M | berdodefinitions2017.parquet 0.0M |\n| berdo2017.csv | CSV | 1,800 | 0.4M | berdo2017.parquet 0.2M |\n| 2016-reported-energy-and-water-metrics.xlsx | XLSX | 1,502 | 0.3M | 2016-reported-energy-and-water-metrics.parquet 0.2M |\n| 2015-reported-energy-and-water-metrics.xlsx | XLSX | 1,380 | 0.3M | 2015-reported-energy-and-water-metrics.parquet 0.2M |\n","truncated":false,"name":"README.md","key":"berdo/README.md"}],"sourceObjectKey":"berdo/parquet/2015-reported-energy-and-water-metrics.parquet","starterCell":"import os\nimport pyarrow.parquet as pq\npf = pq.ParquetFile(os.path.join(os.environ['SCIGANTIC_MOUNT_PATH'], 'parquet/2015-reported-energy-and-water-metrics.parquet'))\nprint(pf.metadata)\ndf = pf.read_row_group(0).to_pandas()\ndf.head()","starterSamplePath":"parquet/2015-reported-energy-and-water-metrics.parquet","totalObjects":"2 top-level prefixes","verifiedRead":{"attempts":[{"error":"ImportError: `Import openpyxl` failed.  Use pip or conda to install the openpyxl package.","family":"excel","ok":false,"path":"raw/berdo-data-for-disclosure-calendar-year-2018.xlsx","seconds":0.04},{"error":"ModuleNotFoundError: No module named 'xarray'","family":"netcdf-xarray","ok":false,"path":"raw/berdo-data-for-disclosure-calendar-year-2018.xlsx","seconds":0},{"error":"ValueError: binary content, not text","family":"text-head","ok":false,"path":"raw/berdo-data-for-disclosure-calendar-year-2018.xlsx","seconds":0.04},{"family":"bytes-head","ok":true,"path":"raw/berdo-data-for-disclosure-calendar-year-2018.xlsx","seconds":0.06},{"error":"ImportError: `Import openpyxl` failed.  Use pip or conda to install the openpyxl package.","family":"excel","ok":false,"path":"raw/2024-reported-energy-and-water-metrics-1.xlsx","seconds":0.08},{"error":"ModuleNotFoundError: No module named 'xarray'","family":"netcdf-xarray","ok":false,"path":"raw/2024-reported-energy-and-water-metrics-1.xlsx","seconds":0},{"error":"ValueError: binary content, not text","family":"text-head","ok":false,"path":"raw/2024-reported-energy-and-water-metrics-1.xlsx","seconds":0.05},{"family":"bytes-head","ok":true,"path":"raw/2024-reported-energy-and-water-metrics-1.xlsx","seconds":0.04},{"family":"parquet","ok":true,"path":"parquet/2015-reported-energy-and-water-metrics.parquet","seconds":0.05}],"bytes":160426,"facts":["under 'berdo/': 2 directories (e.g. parquet, raw); 2 objects named like README.md, 3 KB to 16 KB","under 'berdo/raw/': 18 objects named like ####-reported-energy-and-water-metrics.xlsx, 5 KB to 1.6 MB"],"family":"parquet","image":"531775725781.dkr.ecr.us-east-1.amazonaws.com/scigantic-notebook-minimal:latest","library":"pyarrow","path":"parquet/2015-reported-energy-and-water-metrics.parquet","rssDeltaMb":0.1,"seconds":0.05,"snippet":"import os\nimport pyarrow.parquet as pq\npf = pq.ParquetFile(os.path.join(os.environ['SCIGANTIC_MOUNT_PATH'], 'parquet/2015-reported-energy-and-water-metrics.parquet'))\nprint(pf.metadata)\ndf = pf.read_row_group(0).to_pandas()\ndf.head()","starterCell":{"ok":true,"seconds":0.22},"summary":"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 Certified:large_string', 'Property Uses:large_string']","verifiedAt":"2026-10-29T06:21:18.346Z"}},"sourceType":"bucket","summary":"Annual energy, water and greenhouse gas reporting filed under Boston's Building Emissions Reduction and Disclosure Ordinance (BERDO), covering reporting years 2015 through 2024:…","title":"Boston BERDO building energy and emissions disclosure, 2015 to 2024","updatedAt":"2026-10-29T06:21:18.347Z","visibility":"public","websiteUrl":"https://www.boston.gov/departments/environment/building-emissions-reduction-and-disclosure","whiteLabel":"boston"}}