About this Dataset

Building Energy Benchmarking

The Clean and Affordable Energy Act of 2008 established that all private buildings over 50,000 gross square feet within the District of Columbia, including multifamily residences, must annually measure and disclose their energy and water consumption to the Department of Energy and Environment (DOEE). Benchmarking is defined as tracking a building’s energy and water use and using a standard metric to compare the building’s performance against past performance and to its peers nationwide. These comparisons have been shown to drive energy efficiency upgrades and increase occupancy rates and property values. The District of Columbia has chosen U.S. EPA’s free, industry-standard ENERGY STAR® Portfolio Manager® tool for benchmarking and reporting. DDOE is required to publicly disclose the ENERGY STAR® Benchmarking results for each publicly or privately owned building that is subject to the benchmarking law, beginning with the 2nd year of benchmarking data for that building. For more information, see https://doee.dc.gov/energybenchmarking.
Organization: District of Columbia
Last updated: 2024-04-30T17:59:06.095285
Tags: benchmarks, building-energy-benchmarking, dc, district-of-columbia, doee, energy, environment, green, solar, washington-dc

Tables

Table 1

@usgov.district_of_columbia_building_energy_benchmarking.table_1

2.35 MB
26,665 rows
76 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "pid" VARCHAR,
  "ssl" VARCHAR,
  "pmpropertyid" DOUBLE,
  "propertyname" VARCHAR,
  "pmparentpropertyid" VARCHAR,
  "parentpropertyname" VARCHAR,
  "reportingyear" BIGINT,
  "reportstatus" VARCHAR,
  "addressofrecord" VARCHAR,
  "ownerofrecord" VARCHAR,
  "ward" DOUBLE,
  "reportedaddress" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postalcode" VARCHAR,
  "yearbuilt" DOUBLE,
  "primarypropertytype_selfselect" VARCHAR,
  "primarypropertytype_epacalc" VARCHAR,
  "taxrecordfloorarea" BIGINT,
  "reportedbuildinggrossfloorarea" DOUBLE,
  "energystarscore" DOUBLE,
  "siteeui_kbtu_ft" DOUBLE,
  "weathernormalzedsiteeui_kbtuft" DOUBLE,
  "sourceeui_kbtu_ft" DOUBLE,
  "weathernormalzedsoureui_kbtuft" DOUBLE,
  "totghgemissions_metrictonsco2e" DOUBLE,
  "totghgemissintensity_kgco2eft" DOUBLE,
  "waterscore_mfproperties" DOUBLE,
  "wateruse_allwatersources_kgal" DOUBLE,
  "meteredareas_energy" VARCHAR,
  "meteredareas_water" VARCHAR,
  "naturalgasuse_therms" DOUBLE,
  "fueloilanddieselfuelusekbtu" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "addressid" DOUBLE,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "gis_last_mod_dttm" TIMESTAMP,
  "distrchilledwater_kbtu" DOUBLE,
  "distrhotwater_kbtu" DOUBLE,
  "distrsteam_kbtu" DOUBLE,
  "electricityuse_renewable_kwh" DOUBLE,
  "electricityuse_grid_kwh" DOUBLE,
  "naturalgas_kbtu_january" DOUBLE,
  "naturalgas_kbtu_february" DOUBLE,
  "naturalgas_kbtu_march" DOUBLE,
  "naturalgas_kbtu_april" DOUBLE,
  "naturalgas_kbtu_may" DOUBLE,
  "naturalgas_kbtu_june" DOUBLE,
  "naturalgas_kbtu_july" DOUBLE,
  "naturalgas_kbtu_august" DOUBLE,
  "naturalgas_kbtu_september" DOUBLE,
  "naturalgas_kbtu_october" DOUBLE,
  "naturalgas_kbtu_november" DOUBLE,
  "naturalgas_kbtu_december" DOUBLE,
  "electricityuse_kbtu_january" DOUBLE,
  "electricityuse_kbtu_february" DOUBLE,
  "electricityuse_kbtu_march" DOUBLE,
  "electricityuse_kbtu_april" DOUBLE,
  "electricityuse_kbtu_may" DOUBLE,
  "electricityuse_kbtu_june" DOUBLE,
  "electricityuse_kbtu_july" DOUBLE,
  "electricityuse_kbtu_august" DOUBLE,
  "electricityuse_kbtu_september" DOUBLE,
  "electricityuse_kbtu_october" DOUBLE,
  "electricityuse_kbtu_november" DOUBLE,
  "electricityuse_kbtu_december" DOUBLE,
  "ubid" VARCHAR,
  "enforcement_action" VARCHAR,
  "verifier_name" VARCHAR,
  "verifier_organization" VARCHAR,
  "lastupdate" TIMESTAMP,
  "objectid" BIGINT
);