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

18 rows where Calendar Year = 2017 and Property Type = "Automobile Dealership" 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, 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), BBL, BIN

Borough 3

Property Type 1

  • Automobile Dealership · 18 ✖

Calendar Year 1

  • 2017 · 18 ✖
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
98039 98039 2017 6,301,536 MBB AUTO BROOKLYN 1800 SHORE PARKWAY 11214 Automobile Dealership 43,000 1986 1                               2-6491-362  
98300 98300 2017 5,224,698 50-30 Northern Blvd QUEENS 50-30 Northern Blvd 11101 Automobile Dealership 60,485 1960 1   89.6 98.4 127.3 322.0 57766.26 236.8 85.2 960.0 4.0         68.8 4-00120-0028 4000823
99229 99229 2017 6,301,536 MBB AUTO BROOKLYN 1800 SHORE PARKWAY 11214 Automobile Dealership 43,000 1986 1   146.8 155.9 282.7 429.3 107463.77 194.8 234.5 2.0 3.0         1.0 3-06491-0362  
101374 101374 2017 6,292,075 706 Manhattan MANHATTAN 706 11th Ave 10019 Automobile Dealership 65,625 1930 1   87.3 96.1 153.5 373.3 61817.91 200.9 172.4 1.0 3.0           1-1079-3 1080967
101375 101375 2017 6,292,115 Potamkin Development Co MANHATTAN 2485 2nd Ave 10019 Automobile Dealership 137,456 2004 1   31.7 32.6 88.4 360.3 28308.27 39.2 321.1 3.0 737.0           1-1792-19 1054700
101376 101376 2017 6,292,118 Potamkin Development Co II MANHATTAN 2495 2nd Ave 10019 Automobile Dealership 91,256 2004 1   77.0 82.4 162.6 500.3 59177.79 183.9 316.4 3.0 3.0           1-1792-5 1087849
102703 102703 2017 6,312,752 235 W. 154th Street MANHATTAN 235 W. 154th Street 10039 Automobile Dealership 35,522 1925 1   71.7 75.8 149.0 179.8 55295.69 68.7 111.1 1.0 1.0           1020400021 1060631
102853 102853 2017 3,856,672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue 10036 Automobile Dealership 75,000 1940 1   53.7 55.6 136.7 316.3 45394.95 60.5 255.7 2.0 1.0         326.7 1-01095-0029 1027121
102854 102854 2017 4,957,573 Girt Realty LLC MANHATTAN 646 11th Avenue 10036 Automobile Dealership 50,207 1946 1   94.2 97.3 208.2 344.4 74141.74 111.6 232.8 2.0 2.0         155.7 1-01076-0001 1026982
104021 104021 2017 6,292,115 Potamkin Development Co MANHATTAN 2485 2nd Ave 10019 Automobile Dealership 137,456 2004 1   31.7 32.6 88.4 360.3 28308.27 39.2 321.1 3.0 737.0           1-01792-0019 1054700
104045 104045 2017 6,292,118 Potamkin Development Co II MANHATTAN 2495 2nd Ave 10019 Automobile Dealership 91,256 2004 1   77.0 82.4 162.6 500.3 59177.79 183.9 316.4 3.0 3.0           1-01792-0005 1087849
104078 104078 2017 6,292,075 706 Manhattan MANHATTAN 706 11th Ave 10019 Automobile Dealership 65,625 1930 1   87.3 96.1 153.5 373.3 61817.91 200.9 172.4 1.0 3.0           1-01079-0003 1080967
111574 111574 2017 2,820,270 706 Manhattan LLC MANHATTAN 706 11th Avenue 10019 Automobile Dealership 65,625 1930 1   85.8 94.4 141.9 360.5 59698.25 195.8 164.7 1.0 3.0           1010790003 1080967
111575 111575 2017 2,820,273 Potamkin Developement LLC MANHATTAN 2495 2nd Avenue 10035 Automobile Dealership 91,256 2004 1   77.0 82.4 149.3 486.1 57498.15 183.9 302.3 3.0 3.0           1017920005 1087849
111576 111576 2017 4,124,879 Potamkin Hy Holdings LLC MANHATTAN 2485 2nd Avenue 10035 Automobile Dealership 137,456 2004 1   31.7 32.6 79.4 345.9 27176.88 39.2 306.7 3.0 737.0           1-01792-0019 1054700
121052 121052 2017 6,672,452 Manhattan Motorcars MANHATTAN 711 11th. Avenue 10019 Automobile Dealership 135,000 1930 1   98.1 98.8 224.4 999.4 79684.75 206.3 793.1 9.0 3.0           1-1098-36 1027135
121719 121719 2017 6,672,452 Manhattan Motorcars MANHATTAN 711 11th. Avenue 10019 Automobile Dealership 135,000 1930 1   98.1 98.8 224.4 999.4 79684.75 206.3 793.1 9.0 3.0           1010980036 1027135
122837 122837 2017 6,312,752 235 W. 154th Street MANHATTAN 235 W. 154th Street 10039 Automobile Dealership 35,522 1925 1   71.7 75.8 137.0 174.9 53788.75 68.7 106.1 1.0 1.0           1-02040-0021 1060631

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