add manual airtable ordinances

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

add manual airtable ordinances #299

Closed TrentonBush closed 6 months ago

TrentonBush commented 7 months ago

Add a new warehouse table with manually updated ordinance data pulled from BigQuery (originally in an Airtable).

add one new column (ordinance_via_self_maintained) to the county and ISO project data mart tables
redefine the ordinance_is_restrictive column to prioritize this data source
update the docs accordingly

I added one validation test to check that the incoming data exactly matches the county FIPS codes from the Census (in table data_warehouse.county_fips).

TrentonBush commented 6 months ago

We don't need to change anything in the c4 repo, correct?

Barely, just update a couple of SELECT queries. I made a PR there the other day