This page gives information regarding the new DR3447 data for the technical user.
Knowledge Base
Standard configurations
As of May 2021, CDOR is now requiring all CO agencies to submit their crash data using the new dr3447 report format. Pd' Programming has identified a discrepancy in the new Road Description field codes. This article addresses that discrepancy.
The State of Arizona provides access to their crash data through a Citrix (remote desktop) portal. In order to download data, a user must log in to a Citrix remote desktop; access the ACIS website; and initiate a download of the data to your local computer.
Note: This document is provided as-is. Pd’ Programming does not have special knowledge of or direct access to the ACIS system. We have captured the screens below with the assistance of a local agency that does have access. Please follow any instructions provided by the DOT.
Colorado has adopted a new crash report form DR 3447. As agencies slowly move over to the new form, we will be updating Crash Magic with a new configuration to match.
This article is for our Arizona clients who are using the DOT's ALISS / ACIS system for their Crash Magic database.
With the redesign of the ADOT crash form some fields were preserved, and others were removed or consolidated. During this process, new lookup values were added to ADOT's database to standardize and accommodate for the changes to the form. ADOT will not be converting old data to match with the new format, some fields and or values could be blank. ADOT's internal database lookup values DO NOT MATCH with the current crash form.
Reference for editing
In Texas, crash data is available to agencies through the CRIS data system. By following the steps included here, you can download and unzip data files suitable for import into Crash Magic. You also have the option to FTP the data to our servers rather than using the browser interface. That process is described at the bottom of this article.
Arizona DOT provides data to jurisdictions to use with Crash Magic. If you would like to request this data, you will need request access and fill out a contract with the DOT, that information is provided below.
Georgia DOT has a crash database managed by Lexis Nexus that can be accessed by any jurisdiction in Georgia. You will need to request access, and fill out a user agreement in order to receive a login and password.
Crash data can be imported from many sources. This article describes the case where the data is provided as an ASCII file or other files that can be read by MS ADO such as MS Access or DBF.
How to obtain data from Washington State Dept of Transportation for Crash Magic
In California, crash data is available to agencies through the SWITRS data website. By following the steps included here, you can download files that are suitable for importing into Crash Magic.
Crash data can be imported from many sources. This article describes the case where the data is provided as an XML file. If your data is being provided in XML format, you also have the option to FTP the data to our servers rather than using the browser interface.
In Arizona, crash data is available to participating agencies through the ALISS Safety Data Mart. By following the steps included here, you can create data files suitable for import into Crash Magic.
Each year, Pd' Programming attends the AZ Spring ITE-IMSA conference. Sometimes we also hold user group meetings or trainings. Let us know what you might be interested in. Please respond by this Friday, Jan 13. Thanks!
Standard format provided by CO DOT for use in Crash Magic. Also called "Data Dictionary Comprehensive".
Clients using data from ADOT cannot create accurate corridor studies.
This article is a reference for users that import SWITRS data into Intersection Magic
The State of Arizona has created a new form for reporting crashes. This article describes changes that have occurred that will affect your crash data in Intersection Magic.
The State of Colorado has created a new form for reporting crashes. The new form is in effect as of 7/1/2006. This article describes changes that have occured that will probably affect your use of crash data in Intersection Magic.
The California Highway Patrol (CHP) maintains the crash records that you use as SWITRS data. In January of 1998 they modified the format which had been used for many years. The format was changed to add the century to any dates in the data file. This makes the data y2k compatible. This requires special treatment of SWITRS data by Intersection Magic.