vkoves / electrify-chicago

Learn about Chicago's most polluting buildings, and what they can do to clean up their act!
http://electrifychicago.net
13 stars 6 forks source link

Show Chart(s) of Total Emissions and/or Intensity #109

Open derekeder opened 3 months ago

derekeder commented 3 months ago

It would be useful to see a high level aggregation for all buildings in the benchmark for a given year. The 2021 report by the city has a chart we could crib from:

Screenshot 2024-06-18 at 8 40 15 PM

It would also be useful, I think, to show a chart of methane gas usage by category over time as well.

I can spend some time and see what charts might be useful.

derekeder commented 3 months ago

I played around with the data and have a few charts to share, all of them available here: https://docs.google.com/spreadsheets/d/1a9E7dwO-kulvCXIFOCjN48fblyKpqd3JkDBdONQiuag/edit?gid=397000190#gid=397000190

Total Natural Gas usage by year

Screenshot 2024-06-19 at 4 52 37 PM

2016 looks to be the first year the City references in its charts, which is likely when the phase-in completed. Between then and 2021, the reporting rate for buildings was between 80-90%, so it would maybe impact the total measurement, but not by a ton. I think showing a chart like this gives a top level indication about gas usage in these larger buildings.

Average Greenhouse Gas Intensity by Property Type

I also tried recreating the average GHG Intensity by Property chart from the 2021 Chicago Energy Benchmarking Report, but its kind of a mess. The categories look to be self-reported, and about 17% of them don't have any label at all. I did chart the top 10 categories by building count. Not sure how useful it is:

Screenshot 2024-06-19 at 5 04 50 PM

Maybe the best thing to show is to average GHG intensity across all building reported by year, similar to Natural Gas used above. It does show a trend downward:

Screenshot 2024-06-19 at 5 09 51 PM