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,215 rows where Borough = "QUEENS" and Calendar Year = 2014 sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Calendar Year 1

  • 2014 · 2,215 ✖

Borough 1

  • QUEENS · 2,215 ✖
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)
49265 49265 2014 1160897 ELMHURST, NY-2814 QUEENS 92-59 59TH AVE Retail Store 204340 1013.5 53.39 99.5 914.1 1013.5 82.9 0.0 0.0   80.0 63.1
49267 49267 2014 1180593 C Building QUEENS 89-00 Van Wyck Expy Hospital (General Medical & Surgical) 131610 323.4 26.45 323.4 0.0 323.4 82.9 0.0 0.0   100.0 46.3
49272 49272 2014 1216329 FDA Queens QUEENS 158-15 Liberty Ave Other 275196 4766.3 186.43 2286.5 2479.8 4766.3 82.9 0.0 0.0   0.0 259.7
49294 49294 2014 1277231 AB Building QUEENS 89-36 Van Wyck Expy Hospital (General Medical & Surgical) 259635 5581.5 231.4 1853.1 3728.4 5581.5 82.9 0.0 0.0   15.0 307.5
49313 49313 2014 1409171 NE - COURT SQUARE I QUEENS 1 Court Square Office 1436950 8644.5 64.75 85.8 8558.6 8644.5 82.9 0.0 0.0   66.0 72.9
49314 49314 2014 1409173 NE - COURT SQUARE II QUEENS 2 Court Square Office 528060 2388.3 48.68 419.8 1968.5 2388.3 82.9 0.0 0.0   90.0 59.2
49364 49364 2014 1547633 COLLEGE POINT (1150) QUEENS 13505 20TH AVE Retail Store 139899 918.4 70.66 198.1 720.4 918.4 82.9 0.0 0.0   80.0 88.7
49385 49385 2014 1719778 Court Square Place QUEENS 24-01 44th Road Office 275252 1848.3 72.28 391.1 1457.2 -49.4 82.9 0.0 1897.8   0.0 90.6
49390 49390 2014 1747000 Main Hospital QUEENS 56-45 Main Street Hospital (General Medical & Surgical) 590371 11585.9 211.24 5827.4 5758.5 11585.9 82.9 0.0 0.0   53.0 295.3
49391 49391 2014 1755636 Citi Field QUEENS Citi Field Other - Entertainment/Public Assembly 1242968 5397.5 46.74 0.0 5397.5 -1042.9 82.9 0.0 6440.4   0.0 52.4
49403 49403 2014 1819837 Center for Automotive Education and Training QUEENS 15-30 Petracca Place Adult Education 92705 491.9 57.11 178.3 313.6 491.9 82.9 0.0 0.0   0.0 77.0
49417 49417 2014 1944274 Queenswood-Building 2 QUEENS 54-39 100th Street Multifamily Housing 133158 681.5 55.09 423.5 258.0 681.5 82.9 0.0 0.0   54.0 83.2
49439 49439 2014 2240788 TSBA QUEENS 3830 Woodside Ave Office 71800 656.9 98.48 247.3 409.6 656.9 82.9 0.0 0.0   41.0 123.4
49456 49456 2014 2318262 Fairview Owners Corp QUEENS 61-20 Grand Central Parkway Multifamily Housing 428836 3113.5 78.15 2271.5 841.9 3113.5 82.9 0.0 0.0   11.0 123.4
49521 49521 2014 2386047 West Building QUEENS 139-24 Booth Memorial Ave Hospital (General Medical & Surgical) 171780 3005.7 188.34 1069.9 1935.8 3005.7 82.9 0.0 0.0   9.0 253.1
49553 49553 2014 2388624 110-45 Queens Boulevard - Park Briar Owners Corp QUEENS 110-45 Queens Boulevard Multifamily Housing 213900 1052.7 52.97 813.8 238.8 1052.7 82.9 0.0 0.0   95.0 77.7
49616 49616 2014 2535105 Krinos Foods LLC QUEENS 4700 Northern Blvd Distribution Center 126125 616.9 52.65 181.2 435.7 616.9 82.9 0.0 0.0   22.0 68.7
49620 49620 2014 2539004 Franhill Realty, LLC QUEENS 205-07 Hillside Avenue Office 39618 160.9 43.72 61.4 99.5 160.9 82.9 0.0 0.0   0.0 59.4
49621 49621 2014 2539023 Pepsi cola Bottling Co of NY QUEENS 112-02 15th Ave Non-Refrigerated Warehouse 160000 4358.5 293.22 3159.8 1198.7 4358.5 82.9 0.0 0.0   1.0 462.2
49656 49656 2014 2556738 River View Gardens QUEENS 4-12 49th Avenue Multifamily Housing 73639 354.0 51.74 282.9 71.1 354.0 82.9 0.0 0.0   69.0 84.0
49679 49679 2014 2559051 Pelican: Oceanview Associates, LLC QUEENS 146 Beach 24th Street Multifamily Housing 94032 0.0 0.0 32.9 0.0 0.0 82.9 0.0 0.0   0.0 0.0
49691 49691 2014 2560626 47-05 CENTER LLC QUEENS 47-05 CENTER BOULEVARD Multifamily Housing 504682 3289.0 70.15 1626.8 1662.1 3289.0 82.9 0.0 0.0   28.0 97.8
49727 49727 2014 2564600 509 48th Avenue - 5th Street Lofts Condominium QUEENS 509 48th Avenue Multifamily Housing 155680 535.3 37.01 248.1 287.2 535.3 82.9 0.0 0.0   78.0 52.3
49780 49780 2014 2592027 Westleigh Company LLC QUEENS 84-09 35th Avenue Multifamily Housing 80754 470.7 62.74 381.3 89.4 470.7 82.9 0.0 0.0   31.0 102.2
49796 49796 2014 2596985 Sibling: Andrew Jackson Realty Co. 68-64 Yellowstone QUEENS 68-64 Yellowstone Blvd Multifamily Housing 149800 656.5 47.17 495.1 161.4 656.5 82.9 0.0 0.0   0.0 75.2
49816 49816 2014 2598293 Rego II QUEENS 61-35 Junction Blvd Retail Store 623684 6416.4 110.74 464.7 5951.8 6416.4 82.9 0.0 0.0   26.0 129.1
49819 49819 2014 2598358 Flushing QUEENS 13620 Roosevelt Ave Retail Store 166738 3605.8 232.78 1784.1 1821.7 3605.8 82.9 0.0 0.0   1.0 333.2
49824 49824 2014 2598405 Queens Boulevard QUEENS 99-01 Queens Boulevard Retail Store 56916 388.7 73.51 0.0 388.7 388.7 82.9 0.0 0.0   34.0 82.3
49836 49836 2014 2604109 Ozanam Hall of Queens Nursing QUEENS 42-41 201st Street Senior Care Community 295126 3613.0 131.77 2424.9 1188.1 3613.0 82.9 0.0 0.0   12.0 203.2
49846 49846 2014 2604568 26-13 21st Street QUEENS 26-13 21st Street Senior Care Community 159572 1082.8 73.04 610.6 472.2 1082.8 82.9 0.0 0.0   75.0 107.7
49851 49851 2014 2605661 CDNY Maspeth QUEENS 50-35 56th Road Distribution Center 130000 982.9 81.38 763.7 219.2 982.9 82.9 0.0 0.0   16.0 130.9
49853 49853 2014 2605764 Rodless Properties LP WEST BLK 10352 LOT 79 QUEENS 184-10 Jamaica Ave ,West Bldg. Non-Refrigerated Warehouse 221187 550.5 26.79 362.4 188.1 550.5 82.9 0.0 0.0   67.0 41.1
49921 49921 2014 2610542 Rodless Properties LP EAST BLK 10352 LOT 89 QUEENS 184-60 Jamaica Ave Non-Refrigerated Warehouse 287240 699.9 26.23 484.6 215.3 699.9 82.9 0.0 0.0   23.0 40.8
49924 49924 2014 2610981 SURFSIDE MANOR QUEENS 9502 ROCKAWAY BEACH BLVD Senior Care Community 75000 377.0 54.11 240.3 136.7 377.0 82.9 0.0 0.0   75.0 82.3
49938 49938 2014 2612575 41-10 BOWNE ST 1ENT QUEENS 41-10 BOWNE ST 1ENT Multifamily Housing 166498 749.9 48.48 589.1 160.8 749.9 82.9 0.0 0.0   75.0 78.3
49939 49939 2014 2612576 178-60 WEXFORD TERR HOBM QUEENS 178-60 WEXFORD TERR HOBM Multifamily Housing 57176 259.7 48.89 194.2 65.6 259.7 82.9 0.0 0.0   87.0 77.8
49940 49940 2014 2612577 178-10 WEXFORD TERR ENTM QUEENS 178-10 WEXFORD TERR ENTM Multifamily Housing 144350 731.7 54.56 498.7 233.0 731.7 82.9 0.0 0.0   55.0 84.5
49941 49941 2014 2612578 162-15 HIGHLAND AVE ENTM QUEENS 162-15 HIGHLAND AVE ENTM Multifamily Housing 99332 569.6 61.72 423.7 145.9 569.6 82.9 0.0 0.0   52.0 98.0
49942 49942 2014 2612579 182-30 WEXFORD TERR PLPM QUEENS 182-30 WEXFORD TERR PLPM Multifamily Housing 184886 1061.4 61.79 790.6 270.8 1061.4 82.9 0.0 0.0   54.0 98.2
49943 49943 2014 2612580 166-05 HIGHLAND AVE PLP QUEENS 166-05 HIGHLAND AVE PLP Multifamily Housing 167857 816.3 52.35 611.4 204.9 816.3 82.9 0.0 0.0   74.0 83.3
49944 49944 2014 2612581 143-06 BARCLAY AVE ENTM QUEENS 143-06 BARCLAY AVE ENTM Multifamily Housing 79438 503.0 68.16 394.2 108.8 503.0 82.9 0.0 0.0   56.0 109.9
49945 49945 2014 2612582 143-09 BARCLAY AVE QUEENS 143-09 BARCLAY AVE Multifamily Housing 161038 758.6 50.71 573.6 185.0 758.6 82.9 0.0 0.0   88.0 80.9
49959 49959 2014 2612621 Parker Jewish Institute For Health Care & Rehabilitation QUEENS 271-11 76th Ave Senior Care Community 381993 6825.0 192.32 3197.7 3627.3 6825.0 178.3 0.0 0.0   5.0 207.1
49963 49963 2014 2614189 86-75 MIDLAND PKWY ENTM QUEENS 86-75 MIDLAND PKWY ENTM Multifamily Housing 102098 467.4 49.28 325.5 141.9 467.4 82.9 0.0 0.0   82.0 76.8
49964 49964 2014 2614190 86-25 VAN WYCK EXPY ENTM QUEENS 86-25 VAN WYCK EXPY ENTM Multifamily Housing 167390 1030.0 66.23 732.0 298.0 1030.0 82.9 0.0 0.0   48.0 103.8
49985 49985 2014 2615087 Hunters Point Plaza QUEENS 47-40 21st Street Office 199365 733.3 39.59 142.6 590.6 733.3 82.9 0.0 0.0   94.0 49.2
49987 49987 2014 2615111 Plastic Center QUEENS 5-46 46th Avenue Other 130000 347.1 28.74 139.3 207.8 347.1 82.9 0.0 0.0   0.0 33.5
49988 49988 2014 2615596 Austin Towers Condo QUEENS 87-30 62nd Ave Multifamily Housing 67502 374.8 59.77 265.3 109.5 374.8 82.9 0.0 0.0   41.0 93.5
49990 49990 2014 2615607 Northridge Coop I QUEENS 32-43 91st Street Multifamily Housing 334890 2218.6 71.31 1706.9 511.8 2218.6 82.9 0.0 0.0   29.0 111.9
49991 49991 2014 2615609 Northridge Coop Sec III QUEENS 32-43 88th Street Multifamily Housing 401868 2245.2 60.14 1661.8 583.4 2245.2 82.9 0.0 0.0   53.0 92.3
49992 49992 2014 2615618 85-14 Broadway Owners Corp QUEENS 85-14 Broadway Multifamily Housing 78401 549.7 75.47 400.6 149.1 549.7 82.9 0.0 0.0   19.0 117.7
49993 49993 2014 2615619 87-20 Apt Corp. QUEENS 87-20 175th Street Multifamily Housing 73313 390.6 57.35 297.3 93.3 390.6 82.9 0.0 0.0   40.0 91.7
49996 49996 2014 2616121 Queensview, Inc. QUEENS 21-66 33rd Road Multifamily Housing 836530 0.0 0.0 6080.1 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50003 50003 2014 2617131 Gospel Tabernacle P/INC QUEENS 39-21 Crescent Street K-12 School 93300 798.7 92.14 210.8 588.0 798.7 82.9 0.0 0.0   81.0 55.8
50180 50180 2014 2640535 147-09 71 RD QUEENS 147-09 71 RD Multifamily Housing 46145 261.0 60.88 202.0 59.0 261.0 82.9 0.0 0.0   36.0 97.8
50181 50181 2014 2640536 147-21 72 AVE QUEENS 147-21 72 AVE Multifamily Housing 46100 255.0 59.54 200.1 54.9 255.0 82.9 0.0 0.0   41.0 96.1
50182 50182 2014 2640537 147-34 71 Road QUEENS 147-34 71 Road Multifamily Housing 46145 260.9 60.86 202.0 58.9 260.9 82.9 0.0 0.0   36.0 97.8
50183 50183 2014 2640538 147-44 71st Road QUEENS 147-44 71st Road Multifamily Housing 46100 253.1 59.1 198.3 54.8 253.1 82.9 0.0 0.0   42.0 95.3
50184 50184 2014 2640539 144-20 41 AVE QUEENS 144-20 41 AVE Multifamily Housing 150870 611.7 43.64 414.3 197.4 611.7 82.9 0.0 0.0   85.0 67.5
50185 50185 2014 2640541 144-45 35 Ave QUEENS 144-45 35 Ave Multifamily Housing 129650 717.1 59.54 577.2 140.0 717.1 82.9 0.0 0.0   58.0 96.8
50186 50186 2014 2640542 221-07 64 AVE QUEENS 221-07 64 AVE Multifamily Housing 14900 98.2 70.94 77.5 20.7 98.2 82.9 0.0 0.0   0.0 114.7
50188 50188 2014 2640544 223-01 65TH AVE QUEENS 223-01 65TH AVE Multifamily Housing 12150 79.0 69.99 61.3 17.7 79.0 82.9 0.0 0.0   0.0 112.6
50189 50189 2014 2640545 223-25A 65TH AVE QUEENS 223-25A 65TH AVE Multifamily Housing 12150 79.0 69.99 61.3 17.7 79.0 82.9 0.0 0.0   0.0 112.6
50190 50190 2014 2640546 223-27 65th Avenue QUEENS 223-27 65th Avenue Multifamily Housing 12150 0.0 0.0 61.3 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50191 50191 2014 2640547 224 30A 64 AVENUE QUEENS 224 30A 64 AVENUE Multifamily Housing 27600 106.6 41.57 83.4 23.2 106.6 82.9 0.0 0.0   93.0 67.0
50192 50192 2014 2640548 224-01 69 AVENUE QUEENS 224-01 69 AVENUE Multifamily Housing 10875 64.9 64.24 64.9 0.0 64.9 82.9 0.0 0.0   0.0 112.3
50193 50193 2014 2640549 224-08 67 AVENUE QUEENS 224-08 67 AVENUE Multifamily Housing 10875 80.8 79.97 64.9 16.0 80.8 82.9 0.0 0.0   0.0 130.0
50194 50194 2014 2640550 224-30 64 AVENUE QUEENS 224-30 64 AVENUE Multifamily Housing 27600 106.6 41.57 83.4 23.2 106.6 82.9 0.0 0.0   93.0 67.1
50195 50195 2014 2640551 224-30 67 AVENUE QUEENS 224-30 67 AVENUE Multifamily Housing 10875 64.9 64.24 64.9 0.0 64.9 82.9 0.0 0.0   0.0 112.3
50196 50196 2014 2640552 224-35 67 AVENUE QUEENS 224-35 67 AVENUE Multifamily Housing 27600 106.6 41.57 83.4 23.2 106.6 82.9 0.0 0.0   93.0 67.0
50197 50197 2014 2640553 224-46A 64TH AVE QUEENS 224-46A 64TH AVE Multifamily Housing 27600 106.6 41.57 83.4 23.1 106.6 82.9 0.0 0.0   93.0 67.0
50198 50198 2014 2640554 225-19 69 AVENUE QUEENS 225-19 69 AVENUE Multifamily Housing 10875 0.0 0.0 64.9 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50199 50199 2014 2640555 225-25 69 AVE QUEENS 225-25 69 AVE Multifamily Housing 10875 0.0 0.0 64.9 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50200 50200 2014 2640556 61-19 223 PLACE QUEENS 61-19 223 PLACE Multifamily Housing 12150 0.0 0.0 61.3 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50201 50201 2014 2640557 61-20 223 PLACE QUEENS 61-20 223 PLACE Multifamily Housing 14900 0.0 0.0 77.5 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50202 50202 2014 2640558 61-27 223 PLACE QUEENS 61-27 223 PLACE Multifamily Housing 12150 0.0 0.0 61.3 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50203 50203 2014 2640559 61-46 224 STREET QUEENS 61-46 224 STREET Multifamily Housing 12150 0.0 0.0 61.3 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50204 50204 2014 2640560 61-47 223 PLACE QUEENS 61-47 223 PLACE Multifamily Housing 12150 0.0 0.0 61.3 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50205 50205 2014 2640561 61-50 223 PLACE QUEENS 61-50 223 PLACE Multifamily Housing 14900 0.0 0.0 77.5 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50206 50206 2014 2640562 61-60 223 PLACE QUEENS 61-60 223 PLACE Multifamily Housing 14900 0.0 0.0 77.5 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50207 50207 2014 2640563 61-63 223 PLACE QUEENS 61-63 223 PLACE Multifamily Housing 12150 0.0 0.0 61.3 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50208 50208 2014 2640564 64-21 223 place QUEENS 64-21 223 place Multifamily Housing 12150 0.0 0.0 61.3 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50209 50209 2014 2640565 64-34 224 STREET QUEENS 64-34 224 STREET Multifamily Housing 12150 0.0 0.0 61.3 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50210 50210 2014 2640566 64-37 223 PLACE QUEENS 64-37 223 PLACE Multifamily Housing 12150 61.3 54.31 61.3 0.0 61.3 82.9 0.0 0.0   0.0 95.0
50211 50211 2014 2640567 65-01 224 STREET QUEENS 65-01 224 STREET Multifamily Housing 27600 434.3 169.38 434.3 0.0 434.3 82.9 0.0 0.0   1.0 296.2
50212 50212 2014 2640568 67-01 224 STREET QUEENS 67-01 224 STREET Multifamily Housing 10875 80.8 79.97 64.9 16.0 80.8 82.9 0.0 0.0   0.0 130.0
50213 50213 2014 2640569 67-02 CLOVERDALE BLVD QUEENS 67-02 CLOVERDALE BLVD Multifamily Housing 10875 80.8 79.97 64.9 16.0 80.8 82.9 0.0 0.0   0.0 130.0
50214 50214 2014 2640570 67-05 224 STREET QUEENS 67-05 224 STREET Multifamily Housing 10875 64.9 64.24 64.9 0.0 64.9 82.9 0.0 0.0   0.0 112.3
50215 50215 2014 2640571 67-13 224 STREET QUEENS 67-13 224 STREET Multifamily Housing 10875 80.9 80.07 64.9 16.0 80.9 82.9 0.0 0.0   0.0 130.1
50216 50216 2014 2640572 67-45 224 STREET QUEENS 67-45 224 STREET Multifamily Housing 10875 0.0 0.0 64.9 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50217 50217 2014 2640573 67-57 224 STREET QUEENS 67-57 224 STREET Multifamily Housing 10875 80.9 80.07 64.9 16.0 80.9 82.9 0.0 0.0   0.0 130.0
50218 50218 2014 2640574 67-89 224 STREET QUEENS 67-89 224 STREET Multifamily Housing 10875 0.0 0.0 64.9 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50219 50219 2014 2640575 67-97 224 STREET QUEENS 67-97 224 STREET Multifamily Housing 10875 0.0 0.0 64.9 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50220 50220 2014 2640576 68-01 224TH ST. QUEENS 68-01 224TH ST. Multifamily Housing 10875 0.0 0.0 64.9 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50221 50221 2014 2640577 68-02 CLOVERDALE BLVD QUEENS 68-02 CLOVERDALE BLVD Multifamily Housing 10875 0.0 0.0 64.9 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50222 50222 2014 2640578 68-40 CLOVERDALE Boulevard QUEENS 68-40 CLOVERDALE Boulevard Multifamily Housing 10875 0.0 0.0 64.9 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50223 50223 2014 2640579 61-32 224 ST QUEENS 61-32 224 ST Multifamily Housing 12150 0.0 0.0 61.3 0.0 0.0 82.9 0.0 0.0   0.0 0.0
50224 50224 2014 2640580 20-53 18th Street QUEENS 20-53 18th Street Multifamily Housing Not Available 357.8   269.0 88.9 357.8 82.9 0.0 0.0   0.0 0.0
50225 50225 2014 2640581 188-01 71 Circle QUEENS 188-01 71 Circle Multifamily Housing 13800 280.7 218.94 218.7 62.0 280.7 82.9 0.0 0.0   1.0 352.5
50226 50226 2014 2640582 188-02 71 Circle QUEENS 188-02 71 Circle Multifamily Housing 13800 273.3 213.17 212.9 60.4 273.3 82.9 0.0 0.0   1.0 343.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");