Summary — Key Metrics (start here)

The 25 most important columns: property info, ENERGY STAR score, EUI, GHG emissions, GHGI (kgCO2e/m²), and fuel use by type. Filter using the column boxes or left-side facets. Export to CSV or JSON.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

5 rows where Borough = "BROOKLYN" and Property Type = "Service (Vehicle Repair/Service, Postal Service)" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Address 1, Postal Code, Year Built, BBL, BIN

Calendar Year 2

Property Type 1

  • Service (Vehicle Repair/Service, Postal Service) · 5 ✖

Borough 1

  • BROOKLYN · 5 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Postal Code Property Type Floor Area (ft2) Year Built Number of Buildings ENERGY STAR Score Site EUI (kBtu/ft2) Weather Norm Site EUI (kBtu/ft2) Source EUI (kBtu/ft2) Total GHG (MtCO2e) GHGI (kgCO2e/m2) Direct GHG (MtCO2e) Indirect GHG (MtCO2e) Electricity (kBtu) Natural Gas Use (kBtu) District Steam Use (kBtu) Fuel Oil #2 Use (kBtu) Fuel Oil #4 Use (kBtu) Fuel Oil #5 & 6 Use (kBtu) Water Use (kgal) BBL BIN
30511 30511 2012 2816562 1775 Dean Street BROOKLYN 1775 Dean Street 11,233 Service (Vehicle Repair/Service, Postal Service) 62700 1962   0 54.1 61.5 67.6         300782.66 3089154.84 0.0 0.0 0.0 0.0   3013430031 3035709
34786 34786 2012 3502582 New York (100) BROOKLYN 300 Maspeth Ave. 11,211 Service (Vehicle Repair/Service, Postal Service) 109500 1958   0 0.0 0.0 0.0         0.0 0.0 0.0 0.0 0.0 0.0   3029270168 3400373
34841 34841 2012 3507200 Brooklyn - HD (3101) BROOKLYN 100 Morgan Avenue 11,237 Service (Vehicle Repair/Service, Postal Service) 102000 1958   0 69.5 77.7 106.9         1517846.36 5570862.79 0.0 0.0 0.0 0.0   3029740170 3070568
18349 18349 2011 2816562 1775 Dean BROOKLYN 1775 Dean Street 11,233 Service (Vehicle Repair/Service, Postal Service) 62,700 1962   0 20.7 21.8 34.4 83.26 14454.88 50.67 32.59 347.0 952.0           3013430031 3035709
19532 19532 2011 2689242 LIFE QUALI BROOKLYN 6223 2ND AVENUE 11,220 Service (Vehicle Repair/Service, Postal Service) 77,000 1947   0                             3057980001 3143892

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE summary(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Postal Code" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "Year Built" TEXT,
  "Number of Buildings" TEXT,
  "ENERGY STAR Score" TEXT,
  "Site EUI (kBtu/ft2)" REAL,
  "Weather Norm Site EUI (kBtu/ft2)" REAL,
  "Source EUI (kBtu/ft2)" REAL,
  "Total GHG (MtCO2e)" REAL,
  "GHGI (kgCO2e/m2)",
  "Direct GHG (MtCO2e)" REAL,
  "Indirect GHG (MtCO2e)" REAL,
  "Electricity (kBtu)" REAL,
  "Natural Gas Use (kBtu)" REAL,
  "District Steam Use (kBtu)" REAL,
  "Fuel Oil #2 Use (kBtu)" REAL,
  "Fuel Oil #4 Use (kBtu)" REAL,
  "Fuel Oil #5 & 6 Use (kBtu)" REAL,
  "Water Use (kgal)" REAL,
  BBL TEXT,
  BIN TEXT
);
CREATE INDEX "idx_summary_Calendar Year" ON [summary] ("Calendar Year");
CREATE INDEX "idx_summary_Property ID" ON [summary] ("Property ID");
CREATE INDEX "idx_summary_Borough" ON [summary] ("Borough");
CREATE INDEX "idx_summary_Property Type" ON [summary] ("Property Type");
CREATE INDEX "idx_summary_Postal Code" ON [summary] ("Postal Code");