search

cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services
17 stars 2 forks source link

Research ways to identify manual lat/lon edits to historical records #19388

Open johnclary opened 1 week ago

johnclary commented 1 week ago

When we populated the crashes_edits table via https://github.com/cityofaustin/atd-data-tech/issues/17207, we had not reliable way to determine if the edit was the result of a manual user edit, or if CRIS had updated values that never propagated to the old DB.

This resulted in many thousands of crashes having latitude and/or longitude "edits" that may or may not be the result of manual QA by the VZ team.

Xavier has asked for our help trying to correctly attribute these changes to CRIS vs VZ staff, so that they can have more confidence in various analyses they undertake.

johnclary commented 1 day ago

i asked @frankhereford to spin up an RDS snapshot for this task. once that's done i will work on a few queries to see if we can come up with any quick answers.