deployment-gap-model-education-fund / deployment-gap-model

ETL code for the Deployment Gap Model Education Fund
https://www.deploymentgap.fund/
MIT License
6 stars 2 forks source link

join all counties into county_wide and refactor county properties #228

Closed TrentonBush closed 2 years ago

TrentonBush commented 2 years ago

Previously, the data_mart.counties_wide_format table only had entries for counties that contained a power plant or proposed fossil infrastructure project. This PR joins in all counties and fills their values with NULL.

The process of creating the county-level properties was exactly duplicated with create_long_format(), so I factored this out into a new function _get_county_properties().