search

GreenInfo-Network / seattle-building-dashboard

Energy benchmarking for Seattle
https://greeninfo-network.github.io/seattle-building-dashboard/
ISC License
1 stars 0 forks source link

Emissions per square foot card - pulling wrong data field for kg/sf #22

Closed seattle-benchmarking closed 2 years ago

seattle-benchmarking commented 2 years ago

The second building details card (emissions per square foot) is using the wrong data field. Should be pulling from total_ghg_emissions_intensity instead of total_ghg_emissions. e.g. this building should be showing 0.3 kg/sf instead of 385.6

┆Issue is synchronized with this Asana task

seattle-benchmarking commented 2 years ago

in SQL SELECT id, year, total_ghg_emissions, total_ghg_emissions_intensity FROM public.seattle_buildings_master_copy_for_update2020 where id = 659 and year = 2020

tomay commented 2 years ago

After updating:

image