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

653 rows where Borough = "BROOKLYN" and Property Type = "Retail Store" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Grid Emissions Rate (kgCO2e/MBtu)

Calendar Year 13

Property Type 1

  • Retail Store · 653 ✖

Borough 1

  • BROOKLYN · 653 ✖
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)
305997 305997 2024 1547924 GATEWAY (1401) BROOKLYN 519 GATEWAY DR Retail Store 148,939 992.0 71.69 218.18 773.81     0.0 0.0 1339.19 76.0 72.7
306000 306000 2024 1548441 BROOKLYN JUNCTION (2212) BROOKLYN 1598 FLATBUSH AVE Retail Store 224,208 1514.56 71.26 270.38 1244.18     0.0 0.0 2018.1 78.0 69.5
307416 307416 2024 2640532 585 Dekalb (569 DE KALB AVE) BROOKLYN 569 DE KALB AVENUE Retail Store 162,999 1109.58 73.3 293.91 815.66     0.0 0.0 1157.41 54.0 77.4
308574 308574 2024 2708994 486 Neptune Avenue BROOKLYN 486 Neptune Avenue Retail Store 919,187 2399.35 28.09 729.16 1670.19     0.0 0.0 4418.94 92.0 30.7
310558 310558 2024 3065257 6152 - STARRETT CITY BROOKLYN 579 Gateway Drive Retail Store 127,503 521.95 44.02 709.84 -187.89     0.0 0.0 1211.72 97.0 92.0
310561 310561 2024 3066775 1225 - BROOKLYN, NY BROOKLYN 550 Hamilton Avenue Retail Store 136,840 694.14 54.57 183.02 511.13     0.0 0.0 1097.29 85.0 57.6
310565 310565 2024 3068204 1256 - CROPSEY BROOKLYN 2970 Cropsey Avenue Retail Store 132,745 668.84 54.25 729.56 -60.72     0.0 0.0 1158.96 90.0 99.5
311703 311703 2024 3531745 2101 Church Avenue Equities - 2101 Church Ave. BROOKLYN 2101 Church Ave. Retail Store 52,169 386.1 79.65 47.89 338.21     0.0 0.0 307.79 28.0 73.6
312544 312544 2024 4137142 Brooklyn, NY- 0197 BROOKLYN 360 Gateway Drive Retail Store 123,942 264.62 23.03 25.21 239.41     0.0 0.0 768.1 99.0 20.6
314854 314854 2024 5866451 Reva Holding Corp BROOKLYN 28 Debevoise Street Retail Store 140,000 541.33 41.66 33.56 507.77     0.0 0.0 827.65 84.0 36.0
315144 315144 2024 6113780 398-406 Fulton Street BROOKLYN 398-406 Fulton Street Retail Store 45,080 199.22 47.58 12.28 186.94     0.0 0.0 198.68 49.0 41.2
315366 315366 2024 6192754 263 Livingston Street BROOKLYN 263 Livingston Street Retail Store 63,373 42.71 7.21 0.0 42.71     0.0 0.0 243.51 100.0 5.9
316382 316382 2024 6282767 Maverick: 493 Fulton St BROOKLYN 493 Fulton St Retail Store 30,056 145.14 51.99 12.89 132.25     0.0 0.0 181.89 70.0 46.3
317178 317178 2024 6319430 Atlantic Avenue BROOKLYN 15 4th Avenue Retail Store 30,115 261.49 93.43 23.68 237.81     0.0 0.0 180.59 16.0 83.4
317879 317879 2024 6545431 David Maleh - 8-44 Brighton 11th St BROOKLYN 8 BRIGHTON 11TH STREET Retail Store 42,000 209.0 53.6 19.88 189.11     0.0 0.0 254.46 66.0 48.0
318050 318050 2024 6579395 D & M King Realty LLC - 1736 Shore pkwy BROOKLYN 1736 Shore pkwy Retail Store 40,283 266.22 71.15 51.71 214.51     0.0 0.0 206.28 0.0 70.4
318090 318090 2024 6585466 Jackson Property Management - 775 Broadway BROOKLYN 777 BROADWAY Retail Store 30,080 231.92 82.99 31.26 200.66     0.0 0.0 152.27 0.0 77.5
318227 318227 2024 6600411 100 Neptune Ave Realty - 100 Neptune ave BROOKLYN 100 Neptune Avenue Retail Store 30,000 15.29 5.49 0.0 15.29     0.0 0.0 104.46 100.0 4.4
318290 318290 2024 6610218 LOLLYPOP IMPORT & EXPORT CORP. BROOKLYN 774 Broadway Retail Store 49,787 409.59 88.59 74.17 335.42     0.0 0.0 443.9 56.0 86.6
318985 318985 2024 6681960 599 BROOKLYN 8923 Bay Parkway Retail Store 40,159 298.5 79.98 45.77 252.73     0.0 0.0 263.6 37.0 76.1
318990 318990 2024 6681970 1886 BROOKLYN 369 Gateway Drive Retail Store 31,594 206.68 70.4 26.48 180.2     0.0 0.0 214.92 53.0 65.3
318993 318993 2024 6681973 2518 BROOKLYN 625 Atlantic Ave Retail Store 48,294 393.07 87.62 54.74 338.33     0.0 0.0 412.98 54.0 82.2
320111 320111 2024 6778571 ACHS Management: 1007-1011 Flatbush BROOKLYN 1007 - 1011 Flatbush Ave Retail Store 141,599 1191.1 90.52 0.99 1190.11     0.0 0.0 698.79 0.0 73.2
320517 320517 2024 6797942 Bobbys Dept Store BROOKLYN 1628 Church Ave Retail Store 60,000 176.66 41.33 48.6 128.06     0.0 0.0 255.81 81.0 44.1
320531 320531 2024 6798010 1601 Kings Highway BROOKLYN 1601 KINGS HGWY Retail Store 85,606 375.51 47.25 24.59 350.92     0.0 0.0 495.02 72.0 41.0
321057 321057 2024 6819366 Gateway Center - 459 Gateway Drive BROOKLYN 459 Gateway Drive Retail Store 37,833 140.61 40.04 10.56 130.05     0.0 0.0 264.12 92.0 35.1
321058 321058 2024 6819367 Gateway Center - Marshalls BROOKLYN 351 Gateway Drive Retail Store 36,905 184.49 53.82 25.35 159.14     0.0 0.0 255.4 78.0 50.4
321060 321060 2024 6819369 Gateway Center - Famous Footwear/Old Navy BROOKLYN 381 Gateway Drive Retail Store 38,237 256.08 72.12 12.34 243.75     0.0 0.0 272.82 56.0 61.5
321275 321275 2024 6889829 Raymour & Flanigan Coney Island BROOKLYN 1509 Hart Place Retail Store 39,350 126.58 34.66 38.01 88.57     0.0 0.0 252.61 94.0 37.7
321502 321502 2024 7095172 Somerstein: 1245 Broadway BROOKLYN 1245 BROADWAY Retail Store 36,412 434.13 128.31 81.39 352.74     0.0 0.0 700.25 86.0 126.3
321768 321768 2024 7536616 464 Rockaway Avenue BROOKLYN 464 ROCKAWAY AVE Retail Store 27,300 106.63 42.09 33.89 72.74     0.0 0.0 181.46 89.0 46.5
321914 321914 2024 8016082 1832 REALTY LLC (TJX) BROOKLYN 1832 86 STREET Retail Store 26,743 242.73 97.74 82.49 160.24     0.0 0.0 277.97 62.0 110.1
322052 322052 2024 8550797 Gateway 2 - Retail G2 BROOKLYN 550 Gateway Drive Retail Store 87,072 421.64 52.1 23.68 397.96     0.0 0.0 523.19 69.0 44.8
322089 322089 2024 8699645 Gateway 2 - Retail C BROOKLYN 410 Gateway Drive Retail Store 203,132 1295.35 68.67 492.83 802.51     0.0 0.0 1300.46 50.0 80.0
322120 322120 2024 8714790 474 Fulton Owner LLC BROOKLYN 474 Fulton Street Retail Store 41,039 127.01 33.26 0.0 127.01     0.0 0.0 240.23 93.0 26.9
322278 322278 2024 9498583 1 12th St BROOKLYN 1 12 St Extension Retail Store 112,463 474.83 45.42 147.63 327.2     0.0 0.0 728.2 84.0 50.0
322375 322375 2024 9648795 Triangle: 1726 McDonald Ave. BROOKLYN 1726 McDonald Ave Retail Store 36,000 196.69 58.77 0.0 196.69     0.0 0.0 213.74 58.0 47.5
322919 322919 2024 10714240 DOL REALTY LLC (MARSHALLS/TJX)_1611 Ave Y BROOKLYN 1611 AVENUE Y Retail Store 26,431 130.53 53.17 12.8 117.73     0.0 0.0 208.82 86.0 47.8
323168 323168 2024 10867758 store BROOKLYN 272 67TH ST APT 10 Retail Store 6,000 0.0 0.0 0.0 0.0     0.0 0.0 229.1 0.0 0.0
323323 323323 2024 11272508 408-416 Fulton Street LLC BROOKLYN 408 Fulton Street Retail Store 43,360 199.29 49.51 0.0 199.29     0.0 0.0 257.48 73.0 39.9
323372 323372 2024 11530291 ACHS: 2162 Nostrand Ave BROOKLYN 2162 Nostrand Ave Retail Store 27,495 358.52 140.36 57.61 300.91     0.0 0.0 139.88 0.0 134.5
323488 323488 2024 11665519 ASG: 438 87th St. BROOKLYN 438 87th St Retail Store 35,000 337.85 103.87 63.71 274.14     0.0 0.0 179.03 0.0 102.3
323742 323742 2024 12063327 6401 18th Avenue BROOKLYN 6401 18th Avenue Retail Store 29,000 284.51 105.59 4.55 279.95     0.0 0.0 227.83 27.0 86.8
323944 323944 2024 12711956 Common: 231 Roebling St BROOKLYN 231 Roebling St Retail Store 28,481 193.05 72.98 11.12 181.93     0.0 0.0 142.07 0.0 62.9
324280 324280 2024 14766398 Raymour & Flanigan Marine Park Showroom BROOKLYN 2570 Flatbush Avenue Retail Store 55,200 177.18 34.55 29.59 147.59     0.0 0.0 334.73 95.0 33.3
324383 324383 2024 14946439 Kingswood Crossing RKI2 NY_BM BROOKLYN 1712 East 14th Street Retail Store 130,175 684.31 56.62 15.44 668.87     0.0 0.0 829.7 68.0 46.9
324643 324643 2024 15283250 2294 Nostrand Avenue (Parent Property) BROOKLYN 2294 Nostrand Avenue Retail Store 34,121 231.24 72.98 46.27 184.97     0.0 0.0 130.08 0.0 72.6
324734 324734 2024 15354002 2520 Flatbush Avenue BROOKLYN 2520 Flatbush Avenue Retail Store 31,737 129.01 43.7 4.33 124.68     0.0 0.0 187.97 81.0 36.7
325670 325670 2024 17312252 Capital Management - 1520 Mcdonald ave BROOKLYN 1530 MCDONALD AVENUE Retail Store 28,400 0.0 0.0 0.0 0.0     0.0 0.0 139.18 0.0 0.0
325762 325762 2024 17981908 Midwood: 55 Lombardy BROOKLYN 55 LOMBARDY STREET Retail Store 48,080 299.81 67.17 0.0 299.81     0.0 0.0 286.48 45.0 54.2
325780 325780 2024 18059185 Jackson Property Management - 250 Utica Ave BROOKLYN 250 Utica Ave Retail Store 59,021 0.0 0.0 0.0 0.0     0.0 0.0 289.24 0.0 0.0
325811 325811 2024 18104592 Erez - 118 Nostrand Avenue BROOKLYN 118 Nostrand Ave Retail Store 27,328 142.65 56.19 57.32 85.33     0.0 0.0 207.92 83.0 66.6
325882 325882 2024 18753946 Norse Realty - 1720 Kings Hwy BROOKLYN 1720 Kings Hwy Retail Store 26,000 186.54 77.18 21.66 164.88     0.0 0.0 131.14 0.0 70.8
326929 326929 2024 20985334 Prospect Management - 5002-5024 13 Ave BROOKLYN 5002-5004 13TH AVE Retail Store 40,802 190.6 50.27 3.93 186.68     0.0 0.0 302.48 86.0 41.6
329147 329147 2024 21971100 ACHS Management : 5132 KINGS HIGHWAY BROOKLYN 5132 KINGS HIGHWAY Retail Store 96,734 837.83 93.22 168.31 669.52     0.0 0.0 601.92 19.0 92.9
329148 329148 2024 21971101 ACHS Management : 2230 CHURCH AVENUE BROOKLYN 2230 CHURCH AVENUE Retail Store 28,462 200.29 75.78 37.82 162.47     0.0 0.0 175.58 36.0 74.6
329149 329149 2024 21971102 ACHS Management : 515 86 Street BROOKLYN 515 86 Street Retail Store 35,247 49.25 15.07 0.0 49.25     0.0 0.0 209.27 100.0 12.1
329314 329314 2024 23351950 5521 8 AVENUE BROOKLYN 5521 8 AVENUE Retail Store 81,430 463.45 61.25 13.91 449.54     0.0 0.0 560.6 67.0 51.2
329795 329795 2024 25437291 Caesar's Bay BROOKLYN 1608 SHORE PARKWAY Retail Store 309,567 0.0 0.0 583.71 0.0     0.0 0.0 1517.05 0.0 0.0
329809 329809 2024 25514440 Kohl's/ Target/ Skechers 8973 Bay Pkwy (3345609) BROOKLYN 8973 BAY PARKWAY Retail Store 219,117 253.89 12.49 253.89 0.0     0.0 0.0 1601.06 100.0 21.8
329810 329810 2024 25514494 Management/ Bobs/ 5 Below/ Pizza D'Amore/ Teriyaki One 8961 Bay Pkwy (3404508) BROOKLYN 8961 BAY PARKWAY Retail Store 26,241 8.29 3.44 8.29 0.0     0.0 0.0 190.14 100.0 6.0
329811 329811 2024 25514498 BestBuy 8923 Bay Pkwy (3345607) BROOKLYN 8923 BAY PARKWAY Retail Store 40,762 45.78 12.06 45.78 0.0     0.0 0.0 292.72 100.0 21.1
329812 329812 2024 25514513 T-MOBILE1696 SHORE PARKWAY (3345608) BROOKLYN 1696 SHORE PARKWAY Retail Store 1,787 0.0 0.0 0.0 0.0     0.0 0.0 8.76 0.0 0.0
329813 329813 2024 25514515 SBUX/ VACANT/ 5GUYS 1608 Shore Pkwy (3336456) BROOKLYN 1608 SHORE PARKWAY Retail Store 7,595 29.14 41.33 29.14 0.0     0.0 0.0 46.12 0.0 72.2
331078 331078 2024 30549653 168 Van Dyke Street BROOKLYN 168 Van Dyke Street Retail Store 25,410 0.0 0.0 0.0 0.0     0.0 0.0 0.0 0.0 0.0
331293 331293 2024 30927350 ESRT - 161 Wythe Ave (161 WYTHE AVENUE) BROOKLYN 161 WYTHE AVENUE Retail Store 3,034 21.57 76.53 0.0 21.57     0.0 0.0 14.97 0.0 61.8
331734 331734 2024 33057249 85 North 3rd St (83 NORTH 3 STREET) BROOKLYN 83 NORTH 3 STREET Retail Store 27,111 0.0 0.0 0.0 0.0     0.0 0.0 132.86 0.0 0.0
331958 331958 2024 33532282 8701 4 Avenue BROOKLYN 8701 4 Avenue Retail Store 31,615 164.79 56.08 10.14 154.65     0.0 0.0 232.91 79.0 48.5
332666 332666 2024 33919619 815 Flatbush Ave, Brooklyn, NY 11226, USA BROOKLYN 815 Flatbush Ave Retail Store 74,570 306.82 44.24 56.7 250.12     0.0 0.0 459.67 83.0 43.5
332667 332667 2024 33919624 1457 Flatbush Ave, Brooklyn, NY 11210, USA BROOKLYN 1457 Flatbush Ave Retail Store 57,430 126.93 23.79 46.53 80.39     0.0 0.0 366.97 99.0 27.4
333534 333534 2024 35002587 2027 Emmons Ave BROOKLYN 2027 Emmons Ave Retail Store 120,126 546.04 48.98 0.0 546.04     0.0 0.0 592.73 0.0 39.5
334035 334035 2024 40977693 Admirals Row- Building E BROOKLYN 25 Navy Street Retail Store 40,950 0.44 0.11 0.44 0.0     0.0 0.0 157.87 100.0 0.2
334037 334037 2024 40977892 Admirals Row- Building C BROOKLYN 3 Flushing Ave Retail Store 36,332 0.0 0.0 0.0 0.0     0.0 0.0 0.0 100.0 0.0
334697 334697 2024 49229593 Besen - 1901 Emmons Avenue BROOKLYN 1901 Emmons Avenue Retail Store 55,300 864.03 168.13 300.86 563.16     0.0 0.0 291.92 0.0 190.9
334853 334853 2024 49806292 Georgetowne Shopping Center 3326928 BROOKLYN 2181 Ralph Ave Retail Store 61,523 0.0 0.0 0.0 0.0     0.0 0.0 301.5 0.0 0.0
334874 334874 2024 49992893 ESRT - 130-136 N 6th St BROOKLYN 130 NORTH 6 STREET Retail Store 11,705 98.39 90.52 3.8 94.6     0.0 0.0 72.1 21.0 76.3
334876 334876 2024 49993494 ESRT - 89 N 6th St BROOKLYN 89 NORTH 6 STREET Retail Store 5,438 11.43 22.6 0.0 11.43     0.0 0.0 26.83 0.0 18.3
334877 334877 2024 49993495 ESRT - 102-104 N 6th St BROOKLYN 102 NORTH 6 STREET Retail Store 16,867 0.0 0.0 0.0 0.0     0.0 0.0 82.66 0.0 0.0
334878 334878 2024 49993496 ESRT - 124-128 N 6th St BROOKLYN 147 BERRY STREET Retail Store 2,510 21.43 91.92 2.76 18.67     0.0 0.0 12.69 0.0 85.3
334879 334879 2024 49993692 ESRT - 81-83 N 6th St BROOKLYN 83 NORTH 6 STREET Retail Store 7,417 0.0 0.0 0.0 0.0     0.0 0.0 36.35 0.0 0.0
334881 334881 2024 49993892 ESRT - 91 N 6th St BROOKLYN 91 NORTH 6 STREET Retail Store 5,438 0.0 0.0 0.0 0.0     0.0 0.0 26.65 0.0 0.0
335039 335039 2024 50258293 ESRT - 111-115 N 6th St BROOKLYN 113 NORTH 6 STREET Retail Store 11,570 0.0 0.0 0.0 0.0     0.0 0.0 56.7 0.0 0.0
335530 335530 2024 51885794 Lesser group - 1080 McDonald Ave BROOKLYN 1080 MCDONALD AVE. Retail Store 130,404 1875.73 154.78 494.56 1381.17     0.0 0.0 1410.88 22.0 163.4
335626 335626 2024 52236992 127 Concord Street BROOKLYN 127 Concord Street Retail Store 64,987 212.02 35.09 50.02 162.01     0.0 0.0 330.06 0.0 36.2
335813 335813 2024 52530892 2360 Bedford Ave BROOKLYN 2360 Bedford Ave Retail Store 175,875 722.47 44.24 198.2 524.27     0.0 0.0 914.86 0.0 47.1
336477 336477 2024 53357198 Pinnacle CHILD - 36 Columbia Place BROOKLYN 36 Columbia Place Retail Store 10,090 0.0 0.0 0.0 0.0     0.0 0.0 49.45 0.0 0.0
337530 337530 2024 54090893 343 IRVING AVENUE - 3429086 BROOKLYN 343 IRVING AVENUE Retail Store 9,906 0.0 0.0 0.0 0.0     0.0 0.0 48.55 0.0 0.0
337773 337773 2024 54164696 1726 MCDONALD AVE. BROOKLYN 1726 MCDONALD AVE. Retail Store 34,800 221.81 68.57 25.13 196.68     0.0 0.0 209.86 44.0 62.7
338014 338014 2024 54343192 ABC Stores - 427 Fulton St. BROOKLYN 427Fulton Street Retail Store 35,445 62.84 19.05 18.0 44.84     0.0 0.0 190.34 99.0 20.6
339367 339367 2024 56887392 4515 New Utrecht Ave BROOKLYN 4515 New Utrecht Ave Retail Store 103,436 304.27 38.0 0.0 304.27     0.0 0.0 514.31 95.0 30.7
339509 339509 2024 57512960 ACHS - 531 86 St. BROOKLYN 531 86TH ST. Retail Store 32,941 61.47 20.13 2.65 58.83     0.0 0.0 154.16 98.0 17.0
339511 339511 2024 57516292 ACHS - 1007 - 1011 Flatbush Ave. BROOKLYN 1007 FLATBUSH AVENUE Retail Store 141,599 1318.83 100.21 128.71 1190.12     0.0 0.0 711.7 0.0 90.1
339898 339898 2024 58599694 National Energy Cost Services Inc:408-416FULTON STREET BROOKLYN 408-416FULTON STREET Retail Store 43,360 169.46 42.09 80.04 89.42     0.0 0.0 283.09 88.0 52.7
339900 339900 2024 58602292 National Energy Cost Services Inc:474-482 FULTON STREET BROOKLYN 474-482 FULTON STREET Retail Store 38,402 164.82 46.18 87.64 77.18     0.0 0.0 253.82 84.0 60.4
340033 340033 2024 58770792 ACHS - 241 Atlantic Ave BROOKLYN 241 Atlantic Ave Retail Store 146,249 1223.53 90.09 483.98 739.56     0.0 0.0 779.42 0.0 106.2
340909 340909 2024 59256793 2294-2300 Nostrand Avenue BROOKLYN 2294-2300 Nostrand Avenue Retail Store 19,710 19.72 10.76 6.8 12.91     0.0 0.0 103.98 0.0 12.2
342127 342127 2024 60212771 ACHS - 2230 church Ave. BROOKLYN 2230 church Ave. Retail Store 26,600 162.51 65.77 0.0 162.51     0.0 0.0 133.42 31.0 53.1
344726 344726 2024 65529792 Kotsonis Management : 100 7 AVENUE BROOKLYN 100 7 AVENUE Retail Store 25,370 114.36 48.55 56.25 58.12     0.0 0.0 166.3 81.0 61.6
273153 273153 2023 6692904 Esquire - 1552-1590 Ralph Avenue BROOKLYN 1552-1590 Ralph Avenue Retail Store 50,048 85.4 18.3 0.0 85.4     0.0 0.0 271.7 100.0 15.7
273322 273322 2023 6691097 427 Sassco BROOKLYN 427Fulton Street Retail Store 35,000 40.7 12.92 0.0 40.7     0.0 0.0 144.3 100.0 10.7

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