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

7 rows where Borough = "QUEENS" 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, Property Name, Address 1, Postal Code, Floor Area (ft2), Year Built, Total GHG (MtCO2e), GHGI (kgCO2e/m2), Direct GHG (MtCO2e), Electricity (kBtu), BBL, BIN

These facets timed out: Property Type

Calendar Year 3

Borough 1

  • QUEENS · 7 ✖
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
29758 29758 2012 2806825 starr QUEENS 30-03 review ave 11,101 Service (Vehicle Repair/Service, Postal Service) 171278 1974   0 160.5 176.8 281.2         8447566.08 19049000.0 0.0 0.0 0.0 0.0   4002950045 4307187
33937 33937 2012 3172070 Evans 40-05 168th St. QUEENS 40-05 168th St. 11,358 Service (Vehicle Repair/Service, Postal Service) 24500 1952   0 206.0 219.1 421.8         2202345.65 2843619.94 0.0 0.0 0.0 0.0   4053230250 4120204
34834 34834 2012 3506542 Queens 114 QUEENS 55090 48th Street 11,378 Service (Vehicle Repair/Service, Postal Service) 52000 1966   0 0.0 0.0 0.0         0.0 0.0 0.0 0.0 0.0 0.0   4026000092 4058953
34836 34836 2012 3506774 Manhatten HD (3102) QUEENS 83-15 24th Avenue 11,370 Service (Vehicle Repair/Service, Postal Service) 115500 1955   0 40.3 43.9 80.5         1927590.69 2732074.19 0.0 0.0 0.0 0.0   4010780001 4023526
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
6710 6710 2010 2806825 starr QUEENS 30-03 review ave 11,101 Service (Vehicle Repair/Service, Postal Service) 171,278     0 217.0 233.4 335.2 2.0 125.89 1.0 757.45 8.0 29.0           4002950045 4307187

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