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

84 rows where Borough = "QUEENS" and Property Type = "Retail" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Postal Code, Year Built, Total GHG (MtCO2e), Direct GHG (MtCO2e), Indirect GHG (MtCO2e), Fuel Oil #2 Use (kBtu), Fuel Oil #4 Use (kBtu)

Calendar Year 3

Property Type 1

  • Retail · 84 ✖

Borough 1

  • QUEENS · 84 ✖
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
22925 22925 2012 1547633 COLLEGE POINT (1150) QUEENS 13505 20TH AVE 11,356 Retail 139899 1998   79 83.8 85.7 229.5         8643119.16 3087281.0 0.0 0.0 0.0 0.0   4041430001 4462119
23019 23019 2012 2038377 1544 QUEENS 9605 QUEENS BLVD 11,374 Retail 197645 1996   63 51.8 51.6 166.2         9646641.83 593300.0 0.0 0.0 0.0 0.0   4020840101 4050415
23054 23054 2012 2343744 9419 QUEENS 66-26 Metropolitan Avenue 11,379 Retail 139755 1999   67 52.2 52.2 174.5         7301130.67 0.0 0.0 0.0 0.0 0.0   4036050001 4443103
23548 23548 2012 2598293 Rego II QUEENS 61-35 Junction Blvd 11,374 Retail 623684 2009   29 111.9 112.5 373.6         69772126.79 0.0 0.0 0.0 0.0 0.0   4020807501 4615634
23551 23551 2012 2598358 Flushing QUEENS 13620 Roosevelt Ave 11,354 Retail 166738 1967   28 165.3 165.5 312.1         10111254.2 17443400.0 0.0 0.0 0.0 0.0   4050190005 4113546
23557 23557 2012 2598405 Queens Boulevard QUEENS 99-01 Queens Boulevard 11,374 Retail 56916 1952   38 75.8 75.7 253.3         4316173.11 0.0 0.0 0.0 0.0 0.0   4021180001 4050967
24263 24263 2012 2646602 (71001A) Queens-Rego Park QUEENS 90-15 Queens Blvd 3 North West 11,373 Retail 375888 1973   92 37.4 38.3 123.3         13787599.54 281098.0 0.0 0.0 0.0 0.0   4018600100 4045999
24276 24276 2012 2647009 (71185A) Flushing QUEENS 136-50 Roosevelt Ave 11,364 Retail 276732 1951   83 40.8 38.8 133.9         11001634.41 282855.7 0.0 0.0 0.0 0.0   4050190024 4113551
27070 27070 2012 2721867 WIN DEPOT QUEENS 42 52 NORTHERN BLVD 11,101 Retail 55176 1982   0 45.7 48.5 100.7         1272475.61 1250024.62 0.0 0.0 0.0 0.0   4001830146 4002368
27980 27980 2012 2771229 259-19 Union Tpke QUEENS 259-19 Union Tpke 11,004 Retail 181187 1949   0 154.5 157.0 461.9         23719606.75 4274517.4 0.0 0.0 0.0 0.0   4085130002 4439455
28956 28956 2012 2797575 Rego Park QUEENS 96-31 Queens Boulevard 11,374 Retail 342728 2010   55 77.3 76.4 258.2         26496940.42 0.0 0.0 0.0 0.0 0.0      
29452 29452 2012 2804420 Jamaica Ave Property QUEENS 163-19 Jamaica Ave 11,432 Retail 54978 1952   61 64.0 61.9 191.6         2993180.41 140300.0 0.0 386807.8 0.0 0.0   4097930001 4209572
31465 31465 2012 2856349 Queensboro Toyota QUEENS 62-10 Northern Boulevard 11,377 Retail 40500 1950   45 110.5 117.1 209.5         1656955.25 2819100.0 0.0 0.0 0.0 0.0   4011850001 4027108
31637 31637 2012 2921876 Costco #243 Queens QUEENS 32-50 Vernon Blvd 11,106 Retail 114154 1996   19 190.7 188.4 490.4         14473249.07 7297366.67 0.0 0.0 0.0 0.0   4003130001 4436725
31839 31839 2012 2954997 Flushing Mall QUEENS 133-31 39th Ave 11,354 Retail 148680 1995   46 102.0 107.9 223.8         7588930.26 7573252.94 0.0 0.0 0.0 0.0      
32093 32093 2012 2974917 Parkwill: 72-25 Woodhaven QUEENS 72-25 Woodhaven Blvd 11,385 Retail 53500 1959   82 44.3 42.5 148.1         2372022.4 0.0 0.0 0.0 0.0 0.0   4038840002 4095019
32121 32121 2012 2975487 Federal 310 QUEENS 61-11 188th St. 11,365 Retail 149981 1950   9 211.1 212.0 434.1         13939666.49 17716640.83 0.0 0.0 0.0 0.0   4071170130 4153294
32122 32122 2012 2975494 Federal 207/321 QUEENS 186-01 73rd Ave. 11,366 Retail 137839 1950   20 97.3 97.3 324.9         13409612.49 0.0 0.0 0.0 0.0 0.0   4071150030 4454260
32161 32161 2012 2976816 Home Depot #1220 Woodhaven Blvd QUEENS 75-11 Woodhaven Blvd 11,385 Retail 121731 2000   32 104.3 105.6 291.8         9694656.09 3001181.82 0.0 0.0 0.0 0.0   4038860074 4095037
32162 32162 2012 2976834 Home Depot #1214 Flushing QUEENS 131-35 Avery Ave. 11,355 Retail 122750 1995   36 103.5 106.1 274.8         8906105.79 3801451.52 0.0 0.0 0.0 0.0   4050660622 4115028
32237 32237 2012 2981291 The Colosseum QUEENS 89-02 165th Street 11,432 Retail 122000 1947   63 105.2 99.3 207.0         5199342.08 4787200.0 0.0 2843848.7 0.0 0.0   4097940048 4209595
32257 32257 2012 2991021 97-16 63rd Rd. LLC QUEENS 97-16 63rd Rd. 11,374 Retail 10480 1959   0 0.0 0.0 0.0         0.0 0.0 0.0 0.0 0.0 0.0   4020890006 4050426
32353 32353 2012 3050380 DE4 1436 - Big Six Towers Retail QUEENS 61-10 Queens Blvd 11,377 Retail 70000 1966   87 181.4 188.4 243.9         1713056.02 6939000.0 0.0 4044076.29 0.0 0.0   4023140100 4437383
32369 32369 2012 3065498 Home Depot #1215 Ozone Park QUEENS 11220 Rockaway Blvd 11,420 Retail 122384 1994   41 99.5 103.0 249.7         7762422.07 4420414.38 0.0 0.0 0.0 0.0   4115430100 4446012
32372 32372 2012 3066772 Home Depot #1255 Long Island City QUEENS 50-10 Northern Boulevard 11,101 Retail 136026 1999   41 96.6 98.8 256.8         9237592.97 3896250.0 0.0 0.0 0.0 0.0   4001200050 4000825
32374 32374 2012 3066791 Home Depot #1238 Springfield Gardens QUEENS 13220 Merrick Blvd 11,434 Retail 125460 2001   45 80.5 81.1 234.4         8209331.45 1895702.93 0.0 0.0 0.0 0.0   4129990044 4279930
32382 32382 2012 3068525 Home Depot #1277 College Point QUEENS 31-44 125 Street 11,354 Retail 116592 2001   58 71.4 71.5 209.6         6853036.12 1476080.42 0.0 0.0 0.0 0.0   4043950002 4438019
33009 33009 2012 3114280 College Point Retail Center QUEENS 135-05 20th Avenue 11,356 Retail 332490 1998   68 114.2 117.0 304.9         26870780.16 11092920.37 0.0 0.0 0.0 0.0   4041430001 4462119
33389 33389 2012 3119998 Heaven 162-21 Jamaica Ave. QUEENS 162-21 Jamaica Ave. 11,432 Retail 99375 1937   0 46.4 46.7 127.1         3403730.96 1204700.0 0.0 0.0 0.0 0.0   4097610083 4208889
33845 33845 2012 3129304 Pat Comings 82-11 37th Ave QUEENS 82-11 37th Ave 11,372 Retail 154708 1995   0 33.5 33.2 87.1         3510353.65 1667500.0 0.0 0.0 0.0 0.0   4014560041 4035816
33968 33968 2012 3181646 242-02 61st Avenue, Douglaston QUEENS 242-02 61st Avenue 11,362 Retail 299897 1985   58 105.9 104.6 341.8         30200301.22 1571900.0 0.0 0.0 0.0 0.0   4082860185 4438369
34197 34197 2012 3266247 Queens Center QUEENS 90-15 Queens Blvd 11,373 Retail 953134 1973   4 133.2 133.7 444.8         126934458.3 0.0 0.0 0.0 0.0 0.0   4018600100 4045999
34818 34818 2012 3506212 Abeco 162-11 Jamaica LL84 QUEENS 162-11 Jamaica Ave 11,432 Retail 57325 1910   93 27.4 28.3 69.9         1029673.58 543061.29 0.0 0.0 0.0 0.0   4097610095 4540158
35153 35153 2012 3526355 New World Mall QUEENS 136-20 Roosevelt Ave 11,354 Retail 266537 1966   100 5.2 5.2 17.5         1392653.29 0.0 0.0 0.0 0.0 0.0   4050190005 4113546
35651 35651 2012 3538763 154-02 Northern Boulevard QUEENS 154-02 Northern Boulevard 11,354 Retail 54381 2008   72 66.0 65.5 158.1         2110260.58 1480400.0 0.0 0.0 0.0 0.0   4052680019 4119237
11078 11078 2011 2038377 1544 QUEENS 9605 QUEENS BLVD 11,374 Retail 197,645 1996   68 56.4 57.5 166.3 969.14 52952.92 101.56 867.57 9.0 1.0           4020840101 4050415
15619 15619 2011 2804420 Jamaica Av QUEENS 163-19 Jamaica Ave 11,432 Retail 54,978 1952   59 63.2 62.7 198.1 319.88 63762.15 22.45 297.43 3.0 0.0   305.0       4097930001 4209572
18809 18809 2011 3119119 3500 48 Street Owners LLC QUEENS 34-54 48 Street 11,377 Retail 129,790 1979   71 106.7 105.2 276.8 1.0 83.44 239.23 877.45 9.0 4.0           4001430010 BIN#s 4001352, 4518761, 454146
20389 20389 2011 2343744 9419 QUEENS 66-26 Metropolitan Avenue 11,379 Retail 139,755 1999   53 64.8 64.8 216.4 849.99 65821.64   849.99 9.0             4036050001 4443103
20457 20457 2011 2721867 WIN DEPOT QUEENS 42 42 NORTHERN BLVD 11,101 Retail 55,176 1982   0 53.2 54.4 112.6 211.87 41464.5 83.35 128.52 1.0 1.0         446.0 4001830146 4002368
20859 20859 2011 3129304 Pat Comings 82-11 37th Ave QUEENS 82-11 37th Ave 11,372 Retail 154,708 1995   0 22.4 22.0 74.8 325.26 22734.2   325.26 3.0             4014560035 4035816;4035815
20860 20860 2011 3129304 Pat Comings 82-11 37th Ave QUEENS 82-11 37th Ave 11,372 Retail 154,708 1995   0 22.4 22.0 74.8 325.26 22734.2   325.26 3.0             4014560041 4035816;4035815
20966 20966 2011 2797575 Rego Park QUEENS 96-31 Queens Boulevard 11,374 Retail 342,728 2010   57 76.6 76.2 255.9 2.0 62.95   2.0 26.0             4020840101 4050415
20990 20990 2011 2646602 (71001A) Q QUEENS 90-15 Queens Blvd 3 North West 11,373 Retail 375,888 1973   92 37.6 37.6 124.2 1.0 28.7 12.63 1.0 13.0 237.0           4018600100  
21049 21049 2011 2598293 Rego II QUEENS 61-35 Junction Blvd 11,374 Retail 623,684 2009   33 107.1 106.4 357.8 6.0 103.67   6.0 66.0             4020800101 4540407
21055 21055 2011 2991021 97-16 63rd Rd. LLC QUEENS 97-16 63rd Rd. 11,374 Retail 10,480 1959   0                           400.0 4020890006 4050426
21088 21088 2011 2598405 Queens Boulevard QUEENS 99-01 Queens Boulevard 11,374 Retail 56,916 1952   44 71.6 69.2 239.0 382.39 73500.14   382.39 4.0             4021180001 4050967
21124 21124 2011 3114280 College Po QUEENS 135-05 20th Avenue 11,356 Retail 331,130 1998   33 120.7 122.5 314.8 3.0 97.56 678.26 2.0 27.0 12.0           4041430040 4462119;4462121;4462122;4462123;4462124;4850201
21163 21163 2011 3114280 College Po QUEENS 135-05 20th Avenue 11,356 Retail 331,130 1998   33 120.7 122.5 314.8 3.0 97.56 678.26 2.0 27.0 12.0           4041430060 4462119;4462121;4462122;4462123;4462124;4850201
21266 21266 2011 3050380 DE4 1436 - Big Six Towers Retail (Submitted) QUEENS 61-10 Queens Blvd 11,377 Retail 70,000 1966   85 206.0 208.1 259.2 921.48 141695.98 789.33 132.15 1.0 8.0   4.0       4023140100 4437383
21506 21506 2011 2954997 Flushing M QUEENS 133-31 39th Ave 11,354 Retail 148,680 1995   0                           7.0 4049720065  
21522 21522 2011 2974917 Parkwill: 72-25 Woodhaven QUEENS 72-25 Woodhaven Blvd 11,385 Retail 53,500 1959   65 77.7 80.4 200.2 333.95 67822.72 73.47 260.48 2.0 1.0         0.0 4038840002 4095019
21536 21536 2011 3114280 College Po QUEENS 135-05 20th Avenue 11,356 Retail 331,130 1998   33 120.7 122.5 314.8 3.0 97.56 678.26 2.0 27.0 12.0           4041430001 4462119;4462121;4462122;4462123;4462124;4850201
21537 21537 2011 3114280 College Po QUEENS 135-05 20th Avenue 11,356 Retail 331,130 1998   33 120.7 122.5 314.8 3.0 97.56 678.26 2.0 27.0 12.0           4041430020 4462119;4462121;4462122;4462123;4462124;4850201
21538 21538 2011 3114280 College Po QUEENS 135-05 20th Avenue 11,356 Retail 331,130 1998   33 120.7 122.5 314.8 3.0 97.56 678.26 2.0 27.0 12.0           4041430025 4462119;4462121;4462122;4462123;4462124;4850201
21539 21539 2011 3114280 College Po QUEENS 135-05 20th Avenue 11,356 Retail 331,130 1998   33 120.7 122.5 314.8 3.0 97.56 678.26 2.0 27.0 12.0           4041430030 4462119;4462121;4462122;4462123;4462124;4850201
21662 21662 2011 2598358 Flushing QUEENS 13620 Roosevelt Ave 11,354 Retail 166,738 1967   60 97.2 94.8 212.8 1.0 64.84 432.12 758.31 8.0 8.0           4050190005 4113546
21663 21663 2011 2647009 (71185A) F QUEENS 136-50 Roosevelt Ave 11,364 Retail 276,732 1951   87 37.7 37.2 123.5 967.26 37722.79 15.55 951.71 10.0 292.0           4050190024  
21716 21716 2011 3114443 Skyview QUEENS 40-20 College Point Boulevard 11,354 Retail 1,597,554 2006   0 92.9 92.9 310.4 13.0 139930.7   13.0 148.0             4050667501 4534020;4540380;4540453
21947 21947 2011 2998475 71-01 Kissena Blvd. QUEENS 71-01 Kissena Blvd. 11,367 Retail   1050                                 4067930055 4146995
21999 21999 2011 2975494 Federal 20 QUEENS 186-01 73rd Ave. 11,366 Retail 134,506 1950   22 94.2 94.2 314.8 1.0 80.33   1.0 12.0             4071150030 4463782;4454260
22142 22142 2011 3181646 242-02 61s QUEENS 242-02 61st Avenue 11,362 Retail 299,897 1985   91 78.4 80.1 221.0 1.0 36.0 284.85 1.0 18.0 5.0           4082860185 4438369
22184 22184 2011 2771229 259-19 Union Tpke QUEENS 259-19 Union Tpke 11,004 Retail 181,187 1949   0 156.7 153.8 461.5 2.0 118.94 260.84 2.0 23.0 4.0           4085130002 4439455;4440956;4845198
22185 22185 2011 2771229 259-19 Union Tpke QUEENS 259-19 Union Tpke 11,004 Retail 181,187 1949   0 156.7 153.8 461.5 2.0 118.94 260.84 2.0 23.0 4.0           4085130004 4439455;4440956;4845198
22294 22294 2011 3119998 Heaven 162 QUEENS 162-21 Jamaica Ave. 11,432 Retail 99,375 1937   0 49.0 49.9 127.7 393.77 42813.14 82.83 310.94 3.0 1.0           4097610083 4208889
22295 22295 2011 3102732 Abeco 162- QUEENS 162-11 Jamaica Ave 11,432 Retail 57,325 1910   24 92.9 92.9 310.4 500.23 94463.61   500.23 5.0             4097610095 4540158
22303 22303 2011 2981291 The Coloss QUEENS 89-02 165th Street 11,432 Retail 122,000 1947   49 116.2 113.1 251.8 1.0 88.23 430.2 653.71 6.0 4.0   2.0       4097940048 4209595
56 56 2010 2685453 32-75 Steinway St. QUEENS 32-75 Steinway St. 11,103 Retail 47,845     100 42.9 42.9 43.4 151.11 34607.08 151.11   0.0 0.0     2.0     4006760010 4530777
4016 4016 2010 2662836 9030 Metropolitan QUEENS 9030 Metropolitan Ave 11,374 Retail 64,868     29 116.8 116.4 337.1 650.29 109369.63 79.61 570.68 6.0 1.0           4038840034 4095021
4596 4596 2010 1160897 2814-Elmhurst,NY QUEENS 9259 59th Ave 11,373 Retail 204,340     81 56.2 54.6 186.8 1.0 52.76 3.48 1.0 11.0 65.0           4018600102 4530817
4766 4766 2010 2721867 WIN DEPOT QUEENS 42 42 NORTHERN BLVD 11,101 Retail 45,500     0 66.6 68.4 141.6 219.22 52436.94 85.39 133.83 1.0 1.0         603.5    
4922 4922 2010 2646602 (71001A) Queens-Rego Park QUEENS 90-15 Queens Blvd 3 North West 11,373 Retail 375,888     90 40.7 40.1 135.9 1.0 28.7 0.4 1.0 15.0 7.0         3.0 4018600100 4045999
4930 4930 2010 2647009 (71185A) Flushing QUEENS 136-50 Roosevelt Ave 11,364 Retail 276,732     89 36.0 34.5 117.7 922.24 35967.03 15.76 906.48 9.0 296.0         4.0 4050190024 4113551
5969 5969 2010 1775104 College Point Retail Center QUEENS 135-05 20th Ave 11,356 Retail 331,130     3 84.3 81.5 281.5 2.0 65.04   2.0 27.0             4041430001 4462119
6805 6805 2010 1547633 COLLEGE POINT (1150) QUEENS 13505 20TH AVE 11,356 Retail 139,899     72 85.0 86.8 237.8 1.0 77.44 149.53 852.36 9.0 2.0           4041430001 4462119
6874 6874 2010 1547842 QUEENS PLACE (1344) QUEENS 8801 QUEENS BLVD 11,373 Retail 238,504     86 57.7 57.1 151.6 999.22 45191.19 21.66 977.56 9.0 407.0           4018437501 4437281
7301 7301 2010 2598293 Rego II QUEENS 61-35 Junction Blvd 11,374 Retail 623,684     58 79.0 79.0 264.0 4.0 69.11   4.0 49.0             4020807501 4615634
7307 7307 2010 2598358 Flushing QUEENS 13620 Roosevelt Ave 11,354 Retail 166,738     100 8.9 8.9 28.3 135.11 8760.91 5.18 129.93 1.0 97.0           4050190005 4113546
7315 7315 2010 2598405 Queens Boulevard QUEENS 99-01 Queens Boulevard 11,374 Retail 56,916     65 55.1 55.1 184.0 294.37 56581.59   294.37 3.0             4021180001 4050967
7316 7316 2010 2797575 Rego Park QUEENS 96-31 Queens Boulevard 11,374 Retail 342,728     54 79.9 78.4 267.0 2.0 62.95   2.0 27.0                
7717 7717 2010 2038377 1544 QUEENS 9605 QUEENS BLVD 11,374 Retail 197,645     66 58.4 58.5 173.1 1.0 54.64 101.55 905.37 9.0 1.0           4020840101 4050415
7745 7745 2010 2343744 9419 QUEENS 66-26 Metropolitan Ave 11,379 Retail 139,755     48 68.7 68.7 229.6 901.96 69846.1   901.96 9.0             4036050001 4443103
8688 8688 2010 2812767 Abeco 162-11 Jamaica QUEENS 162-11 Jamaica Ave 11,432 Retail 57,325     24 92.9 92.9 310.4 500.23 94463.61   500.23 5.0             4097610095 4540158
9153 9153 2010 2771229 259-19 Union Tpke QUEENS 259-19 Union Tpke 11,004 Retail 145,918     16 85.4 86.0 244.8 1.0 74.23 136.79 928.25 9.0 2.0           4085130002 4439455

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