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

78 rows where Borough = "MANHATTAN" 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, ENERGY STAR Score, Water Use (kgal), BBL, BIN

These facets timed out: Property Type

Calendar Year 12

Borough 1

  • MANHATTAN · 78 ✖
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
243400 243400 2022 5983666 Open Road Audi: 802 11th Ave MANHATTAN 802 11th Ave 10019 Automobile Dealership 243,960 1967 1 Not Available 56.6 57.5 110.2 955.5 41.98 356.6 598.8 7083558.1 6714699.8 0.0 0.0 0.0 0.0 1339.0 1-01084-0001 1080969
252093 252093 2022 4124879 Spectrum - Charter Communications MANHATTAN 2485 2nd Avenue 10035 Automobile Dealership 137,456 2004 1 Not Available 46.3 47.1 123.4 522.8 40.9 26.2 496.6 5874410.2 493600.0 0.0 0.0 0.0 0.0 353.9 1-01792-0019 1054700
257624 257624 2022 6672452 Manhattan Motorcars MANHATTAN 711 11th. Avenue 10019 Automobile Dealership 135,000 1930 1 Not Available 75.6 75.0 167.5 755.7 60.28 180.9 574.8 6798832.1 3405707.3 0.0 0.0 0.0 0.0 0.0 1010980036 1027135
266558 266558 2022 25178230 2495 Second Avenue MANHATTAN 2495 Second Avenue 10035 Automobile Dealership 91,256 2004 1 Not Available 33.5 33.5 90.8 253.7 30.14 8.4 245.2 2900759.5 158700.0 0.0 0.0 0.0 0.0 0.0 1-01792-0005 1087849
267212 267212 2022 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue 10036 Automobile Dealership 75,000 1940 1 Not Available 39.8 40.5 80.0 209.9 30.14 71.5 138.4 1637210.8 1345300.0 0.0 0.0 0.0 0.0 633.8 1-01095-0029 1027121
267262 267262 2022 6312752 235 W. 154th Street MANHATTAN 235 W. 154th Street 10039 Automobile Dealership 35,522 1925 1 Not Available 61.4 61.9 115.1 148.1 45.21 61.2 86.9 1027912.7 1152700.0 0.0 0.0 0.0 0.0 182.5 1-02040-0021 1060631
215857 215857 2021 5983666 Open Road Audi: 802 11th Ave MANHATTAN 802 11th Ave 10019 Automobile Dealership 243,960 1967 1 Not Available 55.7 58.2 111.3 874.3 38727.89 331.4 542.9 7357590.6 6239386.3 0.0 0.0 0.0 0.0 1380.2 1-01084-0001 1080969
228344 228344 2021 4124879 Spectrum - Charter Communications MANHATTAN 2485 2nd Avenue 10035 Automobile Dealership 137,456 2004 1 Not Available 50.4 52.3 134.9 501.3 39386.45 26.3 475.0 6437753.4 495630.4 0.0 0.0 0.0 0.0 0.0 1-01792-0019 1054700
234670 234670 2021 6312752 235 W. 154th Street MANHATTAN 235 W. 154th Street 10039 Automobile Dealership 35,522 1925 1 Not Available 57.1 59.5 108.0 127.9 39334.37 56.0 71.9 974458.9 1054997.0 0.0 0.0 0.0 0.0 140.9 1-02040-0021 1060631
237434 237434 2021 2820273 Potamkin Developement LLC MANHATTAN 2495 2nd Avenue 10035 Automobile Dealership 91,256 2004 1 Not Available 19.8 21.2 36.0 112.6 13318.85 54.1 58.5 792218.0 1018906.5 0.0 0.0 0.0 0.0 0.0 1-01792-0005 1087849
241539 241539 2021 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue 10036 Automobile Dealership 75,000 1940 1 Not Available 49.3 51.9 96.5 235.9 33856.05 94.4 141.5 1917572.5 1778200.3 0.0 0.0 0.0 0.0 1609.4 1-01095-0029 1027121
188808 188808 2020 2820273 Potamkin Developement LLC MANHATTAN 2495 2nd Avenue 10035 Automobile Dealership 91256 2004 1 Not Available 54.0 56.2 96.6 316.4 37.32 150.8 165.6 2083790.9 2839909.0 0.0 0.0 0.0 0.0 0.0 1-01792-0005 1087849
191019 191019 2020 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue 10036 Automobile Dealership 75000 1940 1 Not Available 53.1 55.9 107.3 269.7 38.71 94.2 175.5 2208830.3 1772674.8 0.0 0.0 0.0 0.0 1414.7 1-01095-0029 1027121
191790 191790 2020 4124879 Spectrum - Charter Communications MANHATTAN 2485 2nd Avenue 10035 Automobile Dealership 137456 2004 1 Not Available 46.2 47.4 124.7 495.1 38.77 20.0 475.1 5978387.8 377209.8 0.0 0.0 0.0 0.0 259.8 1-01792-0019 1054700
195242 195242 2020 5983666 Open Road Audi: 802 11th Ave MANHATTAN 802 11th Ave 10019 Automobile Dealership 243960 1967 1 Not Available 57.8 68.3 106.8 918.7 40.53 408.5 510.1 6419770.5 7691560.3 0.0 0.0 0.0 0.0 1051.0 1-01084-0001 1080969
198997 198997 2020 6312752 235 W. 154th Street MANHATTAN 235 W. 154th Street 10039 Automobile Dealership 35522 1925 1 Not Available 61.6 69.6 107.7 139.2 42.18 69.9 69.3 872156.5 1316356.6 0.0 0.0 0.0 0.0 0.0 1-02040-0021 1060631
201345 201345 2020 6672452 Manhattan Motorcars MANHATTAN 711 11th. Avenue 10019 Automobile Dealership 135000 1930 1 Not Available 96.8 101.2 216.7 928.2 74.01 223.2 705.0 8871867.0 4202601.9 0.0 0.0 0.0 0.0 0.0 1010980036 1027135
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
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
135127 135127 2018 2820270 706 Manhattan LLC MANHATTAN 706 11th Avenue 10019 Automobile Dealership 65,625 1,930 1 Not Available 84.7 84.9 138.7 354.2 58654.98 195.9 158.2 1868535.2 3688582.2 0.0 0.0 0.0 0.0 0.0 1-01079-0003 1080967
135128 135128 2018 2820273 Potamkin Developement LLC MANHATTAN 2495 2nd Avenue 10035 Automobile Dealership 91,256 2,004 1 Not Available 77.1 75.9 148.0 484.2 57273.41 188.4 295.7 3491928.9 3547709.2 0.0 0.0 0.0 0.0 0.0 1-01792-0005 1087849
137605 137605 2018 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue 10036 Automobile Dealership 75,000 1,940 1 Not Available 59.4 59.6 128.0 325.4 46700.97 87.2 238.2 2812348.0 1641650.6 0.0 0.0 0.0 0.0 0.0 1-01095-0029 1027121
138526 138526 2018 4124879 Potamkin Hy Holdings LLC MANHATTAN 2485 2nd Avenue 10035 Automobile Dealership 137,456 2,004 1 Not Available 36.4 36.6 89.8 393.9 30948.18 50.8 343.1 4051059.1 956753.5 0.0 0.0 0.0 0.0 462.7 1-01792-0019 1054700
146747 146747 2018 6312752 235 W. 154th Street MANHATTAN 235 W. 154th Street 10039 Automobile Dealership 35,522 1,925 1 Not Available 66.2 65.2 132.3 165.1 50774.85 57.2 107.9 1274023.6 1077236.9 0.0 0.0 0.0 0.0 0.0 1-02040-0021 1060631
149521 149521 2018 6672452 Manhattan Motorcars MANHATTAN 711 11th. Avenue 10019 Automobile Dealership 135,000 1,930 1 Not Available 97.4 0.0 209.7 960.1 76551.26 258.2 0.0 0.0 4861818.3 0.0 0.0 0.0 0.0 0.0 1010980036 1027135
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
88577 88577 2016 2,820,270 706 MANHATTAN LLC MANHATTAN 706 11 AVENUE 10019 Automobile Dealership 65,625 1,930 1 Not Available 98.9 107.9 164.1 419.7 69501.67 244.2 175.5 1891612.8 4597300.1 0.0 0.0 0.0 0.0 0.0 1010790003 1080967
88578 88578 2016 2,820,273 Potamkin Developement LLC MANHATTAN 2495 2 AVENUE 10035 Automobile Dealership 91,256 2,004 1 Not Available 76.5 81.7 161.0 510.6 60396.12 183.7 326.9 3522548.9 3459300.2 0.0 0.0 0.0 0.0 0.0 1017920005 1087849
88579 88579 2016 4,124,879 POTAMKIN HY HOLDINGS LLC MANHATTAN 2485 2nd ave 10035 Automobile Dealership 137,456 2,004 1 Not Available 35.0 35.8 101.0 423.3 33258.09 31.7 391.6 4219961.2 596400.0 0.0 0.0 0.0 0.0 0.0 1-01792-0019 1054700
64099 64099 2015 3104030 711 11 AVENUE MANHATTAN 711 11 AVENUE 10019 Automobile Dealership 115500 1930 1 Not Available 40.3 40.3 117.6 371.3 34.6 26.4 344.9 4158145.2 497022.6 0.0 0.0 0.0 0.0 0.0 1010980036 1027135
66183 66183 2015 2820270 706 MANHATTAN LLC MANHATTAN 706 11 AVENUE 10019 Automobile Dealership 65625 1930 1 Not Available 62.6 63.1 123.9 272.5 44.7 121.0 151.5 1827194.2 2277699.8 0.0 0.0 0.0 0.0 0.0 1010790003 1080967
66184 66184 2015 2820273 Potamkin Developement LLC MANHATTAN 2495 2 AVENUE 10035 Automobile Dealership 91256 2004 1 Not Available 74.1 74.2 162.0 468.7 55.28 163.8 304.8 3675406.6 3084600.1 0.0 0.0 0.0 0.0 0.0 1017920005 1087849
66185 66185 2015 4124879 POTAMKIN HY HOLDINGS LLC MANHATTAN 2485 2nd ave 10035 Automobile Dealership 137456 2004 1 Not Available 53.2 53.2 154.4 581.6 45.54 44.3 537.3 6478705.1 834499.9 0.0 0.0 0.0 0.0 0.0 1-01792-0019 1054700
66189 66189 2015 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue 10036 Automobile Dealership 75000 1940 1 Not Available 57.8 56.4 129.3 303.5 43.56 99.3 204.2 2462446.1 1869594.8 0.0 0.0 0.0 0.0 906.6 1-01095-0029 1027121
70645 70645 2015 4957573 Girt Realty LLC MANHATTAN 646 11th Avenue 10036 Automobile Dealership 50207 1946 1 Not Available 112.1 110.1 242.5 388.3 83.25 139.8 248.5 2996378.8 2632522.4 0.0 0.0 0.0 0.0 749.5 1-01076-0001 1026982
52252 52252 2014 2707343 MBM, 514 11th Avenue MANHATTAN 514 11th Avenue 10018 Automobile Dealership 411153 1967 1 Not Available 34.9 34.9 49.1 834.7 21.85 631.1 203.7 2455707.8 11881228.4 0.0 0.0 0.0 0.0 0.0 1-01069-0001 1800775;1088726
55204 55204 2014 2820270 706 MANHATTAN LLC MANHATTAN 706 11 AVENUE 10019 Automobile Dealership 65625 1930 1 Not Available 72.4 63.6 131.0 303.8 49.83 160.3 143.4 1729474.5 3018494.1 0.0 0.0 0.0 0.0 0.0 1010790003 1080967
55205 55205 2014 2820273 Potamkin Developement LLC MANHATTAN 2495 2 AVENUE 10035 Automobile Dealership 91256 2004 1 Not Available 75.5 72.7 166.1 479.0 56.5 164.3 314.7 3794143.7 3093720.7 0.0 0.0 0.0 0.0 0.0 1017920005 1087849
56272 56272 2014 3029926 MBM, 770 11th Ave MANHATTAN 770 11th Avenue 10019 Automobile Dealership 330000 2009 1 Not Available 106.1 103.8 237.1 2451.2 79.95 805.5 1645.7 19843664.1 15164798.3 0.0 0.0 0.0 0.0 0.0 1-01082-7501 1088726
58779 58779 2014 3856170 GIRT Realty LLC MANHATTAN 547 West 47th Street 10036 Automobile Dealership 50207 1946 1 Not Available 129.0 120.6 263.2 435.4 93.35 180.9 254.5 3069212.2 3405455.6 0.0 0.0 0.0 0.0 755.4 1-1076-001 1026982
58784 58784 2014 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue 10036 Automobile Dealership 75000 1940 1 Not Available 69.3 65.2 151.0 359.8 51.64 127.0 232.7 2806194.2 2391659.2 0.0 0.0 0.0 0.0 904.3 1010950029 1027121
60147 60147 2014 4124879 POTAMKIN HY HOLDINGS LLC MANHATTAN 2485 2nd ave 10035 Automobile Dealership 137456 2004 1 Not Available 58.1 56.5 135.1 569.3 44.58 165.3 404.1 4872336.1 0.0 0.0 0.0 0.0 0.0 0.0 01-01792-0019 1054700
38490 38490 2013 2671527 Manhattan Ford Lincoln MANHATTAN 787 11th Avenue 10019 Automobile Dealership 411845 1,929 1 Not Available 47.6 46.5 98.2 1309.5 34.22 536.1 773.4 9505541.0 10100617.0 0.0 0.0 0.0 0.0 3272.4 1-01102-0029 1027156
39426 39426 2013 2707343 MBM, 514 11th Avenue MANHATTAN 514 11th Avenue 10018 Automobile Dealership 411153 1,967 1 Not Available 32.0 32.0 55.7 820.8 21.49 466.7 354.1 4351645.5 8794173.3 0.0 0.0 0.0 0.0 0.0 1010690001 1800775;1088726
42940 42940 2013 2820270 706 MANHATTAN LLC MANHATTAN 706 11 AVENUE 10019 Automobile Dealership 65625 1,930 1 Not Available 102.2 101.4 175.5 416.6 68.33 242.6 174.0 2138368.6 4570999.6 0.0 0.0 0.0 0.0 0.0 1010790003 1080967
42941 42941 2013 2820273 Potamkin Developement LLC MANHATTAN 2495 2 AVENUE 10035 Automobile Dealership 91256 2,004 1 Not Available 69.2 68.6 152.6 433.7 51.16 149.7 284.0 3491158.3 2821299.8 0.0 0.0 0.0 0.0 0.0 1017920005 1087849
44120 44120 2013 3029926 MBM, 770 11th Ave MANHATTAN 770 11th Avenue 10019 Automobile Dealership 330000 2,009 1 Not Available 110.7 110.4 244.6 2512.1 81.94 862.8 1649.3 20270912.7 16256434.6 0.0 0.0 0.0 0.0 0.0 1010851001; 1010851011 1088726
44400 44400 2013 3104030 711 11 AVENUE MANHATTAN 711 11 AVENUE 10019 Automobile Dealership 115500 1,930 1 Not Available 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 116.9 1010980036 1027135
47238 47238 2013 3856170 GIRT Realty LLC MANHATTAN 547 West 47th Street 10036 Automobile Dealership 50207 1,946 1 Not Available 187.1 184.8 439.0 663.2 142.18 189.2 474.0 5826292.4 3565600.4 0.0 0.0 0.0 0.0 763.0 1010760001 1026982
47243 47243 2013 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue 10036 Automobile Dealership 75000 1,940 1 Not Available 80.9 80.7 170.3 408.8 58.67 159.6 249.2 3062852.6 3007674.1 0.0 0.0 0.0 0.0 886.9 1010950029 1027121
26617 26617 2012 2707343 MBM, 514 11th Avenue MANHATTAN 514 11th Avenue 10,018 Automobile Dealership 411153 1967   0 29.3 32.3 51.8         3783997.82 8269632.26 0.0 0.0 0.0 0.0   1010690001 1000000
30957 30957 2012 2820270 706 MANHATTAN LLC MANHATTAN 706 11 AVENUE 10,019 Automobile Dealership 65625 1930   0 82.7 82.7 159.3         2082684.8 3343400.0 0.0 0.0 0.0 0.0   1010790003 1080967
30958 30958 2012 2820273 Potamkin Developement LLC MANHATTAN 2495 2 AVENUE 10,035 Automobile Dealership 91256 2004   0 69.9 69.9 173.4         3989310.4 2387600.0 0.0 0.0 0.0 0.0   1017920005 1087849
32339 32339 2012 3029926 MBM, 770 11th Ave MANHATTAN 770 11th Avenue 10,019 Automobile Dealership 330000 2009   0 104.6 109.4 256.4         21132161.79 13386908.82 0.0 0.0 0.0 0.0   1010827501 1088726
32685 32685 2012 3104030 711 11 AVENUE MANHATTAN 711 11 AVENUE 10,019 Automobile Dealership 115500 1930   0 29.6 32.2 64.3         1677976.51 1735865.3 0.0 0.0 0.0 0.0   1010980036 1027135
12589 12589 2011 3118604 706 MANHAT MANHATTAN 706 11TH AVE 10,019 Automobile Dealership 65,625 1940   0 33.6 33.6 112.1 206.86 34255.7   206.86 2.0             1010790003 1080967
12606 12606 2011 3029926 Mercedes B MANHATTAN 770 11th Avenue 10,019 Automobile Dealership 330,000 2009   0 75.8 72.0 221.7 2.0 65.24 241.84 1.0 20.0 4.0           1010851001 1088726
12620 12620 2011 3104030 711 11 AVENUE MANHATTAN 711 11 AVENUE 10,019 Automobile Dealership 115,500 1930   0 31.7 31.8 64.3 258.28 24174.78 111.09 147.19 1.0 2.0           1010980036 1027135
14805 14805 2011 3118694 POTAMKIN D MANHATTAN 2495 2ND AVE 10,035 Automobile Dealership 91,256 2005   0 33.6 33.6 112.1 287.66 34025.75   287.66 3.0             1017920005 1087849
14826 14826 2011 3118699 POTAMKIN H MANHATTAN 2485 2ND AVE 10,035 Automobile Dealership 137,456 2005   0 31.8 32.2 106.3 410.54 32255.56   410.54 4.0             1017920019 1054700

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