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

95 rows where Calendar Year = 2022 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), Net GHG (MtCO2e), Site EUI (kBtu/ft2)

Borough 5

Property Type 1

  • Other - Public Services · 95 ✖

Calendar Year 1

  • 2022 · 95 ✖
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)
258196 258196 2022 6586703 Jacob Shafran - 3674 3rd Avenue BRONX 3674 3rd Avenue Other - Public Services 39,900 304.0 81.81 201.7 102.3 304.0   0.0 0.0 146.8 0.0 125.5
258197 258197 2022 6586705 Jacob Shafran - 385 Mcdonald ave BROOKLYN 385 Mcdonald ave Other - Public Services 44,000 289.1 71.04 135.0 154.0 289.1   0.0 0.0 146.1 0.0 99.2
260874 260874 2022 12714593 Action Environmental - Bronx BRONX 920 E 132nd Street Other - Public Services 155,778 506.6 35.52 12.4 494.2 506.6   0.0 0.0 424.1 0.0 39.0
269594 269594 2022 21353741 FDNY_4000_EMS 57 BROOKLYN 131 Throop Ave Other - Public Services 9,500 87.7 99.03 53.9 33.7 87.7   0.0 0.0 34.1 0.0 148.9
269616 269616 2022 21353763 EDC_8038_Gateway Plaza BRONX 665 River Ave Other - Public Services 36,296 0.0 0.0 0.0 0.0 0.0   0.0 0.0 98.4 0.0 0.0
269652 269652 2022 21353799 FDNY_3996_EMS 26 BRONX 1265 Boston Rd Other - Public Services 5,000 65.5 141.01 48.2 17.3 65.5   0.0 0.0 19.2 0.0 222.5
269685 269685 2022 21353832 FDNY_3995_EMS 18 BRONX 1647 Washington Ave Other - Public Services 6,000 142.8 256.18 47.6 95.2 142.8   0.0 0.0 18.7 0.0 337.0
269955 269955 2022 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 0.0 2.0 0.0 0.0
270091 270091 2022 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 0.0 26.7 0.0 0.0
270247 270247 2022 21354401 ACS_5419_Bellevue Hospital Center MANHATTAN 492 1st Ave Other - Public Services 117,833 1097.3 100.1 0.0 1097.3 1097.3   0.0 0.0 360.5 0.0 118.1
270275 270275 2022 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 0.0 33.9 0.0 0.0
270296 270296 2022 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 0.0 21.6 0.0 0.0
270376 270376 2022 21354530 FDNY_3998_EMS 38 BROOKLYN 554 Winthrop St Other - Public Services 9,800 124.7 136.7 91.4 33.3 124.7   0.0 0.0 37.5 0.0 215.8
270489 270489 2022 21354645 Benchmarking Group - 50 QUEENS Fort Totten Other - Public Services 726,942 2293.5 34.44 1331.8 961.7 2293.5   0.0 0.0 2978.1 0.0 40.3
270517 270517 2022 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 0.0 12.4 0.0 0.0
270518 270518 2022 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 0.0 33.6 0.0 0.0
270519 270519 2022 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 0.0 11.6 0.0 0.0
270520 270520 2022 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 0.0 86.4 0.0 0.0
270521 270521 2022 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 0.0 64.3 0.0 0.0
270522 270522 2022 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 0.0 29.6 0.0 0.0
270523 270523 2022 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 0.0 37.2 0.0 0.0
270525 270525 2022 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 0.0 60.7 0.0 0.0
270526 270526 2022 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 0.0 37.2 0.0 0.0
270527 270527 2022 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.0 0.3 0.0 0.0
270528 270528 2022 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 0.0 37.2 0.0 0.0
270529 270529 2022 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 0.0 12.4 0.0 0.0
270530 270530 2022 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 0.0 11.8 0.0 0.0
270531 270531 2022 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 0.0 11.6 0.0 0.0
270532 270532 2022 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 0.0 11.0 0.0 0.0
270533 270533 2022 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 0.0 78.1 0.0 0.0
270534 270534 2022 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 0.0 4.2 0.0 0.0
270535 270535 2022 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 0.0 11.4 0.0 0.0
270536 270536 2022 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 0.0 11.4 0.0 0.0
270537 270537 2022 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 0.0 11.4 0.0 0.0
270538 270538 2022 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 0.0 13.2 0.0 0.0
270539 270539 2022 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 0.0 2.4 0.0 0.0
270540 270540 2022 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 0.0 29.6 0.0 0.0
270541 270541 2022 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 0.0 2.4 0.0 0.0
270542 270542 2022 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 0.0 6.9 0.0 0.0
270543 270543 2022 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 0.0 16.4 0.0 0.0
270544 270544 2022 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 0.0 33.6 0.0 0.0
270545 270545 2022 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 0.0 26.8 0.0 0.0
270546 270546 2022 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 0.0 82.0 0.0 0.0
270547 270547 2022 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 0.0 86.5 0.0 0.0
270548 270548 2022 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 0.0 11.8 0.0 0.0
270549 270549 2022 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 0.0 32.8 0.0 0.0
270550 270550 2022 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 0.0 2.4 0.0 0.0
270552 270552 2022 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 0.0 35.1 0.0 0.0
270553 270553 2022 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 0.0 17.0 0.0 0.0
270554 270554 2022 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.0 0.3 0.0 0.0
270555 270555 2022 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.0 0.5 0.0 0.0
270556 270556 2022 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 0.0 47.7 0.0 0.0
270557 270557 2022 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 0.0 32.6 0.0 0.0
270558 270558 2022 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 0.0 4.7 0.0 0.0
270559 270559 2022 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 0.0 11.4 0.0 0.0
270560 270560 2022 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 0.0 11.6 0.0 0.0
270561 270561 2022 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 0.0 8.9 0.0 0.0
270562 270562 2022 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 0.0 1.6 0.0 0.0
270563 270563 2022 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.0 0.2 0.0 0.0
270564 270564 2022 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.0 0.1 0.0 0.0
270565 270565 2022 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 0.0 2.3 0.0 0.0
270566 270566 2022 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 0.0 0.9 0.0 0.0
270567 270567 2022 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 0.0 1.8 0.0 0.0
270568 270568 2022 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 0.0 1.6 0.0 0.0
270569 270569 2022 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 0.0 1.8 0.0 0.0
270570 270570 2022 21354738 FDNY_10515_Fort Totten: Building 420 QUEENS 420 Weaver Ave Other - Public Services 10,935 30.4 30.14 30.4 0.0 30.4   0.0 0.0 71.7 0.0 37.5
270571 270571 2022 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.0 0.3 0.0 0.0
270572 270572 2022 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.0 0.2 0.0 0.0
270574 270574 2022 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.0 0.2 0.0 0.0
270575 270575 2022 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.0 0.2 0.0 0.0
270576 270576 2022 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.0 0.2 0.0 0.0
270577 270577 2022 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.0 0.4 0.0 0.0
270579 270579 2022 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.0 0.2 0.0 0.0
270581 270581 2022 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.0 0.2 0.0 0.0
270582 270582 2022 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 0.0 12.4 0.0 0.0
270583 270583 2022 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 0.0 11.8 0.0 0.0
270837 270837 2022 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 0.0 13.6 0.0 0.0
270845 270845 2022 21355023 Benchmarking Group - 9 MANHATTAN 9 Reilly Blvd Other - Public Services 185,896 1644.1 94.72 715.5 928.6 1644.1   0.0 0.0 673.8 0.0 111.0
270846 270846 2022 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 0.0 26.0 0.0 0.0
270848 270848 2022 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 0.0 17.7 0.0 0.0
270849 270849 2022 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 0.0 111.7 0.0 0.0
270850 270850 2022 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 0.0 115.3 0.0 0.0
270851 270851 2022 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 0.0 13.2 0.0 0.0
270853 270853 2022 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 0.0 49.8 0.0 0.0
270854 270854 2022 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 0.0 29.5 0.0 0.0
270856 270856 2022 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 0.0 11.2 0.0 0.0
270857 270857 2022 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 0.0 11.7 0.0 0.0
270858 270858 2022 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 0.0 13.0 0.0 0.0
270859 270859 2022 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 0.0 16.5 0.0 0.0
270860 270860 2022 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 0.0 14.6 0.0 0.0
270861 270861 2022 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 0.0 9.2 0.0 0.0
270862 270862 2022 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.0 0.5 0.0 0.0
270994 270994 2022 21355173 DCAS_599_115 Chrystie Street Office Building MANHATTAN 115 Chrystie St Other - Public Services 42,500 203.6 51.67 119.4 84.2 203.6   0.0 0.0 173.3 0.0 62.2
271393 271393 2022 21355587 DEP > BWSO_865_Jerome Park Reservoir: 3201 Jerome Ave BRONX 3201 Jerome Ave Other - Public Services 39,431 133.4 36.6 0.0 133.4 133.4   0.0 0.0 106.3 0.0 40.0
271491 271491 2022 21355688 FDNY_4044_Special Operations Command MANHATTAN 750 Main St Other - Public Services 10,044 83.8 89.34 24.6 59.2 83.8   0.0 0.0 30.7 0.0 115.8

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