home / nyc_ll84

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

10 rows where Calendar Year = 2012 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: Year Built, Site EUI (kBtu/ft2), Weather Norm Site EUI (kBtu/ft2), Source EUI (kBtu/ft2), Electricity (kBtu), Natural Gas Use (kBtu), Fuel Oil #2 Use (kBtu)

Borough 3

  • QUEENS 4
  • BROOKLYN 3
  • BRONX 2

Property Type 1

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

Calendar Year 1

  • 2012 · 10 ✖
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
24864 24864 2012 2663193 The FEGS Weinberg Center BRONX 3600 Jerome Avenue 10,467 Service (Vehicle Repair/Service, Postal Service) 77220 1929   0 56.7 57.7 151.4         3117203.2 188800.0 0.0 1074435.3 0.0 0.0   2033290085 2017852
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
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
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
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
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
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
34849 34849 2012 3508368 Bronx 104 BRONX 635 Zerega Avenue 10,473 Service (Vehicle Repair/Service, Postal Service) 135700 2001   0 43.4 43.4 127.5         4854654.14 1035845.26 0.0 0.0 0.0 0.0   2035760050 2114541
34850 34850 2012 3508436 Queens HD 3114   24-25 Brooklyn Queens Express W 11,377 Service (Vehicle Repair/Service, Postal Service) 52400 1965   0 45.6 45.6 94.6         1070597.29 1319496.77 0.0 0.0 0.0 0.0      

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");
Powered by Datasette · Queries took 1956.084ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability