Summary — Key Metrics (start here)

The 25 most important columns: property info, ENERGY STAR score, EUI, GHG emissions, GHG intensity (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

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

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 3

Property Type 1

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

Calendar Year 1

  • 2011 · 6 ✖
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
11289 11289 2011 2870866 Mercedes-B MANHATTAN 535 West 38 Street 10,018 Service (Vehicle Repair/Service, Postal Service) 41,476 1929   0 85.2 85.2 125.4 274.07 71952.73 208.25 65.82 701.0 7.0     2.0     1007100011 1012524
12600 12600 2011 2614859 VW/Audi De MANHATTAN 798 - 808 Eleventh Ave. 10,013 Service (Vehicle Repair/Service, Postal Service) 265,000 1930   0                           1.0 1010840001  
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
20529 20529 2011 2806825 starr QUEENS 30-03 review ave 11,101 Service (Vehicle Repair/Service, Postal Service) 171,278 1974   0 209.5 209.4 328.3 2.0 125.89 1.0 764.16 8.0 27.0           4002950045 4002950045
21784 21784 2011 3172070 Melissa 40 QUEENS 40-05 168th St. 11,358 Service (Vehicle Repair/Service, Postal Service) 24,500 1952   0 216.5 226.9 432.9 371.83 166764.21 165.0 206.83 2.0 3.0           4053230250 4120204;4855780

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");