search

colorado-cancer-center / ecco

An interactive resource for exploring cancer data in Colorado
https://coe-ecco.org
Apache License 2.0
1 stars 2 forks source link

Integrates CDPHE radon data #73

Closed falquaddoomi closed 2 months ago

falquaddoomi commented 2 months ago

This PR imports the radon data from https://coepht.colorado.gov/radon-data.

Specifically, it adds the models RadonCounty and RadonTract along with the migration to create the models in the database, a command to import data into the models from the radon spreadsheet, and an updated database dump containing the most recent radon data as of today (June 20th, 2024).

Each table contains the following measures:

Todos:

Closes #24.

netlify[bot] commented 2 months ago

Deploy Preview for exploring-cancer-in-colorado ready!

Name Link
Latest commit 15bf041f88d2197e3ff58e126a6246c178c64a2a
Latest deploy log https://app.netlify.com/sites/exploring-cancer-in-colorado/deploys/66748517cd8f44000884a01d
Deploy Preview https://deploy-preview-73--exploring-cancer-in-colorado.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.

vincerubinetti commented 2 months ago

It looks like this is being added as a measure category. The frontend sort of expects the real data to be at the "measure" level. So there's a blank space in the legend here:

Screenshot 2024-06-20 at 3 10 30 PM

And the "measure" dropdown has no options.

I could hide the legend gap and just not display the dropdown when there are no measure options. But perhaps it'd be better to put this under the "environment" measure category?

vincerubinetti commented 2 months ago

Sorry ignore that previous comment, it seems like the sub-measures you listed above are just not showing. Looking into it.

falquaddoomi commented 2 months ago

Hey @vincerubinetti, I think this is probably another situation in which the latest dump (included in this PR) isn't being loaded due to the database already being populated.

I need to implement some way to get it to load a new dump automatically, but for the time being you can:

  1. execute ./run_stack.sh down -v to delete the local database volume
  2. execute ./run_stack.sh which should import the new dump since the database volume is now empty