As a J40 developer, I want to be able to generate an aggregate of the score for zoom levels 0 - X, so that the map renders faster

[esfoobar-usds]

Description We want to add a post-score ETL that takes the output of the score and using geopandas does aggregation of the CBG-level score into a tract-level score.

Solution We can use an approach similar to this to generate a new score CSV.

Describe alternatives you've considered

Links to user research or other resources

Tasks

• [x] Add a national geojson file as output of the census-data-download output
• [ ] Create an ETL Python file that applies the Geopandas dissolve is applied and output usa-low
• [x] Merge the national score with state geojson and output usa-high

Definition of "Done"

• [ ] ETL Python file for Geo Scores

[esfoobar-usds]

Here's the latest Jupyter Notebook from @NatHillardUSDS

[switzersc-usds]

Code complete; one outstanding issue with missing block groups.