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

25 rows where Calendar Year = 2019 and Property Type = "Automobile Dealership" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Postal Code, Floor Area (ft2), Year Built, Number of Buildings, Direct GHG (MtCO2e), Indirect GHG (MtCO2e), Natural Gas Use (kBtu), Water Use (kgal), BBL

Borough 4

Property Type 1

  • Automobile Dealership · 25 ✖

Calendar Year 1

  • 2019 · 25 ✖
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
160429 160429 2019 2820270 706 Manhattan LLC MANHATTAN 706 11th Avenue 10019 Automobile Dealership 65,625 1930 1 Not Available 84.3 83.9 137.6 352.0 58290.66 196.4 155.7 1838385.6 3696799.7 0.0 0.0 0.0 0.0 0.0 1-01079-0003 1080967
160430 160430 2019 2820273 Potamkin Developement LLC MANHATTAN 2495 2nd Avenue 10035 Automobile Dealership 91,256 2004 1 Not Available 68.2 68.8 123.9 416.8 49301.03 185.7 231.0 2727994.6 3496868.7 0.0 0.0 0.0 0.0 0.0 1-01792-0005 1087849
162846 162846 2019 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue 10036 Automobile Dealership 75,000 1940 1 Not Available 62.7 62.2 127.5 333.2 47820.42 109.2 224.0 2644874.9 2055593.9 0.0 0.0 0.0 0.0 813.5 1-01095-0029 1027121
166503 166503 2019 5224698 50-30 Northern Blvd QUEENS 50-30 Northern Blvd 11101 Automobile Dealership 60,485 1960 1 Not Available 83.1 83.2 112.0 293.9 52725.17 221.3 72.6 857668.8 4166629.2 0.0 0.0 0.0 0.0 0.0 4-00120-0028 4000823
167462 167462 2019 5983666 Open Road Audi: 802 11th Ave MANHATTAN 802 11th Ave 10019 Automobile Dealership 243,960 1967 1 Not Available 59.9 58.9 116.6 1012.3 44840.72 378.0 634.3 7489883.3 7116854.0 0.0 0.0 0.0 0.0 1567.2 1-01084-0001 1080969
171642 171642 2019 6312752 235 W. 154th Street MANHATTAN 235 W. 154th Street 10039 Automobile Dealership 35,522 1925 1 Not Available 66.6 65.3 123.5 160.0 49206.4 68.1 91.9 1085505.7 1281806.5 0.0 0.0 0.0 0.0 0.0 1-02040-0021 1060631
174225 174225 2019 6672452 Manhattan Motorcars MANHATTAN 711 11th. Avenue 10019 Automobile Dealership 135,000 1930 1 Not Available 103.2 102.4 235.0 1048.2 83575.7 220.9 827.3 9768866.1 4158036.5 0.0 0.0 0.0 0.0 0.0 1010980036 1027135
174458 174458 2019 6678589 153-20 South Conduit Avenue QUEENS 15320 South Conduit Ave 11434 Automobile Dealership 59,000 1998 1 Not Available 117.1 115.3 226.3 274.8 50134.23 104.7 170.2 2009429.1 1970599.9 0.0 0.0 0.0 0.0 458.6 4-14260-0111 4575340
175278 175278 2019 6694323 rydan BRONX 110 E 138th st 10451 Automobile Dealership 30,284 1930 1 Not Available 41.8 40.8 71.6 82.3 29528.97 41.7 40.6 479926.1 784966.7 0.0 0.0 0.0 0.0 0.0 2023230043 2000815;2815311
177267 177267 2019 6798925 36-11 Northern Blvd QUEENS 36-11 Northern Blvd 11101 Automobile Dealership 30,000 1931 1 Not Available 114.5 114.2 178.7 214.2 76854.25 129.3 84.8 1001872.4 2434567.3 0.0 0.0 0.0 0.0 178.3 4-00378-0001 4004571
177496 177496 2019 6802619 Bayside: 212-19 Northern Blvd. QUEENS 212-19 Northern Blvd. 11361 Automobile Dealership 36,581 1966 1 Not Available 75.4 75.1 127.2 178.2 53281.3 93.4 84.9 1002104.4 1757912.4 0.0 0.0 0.0 0.0 0.0 4062860032 4138259
178118 178118 2019 6819514 BRAM - 40-40 Northern Boulevard QUEENS 40-40 Northern Boulevard 11101 Automobile Dealership 37,610 1971 1 Not Available 151.4 149.9 277.5 382.9 111391.82 167.1 215.8 2548006.8 3145279.9 0.0 0.0 0.0 0.0 0.0 4-00183-0009 4436669
178119 178119 2019 6819515 BRAM - 6401 6th Avenue BROOKLYN 6401 6th Avenue 11220 Automobile Dealership 35,350 1931 1 Not Available 59.1 58.6 150.2 167.3 51451.44 16.5 150.7 1779954.0 310900.0 0.0 0.0 0.0 0.0 0.0 3-05820-0005 3328800
178120 178120 2019 6819516 BRAM - 6502 5th Avenue BROOKLYN 6502 5th Avenue 11220 Automobile Dealership 34,746 1931 1 Not Available 113.9 117.1 172.8 243.6 77120.18 154.1 89.5 1056694.1 2901100.1 0.0 0.0 0.0 0.0 1396.6 3-05818-0027 3144161
178250 178250 2019 6821854 MICHAEL NACLERIO QUEENS 92-12 172nd Street 11433 Automobile Dealership 25,942 1922 1 Not Available 87.3 85.5 167.2 155.7 67037.57 60.9 94.8 1119348.8 1146538.0 0.0 0.0 0.0 0.0 27265.6 4/10212/0011 4217488
179210 179210 2019 7468642 95-10 Ditmars Blvd QUEENS 2201 95 St 11369 Automobile Dealership 143,934 1976 1 Not Available 24.0 23.9 42.8 229.0 17237.29 106.2 122.8 1449772.5 2000300.0 0.0 0.0 0.0 0.0 9480.8 4-01072-0001 4439596
179960 179960 2019 8718579 4814 Glenwood Rd BROOKLYN 4814 Glenwood Rd 11234 Automobile Dealership 34,840 1950 1 Not Available 160.8 160.6 217.4 328.1 103871.64 246.0 82.0 968581.5 4632300.2 0.0 0.0 0.0 0.0 0.0 3-07732-0045 3213509
182320 182320 2019 11591208 MMC Brooklyn BROOKLYN 2875 Flatbush Avenue 11234 Automobile Dealership 45,696 1991 1 Not Available 15.9 15.9 44.6 61.7 14758.5 0.0 61.7 728147.5 0.0 0.0 0.0 0.0 0.0 0.0 3085910125 3242373
182339 182339 2019 11609549 2859 Flatbush Avenue BROOKLYN 2859 Flatbush Avenue 11234 Automobile Dealership 147,187 2016 1 Not Available 24.8 24.3 43.2 239.4 17529.78 116.6 122.8 1449756.4 2194699.8 0.0 0.0 0.0 0.0 172.8 3-08591-0150 3425369
182510 182510 2019 11849778 City Cadillac QUEENS 43-60 Northern Blvd 11101 Automobile Dealership 28,732 1989 1 Not Available 90.8 90.7 156.3 170.2 65429.13 85.5 84.7 999770.6 1609566.8 0.0 0.0 0.0 0.0 0.0 4-00143-0500 4441943
182511 182511 2019 11849808 Old Regan Bldg QUEENS 43-20 Northern Blvd 11101 Automobile Dealership 28,732 1989 1 Not Available 16.2 16.3 45.5 39.5 15184.79 0.0 39.5 466600.6 0.0 0.0 0.0 0.0 0.0 1931.3 4-00143-0500 4542920
182512 182512 2019 11849810 Major World QUEENS 43-40 Northern Blvd 11101 Automobile Dealership 28,732 1989 1 Not Available 124.8 123.6 235.9 244.8 94107.24 99.1 145.7 1720263.7 1866682.9 0.0 0.0 0.0 0.0 0.0 4-00143-0500 4430172; 4441945
182753 182753 2019 12002753 General Motors Site A (Parent)   43-20, 43-40, 43-60 Northern Blvd 11101 Automobile Dealership 86,196 1989 3 Not Available 77.3 76.6 145.9 454.5 56885.96 184.6 269.9 3186634.9 3476249.7 0.0 0.0 0.0 0.0 1931.3 4-00143-0500 4441943; 4430172; 4441945; 4542920
182800 182800 2019 12011923 105-20 Gerard Place QUEENS 105-20 Gerard Place 11375 Automobile Dealership 50,000 1950 1 Not Available 89.6 89.1 152.6 290.8 62602.84 149.2 141.6 1672355.5 2809099.7 0.0 0.0 0.0 0.0 0.0 4032360022 4836336
183559 183559 2019 12860567 30-35 College Point Blvd QUEENS 30-35 College Point Blvd 11354 Automobile Dealership 81,532 1989 1 Not Available 73.6 73.6 147.2 404.5 53753.06 145.4 259.1 3260370.7 2737416.8 0.0 0.0 0.0 0.0 624.6 4-04357-0100 4539230

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