search

hackoregon / emergency-response

Simulations, Models, and Visualizations of Portland Fire and Rescue data
11 stars 10 forks source link

Remove References to Incident(s) Not Entered In incident Table #46

Closed russellgould closed 7 years ago

russellgould commented 7 years ago

Some records in tables other than the incident table have references to incidents initiated in 2009, and so the easiest route will just be to delete these referencing records.

russellgould commented 7 years ago

Removed the initially apparent records referencing missing incident_id's, but a few more have popped up. I'll leave this issue open while I investigate what other tables might be referencing incident_id's not in the incident table.

russellgould commented 7 years ago

Fixed erroneous rows from inctimes table with realtime fields prior to 2010. Specifically some rows were written with a date of 2001 when (we assume) they were meant to be in 2011.

If we find more "dirty" data we can reopen, but will close this issue for now.