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

230 rows where Borough = "BROOKLYN" and Property Type = "Police Station" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address 1, Grid Emissions Rate (kgCO2e/MBtu)

Calendar Year 10

Property Type 1

  • Police Station · 230 ✖

Borough 1

  • BROOKLYN · 230 ✖
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)
327367 327367 2024 21353863 NYPD_4536_Highway District Unit 2 BROOKLYN 2900 Flatbush Ave Police Station 23,700 236.23 107.32 131.88 104.35     0.0 0.0 135.85 0.0 143.0
327981 327981 2024 21354553 Benchmarking Group - 40 BROOKLYN 2951 West 8th St Police Station 35,620 493.84 149.19 230.11 263.72     0.0 0.0 229.41 0.0 152.0
327983 327983 2024 21354555 NYPD_4498_60th Precinct and Engine Company 245 BROOKLYN 2951 West 8th St Police Station 32,400 402.77 133.8 230.11 172.66     0.0 0.0 221.44 0.0 142.7
328743 328743 2024 21355428 NYPD_4499_61st Precinct BROOKLYN 2575 Coney Island Ave Police Station 31,429 319.56 109.47 107.74 211.82     0.0 0.0 172.19 0.0 123.1
328744 328744 2024 21355429 NYPD_4500_62nd Precinct BROOKLYN 1925 Bath Ave Police Station 21,300 162.05 81.91 55.13 106.92     0.0 0.0 116.77 0.0 92.3
328745 328745 2024 21355430 NYPD_4501_63rd Precinct BROOKLYN 1844 Brooklyn Ave Police Station 11,904 75.75 68.46 8.73 67.01     0.0 0.0 62.45 0.0 62.7
328746 328746 2024 21355431 NYPD_4503_67th Precinct and Engine Company 248 BROOKLYN 2820 Snyder Ave Police Station 54,056 542.41 107.96 118.05 424.36     0.0 0.0 289.24 0.0 109.3
328747 328747 2024 21355432 NYPD_4504_68th Precinct BROOKLYN 333 65th St Police Station 39,050 164.14 45.21 0.01 164.13     0.0 0.0 200.42 0.0 36.5
328748 328748 2024 21355433 NYPD_4505_69th Precinct BROOKLYN 9720 Foster Ave Police Station 15,792 264.17 180.08 83.88 180.29     0.0 0.0 86.18 0.0 199.2
328749 328749 2024 21355434 NYPD_4506_70th Precinct BROOKLYN 154 Lawrence Ave Police Station 18,000 170.51 101.93 47.44 123.08     0.0 0.0 97.47 0.0 109.0
328750 328750 2024 21355435 NYPD_4507_71st Precinct BROOKLYN 421 Empire Blvd Police Station 24,300 257.39 113.99 49.13 208.26     0.0 0.0 129.35 0.0 112.5
328751 328751 2024 21355436 NYPD_4508_72nd Precinct BROOKLYN 830 4th Ave Police Station 53,600 392.88 78.9 193.28 199.61     0.0 0.0 303.04 0.0 100.2
328752 328752 2024 21355437 NYPD_4509_73rd Precinct BROOKLYN 1470 East New York Ave Police Station 50,020 472.89 101.72 154.64 318.25     0.0 0.0 273.49 0.0 113.5
328753 328753 2024 21355438 NYPD_4510_75th Precinct BROOKLYN 1000 Sutter Ave Police Station 30,160 474.34 169.32 198.38 275.97     0.0 0.0 167.96 0.0 203.3
328754 328754 2024 21355439 NYPD_4511_76th Precinct BROOKLYN 191 Union St Police Station 14,984 156.84 112.7 39.38 117.46     0.0 0.0 80.7 0.0 117.6
328755 328755 2024 21355440 NYPD_4512_77th Precinct BROOKLYN 127 Utica Ave Police Station 45,102 438.63 104.73 199.75 238.89     0.0 0.0 253.09 0.0 129.4
328757 328757 2024 21355442 NYPD_4514_78th Precinct BROOKLYN 65 6th Ave Police Station 34,500 374.98 117.0 257.79 117.19     0.0 0.0 203.26 0.0 170.2
328758 328758 2024 21355443 NYPD_4515_79th Precinct BROOKLYN 263 Tompkins Ave Police Station 33,540 336.31 107.96 117.46 218.85     0.0 0.0 184.2 0.0 122.6
328759 328759 2024 21355444 NYPD_4516_81st Precinct BROOKLYN 30 Ralph Ave Police Station 58,745 427.1 78.25 182.84 244.27     0.0 0.0 327.81 0.0 94.7
328760 328760 2024 21355445 NYPD_4517_83rd Precinct BROOKLYN 480 Knickerbocker Ave Police Station 31,729 291.57 98.92 104.98 186.59     0.0 0.0 174.63 0.0 113.4
328761 328761 2024 21355446 NYPD_4518_84th Precinct BROOKLYN 301 Gold St Police Station 50,000 514.88 110.87 176.18 338.7     0.0 0.0 274.21 0.0 125.2
328762 328762 2024 21355447 NYPD_4519_88th Precinct BROOKLYN 298 Classon Ave Police Station 18,600 151.57 87.73 60.28 91.29     0.0 0.0 103.15 0.0 103.7
328763 328763 2024 21355448 NYPD_4520_90th Precinct and Engine Company 216 BROOKLYN 211 Union Ave Police Station 39,345 525.38 143.7 173.88 351.5     0.0 0.0 215.29 0.0 160.8
332577 332577 2024 33910510 NYPD_4521_94th Precinct BROOKLYN 100 Meserole Ave Police Station 18,500 294.27 171.25 107.92 186.36     0.0 0.0 101.96 0.0 197.4
289647 289647 2023 33910510 NYPD_4521_94th Precinct BROOKLYN 100 Meserole Ave Police Station 18,500 254.1 147.47 72.4 181.7     0.0 0.0 96.1 0.0 164.0
293820 293820 2023 21353863 NYPD_4536_Highway District Unit 2 BROOKLYN 2900 Flatbush Ave Police Station 23,700 214.1 96.88 112.6 101.5     0.0 0.0 136.8 0.0 121.2
294503 294503 2023 21354553 Benchmarking Group - 40 BROOKLYN 2951 West 8th St Police Station 35,620 608.3 184.06 341.2 267.1     0.0 0.0 233.7 0.0 199.4
294505 294505 2023 21354555 NYPD_4498_60th Precinct and Engine Company 245 BROOKLYN 2951 West 8th St Police Station 32,400 521.9 173.3 341.2 180.7     0.0 0.0 225.8 0.0 194.7
295358 295358 2023 21355428 NYPD_4499_61st Precinct BROOKLYN 2575 Coney Island Ave Police Station 31,429 338.3 116.25 130.3 208.0     0.0 0.0 167.4 0.0 138.9
295359 295359 2023 21355429 NYPD_4500_62nd Precinct BROOKLYN 1925 Bath Ave Police Station 21,300 144.2 73.19 47.5 96.7     0.0 0.0 111.8 0.0 83.7
295360 295360 2023 21355430 NYPD_4501_63rd Precinct BROOKLYN 1844 Brooklyn Ave Police Station 11,904 91.1 81.81 24.7 66.3     0.0 0.0 61.6 0.0 90.4
295361 295361 2023 21355431 NYPD_4503_67th Precinct and Engine Company 248 BROOKLYN 2820 Snyder Ave Police Station 46,570 497.9 115.17 135.1 362.8     0.0 0.0 241.0 0.0 126.3
295362 295362 2023 21355432 NYPD_4504_68th Precinct BROOKLYN 333 65th St Police Station 39,050 257.4 71.04 79.0 178.4     0.0 0.0 203.9 0.0 80.1
295363 295363 2023 21355433 NYPD_4505_69th Precinct BROOKLYN 9720 Foster Ave Police Station 15,792 220.7 150.69 52.7 168.0     0.0 0.0 81.1 0.0 160.7
295364 295364 2023 21355434 NYPD_4506_70th Precinct BROOKLYN 154 Lawrence Ave Police Station 18,000 146.2 87.19 23.0 123.2     0.0 0.0 91.6 0.0 85.2
295365 295365 2023 21355435 NYPD_4507_71st Precinct BROOKLYN 421 Empire Blvd Police Station 24,300 272.2 120.56 74.5 197.7     0.0 0.0 125.8 0.0 132.6
295366 295366 2023 21355436 NYPD_4508_72nd Precinct BROOKLYN 830 4th Ave Police Station 53,600 372.5 75.35 161.1 211.5     0.0 0.0 288.9 0.0 92.9
295367 295367 2023 21355437 NYPD_4509_73rd Precinct BROOKLYN 1470 East New York Ave Police Station 50,020 464.5 100.1 188.5 276.0     0.0 0.0 267.8 0.0 121.7
295368 295368 2023 21355438 NYPD_4510_75th Precinct BROOKLYN 1000 Sutter Ave Police Station 30,160 421.9 150.69 153.9 268.0     0.0 0.0 159.8 0.0 177.8
295369 295369 2023 21355439 NYPD_4511_76th Precinct BROOKLYN 191 Union St Police Station 14,984 162.2 116.25 38.1 124.1     0.0 0.0 76.9 0.0 124.1
295370 295370 2023 21355440 NYPD_4512_77th Precinct BROOKLYN 127 Utica Ave Police Station 45,102 387.5 92.57 148.5 239.0     0.0 0.0 240.1 0.0 110.7
295372 295372 2023 21355442 NYPD_4514_78th Precinct BROOKLYN 65 6th Ave Police Station 34,500 322.3 100.1 211.0 111.3     0.0 0.0 202.7 0.0 140.0
295373 295373 2023 21355443 NYPD_4515_79th Precinct BROOKLYN 263 Tompkins Ave Police Station 33,540 332.3 106.56 131.3 201.0     0.0 0.0 179.1 0.0 128.8
295374 295374 2023 21355444 NYPD_4516_81st Precinct BROOKLYN 30 Ralph Ave Police Station 39,700 410.1 110.87 134.7 275.4     0.0 0.0 208.4 0.0 127.7
295375 295375 2023 21355445 NYPD_4517_83rd Precinct BROOKLYN 480 Knickerbocker Ave Police Station 31,729 248.2 83.96 69.7 178.5     0.0 0.0 164.6 0.0 93.1
295376 295376 2023 21355446 NYPD_4518_84th Precinct BROOKLYN 301 Gold St Police Station 28,100 462.8 177.6 137.1 325.7     0.0 0.0 146.3 0.0 198.5
295377 295377 2023 21355447 NYPD_4519_88th Precinct BROOKLYN 298 Classon Ave Police Station 18,600 136.1 78.58 47.3 88.7     0.0 0.0 98.1 0.0 91.8
295378 295378 2023 21355448 NYPD_4520_90th Precinct and Engine Company 216 BROOKLYN 211 Union Ave Police Station 39,345 518.3 142.08 155.1 363.1     0.0 0.0 205.0 0.0 159.1
269713 269713 2022 21353863 NYPD_4536_Highway District Unit 2 BROOKLYN 2900 Flatbush Ave Police Station 23,700 231.9 105.49 144.0 87.9 231.9   0.0 0.0 119.2 0.0 158.3
270398 270398 2022 21354553 Benchmarking Group - 40 BROOKLYN 2951 West 8th St Police Station 35,620 615.2 186.22 406.3 208.9 615.2   0.0 0.0 218.6 0.0 224.7
270400 270400 2022 21354555 NYPD_4498_60th Precinct and Engine Company 245 BROOKLYN 2951 West 8th St Police Station 32,400 554.7 184.06 406.3 148.4 554.7   0.0 0.0 213.5 0.0 225.0
271246 271246 2022 21355428 NYPD_4499_61st Precinct BROOKLYN 2575 Coney Island Ave Police Station 31,429 354.7 121.63 204.3 150.4 354.7   0.0 0.0 159.5 0.0 170.9
271247 271247 2022 21355429 NYPD_4500_62nd Precinct BROOKLYN 1925 Bath Ave Police Station 21,300 124.8 63.51 55.0 69.8 124.8   0.0 0.0 97.6 0.0 87.3
271248 271248 2022 21355430 NYPD_4501_63rd Precinct BROOKLYN 1844 Brooklyn Ave Police Station 11,904 79.2 72.12 30.8 48.4 79.2   0.0 0.0 53.2 0.0 96.8
271249 271249 2022 21355431 NYPD_4503_67th Precinct and Engine Company 248 BROOKLYN 2820 Snyder Ave Police Station 46,570 428.0 99.03 165.1 263.0 428.0   0.0 0.0 207.9 0.0 133.5
271250 271250 2022 21355432 NYPD_4504_68th Precinct BROOKLYN 333 65th St Police Station 39,050 307.6 85.03 167.4 140.1 307.6   0.0 0.0 188.6 0.0 123.2
271251 271251 2022 21355433 NYPD_4505_69th Precinct BROOKLYN 9720 Foster Ave Police Station 15,792 168.6 115.17 55.4 113.2 168.6   0.0 0.0 68.6 0.0 150.8
271252 271252 2022 21355434 NYPD_4506_70th Precinct BROOKLYN 154 Lawrence Ave Police Station 18,000 157.6 94.72 73.0 84.6 157.6   0.0 0.0 83.5 0.0 132.0
271253 271253 2022 21355435 NYPD_4507_71st Precinct BROOKLYN 421 Empire Blvd Police Station 24,300 223.9 99.03 94.6 129.3 223.9   0.0 0.0 110.4 0.0 136.2
271254 271254 2022 21355436 NYPD_4508_72nd Precinct BROOKLYN 830 4th Ave Police Station 53,600 462.3 92.57 317.6 144.7 462.3   0.0 0.0 279.5 0.0 143.5
271255 271255 2022 21355437 NYPD_4509_73rd Precinct BROOKLYN 1470 East New York Ave Police Station 50,020 406.2 87.19 217.7 188.4 406.2   0.0 0.0 240.6 0.0 126.5
271256 271256 2022 21355438 NYPD_4510_75th Precinct BROOKLYN 1000 Sutter Ave Police Station 30,160 371.4 132.4 180.0 191.4 371.4   0.0 0.0 141.3 0.0 187.4
271257 271257 2022 21355439 NYPD_4511_76th Precinct BROOKLYN 191 Union St Police Station 14,984 146.9 105.49 59.2 87.7 146.9   0.0 0.0 67.5 0.0 143.7
271258 271258 2022 21355440 NYPD_4512_77th Precinct BROOKLYN 127 Utica Ave Police Station 45,102 327.0 77.5 157.6 169.4 327.0   0.0 0.0 211.1 0.0 110.2
271260 271260 2022 21355442 NYPD_4514_78th Precinct BROOKLYN 65 6th Ave Police Station 34,500 347.5 108.72 254.2 93.3 347.5   0.0 0.0 184.5 0.0 170.7
271261 271261 2022 21355443 NYPD_4515_79th Precinct BROOKLYN 263 Tompkins Ave Police Station 33,540 297.8 95.8 151.9 145.8 297.8   0.0 0.0 159.2 0.0 136.7
271262 271262 2022 21355444 NYPD_4516_81st Precinct BROOKLYN 30 Ralph Ave Police Station 39,700 378.8 102.26 181.7 197.2 378.8   0.0 0.0 185.5 0.0 144.9
271263 271263 2022 21355445 NYPD_4517_83rd Precinct BROOKLYN 480 Knickerbocker Ave Police Station 31,729 276.5 93.65 127.3 149.2 276.5   0.0 0.0 146.9 0.0 131.1
271264 271264 2022 21355446 NYPD_4518_84th Precinct BROOKLYN 301 Gold St Police Station 28,100 373.0 143.16 119.7 253.3 373.0   0.0 0.0 121.7 0.0 186.8
271265 271265 2022 21355447 NYPD_4519_88th Precinct BROOKLYN 298 Classon Ave Police Station 18,600 162.0 93.65 93.9 68.2 162.0   0.0 0.0 96.6 0.0 128.2
271266 271266 2022 21355448 NYPD_4520_90th Precinct and Engine Company 216 BROOKLYN 211 Union Ave Police Station 39,345 436.7 119.48 172.7 264.0 436.7   0.0 0.0 176.5 0.0 162.0
222062 222062 2021 21353858 Benchmarking Group - 148 BROOKLYN 2900 Flatbush Ave Police Station 49,935 318.3 69921.42 232.6 85.7 318.3 73.8 0.0 0.0   0.0 111.0
222067 222067 2021 21353863 NYPD_4536_Highway District Unit 2 BROOKLYN 2900 Flatbush Ave Police Station 23,700 232.5 108808.99 160.9 71.6 232.5 73.8 0.0 0.0   0.0 168.8
222755 222755 2021 21354553 Benchmarking Group - 40 BROOKLYN 2951 West 8th St Police Station 35,620 419.7 129074.54 278.9 140.8 419.7 73.8 0.0 0.0   0.0 160.4
222757 222757 2021 21354555 NYPD_4498_60th Precinct and Engine Company 245 BROOKLYN 2951 West 8th St Police Station 32,400 419.7 141175.28 278.9 140.8 419.7 73.8 0.0 0.0   0.0 176.4
223628 223628 2021 21355428 NYPD_4499_61st Precinct BROOKLYN 2575 Coney Island Ave Police Station 31,429 249.6 86666.76 110.8 138.8 249.6 73.8 0.0 0.0   0.0 126.2
223629 223629 2021 21355429 NYPD_4500_62nd Precinct BROOKLYN 1925 Bath Ave Police Station 21,300 130.8 67043.72 57.2 73.7 130.8 73.8 0.0 0.0   0.0 97.4
223630 223630 2021 21355430 NYPD_4501_63rd Precinct BROOKLYN 1844 Brooklyn Ave Police Station 11,904 89.6 87676.86 40.9 48.7 89.6 73.8 0.0 0.0   0.0 120.1
223631 223631 2021 21355431 NYPD_4503_67th Precinct and Engine Company 248 BROOKLYN 2820 Snyder Ave Police Station 46,570 449.4 105158.62 192.9 256.5 449.4 73.8 0.0 0.0   0.0 152.6
223632 223632 2021 21355432 NYPD_4504_68th Precinct BROOKLYN 333 65th St Police Station 39,050 220.0 60719.44 90.5 129.5 220.0 73.8 0.0 0.0   0.0 88.6
223633 223633 2021 21355433 NYPD_4505_69th Precinct BROOKLYN 9720 Foster Ave Police Station 15,792 180.8 129740.87 74.5 106.2 180.8 73.8 0.0 0.0   0.0 180.0
223634 223634 2021 21355434 NYPD_4506_70th Precinct BROOKLYN 154 Lawrence Ave Police Station 18,000 157.9 94423.32 77.1 80.8 157.9 73.8 0.0 0.0   0.0 141.5
223635 223635 2021 21355435 NYPD_4507_71st Precinct BROOKLYN 421 Empire Blvd Police Station 24,300 212.0 95081.12 83.5 128.4 212.0 73.8 0.0 0.0   0.0 136.3
223636 223636 2021 21355436 NYPD_4508_72nd Precinct BROOKLYN 830 4th Ave Police Station 53,600 393.5 79916.88 241.7 151.8 393.5 73.8 0.0 0.0   0.0 123.3
223637 223637 2021 21355437 NYPD_4509_73rd Precinct BROOKLYN 1470 East New York Ave Police Station 50,020 437.5 94184.13 260.4 177.1 437.5 73.8 0.0 0.0   0.0 146.0
223638 223638 2021 21355438 NYPD_4510_75th Precinct BROOKLYN 1000 Sutter Ave Police Station 30,160 358.0 128449.21 168.9 189.1 358.0 73.8 0.0 0.0   0.0 190.4
223639 223639 2021 21355439 NYPD_4511_76th Precinct BROOKLYN 191 Union St Police Station 14,984 176.3 135548.26 92.7 83.6 176.3 73.8 0.0 0.0   0.0 192.1
223640 223640 2021 21355440 NYPD_4512_77th Precinct BROOKLYN 127 Utica Ave Police Station 45,102 340.3 81399.0 165.7 174.6 340.3 73.8 0.0 0.0   0.0 121.6
223642 223642 2021 21355442 NYPD_4514_78th Precinct BROOKLYN 65 6th Ave Police Station 34,500 461.0 145945.82 368.1 92.9 461.0 73.8 0.0 0.0   0.0 230.7
223643 223643 2021 21355443 NYPD_4515_79th Precinct BROOKLYN 263 Tompkins Ave Police Station 33,540 265.6 86633.09 132.2 133.5 265.6 73.8 0.0 0.0   0.0 128.1
223644 223644 2021 21355444 NYPD_4516_81st Precinct BROOKLYN 30 Ralph Ave Police Station 39,700 399.5 110260.98 198.6 201.0 399.5 73.8 0.0 0.0   0.0 162.8
223645 223645 2021 21355445 NYPD_4517_83rd Precinct BROOKLYN 480 Knickerbocker Ave Police Station 31,729 301.9 104826.5 141.8 160.1 301.9 73.8 0.0 0.0   0.0 152.5
223646 223646 2021 21355446 NYPD_4518_84th Precinct BROOKLYN 301 Gold St Police Station 28,100 387.6 149003.13 126.6 261.0 387.6 73.8 0.0 0.0   0.0 210.7
223647 223647 2021 21355447 NYPD_4519_88th Precinct BROOKLYN 298 Classon Ave Police Station 18,600 102.6 61354.23 44.8 57.8 102.6 73.8 0.0 0.0   0.0 87.4
223648 223648 2021 21355448 NYPD_4520_90th Precinct and Engine Company 216 BROOKLYN 211 Union Ave Police Station 39,345 447.7 123564.05 187.2 260.5 447.7 73.8 0.0 0.0   0.0 179.3
198297 198297 2020 6297130 NYPD - c000011 - 60th Precinct and Batt. 43, Eng. 245, Ladder 161 Campus (LL84) BROOKLYN 2951 West 8th St Police Station 35620 484.7 146.47 248.0 236.7 484.7 79.5 0.0 0.0   0.0 179.2
198298 198298 2020 6297131 NYPD - 3200556 - 61st Precinct (LL84) BROOKLYN 2575 Coney Island Ave Police Station 31429 325.7 111.55 160.7 164.9 325.7 79.5 0.0 0.0   0.0 162.3
198299 198299 2020 6297132 NYPD - 3167815 - 62nd Precinct (LL84) BROOKLYN 1925 Bath Ave Police Station 21300 136.5 68.98 59.6 76.9 136.5 79.5 0.0 0.0   0.0 98.1
198300 198300 2020 6297133 NYPD - 3207376 - 63rd Precinct (LL84) BROOKLYN 1844 Brooklyn Ave Police Station 11904 93.5 84.55 43.6 49.9 93.5 79.5 0.0 0.0   0.0 121.7
198301 198301 2020 6297135 NYPD - c000012 - 67th Precinct, Engine Co. 248 and Batt. 41 Campus (LL84) BROOKLYN 2820 Snyder Ave Police Station 54056 469.0 93.39 184.6 284.4 469.0 79.5 0.0 0.0   0.0 130.5

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