vkoves / electrify-chicago

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

Integrate Full Data Source (Historic Data) #73

Closed alexkcode closed 1 month ago

alexkcode commented 4 months ago

Depends on #89.

Currently we are only feeding the "latest year" (the last year of data that we have, not necessarily the current year) to the frontend of the website. We should track the below fields over time so that we can build further data visualizations (e.g. issue #4).

Fields to track over time:

The main script for this change should be src/data/scripts/clean_and_pare_down_data_current_year.py. The current thinking is we either modify that component to do what we want or, more ideally, we create a new script that outputs to a different file to maintain the stability of current processes.

This should output to a separate CSV file in the dist (e.g. buildings_across_years.csv) so that building list pages and search pages don't need to do a bunch of complex filtering. Also the current ranking UI might break. We'd basically have a latest data set (what we have right now) and the historical data we can query building by building.

thetenzinwoser commented 3 months ago

I'm working on the visualization of this data!

vkoves commented 3 months ago

@thetenzinwoser - awesome! Here's all the info on Merch Mart over the years, it's improved every year, which I think is a great thing to highlight.

vkoves commented 2 months ago

@alexkcode - have you started on this issue? I think you have and had some code going, but I wanted to check just in case