Arizona database updates
This article is for our Arizona clients who are using the DOT’s ALISS / ACIS system for their Crash Magic database.
As Arizona continues to update and improve their system, they also continue to change the output format that you use for Crash Magic. Often we are informed of these changes in advance, but sometimes we find out when our clients contact us with a problem. Pd’ Programming will continue to update the ALISS/ACIS configuration as fast as possible. But please let us know if you see any changes as you encounter them.
The following is a list of changes over time that we have encountered and how we addressed them.
- 6/2020 – “First harmful” lookup is no longer active, has been replaced with “First harmful event” lookup. Crash Magic lookup tables revised. We’re not sure when this change occurred, but Crash Magic has been updated.
- 12/2019 – Major changes – Many lookup and database value changes for ACIS. Crash Magic lookup tables revised. If you would like more information on these changes see our knowledge base article at http://www.pdmagic.com/kb/ShowKBArticle.Cfm?ID=326.
- 11/2019 – “RegYear” field changed data type. Crash Magic database updated. We’re not sure when this change occurred, but Crash Magic has been updated.
- 8/2019 – Deleted and re-imported databases for Tempe and Mesa to fix street name issues.
- 8/2019 – ACIS finalizes streets / geocoding fixes. No changes to Crash Magic importer, but should no longer see additions to street names.
- 2/2019 – ACIS adds column headers to data structure. Crash Magic converter changes.
- 10/2018 – ACIS adds alpha characters to the end of street names. Crash Magic importer changes to remove / convert all extra characters to match with existing street names.
- 8/2018 – ACIS adds extra spaces to street names. Crash Magic importer changes to remove / convert all extra characters to match with existing street names.
- 6/2018 – ACIS adds extra characters to street names for county and state roads during geocoding process. Crash Magic importer changes to remove / convert all extra characters to match with existing street names.
- 12/2015 – ALISS moves “hit and run flag” to crash level and “road surface” field to vehicle level. Intersection Magic database and importer change.
- 4/2015 – ALISS adds “offset direction” (instead of “suppdirfromint”), “secondary crash flag”, and “distracted driving” fields. Crash Magic database, importer, and lookups changed.
- 3/2015 – ALISS database change for ped and bike crash values. Intersection Magic database, importer changed.