bdit_data-sources icon indicating copy to clipboard operation
bdit_data-sources copied to clipboard

VZ MAP: create an airflow process to update CSZ

Open KatiRG opened this issue 3 years ago • 0 comments

There are 3 tables involved in updating the Community Safety Zone layer.

  1. the master spreadsheet that comes by email has to be imported manually into the toadd table
  2. once imported, rows in toadd that are new must be appended to the existing tracking table
  3. 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_ids 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().)

KatiRG avatar Jun 18 '21 19:06 KatiRG