Table of Contents

Arizona database updates

Issue

This article is for our Arizona clients who are using the DOT’s ALISS / ACIS system for their Crash Magic database.

Explanation

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.

Solution

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.
If you have any questions about the ADOT database, please contact John Riemer at JRiemer@azdot.gov.
If you have any questions regarding Crash Magic, please contact us at help@pdmagic.com.
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?