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

101 rows where Calendar Year = 2023 and Property Type = "Other - Public Services" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Total GHG (MtCO2e), GHGI (kgCO2e/m2), Direct GHG (MtCO2e), Indirect GHG (MtCO2e), Site EUI (kBtu/ft2)

Borough 5

Property Type 1

  • Other - Public Services · 101 ✖

Calendar Year 1

  • 2023 · 101 ✖
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)
278590 278590 2023 12714593 Action Environmental - Bronx BRONX 920 E 132nd Street Other - Public Services 155,778 644.9 44.13 22.2 622.6     0.0 0.0 544.4 0.0 39.4
289635 289635 2023 33910497 DSNY_10222_BME Bronx 9/10/11 Warehouse BRONX 1155 Commerce Ave Other - Public Services 17,500 159.2 97.95 113.3 45.9     0.0 0.0 72.7 0.0 146.0
289636 289636 2023 33910499 Benchmarking Group - 218 BRONX 3701 Jerome Ave Other - Public Services 457,900 16042.0 376.74 4429.6 11612.4     0.0 0.0 1696.1 0.0 415.4
289638 289638 2023 33910501 DEP_9921_Croton Water Treatment Plant BRONX 3701 Jerome Ave Other - Public Services 456,500 16025.6 377.81 4424.6 11601.0     0.0 0.0 1690.9 0.0 416.2
290364 290364 2023 33980357 FDNY_3619_Fire Academy: Fire Academy MANHATTAN Wards Island Other - Public Services 161,858 1961.8 130.24 813.7 1148.1     0.0 0.0 697.5 0.0 133.0
291307 291307 2023 16734771 3220 Henry Hudson Parkway - data BRONX 3220 H HUDSON PKWY Other - Public Services 60,919 645.3 114.1 347.8 297.5     0.0 0.0 241.4 0.0 152.4
293666 293666 2023 21353741 FDNY_4000_EMS 57 BROOKLYN 131 Throop Ave Other - Public Services 9,500 82.8 93.65 39.0 43.8     0.0 0.0 37.0 0.0 119.6
293688 293688 2023 21353763 EDC_8038_Bronx Terminal Market/Gateway Plaza (560 Exterior St.) BRONX 665 River Ave Other - Public Services 36,296 0.0 0.0 0.0 0.0     0.0 0.0 224.3 0.0 0.0
293724 293724 2023 21353799 FDNY_3996_EMS 26 BRONX 1265 Boston Rd Other - Public Services 5,000 62.5 134.55 38.9 23.6     0.0 0.0 20.3 0.0 189.8
293757 293757 2023 21353832 FDNY_3995_EMS 18 BRONX 1647 Washington Ave Other - Public Services 6,000 171.0 306.77 37.4 133.6     0.0 0.0 21.9 0.0 322.2
294062 294062 2023 21354107 CIG > WCS BZ_9349_Bronx Zoo: Gains Trailer BRONX 2300 Southern Blvd Other - Public Services 750 0.0 0.0 0.0 0.0     0.0 0.0 2.4 0.0 0.0
294198 294198 2023 21354243 FDNY_4267_Marine Co. 9 STATEN IS 305 Front Street Other - Public Services 9,850 0.0 0.0 0.0 0.0     0.0 0.0 31.1 0.0 0.0
294353 294353 2023 21354401 ACS_5419_Bellevue Hospital Center MANHATTAN 492 1st Ave Other - Public Services 117,833 1227.5 111.94 0.0 1227.5     0.0 0.0 436.6 0.0 109.1
294381 294381 2023 21354429 FDNY_10416_Jacobi Medical Center: EMS 20 BRONX 1410 Pelham Pkwy Other - Public Services 12,500 0.0 0.0 0.0 0.0     0.0 0.0 39.5 0.0 0.0
294402 294402 2023 21354450 NYPD_11604_Rodman's Neck Training Campus: Bomb Squad Building BRONX Rodman's Neck Other - Public Services 7,987 0.0 0.0 0.0 0.0     0.0 0.0 25.2 0.0 0.0
294481 294481 2023 21354530 FDNY_3998_EMS 38 BROOKLYN 554 Winthrop St Other - Public Services 9,800 108.5 119.48 69.0 39.6     0.0 0.0 39.9 0.0 169.6
294594 294594 2023 21354645 Benchmarking Group - 50 QUEENS Fort Totten Other - Public Services 643,459 2413.6 40.9 1129.5 1284.1     0.0 0.0 2862.1 0.0 42.0
294622 294622 2023 21354673 FDNY_10423_Fort Totten: Building 103 (EMS Marine 4/Training) QUEENS 103 Totten Ave Other - Public Services 4,591 0.0 0.0 0.0 0.0     0.0 0.0 14.5 0.0 0.0
294623 294623 2023 21354674 FDNY_10424_Fort Totten: Building 107 QUEENS 107 Duane Rd Other - Public Services 12,404 0.0 0.0 0.0 0.0     0.0 0.0 39.2 0.0 0.0
294624 294624 2023 21354675 FDNY_10425_Fort Totten: Building 316 QUEENS 316 Sergeant Beers Ave Other - Public Services 4,287 0.0 0.0 0.0 0.0     0.0 0.0 13.5 0.0 0.0
294625 294625 2023 21354676 FDNY_10426_Fort Totten: Building 325 QUEENS 325 Pratt Ave Other - Public Services 31,892 0.0 0.0 0.0 0.0     0.0 0.0 100.7 0.0 0.0
294626 294626 2023 21354677 FDNY_10427_Fort Totten: Building 336 QUEENS 336 Shore Rd Other - Public Services 23,732 0.0 0.0 0.0 0.0     0.0 0.0 74.9 0.0 0.0
294627 294627 2023 21354678 FDNY_10428_Fort Totten: Building 418 QUEENS 418 Weaver Ave Other - Public Services 10,935 0.0 0.0 0.0 0.0     0.0 0.0 34.5 0.0 0.0
294628 294628 2023 21354679 FDNY_10446_Fort Totten: Building 411 QUEENS 411 Shore Rd Other - Public Services 13,728 0.0 0.0 0.0 0.0     0.0 0.0 43.3 0.0 0.0
294630 294630 2023 21354681 FDNY_10449_Fort Totten: Building 405   405 Whistler Ave Other - Public Services 22,392 0.0 0.0 0.0 0.0     0.0 0.0 70.7 0.0 0.0
294631 294631 2023 21354682 FDNY_10450_Fort Totten: Building 413 QUEENS 413 Shore Rd Other - Public Services 13,728 0.0 0.0 0.0 0.0     0.0 0.0 43.3 0.0 0.0
294632 294632 2023 21354683 FDNY_10451_Fort Totten: Building 327 QUEENS Fort Totten Other - Public Services 101 0.0 0.0 0.0 0.0     0.0 0.0 0.3 0.0 0.0
294633 294633 2023 21354684 FDNY_10452_Fort Totten: Building 409 QUEENS 409 Shore Rd Other - Public Services 13,728 0.0 0.0 0.0 0.0     0.0 0.0 43.3 0.0 0.0
294634 294634 2023 21354689 FDNY_10457_Fort Totten: Building 129 QUEENS 129 Sergeant Beers Ln Other - Public Services 4,566 0.0 0.0 0.0 0.0     0.0 0.0 14.4 0.0 0.0
294635 294635 2023 21354690 FDNY_10458_Fort Totten: Building 135 QUEENS 135 General Berry Dr Other - Public Services 4,339 0.0 0.0 0.0 0.0     0.0 0.0 13.7 0.0 0.0
294636 294636 2023 21354691 FDNY_10459_Fort Totten: Building 136 QUEENS 136 General Berry Dr Other - Public Services 4,287 0.0 0.0 0.0 0.0     0.0 0.0 13.5 0.0 0.0
294637 294637 2023 21354693 FDNY_10461_Fort Totten: Building 138 QUEENS 138 General Berry Dr Other - Public Services 4,048 0.0 0.0 0.0 0.0     0.0 0.0 12.8 0.0 0.0
294638 294638 2023 21354700 FDNY_10471_Fort Totten: Building 304 QUEENS 304 Shore Rd Other - Public Services 28,831 0.0 0.0 0.0 0.0     0.0 0.0 91.0 0.0 0.0
294639 294639 2023 21354701 FDNY_10472_Fort Totten: Building 305 QUEENS 305 Shore Rd Other - Public Services 1,555 0.0 0.0 0.0 0.0     0.0 0.0 4.9 0.0 0.0
294640 294640 2023 21354702 FDNY_10473_Fort Totten: Building 306 QUEENS 306 Shore Rd Other - Public Services 4,194 0.0 0.0 0.0 0.0     0.0 0.0 13.2 0.0 0.0
294641 294641 2023 21354703 FDNY_10474_Fort Totten: Building 307 QUEENS 307 Shore Rd Other - Public Services 4,194 0.0 0.0 0.0 0.0     0.0 0.0 13.2 0.0 0.0
294642 294642 2023 21354704 FDNY_10475_Fort Totten: Building 308 QUEENS 308 Shore Rd Other - Public Services 4,194 0.0 0.0 0.0 0.0     0.0 0.0 13.2 0.0 0.0
294643 294643 2023 21354705 FDNY_10476_Fort Totten: Building 309   309 Pratt Ave Other - Public Services 4,874 0.0 0.0 0.0 0.0     0.0 0.0 15.4 0.0 0.0
294644 294644 2023 21354706 FDNY_10477_Fort Totten: Building 311 QUEENS 311 Theater Rd Other - Public Services 874 0.0 0.0 0.0 0.0     0.0 0.0 2.8 0.0 0.0
294645 294645 2023 21354707 FDNY_10479_Fort Totten: Building 400 QUEENS 400 Murray Ave Other - Public Services 10,935 0.0 0.0 0.0 0.0     0.0 0.0 34.5 0.0 0.0
294646 294646 2023 21354708 FDNY_10480_Fort Totten: Building 315 QUEENS Fort Totten Other - Public Services 874 0.0 0.0 0.0 0.0     0.0 0.0 2.8 0.0 0.0
294647 294647 2023 21354709 FDNY_10481_Fort Totten: Building 331 QUEENS 331 Pratt ave Other - Public Services 2,550 0.0 0.0 0.0 0.0     0.0 0.0 8.1 0.0 0.0
294648 294648 2023 21354710 FDNY_10482_Fort Totten: Building 317 QUEENS 317 Murray Ave Other - Public Services 6,056 0.0 0.0 0.0 0.0     0.0 0.0 19.1 0.0 0.0
294649 294649 2023 21354711 FDNY_10483_Fort Totten: Building 401 QUEENS 401 Murray Ave Other - Public Services 12,401 0.0 0.0 0.0 0.0     0.0 0.0 39.2 0.0 0.0
294650 294650 2023 21354712 FDNY_10484_Fort Totten: Building 415   415 Cleaver Ave Other - Public Services 9,894 0.0 0.0 0.0 0.0     0.0 0.0 31.2 0.0 0.0
294651 294651 2023 21354713 FDNY_10485_Fort Totten: Building 322   322 Story Ave Other - Public Services 30,260 0.0 0.0 0.0 0.0     0.0 0.0 95.5 0.0 0.0
294652 294652 2023 21354714 FDNY_10486_Fort Totten: Building 323 QUEENS 323 Story Ave Other - Public Services 31,902 0.0 0.0 0.0 0.0     0.0 0.0 100.7 0.0 0.0
294653 294653 2023 21354715 FDNY_10487_Fort Totten: Building 134 QUEENS 134 Sergeant Beers Ln Other - Public Services 4,339 0.0 0.0 0.0 0.0     0.0 0.0 13.7 0.0 0.0
294654 294654 2023 21354716 FDNY_10488_Fort Totten: Building 326 QUEENS 326 Story Ave Other - Public Services 12,108 0.0 0.0 0.0 0.0     0.0 0.0 38.2 0.0 0.0
294655 294655 2023 21354717 FDNY_10489_Fort Totten: Building 410 QUEENS 410 Walter Reed Rd Other - Public Services 874 0.0 0.0 0.0 0.0     0.0 0.0 2.8 0.0 0.0
294657 294657 2023 21354719 FDNY_10491_Fort Totten: Building 318 QUEENS 318 Murray Ave Other - Public Services 12,966 0.0 0.0 0.0 0.0     0.0 0.0 40.9 0.0 0.0
294658 294658 2023 21354720 FDNY_10492_Fort Totten: Building 332 QUEENS 332 Theater Rd Other - Public Services 6,288 0.0 0.0 0.0 0.0     0.0 0.0 19.9 0.0 0.0
294659 294659 2023 21354721 FDNY_10493_Fort Totten: Building 101 QUEENS Fort Totten Other - Public Services 112 0.0 0.0 0.0 0.0     0.0 0.0 0.4 0.0 0.0
294660 294660 2023 21354723 FDNY_10498_Fort Totten: Building 344   344 Sergeant Beers Ave Other - Public Services 192 0.0 0.0 0.0 0.0     0.0 0.0 0.6 0.0 0.0
294661 294661 2023 21354724 FDNY_10500_Fort Totten: Building 333 QUEENS 333 Pratt Ave Other - Public Services 17,602 0.0 0.0 0.0 0.0     0.0 0.0 55.6 0.0 0.0
294662 294662 2023 21354725 FDNY_10501_Fort Totten: Building 402 QUEENS 402 Murray Ave Other - Public Services 12,041 0.0 0.0 0.0 0.0     0.0 0.0 38.0 0.0 0.0
294663 294663 2023 21354726 FDNY_10502_Fort Totten: Building 403 QUEENS 403 Sylvester Ln Other - Public Services 1,748 0.0 0.0 0.0 0.0     0.0 0.0 5.5 0.0 0.0
294664 294664 2023 21354727 FDNY_10503_Fort Totten: Building 310 QUEENS 310 Sergeant Beers Ave Other - Public Services 4,208 0.0 0.0 0.0 0.0     0.0 0.0 13.3 0.0 0.0
294665 294665 2023 21354728 FDNY_10504_Fort Totten: Building 312 QUEENS 312 Sergeant Beers Ave Other - Public Services 4,282 0.0 0.0 0.0 0.0     0.0 0.0 13.5 0.0 0.0
294666 294666 2023 21354729 FDNY_10505_Fort Totten: Building 314 QUEENS 314 Sergeant Beers Ave Other - Public Services 3,274 0.0 0.0 0.0 0.0     0.0 0.0 10.3 0.0 0.0
294667 294667 2023 21354730 FDNY_10506_Fort Totten: Building 334   334 May Rd Other - Public Services 600 0.0 0.0 0.0 0.0     0.0 0.0 1.9 0.0 0.0
294668 294668 2023 21354731 FDNY_10507_Fort Totten: Building 100 QUEENS 100 Totten Ave Other - Public Services 63 0.0 0.0 0.0 0.0     0.0 0.0 0.2 0.0 0.0
294669 294669 2023 21354732 FDNY_10508_Fort Totten: Building 106 QUEENS Fort Totten Other - Public Services 48 0.0 0.0 0.0 0.0     0.0 0.0 0.2 0.0 0.0
294670 294670 2023 21354733 FDNY_10509_Fort Totten: Building 414 QUEENS 414 Walter Reed Rd Other - Public Services 864 0.0 0.0 0.0 0.0     0.0 0.0 2.7 0.0 0.0
294671 294671 2023 21354734 FDNY_10510_Fort Totten: Building 108 QUEENS Fort Totten Other - Public Services 319 0.0 0.0 0.0 0.0     0.0 0.0 1.0 0.0 0.0
294672 294672 2023 21354735 FDNY_10512_Fort Totten: Building 417 QUEENS 417 Walter Reed Rd Other - Public Services 660 0.0 0.0 0.0 0.0     0.0 0.0 2.1 0.0 0.0
294673 294673 2023 21354736 FDNY_10513_Fort Totten: Building 105 QUEENS Fort Totten Other - Public Services 600 0.0 0.0 0.0 0.0     0.0 0.0 1.9 0.0 0.0
294674 294674 2023 21354737 FDNY_10514_Fort Totten: Building 419 QUEENS 419 Walter Reed Rd Other - Public Services 660 0.0 0.0 0.0 0.0     0.0 0.0 2.1 0.0 0.0
294675 294675 2023 21354738 FDNY_10515_Fort Totten: Building 420 QUEENS 420 Weaver Ave Other - Public Services 10,935 25.8 25.83 25.8 0.0     0.0 0.0 71.7 0.0 31.8
294676 294676 2023 21354739 FDNY_10520_Fort Totten: Building 104 QUEENS Fort Totten Other - Public Services 105 0.0 0.0 0.0 0.0     0.0 0.0 0.3 0.0 0.0
294677 294677 2023 21354740 FDNY_10521_Fort Totten: Building 313 QUEENS 313 Theater Rd Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.2 0.0 0.0
294679 294679 2023 21354742 FDNY_10524_Fort Totten: Building 321 QUEENS Fort Totten Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.2 0.0 0.0
294680 294680 2023 21354743 FDNY_10525_Fort Totten: Building 324 QUEENS Fort Totten Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.2 0.0 0.0
294681 294681 2023 21354744 FDNY_10526_Fort Totten: Building 328 QUEENS Fort Totten Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.2 0.0 0.0
294682 294682 2023 21354745 FDNY_10527_Fort Totten: Building 337 QUEENS Fort Totten Other - Public Services 150 0.0 0.0 0.0 0.0     0.0 0.0 0.5 0.0 0.0
294684 294684 2023 21354748 FDNY_10531_Fort Totten: Building 404 QUEENS Fort Totten Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.2 0.0 0.0
294686 294686 2023 21354756 FDNY_10555_Fort Totten: Building 416 QUEENS Fort Totten Other - Public Services 74 0.0 0.0 0.0 0.0     0.0 0.0 0.2 0.0 0.0
294687 294687 2023 21354757 FDNY_11882_EMS 53 (Fort Totten Bldg 103) QUEENS 103 Totten Ave Other - Public Services 4,591 0.0 0.0 0.0 0.0     0.0 0.0 14.5 0.0 0.0
294688 294688 2023 21354758 FDNY_14635_Fort Totten Operation Bldg #135B QUEENS 135 General Berry Rd Other - Public Services 4,339 0.0 0.0 0.0 0.0     0.0 0.0 13.7 0.0 0.0
294941 294941 2023 21355015 FDNY_11877_EMS 14 (Lincoln Hospital) BRONX 234 East 149th St Other - Public Services 5,000 0.0 0.0 0.0 0.0     0.0 0.0 15.8 0.0 0.0
294948 294948 2023 21355023 Benchmarking Group - 9 MANHATTAN 9 Reilly Blvd Other - Public Services 347,754 1961.8 60.28 813.7 1148.1     0.0 0.0 1498.6 0.0 61.9
294949 294949 2023 21355024 FDNY_10276_Fire Academy: Fire Academy Complex MANHATTAN 8 Randall's Island Other - Public Services 9,594 0.0 0.0 0.0 0.0     0.0 0.0 30.3 0.0 0.0
294951 294951 2023 21355026 FDNY_10278_Fire Academy: Building 14 - Subway Simulator MANHATTAN 2 Anaya Pl Other - Public Services 6,535 0.0 0.0 0.0 0.0     0.0 0.0 20.6 0.0 0.0
294952 294952 2023 21355027 FDNY_10279_Fire Academy: Building 9 - Administration MANHATTAN 9 Reilly Blvd Other - Public Services 41,224 0.0 0.0 0.0 0.0     0.0 0.0 130.1 0.0 0.0
294953 294953 2023 21355028 FDNY_10280_Fire Academy: Building 11 - Administration MANHATTAN 11 Reilly Blvd Other - Public Services 42,554 0.0 0.0 0.0 0.0     0.0 0.0 134.3 0.0 0.0
294954 294954 2023 21355029 FDNY_10281_Fire Academy: Building 12 - Field House MANHATTAN 15 Reilly Blvd Other - Public Services 4,857 0.0 0.0 0.0 0.0     0.0 0.0 15.3 0.0 0.0
294956 294956 2023 21355031 FDNY_10283_Fire Academy: Building 7 - Mask Services Unit MANHATTAN 4 Cammarata Ave Other - Public Services 18,359 0.0 0.0 0.0 0.0     0.0 0.0 58.0 0.0 0.0
294957 294957 2023 21355032 FDNY_10284_Fire Academy: Building 8 - Haz Mat Ops MANHATTAN 8 Cammarata Ave Other - Public Services 10,882 0.0 0.0 0.0 0.0     0.0 0.0 34.4 0.0 0.0
294959 294959 2023 21355034 FDNY_10286_Fire Academy: Building 3 - Training MANHATTAN 1 Higgins Ave Other - Public Services 4,150 0.0 0.0 0.0 0.0     0.0 0.0 13.1 0.0 0.0
294960 294960 2023 21355035 FDNY_10287_Fire Academy: Building 4 - Training - Old Law Tenement MANHATTAN 3 Higgins Ave Other - Public Services 4,320 0.0 0.0 0.0 0.0     0.0 0.0 13.6 0.0 0.0
294961 294961 2023 21355036 FDNY_10288_Fire Academy: Building 5 - Training - Fire Simulator MANHATTAN 5 Higgins Ave Other - Public Services 4,800 0.0 0.0 0.0 0.0     0.0 0.0 15.2 0.0 0.0
294962 294962 2023 21355037 FDNY_10289_Fire Academy: Building 2 - Smoke House MANHATTAN 2 D'Auria St Other - Public Services 6,083 0.0 0.0 0.0 0.0     0.0 0.0 19.2 0.0 0.0
294963 294963 2023 21355038 FDNY_10290_Fire Academy: Building 1 - Leary Firefighting Building MANHATTAN 2 Tepper Ave Other - Public Services 5,400 0.0 0.0 0.0 0.0     0.0 0.0 17.0 0.0 0.0
294964 294964 2023 21355039 FDNY_10291_Fire Academy: Subway Simulator Woodshed MANHATTAN 16 Kaminsky Rd Other - Public Services 3,380 0.0 0.0 0.0 0.0     0.0 0.0 10.7 0.0 0.0
294965 294965 2023 21355040 FDNY_10292_Fire Academy: Con Ed Transformer Vault MANHATTAN 1 McGinty Circle Other - Public Services 200 0.0 0.0 0.0 0.0     0.0 0.0 0.6 0.0 0.0
295094 295094 2023 21355173 DCAS_599_115 Chrystie Street Office Building MANHATTAN 115 Chrystie St Other - Public Services 42,500 138.5 35.52 7.6 130.9     0.0 0.0 149.2 0.0 31.7
295506 295506 2023 21355587 DEP > BWSO_865_Jerome Park Reservoir: 3201 Jerome Ave BRONX 3201 Jerome Ave Other - Public Services 39,431 160.4 44.13 0.0 160.4     0.0 0.0 136.7 0.0 37.4
297929 297929 2023 28620953 Hasc Center : 120 AVENUE M BROOKLYN 120 AVENUE M Other - Public Services 47,936 66.6 15.07 0.0 66.6     0.0 0.0 166.2 0.0 12.8
297943 297943 2023 28621238 Fairview Nursing Care Center : 69-70 Grand Central Parkway QUEENS 69-70 Grand Central Parkway Other - Public Services 51,467 0.0 0.0 0.0 0.0     0.0 0.0 162.5 0.0 0.0
305228 305228 2023 6586703 Jacob Shafran - 3674 3rd Avenue BRONX 3674 3rd Avenue Other - Public Services 39,900 326.1 88.26 206.9 119.2     0.0 0.0 162.2 0.0 125.1

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