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

217 rows where Borough = "QUEENS" and Property Type = "Other - Recreation" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Grid Emissions Rate (kgCO2e/MBtu)

Calendar Year 12

Property Type 1

  • Other - Recreation · 217 ✖

Borough 1

  • QUEENS · 217 ✖
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)
324846 324846 2024 15530376 Tafner Field House QUEENS 8000 Utopia Parkway Other - Recreation 43,000 0.0 0.0 0.0 0.0     0.0 0.0 169.57 0.0 0.0
327409 327409 2024 21353906 DPR_5907_Spirit Playground Comfort Station QUEENS 36-36 10th St Other - Recreation 335 0.62 19.91 0.0 0.62     0.0 0.0 1.54 0.0 16.1
327418 327418 2024 21353915 DPR_5888_East Elmhurst Playground Comfort Station QUEENS 9801 25th Ave Other - Recreation 443 3.53 85.68 2.29 1.24     0.0 0.0 2.32 0.0 121.5
327421 327421 2024 21353918 DPR_5882_Playground 90 Comfort Station QUEENS 8902 32nd Ave Other - Recreation 440 3.62 88.69 2.47 1.16     0.0 0.0 2.32 0.0 128.4
327424 327424 2024 21353921 DPR_5894_Northern Playground Comfort Station QUEENS 93-11 34th Ave Other - Recreation 437 7.87 193.86 6.88 0.99     0.0 0.0 2.41 0.0 316.2
327433 327433 2024 21353930 DPR_5887_Playground 62 Comfort Station QUEENS 62-10 108 St Other - Recreation 434 3.42 84.82 2.74 0.68     0.0 0.0 2.35 0.0 132.3
327434 327434 2024 21353931 Benchmarking Group - 159 QUEENS Flushing Meadows Corona Park Other - Recreation 6,262 55.98 96.23 30.04 25.93     0.0 0.0 34.78 0.0 113.0
327437 327437 2024 21353934 DPR_5609_Triassic Playground Comfort Station QUEENS 47-01 111 St Other - Recreation 427 12.83 323.56 0.0 12.83     0.0 0.0 1.97 0.0 261.2
327438 327438 2024 21353935 DPR_9942_Meadow Lake Boathouse QUEENS Flushing Meadows Corona Park Other - Recreation 9,532 25.38 28.74 15.58 9.8     0.0 0.0 60.07 0.0 31.0
327443 327443 2024 21353941 DPR_5860_Willow Lake Playground Comfort Station QUEENS 7125 113th St Other - Recreation 409 0.82 21.64 0.0 0.82     0.0 0.0 1.88 0.0 17.5
327446 327446 2024 21353944 DPR_5881_Russell Sage Playground Comfort Station QUEENS 68-17 Austin St Other - Recreation 414 11.76 305.8 10.74 1.02     0.0 0.0 2.3 0.0 509.8
327448 327448 2024 21353946 DPR_3794_Forest Park - 87th Street Comfort Station QUEENS 87-00 Park Ln South Other - Recreation 1,333 1.46 11.73 0.0 1.46     0.0 0.0 6.14 0.0 9.5
327449 327449 2024 21353947 DPR_3795_Forest Park - 89th Street Comfort Station QUEENS 83-66 Woodhaven Blvd Other - Recreation 1,500 141.98 1018.8 138.53 3.45     0.0 0.0 8.45 0.0 1758.7
327453 327453 2024 21353951 DPR_6203_Forest Hills Park Comfort Station (Oak Ridge Bldg) QUEENS 1 Forest Park Dr Other - Recreation 8,770 1.33 1.61 0.0 1.33     0.0 0.0 40.38 0.0 1.3
327460 327460 2024 21353958 DPR_5198_Colden Playground Public Restroom QUEENS 140-45 31st Dr Other - Recreation 444 0.21 5.17 0.0 0.21     0.0 0.0 2.04 0.0 4.1
327463 327463 2024 21353961 DPR_5892_Clintonville Playground Comfort Station QUEENS 154-70 17 Ave Other - Recreation 407 7.46 197.3 0.0 7.46     0.0 0.0 1.87 0.0 159.3
327466 327466 2024 21353964 DPR_5870_Bowne Playground Comfort Station QUEENS 37-01 Bowne St Other - Recreation 439 12.12 297.19 11.56 0.56     0.0 0.0 3.29 0.0 386.4
327469 327469 2024 21353967 DPR_5585_PS 164 Playground (Queens Valley) Comfort Station QUEENS 138-01 77th Ave Other - Recreation 375 5.65 162.21 5.65 0.0     0.0 0.0 2.12 0.0 283.7
327475 327475 2024 21353973 DPR_5190_Emerald Playground Public Restroom QUEENS 70-10 164th St Other - Recreation 417 5.8 149.73 5.8 0.0     0.0 0.0 2.36 0.0 261.9
327629 327629 2024 21354127 DPR_5889_Playground 75 Comfort Station QUEENS 75-02 162nd St Other - Recreation 416 11.16 288.9 0.0 11.16     0.0 0.0 1.92 0.0 233.2
327635 327635 2024 21354133 DPR_3776_Cunningham Park - Avon Rd Comfort Station QUEENS Cunningham Park E/O Avon Rd Other - Recreation 1,266 1.66 14.1 0.0 1.66     0.0 0.0 5.83 0.0 11.4
327638 327638 2024 21354136 DPR_3781_Cunningham Park Tennis House Public Restroom QUEENS 19600 Union Tpke Other - Recreation 1,981 33.34 181.16 26.62 6.72     0.0 0.0 12.02 0.0 249.8
327641 327641 2024 21354139 DPR_5884_Marie Curie Park Comfort Station QUEENS 46-35 Oceania St Other - Recreation 418 1.84 47.47 0.0 1.84     0.0 0.0 1.92 0.0 38.3
327644 327644 2024 21354142 DPR_5872_Saul Weprin Playground Comfort Station QUEENS 201-02 53 Ave Other - Recreation 401 0.46 12.38 0.0 0.46     0.0 0.0 1.85 0.0 10.0
327647 327647 2024 21354145 DPR_5175_Tall Oak Playground Comfort Station QUEENS 218-12 64 Ave Other - Recreation 434 0.51 12.59 0.16 0.34     0.0 0.0 2.13 0.0 14.0
327656 327656 2024 21354154 DPR_5233_Castlewood Playground Comfort Station QUEENS 252-12 72 Ave Other - Recreation 432 4.41 109.79 2.6 1.81     0.0 0.0 2.24 0.0 149.6
327666 327666 2024 21354164 DPR_5871_Playground 80 Comfort Station QUEENS 80-51 261st St Other - Recreation 443 12.61 306.45 0.0 12.61     0.0 0.0 2.04 0.0 247.4
327675 327675 2024 21354173 DPR_5893_Joseph Austin Playground Comfort Station QUEENS 165-65 84 Ave Other - Recreation 431 12.65 315.81 11.07 1.58     0.0 0.0 2.37 0.0 515.3
327681 327681 2024 21354179 DPR_5181_Hollis Playground Comfort Station QUEENS 204-00 Hollis Ave Other - Recreation 427 10.95 276.09 0.0 10.95     0.0 0.0 1.97 0.0 222.9
327688 327688 2024 21354186 DPR_5215_Shea Stadium Parking Lot QUEENS 119-02 Roosevelt Ave Other - Recreation 1,520 33.3 235.84 0.0 33.3     0.0 0.0 7.0 0.0 190.4
327689 327689 2024 21354187 DPR_5217_Roy Wilkens Park Comfort Station QUEENS 117-00 Merrick Blvd Other - Recreation 1,520 8.4 59.52 8.4 0.0     0.0 0.0 8.61 0.0 104.0
327695 327695 2024 21354193 DPR_10234_PS 197 Playground Comfort Station QUEENS 8-25 Lanett Ave Other - Recreation 781 8.51 117.33 6.92 1.6     0.0 0.0 4.24 0.0 184.5
327806 327806 2024 21354328 DPR_5921_Locust Manor Playground Comfort Station QUEENS 121-15 Lucas St Other - Recreation 435 5.26 130.03 4.07 1.19     0.0 0.0 2.34 0.0 199.9
327883 327883 2024 21354414 DPR_3786_Flushing Meadows: FMCP Aquatic Center QUEENS 131-00 Avery Ave Other - Recreation 110,000 1810.85 177.17 753.2 1057.66     0.0 0.0 549.24 0.0 212.5
327884 327884 2024 21354415 DPR_3788_Flushing Meadows: Queens Zoo Concession and Admin Bldgs QUEENS 53-51 111th St Other - Recreation 6,198 11.13 19.38 11.13 0.0     0.0 0.0 35.12 0.0 33.8
327889 327889 2024 21354420 DPR_9925_FMCP Passerelle Building QUEENS 26 Meridian Rd Other - Recreation 34,558 145.7 45.42 145.7 0.0     0.0 0.0 195.5 0.0 79.5
328054 328054 2024 21354626 DPR_5902_Louis Armstrong Playground Comfort Station QUEENS 34-60 113th St Other - Recreation 414 6.34 164.9 5.41 0.94     0.0 0.0 2.27 0.0 265.6
328057 328057 2024 21354629 DPR_3784_Whitestone Playground - PS 193 TCU Trailer QUEENS 43-48 Main St Other - Recreation 1,275 8.5 71.8 8.5 0.0     0.0 0.0 7.22 0.0 125.6
328065 328065 2024 21354637 DPR_3791_Kissena Corridor Park - Building QUEENS W/O 134-40 Elder Ave Other - Recreation 1,004 0.0 0.0 0.0 0.0     0.0 0.0 3.95 0.0 0.0
328068 328068 2024 21354641 DPR_5896_Auburndale Playground Comfort Station QUEENS 171-11 35th Ave Other - Recreation 418 3.57 91.82 2.69 0.88     0.0 0.0 2.24 0.0 139.3
328082 328082 2024 21354655 DPR_10523_Fort Totten: Building 338 QUEENS 338 Story Ave Other - Recreation 511 0.0 0.0 0.0 0.0     0.0 0.0 2.02 0.0 0.0
328182 328182 2024 21354817 DPR_5873_Fresh Meadows Playground Comfort Station QUEENS 67-10 Fresh Meadow Ln Other - Recreation 434 10.6 262.85 9.28 1.32     0.0 0.0 2.39 0.0 428.9
328205 328205 2024 21354843 DPR_5898_Harold Schneiderman Playground Comfort Station QUEENS 153-23 83rd St Other - Recreation 378 4.7 133.8 4.07 0.63     0.0 0.0 2.08 0.0 217.0
328208 328208 2024 21354847 DPR_5187_North Rochdale Playground Comfort Station QUEENS 168-02 Baisley Blvd Other - Recreation 499 1.89 40.69 1.46 0.43     0.0 0.0 2.69 0.0 62.5
328214 328214 2024 21354853 DPR_14301_Springfield Park North Playground Comfort Station QUEENS 145-12 Springfield Blvd Other - Recreation 411 2.96 77.39 0.88 2.07     0.0 0.0 2.0 0.0 84.3
333069 333069 2024 33964537 DPR_9054_Walter Ward Playground QUEENS 159-90 89th St Other - Recreation 1 0.01 97.2 0.0 0.01     0.0 0.0 0.0 0.0 78.5
279601 279601 2023 15530376 Tafner Field House QUEENS 8000 Utopia Parkway Other - Recreation 43,000 0.0 0.0 0.0 0.0     0.0 0.0 174.0 0.0 0.0
281018 281018 2023 2611745 XXZNorth Shore Towers - Golf Course/Irrigation Wells - 272-86 Grand Central Pkwy QUEENS 272-86 Grand Central Pkwy Other - Recreation 200 0.0 0.0 0.0 0.0     0.0 0.0 0.7 0.0 0.0
281607 281607 2023 2653160 47-12 32nd Place AKA 47-11 Van Dam Street QUEENS 47-12 32nd Place AKA 47-11 Van Dam Street Other - Recreation 71,276 244.0 36.6 127.5 116.4     0.0 0.0 352.9 0.0 48.7
290005 290005 2023 33964537 DPR_9054_Walter Ward Playground QUEENS 159-90 89th St, Howard Beach Other - Recreation 1 0.0 0.0 0.0 0.0     0.0 0.0 0.0 0.0 0.0
293862 293862 2023 21353906 DPR_5907_Spirit Playground Comfort Station QUEENS 36-36 10th St Other - Recreation 335 0.6 20.45 0.0 0.6     0.0 0.0 1.5 0.0 17.1
293871 293871 2023 21353915 DPR_5888_East Elmhurst Playground Comfort Station QUEENS 9801 25th Ave Other - Recreation 443 3.0 73.19 2.0 1.0     0.0 0.0 2.3 0.0 105.1
293874 293874 2023 21353918 DPR_5882_Playground 90 Comfort Station QUEENS 8902 32nd Ave Other - Recreation 440 4.9 120.56 3.8 1.2     0.0 0.0 2.3 0.0 185.7
293877 293877 2023 21353921 DPR_5894_Northern Playground Comfort Station QUEENS 93-11 34th Ave Other - Recreation 437 6.0 148.54 5.1 1.0     0.0 0.0 2.4 0.0 239.1
293886 293886 2023 21353930 DPR_5887_Playground 62 Comfort Station QUEENS 62-10 108 St Other - Recreation 434 2.6 64.58 2.1 0.5     0.0 0.0 2.3 0.0 102.3
293887 293887 2023 21353931 Benchmarking Group - 159 QUEENS Flushing Meadows Corona Park Other - Recreation 6,262 55.6 95.8 32.6 23.0     0.0 0.0 36.0 0.0 110.5
293890 293890 2023 21353934 DPR_5609_Triassic Playground Comfort Station QUEENS 47-01 111 St Other - Recreation 427 13.0 327.22 0.0 13.0     0.0 0.0 1.9 0.0 279.7
293891 293891 2023 21353935 DPR_9942_Meadow Lake Boathouse QUEENS Flushing Meadows Corona Park Other - Recreation 4,529 32.0 76.42 24.8 7.2     0.0 0.0 31.1 0.0 88.4
293896 293896 2023 21353941 DPR_5860_Willow Lake Playground Comfort Station QUEENS 7125 113th St Other - Recreation 409 0.8 21.53 0.0 0.8     0.0 0.0 1.8 0.0 18.0
293899 293899 2023 21353944 DPR_5881_Russell Sage Playground Comfort Station QUEENS 68-17 Austin St Other - Recreation 414 13.3 345.52 12.3 1.0     0.0 0.0 2.3 0.0 581.4
293901 293901 2023 21353946 DPR_3794_Forest Park - 87th Street Comfort Station QUEENS 87-00 Park Ln South Other - Recreation 1,333 1.3 10.76 0.0 1.3     0.0 0.0 5.8 0.0 9.2
293902 293902 2023 21353947 DPR_3795_Forest Park - 89th Street Comfort Station QUEENS 83-66 Woodhaven Blvd Other - Recreation 1,500 109.1 782.54 106.3 2.8     0.0 0.0 8.4 0.0 1351.0
293906 293906 2023 21353951 DPR_6203_Forest Hills Park Comfort Station (Oak Ridge Bldg) QUEENS 1 Forest Park Dr Other - Recreation 8,770 1.4 2.15 0.0 1.4     0.0 0.0 38.1 0.0 1.5
293913 293913 2023 21353958 DPR_5198_Cadwallader Colden Playground Comfort Station QUEENS 140-45 31st Dr Other - Recreation 444 0.3 7.53 0.0 0.3     0.0 0.0 1.9 0.0 6.7
293916 293916 2023 21353961 DPR_5892_Clintonville Playground Comfort Station QUEENS 154-70 17 Ave Other - Recreation 407 1.9 49.51 0.0 1.9     0.0 0.0 1.8 0.0 42.4
293919 293919 2023 21353964 DPR_5870_Bowne Playground Comfort Station QUEENS 37-01 Bowne St Other - Recreation 439 51.2 1255.07 15.5 35.7     0.0 0.0 2.2 0.0 1240.9
293922 293922 2023 21353967 DPR_5585_PS 164 Playground (Queens Valley) Comfort Station QUEENS 138-01 77th Ave Other - Recreation 375 5.2 148.54 5.2 0.0     0.0 0.0 2.1 0.0 259.7
293928 293928 2023 21353973 DPR_5190_PS 200 Playground Comfort Station QUEENS 70-10 164th St Other - Recreation 417 5.6 144.24 5.6 0.0     0.0 0.0 2.4 0.0 251.4
294082 294082 2023 21354127 DPR_5889_Playground 75 Comfort Station QUEENS 75-02 162nd St Other - Recreation 416 10.9 283.09 0.0 10.9     0.0 0.0 1.8 0.0 242.1
294088 294088 2023 21354133 DPR_3776_Cunningham Park - Avon Rd Comfort Station QUEENS Cunningham Park E/O Avon Rd Other - Recreation 1,266 1.7 13.99 0.0 1.7     0.0 0.0 5.5 0.0 12.3
294091 294091 2023 21354136 DPR_3781_Cunningham Park Tennis Center QUEENS 19600 Union Tpke Other - Recreation 1,981 36.4 198.06 29.9 6.5     0.0 0.0 12.5 0.0 264.6
294094 294094 2023 21354139 DPR_5884_Marie Curie Park Comfort Station QUEENS 46-35 Oceania St Other - Recreation 418 1.7 44.13 0.0 1.7     0.0 0.0 1.8 0.0 37.8
294097 294097 2023 21354142 DPR_5872_Saul Weprin Playground Comfort Station QUEENS 201-02 53 Ave Other - Recreation 401 4.7 124.86 4.1 0.5     0.0 0.0 2.2 0.0 206.1
294100 294100 2023 21354145 DPR_5175_Tall Oak Playground Comfort Station QUEENS 218-12 64 Ave Other - Recreation 434 3.1 76.42 2.8 0.2     0.0 0.0 2.4 0.0 127.6
294109 294109 2023 21354154 DPR_5233_Castlewood Playground Comfort Station QUEENS 252-12 72 Ave Other - Recreation 432 6.3 157.15 4.6 1.7     0.0 0.0 2.3 0.0 236.7
294119 294119 2023 21354164 DPR_5871_Playground 80 Comfort Station QUEENS 80-51 261st St Other - Recreation 443 2.4 57.05 0.0 2.4     0.0 0.0 1.9 0.0 48.9
294128 294128 2023 21354173 DPR_5893_Joseph Austin Playground Comfort Station QUEENS 165-65 84 Ave Other - Recreation 431 10.8 270.17 9.1 1.7     0.0 0.0 2.3 0.0 434.7
294134 294134 2023 21354179 DPR_5181_Hollis Playground Comfort Station QUEENS 204-00 Hollis Ave Other - Recreation 427 5.3 134.55 0.0 5.3     0.0 0.0 1.9 0.0 115.1
294141 294141 2023 21354186 DPR_5215_Shea Stadium Parking Lot QUEENS 119-02 Roosevelt Ave Other - Recreation 1,520 29.4 208.82 0.0 29.4     0.0 0.0 6.6 0.0 178.0
294142 294142 2023 21354187 DPR_5217_Roy Wilkens Park Comfort Station QUEENS 117-00 Merrick Blvd Other - Recreation 1,520 16.6 117.33 16.6 0.0     0.0 0.0 8.6 0.0 205.8
294148 294148 2023 21354193 DPR_10234_PS 197 Playground Comfort Station QUEENS 8-25 Lanett Ave Other - Recreation 781 10.3 141.01 9.3 1.0     0.0 0.0 4.3 0.0 235.2
294281 294281 2023 21354328 DPR_5921_Locust Manor Playground Comfort Station QUEENS 121-15 Lucas St Other - Recreation 435 5.0 123.78 4.1 0.9     0.0 0.0 2.3 0.0 196.5
294366 294366 2023 21354414 DPR_3786_Flushing Meadows: FMCP Aquatic Center QUEENS 131-00 Avery Ave Other - Recreation 110,000 1760.1 172.22 771.4 988.7     0.0 0.0 532.7 0.0 214.7
294367 294367 2023 21354415 DPR_3788_Flushing Meadows: Queens Zoo Concession and Admin Bldgs QUEENS 53-51 111th St Other - Recreation 6,198 22.8 39.83 22.8 0.0     0.0 0.0 35.1 0.0 69.4
294372 294372 2023 21354420 DPR_9925_Playground for All Children QUEENS 26 Meridian Rd Other - Recreation 15,000 115.7 82.88 115.7 0.0     0.0 0.0 85.0 0.0 145.3
294576 294576 2023 21354626 DPR_5902_Louis Armstrong Playground Comfort Station QUEENS 34-60 113th St Other - Recreation 414 7.3 190.52 6.4 0.9     0.0 0.0 2.3 0.0 311.8
294579 294579 2023 21354629 DPR_3784_Whitestone Playground - PS 193 TCU Trailer QUEENS 43-48 Main St Other - Recreation 1,275 5.7 48.44 5.7 0.0     0.0 0.0 7.2 0.0 84.1
294587 294587 2023 21354637 DPR_3791_FMCP Comfort Station QUEENS W/O 134-40 Elder Ave Other - Recreation 500 0.0 0.0 0.0 0.0     0.0 0.0 2.0 0.0 0.0
294590 294590 2023 21354641 DPR_5896_Auburndale Playground Comfort Station QUEENS 171-11 35th Ave Other - Recreation 600 2.6 46.28 1.7 0.9     0.0 0.0 3.1 0.0 67.1
294604 294604 2023 21354655 DPR_10523_Fort Totten: Building 338 QUEENS 338 Story Ave Other - Recreation 511 0.0 0.0 0.0 0.0     0.0 0.0 2.1 0.0 0.0
294746 294746 2023 21354817 DPR_5873_Fresh Meadows Playground Comfort Station QUEENS 67-10 Fresh Meadow Ln Other - Recreation 434 5.7 141.01 4.7 1.0     0.0 0.0 2.3 0.0 224.7
294772 294772 2023 21354843 DPR_5898_Harold Schneiderman Playground Comfort Station QUEENS 153-23 83rd St Other - Recreation 378 5.3 151.77 4.5 0.8     0.0 0.0 2.0 0.0 243.9
294775 294775 2023 21354847 DPR_5187_North Rochdale Playground Comfort Station QUEENS 168-02 Baisley Blvd Other - Recreation 499 12.6 271.25 11.4 1.2     0.0 0.0 2.7 0.0 451.1
294781 294781 2023 21354853 DPR_14301_Springfield Park North Playground Comfort Station QUEENS 145-12 Springfield Blvd Other - Recreation 411 6.2 162.53 4.7 1.5     0.0 0.0 2.2 0.0 249.6
304795 304795 2023 6430363 Central Queens YMCA QUEENS 8925 PARSONS BLVD Other - Recreation 80,600 0.0 0.0 0.0 0.0     0.0 0.0 326.2 0.0 0.0
305553 305553 2023 6629480 Rocklyn: 39-56 56th St QUEENS 39-56 56th St Other - Recreation 43,755 368.7 90.42 241.7 126.9     0.0 0.0 224.5 0.0 130.7
244109 244109 2022 6629480 Rocklyn: 39-56 56th St QUEENS 39-56 56th St Other - Recreation 43,755 274.9 67.81 179.3 95.6 274.9   0.0 0.0 200.8 0.0 103.0
250419 250419 2022 2611745 North Shore Towers - Golf Course/Irrigation Wells - 272-86 Grand Central Pkwy QUEENS 272-86 Grand Central Pkwy Other - Recreation 200 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.6 0.0 0.0
257328 257328 2022 15530376 Tafner Field House QUEENS 8000 Utopia Parkway Other - Recreation 43,000 0.0 0.0 0.0 0.0 0.0   0.0 0.0 148.8 0.0 0.0
263546 263546 2022 2653160 47-11 Van Dam Street QUEENS 47-11 Van Dam Street Other - Recreation 71,276 220.3 33.37 126.4 93.9 220.3   0.0 0.0 313.6 0.0 49.0

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