GHG — Emissions and Intensity

Total, direct, indirect, and net GHG emissions. Includes GHGI (kgCO2e/m²) calculated for all years.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

2,907 rows where Borough = "QUEENS" and Calendar Year = 2015 sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Calendar Year 1

  • 2015 · 2,907 ✖

Borough 1

  • QUEENS · 2,907 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Property Type Floor Area (ft2) Total GHG (MtCO2e) GHGI (kgCO2e/m2) Direct GHG (MtCO2e) Indirect GHG (MtCO2e) Net GHG (MtCO2e) Grid Emissions Rate (kgCO2e/MBtu) Avoided GHG Onsite (MtCO2e) Avoided GHG Offsite (MtCO2e) National Median GHG (MtCO2e) ENERGY STAR Score Site EUI (kBtu/ft2)
62301 62301 2015 2674133 Lightstone - 98th St Beach Channel Drive QUEENS 319 Beach 98th Street Multifamily Housing 424278 2477.9 62.86 1635.7 842.2 2477.9 82.9 0.0 0.0   0.0 96.5
62302 62302 2015 4035088 Northridge Coop Section II QUEENS 90-08 32nd Avenue Multifamily Housing 415172 2335.9 60.56 1681.8 654.1 2335.9 82.9 0.0 0.0   49.0 90.1
62310 62310 2015 2932560 Lewis Realty - 3410 145 QUEENS 1819 Flushing Avenue Distribution Center 53660 259.2 51.99 20.1 239.1 259.2 82.9 0.0 0.0   4.0 60.8
62311 62311 2015 2939630 Lewis Realty - 3410 190 QUEENS 1819 Flushing Avenue Distribution Center 60376 40.6 7.24 0.0 40.6 40.6 82.9 0.0 0.0   94.0 8.1
62314 62314 2015 3980172 Prestone Press QUEENS 47-50 30th Street Manufacturing/Industrial Plant 52500 693.9 142.27 115.3 578.5 693.9 82.9 0.0 0.0   0.0 182.9
62317 62317 2015 2734844 College Point Multiplex QUEENS 28-55 Ulmer Street Other - Entertainment/Public Assembly 71815 860.7 129.0 215.7 645.0 860.7 82.9 0.0 0.0   0.0 164.8
62321 62321 2015 4320370 Saxon Hall Apartments QUEENS 62-60 99th Street Multifamily Housing 503000 1877.0 40.17 1771.5 105.5 1877.0 82.9 0.0 0.0   97.0 64.4
62328 62328 2015 4414595 Marco Hotel QUEENS 137-07 Northern Blvd Hotel 44000 375.8 91.93 162.7 213.1 375.8 82.9 0.0 0.0   8.0 128.0
62333 62333 2015 3782599 J F K Hilton QUEENS 14402 135Th Ave. Hotel 210000 1901.1 97.44 859.5 1041.6 1901.1 82.9 0.0 0.0   30.0 136.9
62339 62339 2015 4794437 Cypress Garden QUEENS 139-66 35th Avenue Senior Care Community 87106 1040.8 128.61 709.3 331.5 1040.8 82.9 0.0 0.0   36.0 158.8
62355 62355 2015 4037366 24-02 Queens Plaza South QUEENS 24-02 Queens Plaza South Adult Education 74105 577.2 83.84 285.6 291.6 577.2 82.9 0.0 0.0   0.0 120.0
62381 62381 2015 3523308 31-74 29th Street - 30540 QUEENS 31-74 29th Street Multifamily Housing 93964 416.0 47.65 329.4 86.6 416.0 82.9 0.0 0.0   85.0 77.1
62382 62382 2015 3523309 31-62 29th Street - 7264 QUEENS 31-62 29th Street Multifamily Housing 93964 449.5 51.49 358.4 91.0 449.5 82.9 0.0 0.0   77.0 83.5
62393 62393 2015 1819837 Center for Automotive Education and Training QUEENS 15-30 Petracca Place Adult Education 92705 508.7 59.06 169.2 339.5 508.7 82.9 0.0 0.0   0.0 78.5
62397 62397 2015 4392106 America Sanford Ave QUEENS 144-44 Sanford Ave Multifamily Housing 54491 180.0 35.56 0.0 180.0 180.0 82.9 0.0 0.0   44.0 39.8
62398 62398 2015 3788659 St. John's Preparatory School QUEENS 21-21 Crescent Street K-12 School 273124 806.9 31.8 654.4 152.5 806.9 82.9 0.0 0.0   98.0 51.8
62399 62399 2015 4392105 America Crocheron Ave QUEENS 189-14 Crocheron Ave Multifamily Housing 96881 360.1 40.01 0.0 360.1 360.1 82.9 0.0 0.0   27.0 44.8
62400 62400 2015 4392104 America Beech Ave QUEENS 140-60 Beech Ave Multifamily Housing 96774 416.8 46.36 0.0 416.8 416.8 82.9 0.0 0.0   11.0 51.9
62401 62401 2015 4392107 America 43 Ave QUEENS 61-15 43 Ave Multifamily Housing 85568 244.0 30.69 0.0 244.0 244.0 82.9 0.0 0.0   67.0 34.4
62403 62403 2015 4392100 New Bedford 129 Street QUEENS 84-70 129th Street Multifamily Housing 107250 453.5 45.51 0.0 453.5 453.5 82.9 0.0 0.0   12.0 51.0
62405 62405 2015 4392101 America Ash Ave QUEENS 140-30 Ash Ave Multifamily Housing 151584 476.8 33.86 0.0 476.8 476.8 82.9 0.0 0.0   52.0 37.9
62422 62422 2015 4440047 Third Housing Company Inc. QUEENS 65-52 160th Street Multifamily Housing 735000 2049.9 30.02 328.2 1721.7 2049.9 82.9 0.0 0.0   96.0 36.7
62423 62423 2015 4442227 First Housing Company Inc. QUEENS 161-04 Harry Van Arsdale Jr. Ave. Multifamily Housing 350000 837.3 25.75 0.0 837.3 837.3 82.9 0.0 0.0   97.0 28.8
62428 62428 2015 4442348 FIrst Hsg Bldg #5 QUEENS 161-04 Harry Van Arsdale Jr. Ave. Multifamily Housing 35000 0.0 0.0 0.0 0.0 0.0 82.9 0.0 0.0   0.0 0.0
62434 62434 2015 4442402 Second Hsg Bldg #4 QUEENS 67-50 164th Street Multifamily Housing 35000 245.1 75.38 245.1 0.0 245.1 82.9 0.0 0.0   96.0 94.4
62436 62436 2015 4442421 Second Hsg Bldg #6 QUEENS 67-30 164th Street Multifamily Housing 35000 289.4 89.0 289.4 0.0 289.4 82.9 0.0 0.0   86.0 111.4
62440 62440 2015 4442469 Second Hsg Bldg #10 QUEENS 67-11 161st street Multifamily Housing 17500 67.2 41.33 67.2 0.0 67.2 82.9 0.0 0.0   0.0 72.3
62442 62442 2015 4442517 Second Hsg Bldg #12 QUEENS 67-47 161st Street Multifamily Housing 17500 69.7 42.87 69.7 0.0 69.7 82.9 0.0 0.0   0.0 75.0
62444 62444 2015 4442600 Third Hsg Bldg #2 QUEENS 67-47 161st Street Multifamily Housing 17500 69.8 42.93 69.8 0.0 69.8 82.9 0.0 0.0   0.0 75.1
62446 62446 2015 4442622 Third Hsg Bldg #4 QUEENS 67-10 161st Street Multifamily Housing 17500 0.0 0.0 0.0 0.0 0.0 82.9 0.0 0.0   0.0 0.0
62460 62460 2015 4442797 Fifth Hsg Bldg #1 QUEENS 65-24 162nd Street Multifamily Housing 145938 535.6 39.5 11.9 523.7 535.6 82.9 0.0 0.0   60.0 44.8
62461 62461 2015 4442800 Fifth Hsg Bldg #2 QUEENS 65-25 160th Street Multifamily Housing 145938 560.8 41.36 13.8 547.0 560.8 82.9 0.0 0.0   53.0 47.0
62462 62462 2015 4442823 Second Housing Company Inc QUEENS 161-29 Harry Van Arsdale Jr. Ave Multifamily Housing 665000 1525.2 24.69 70.5 1454.8 1525.2 82.9 0.0 0.0   99.0 28.4
62463 62463 2015 4442829 Fourth Housing Company Inc. QUEENS 65-94 162nd Street Multifamily Housing 350000 788.5 24.25 44.7 743.8 788.5 82.9 0.0 0.0   99.0 28.0
62464 62464 2015 4442836 Fifth Housing Company Inc QUEENS 65-24 162nd Street Multifamily Housing 291876 1096.4 40.43 25.7 1070.7 1096.4 82.9 0.0 0.0   58.0 45.9
62480 62480 2015 2910150 47-30 29th Street (American Self Storage) QUEENS 47-30 29th Street Non-Refrigerated Warehouse 116445 236.2 21.83 169.8 66.5 236.2 82.9 0.0 0.0   88.0 34.3
62482 62482 2015 3536783 89-07 34th Avenue QUEENS 89-07 34th Avenue Multifamily Housing 90000 505.0 60.4 422.9 82.1 505.0 82.9 0.0 0.0   78.0 99.5
62491 62491 2015 3280103 Park Briarwood QUEENS 85-15 139th Street Multifamily Housing 73280 105.3 15.47 91.9 13.4 105.3 82.9 0.0 0.0   100.0 20.8
62492 62492 2015 4034640 The Boulevard Towers QUEENS 119-49 Union Tpke Multifamily Housing 89 0.0 0.0 0.0 0.0 0.0 82.9 0.0 0.0   0.0 0.0
62499 62499 2015 4044995 12 - 16 43rd Ave QUEENS 12 - 16 43rd Ave Office 108880 784.7 77.58 159.3 625.4 784.7 82.9 0.0 0.0   24.0 96.8
62500 62500 2015 4443448 Courthouse Square Realty Co. LP. QUEENS 89-02 Sutphin Blvd. Office 52758 220.7 45.03 108.0 112.7 220.7 82.9 0.0 0.0   89.0 53.8
62525 62525 2015 3110393 137-77 45th Ave - 10879 QUEENS 137-77 45th Ave Multifamily Housing 73765 195.4 28.51 0.0 195.4 195.4 82.9 0.0 0.0   93.0 31.9
62566 62566 2015 2709048 College Point Reality LLC. QUEENS 114-02 15th Avenue Non-Refrigerated Warehouse 107000 379.6 38.19 166.3 213.3 379.6 82.9 0.0 0.0   16.0 53.3
62569 62569 2015 3313994 Flushing Tower Condo QUEENS 3370 Prince Street Office 63966 302.0 50.82 158.6 143.4 302.0 82.9 0.0 0.0   80.0 73.7
62577 62577 2015 1241684 0539 Glendale QUEENS 8989 Union Turnpike Supermarket/Grocery Store 60713 993.0 176.05 313.3 679.7 993.0 82.9 0.0 0.0   75.0 232.1
62607 62607 2015 3323163 41-41/43 43rd Street QUEENS 41-41 43rd Street Multifamily Housing 70000 479.8 73.78 463.9 15.9 479.8 82.9 0.0 0.0   92.0 92.1
62609 62609 2015 2817642 85-10 120 st QUEENS 85-10 120 st Multifamily Housing 61092 293.4 51.69 204.9 88.6 293.4 82.9 0.0 0.0   73.0 80.6
62626 62626 2015 2804420 Jamaica Ave Property QUEENS 163-19 Jamaica Ave Retail Store 54978 182.3 35.69 38.5 143.8 182.3 82.9 0.0 0.0   89.0 41.3
62658 62658 2015 3602796 Riverton Street Charter School QUEENS 11834 Riverton Street K-12 School 53052 251.5 51.03 115.1 136.5 251.5 82.9 0.0 0.0   56.0 71.8
62666 62666 2015 2928732 Norampac New York City Inc. QUEENS 56-19 Grand Avenue (aka 56-05 Grand Ave.) Other 72000 0.0 0.0 0.0 48.4 0.0 82.9 0.0 0.0   0.0 0.0
62686 62686 2015 2686823 Norampac Plant-Maspeth QUEENS 55-15 Grand Ave Manufacturing/Industrial Plant 254000 0.0 0.0 0.0 1453.8 0.0 82.9 0.0 0.0   0.0 0.0
62730 62730 2015 3091249 162-01 Powells Cove Blvd - 40020 QUEENS 162-01 Powells Cove Blvd Multifamily Housing 175000 598.7 36.82 446.0 152.7 598.7 82.9 0.0 0.0   91.0 58.5
62731 62731 2015 3091250 162-21 Powells Cove Blvd - 40021 QUEENS 162-21 Powells Cove Blvd. Multifamily Housing 175000 615.7 37.87 449.0 166.7 615.7 82.9 0.0 0.0   88.0 59.8
62732 62732 2015 3091252 162-41 Powells Cove Blvd - 40022 QUEENS 162-41 Powells Cove Blvd Multifamily Housing 175000 646.9 39.79 490.2 156.7 646.9 82.9 0.0 0.0   86.0 63.5
62735 62735 2015 2651648 Berkeley Cooperative Towers Section III Corp. QUEENS 39-65 52nd Street Other 207086 0.0 0.0 0.0 0.0 0.0 82.9 0.0 0.0   0.0 0.0
62742 62742 2015 4352693 Octagon Realty LLC QUEENS 17-20 Whitestone Expressway Office 63110 257.0 43.83 20.7 236.3 257.0 82.9 0.0 0.0   78.0 51.3
62786 62786 2015 2674416 Deepdale Gardens C1 QUEENS 252-10 58th Ave Multifamily Housing 54270 318.0 63.07 317.5 0.5 318.0 82.9 0.0 0.0   73.0 110.2
62787 62787 2015 2674712 Deepdale Gardens C4 QUEENS 58-31 251 Street Multifamily Housing 48947 327.1 71.93 246.2 80.9 327.1 82.9 0.0 0.0   21.0 114.6
62788 62788 2015 2674960 Deepdale Gardens C6 QUEENS 252-17 60th Avenue Multifamily Housing 52456 378.6 77.69 279.6 99.0 378.6 82.9 0.0 0.0   12.0 123.1
62789 62789 2015 2675436 Deepdale Gardens D9 QUEENS 58-42 251 Street Multifamily Housing 52738 356.2 72.7 255.6 100.6 356.2 82.9 0.0 0.0   21.0 114.2
62790 62790 2015 2675785 Deepdale Gardens D13 QUEENS 249-20 57th Avenue Multifamily Housing 51163 383.1 80.6 301.0 82.2 383.1 82.9 0.0 0.0   11.0 130.1
62791 62791 2015 2675859 Deepdale Gardens D16 QUEENS 57-35 Marathon Parkway Multifamily Housing 54733 423.0 83.19 322.4 100.6 423.0 82.9 0.0 0.0   8.0 133.1
62792 62792 2015 2676158 Deepdale Gardens E2 QUEENS 249-34 60th Avenue Multifamily Housing 45512 270.3 63.93 199.8 70.5 270.3 82.9 0.0 0.0   37.0 101.3
62793 62793 2015 2676374 Deepdale Gardens E5 QUEENS 60-35 Marathon Parkway Multifamily Housing 49457 382.0 83.14 279.4 102.6 382.0 82.9 0.0 0.0   8.0 131.4
62794 62794 2015 2676492 Deepdale Gardens E9 QUEENS 60-28 251st Street Multifamily Housing 54443 355.1 70.21 258.6 96.5 355.1 82.9 0.0 0.0   24.0 110.8
62795 62795 2015 2677294 Deepdale Gardens F12 QUEENS 252-14 60th Avenue Multifamily Housing 50694 358.3 76.08 279.5 78.8 358.3 82.9 0.0 0.0   17.0 122.5
62796 62796 2015 2677368 Deepdale Gardens F15 QUEENS 253-22 60th Avenue Multifamily Housing 51069 390.3 82.26 297.1 93.2 390.3 82.9 0.0 0.0   10.0 131.5
62797 62797 2015 2677578 Deepdale Gardens F20 QUEENS 253-17 61st Avenue Multifamily Housing 62906 352.2 60.27 246.9 105.3 352.2 82.9 0.0 0.0   39.0 94.1
62798 62798 2015 2677736 Deepdale Gardens F24 QUEENS 251-07 61 Avenue Multifamily Housing 48388 341.1 75.88 261.1 80.0 341.1 82.9 0.0 0.0   16.0 121.5
62799 62799 2015 2677868 Deepdale Gardens F26 QUEENS 60-35 251 Street Multifamily Housing 47303 346.9 78.94 265.0 81.8 346.9 82.9 0.0 0.0   14.0 126.3
62800 62800 2015 2677878 Deepdale Gardens G3 QUEENS 60-22 Little Neck Parkway Multifamily Housing 32844 233.2 76.43 173.0 60.2 233.2 82.9 0.0 0.0   12.0 121.3
62801 62801 2015 2678225 Deepdale Gardens G6 QUEENS 255-25 61 Avenue Multifamily Housing 35748 234.0 70.46 173.1 60.9 234.0 82.9 0.0 0.0   22.0 111.7
62802 62802 2015 2678342 Deepdale Gardens H7 QUEENS 255-26 61 Avenue Multifamily Housing 49143 351.6 77.01 265.2 86.4 351.6 82.9 0.0 0.0   13.0 122.8
62803 62803 2015 2678381 Deepdale Gardens H8 QUEENS 61-40 Little Neck Parkway Multifamily Housing 31709 210.6 71.49 153.4 57.3 210.6 82.9 0.0 0.0   21.0 112.8
62804 62804 2015 2678399 Deepdale Gardens J11 QUEENS 253-44 61 Avenue Multifamily Housing 62516 387.4 66.7 287.7 99.7 387.4 82.9 0.0 0.0   33.0 105.9
62805 62805 2015 2678466 Deepdale Gardens J12 QUEENS 252-41 63 Avenue Multifamily Housing 64178 428.3 71.83 315.3 113.0 428.3 82.9 0.0 0.0   19.0 113.7
62806 62806 2015 2678583 Deepdale Gardens J16 QUEENS 251-32 61 Avenue Multifamily Housing 63982 443.8 74.66 342.2 101.6 443.8 82.9 0.0 0.0   19.0 119.8
62807 62807 2015 2678605 Deepdale Gardens L2 QUEENS 63-07 Marathon Parkway Multifamily Housing 52803 372.2 75.87 278.3 94.0 372.2 82.9 0.0 0.0   15.0 120.7
62808 62808 2015 2678646 Deepdale Gardens L4 QUEENS 63-10 252 Street Multifamily Housing 43778 319.9 78.66 237.3 82.7 319.9 82.9 0.0 0.0   11.0 124.8
62809 62809 2015 2678713 Deepdale Gardens M5 QUEENS 252-08 63 Avenue Multifamily Housing 35402 325.5 98.97 275.6 49.8 325.5 82.9 0.0 0.0   4.0 163.6
62810 62810 2015 2679529 Deepdale Gardens M7 QUEENS 252-58 63 Avenue Multifamily Housing 38054 273.9 77.47 212.4 61.5 273.9 82.9 0.0 0.0   16.0 124.6
62827 62827 2015 2726072 134-14 Franklin Avenue - 32503 QUEENS 134-14 Franklin Avenue Multifamily Housing 88000 587.7 71.89 468.8 118.9 587.7 82.9 0.0 0.0   63.0 88.9
62829 62829 2015 2726090 21-24 31st Street - 32496 QUEENS 21-24 31st Street Multifamily Housing 88000 608.9 74.48 488.7 120.2 608.9 82.9 0.0 0.0   65.0 91.9
62830 62830 2015 2726092 21-38 31st Street - 32497 QUEENS 21-38 31st Street Multifamily Housing 88096 609.6 74.48 499.4 110.2 609.6 82.9 0.0 0.0   0.0 91.7
62831 62831 2015 2726122 41-11 40th Street - 32498 QUEENS 41-11 40th Street Multifamily Housing 79000 663.4 90.39 563.1 100.3 663.4 82.9 0.0 0.0   22.0 111.9
62834 62834 2015 2726152 78-12 35th Avenue - 32499 QUEENS 78-12 35th Avenue Multifamily Housing 103200 623.6 65.04 521.6 102.1 623.6 82.9 0.0 0.0   40.0 99.4
62835 62835 2015 2726158 91-40 LaMont Avenue - 32515 QUEENS 91-40 LaMont Avenue Multifamily Housing 86000 193.8 24.26 87.1 106.7 193.8 82.9 0.0 0.0   100.0 28.6
62870 62870 2015 2750378 46-30 Center Boulevard Condominium QUEENS 46-30 Center Blvd Multifamily Housing 258300 1154.4 48.11 473.1 681.3 1154.4 82.9 0.0 0.0   43.0 66.3
62875 62875 2015 3966750 45-40 Center Boulevard QUEENS 45-40 Center Blvd Multifamily Housing 314525 1808.1 61.88 1045.5 762.6 1808.1 82.9 0.0 0.0   25.0 90.4
62876 62876 2015 3966756 46-15 Center Boulevard QUEENS 46-15 Center Blvd Multifamily Housing 354622 1741.9 52.87 1067.2 674.7 1741.9 82.9 0.0 0.0   47.0 79.6
62877 62877 2015 4326521 45-45 Center Boulevard QUEENS 45-45 Center Blvd Multifamily Housing 809708 4483.3 59.6 2752.7 1730.5 4483.3 82.9 0.0 0.0   0.0 89.3
62882 62882 2015 4382978 111-23 76 Rd QUEENS 111-23 76 Rd Multifamily Housing 65000 327.8 54.28 269.2 58.6 327.8 82.9 0.0 0.0   43.0 88.8
62889 62889 2015 2671146 Arc Rebuilders Inc. QUEENS 19-40 42nd Street Non-Refrigerated Warehouse 100000 224.8 24.2 108.6 116.2 224.8 82.9 0.0 0.0   0.0 34.5
62896 62896 2015 2710966 Beech Hills 1-3 QUEENS 245-66 62 Avenue Multifamily Housing 38960 297.7 82.25 234.6 63.1 297.7 82.9 0.0 0.0   29.0 99.5
62897 62897 2015 2710985 Beech Hills 1-10 QUEENS 245-07 62 Avenue Multifamily Housing 55316 411.4 80.05 321.2 90.3 411.4 82.9 0.0 0.0   35.0 96.8
62898 62898 2015 2710992 Beech Hills 1-5 QUEENS 245-28 62 Avenue Multifamily Housing 44594 345.5 83.4 264.2 81.3 345.5 82.9 0.0 0.0   34.0 100.7
62899 62899 2015 2711000 Beech Hills 1-7 QUEENS 61-24 245 Place Multifamily Housing 32466 255.3 84.64 198.4 56.9 255.3 82.9 0.0 0.0   32.0 102.3
62900 62900 2015 2711005 Beech Hills 1-13 QUEENS 245-75 62 Avenue Multifamily Housing 35292 218.5 66.64 157.4 61.1 218.5 82.9 0.0 0.0   31.0 104.9
62901 62901 2015 2711341 Beech Hills 2-1 QUEENS 242-41 61 Avenue Multifamily Housing 60904 431.4 76.24 320.1 111.3 431.4 82.9 0.0 0.0   40.0 91.8
62902 62902 2015 2711368 Beech Hills 2-4 QUEENS 242-52 Horace Harding Boulevard Multifamily Housing 49536 412.4 89.61 317.5 95.0 412.4 82.9 0.0 0.0   19.0 108.2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE ghg(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "Total GHG (MtCO2e)" REAL,
  "GHGI (kgCO2e/m2)",
  "Direct GHG (MtCO2e)" REAL,
  "Indirect GHG (MtCO2e)" REAL,
  "Net GHG (MtCO2e)" REAL,
  "Grid Emissions Rate (kgCO2e/MBtu)" REAL,
  "Avoided GHG Onsite (MtCO2e)" REAL,
  "Avoided GHG Offsite (MtCO2e)" REAL,
  "National Median GHG (MtCO2e)" REAL,
  "ENERGY STAR Score" REAL,
  "Site EUI (kBtu/ft2)" REAL
);
CREATE INDEX "idx_ghg_Calendar Year" ON [ghg] ("Calendar Year");
CREATE INDEX "idx_ghg_Property ID" ON [ghg] ("Property ID");
CREATE INDEX "idx_ghg_Borough" ON [ghg] ("Borough");
CREATE INDEX "idx_ghg_Property Type" ON [ghg] ("Property Type");