Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Integrate Full Data Source (Historic Data) #73

Closed
alexkcode opened this issue Feb 14, 2024 · 3 comments · Fixed by #94
Closed

Integrate Full Data Source (Historic Data) #73

alexkcode opened this issue Feb 14, 2024 · 3 comments · Fixed by #94
Labels
important Something we should do soon

Comments

@alexkcode
Copy link
Collaborator

alexkcode commented Feb 14, 2024

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:

  • Submission Status (so we know if they skipped a year?)
  • Square Footage
  • TotalGHGEmissions
  • GHGIntensity
  • SiteEUI
  • SourceEUI
  • ENERGYSTARScore
  • ElectricityUse
  • NaturalGasUse
  • DistrictSteamUse
  • DistrictChilledWaterUse

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.

@alexkcode alexkcode added the important Something we should do soon label Feb 14, 2024
@thetenzinwoser
Copy link

I'm working on the visualization of this data!

@vkoves
Copy link
Owner

vkoves commented Mar 27, 2024

@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
Copy link
Owner

vkoves commented May 1, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
important Something we should do soon
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants