vkoves / electrify-chicago

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

Generate Historic Data, Showing In Simple Table #94

Closed vkoves closed 6 months ago

vkoves commented 7 months ago

Description

Updated the data process to generate a new benchmarking-all-years.csv, which contains a smaller set of columns with historic data, so we can see emissions and energy use change over time, and adds a simple table view to render this data. This isn't elegant, but is better than not having the data at all.

Demo From Merchandise Mart:

Screenshot from 2024-05-07 22-05-43

Note: Only columns with any values will be rendered, to reduce noise. So for Merchandise Mart, the Energy Star Score or District Heating is not shown over time.

Resolves #73

Testing Instructions

Confirmed that historical data renders properly on a variety of pages - even if a building only has one year of data, the table should render fine. Also made sure the table works well on mobile by scrolling it horizontally.

Checklist:

netlify[bot] commented 7 months ago

Deploy Preview for radiant-cucurucho-d09bae ready!

Name Link
Latest commit ee31e3502ba9e30d2d8319226533c020bb3bad43
Latest deploy log https://app.netlify.com/sites/radiant-cucurucho-d09bae/deploys/663aeba1f14a880008095b8b
Deploy Preview https://deploy-preview-94--radiant-cucurucho-d09bae.netlify.app
Preview on mobile
Toggle QR Code...

QR Code

Use your smartphone camera to open QR code link.

To edit notification comments on pull requests, go to your Netlify site configuration.

vkoves commented 6 months ago

Idea for improvement: Hide columns that never have data (e.g. the Energy Star Score in the PR description screenshot from Merch Mart) since there's no point comparing something with no data at all.