bdit_data-sources
bdit_data-sources copied to clipboard
VZ MAP: create an airflow process to update CSZ
There are 3 tables involved in updating the Community Safety Zone layer.
- the master spreadsheet that comes by email has to be imported manually into the
toadd
table - once imported, rows in
toadd
that are new must be appended to the existingtracking
table - the geoms for these new rows have to be created and appended to the
geom
table
Write an airflow process that executes steps 2 & 3 and sends an alert message if there are tracking_id
s that are missing geoms.
(Missing geoms have to be handled manually -- they are often due to e.g. typos, non-existent locations, streets that change name, and/or location descriptions that are not understood by text_to_centreline()
.)