show county report card for selected county

[cypressf]

inspiration https://hazards.fema.gov/nri/map

• Search bar to find a county
• A new page loads that shows a report card for that county displaying all metrics that are in the risk tab. Can copy and paste the link to share the county report card.
• Shows them as percentile, but also raw raw value
• Potentially toggle between relative to nation and relative to state

[cypressf]

John Reilly mentioned cities or communities could be a potential user of this feature. Maybe we reach out to contacts, like people in the city of cambridge government or the mass government, or other city or state governments, or the city that Alyssa reached out to to get some ideas.

Alyssa had reached out to someone in a local government who was in charge of tourism and business development in the county. That's were this county report card idea originated.

[cypressf]

Some needs:

• Determine the local risk to apply to grants to get aid
• Figure out if there are specific risks to try to mitigate before development
• Could help people who are looking to apply to community grants
• Some cities and towns create climate vulnerability assessments; perhaps we could help provide info for those assessments

[cypressf]

We could go to a national conference for city planners and talk to them, present stuff, or do co-design to see what needs and values they have and get feedback on any ideas we have. American Planning Association does a national planning conference. There's one in April in Philly, and they have "climate emergency" as one of the items on their list.

The farmers association is a potential group we could reach out to.

Horacio also could connect with someone at the Foundation for Food and Agriculture research.

[cypressf]

We can just get something up, like a beta that might not be even public for a report card idea, and show it to people.

[cypressf]

Bill Becker was the president of state-level environmental organization. We could reach out to see if state-level planners could give feedback. We worked with Section 115 w Phil Barnet.

[cypressf]

Users

Local to state policymakers

They could use the report card for grants, planning, and such.

Industry decision makers

Help them figure out how to plan around risks in the area.

[cypressf]

• [ ] Can we download the social vulnerability and resilience indexes? https://hazards.fema.gov/nri/social-vulnerability

[cypressf]

Disclaimer: each risk is only relative to itself, not measured against other risks.

[cypressf]

I'm working on a proof of concept for this right now.

[cypressf]

cannot deploy until svante container state is fixed

[cypressf]

some lingering improvements I should add:

• [x] units
• [x] format number
• [x] inverted-percentile for metrics where low is bad and high is good
• [x] visualization of percentile
• [ ] data description
• [ ] data source
• [ ] show state-relative percentile

[cypressf]

since I calculate the percentile on the backend for this feature, I need to invert it on the backend too. Can I invert simply by subtracting it from 1?

[cypressf]

[cypressf]

I think null values are included in the percentile rankings, which isn't good. I need to filter those out before calculating percentiles in the database query. eg: http://localhost:3000/report-card/2/02158

[cypressf]

I tried filtering out percentile ranks for all entries with no value in the controller, after querying the database, but that won't return the expected results for all other counties because those null values will still be included in the percentile ordering. I must find a way to filter out those null values in the database query, or calculate percent rank completely at the controller level.

[cypressf]

county_data.value is always non-NULL because if a specific county has no value, that row simply will not exist. In order to filter on null values, I'll have to filter some other way. Perhaps on a result of a join?

[cypressf]

Report card is live.