Data

The data used to generate Crash Magic diagrams and reports are any data collected for individual crashes and stored in an SQL database.  A large number of jurisdictions presently enter the necessary data into a centralized database for use by engineers and enforcement officials.  CM requires only that data be stored in a compatible SQL database.  Some common SQL compatible databases are Microsoft SQL Server™; Oracle™; and Microsoft Access™.  Crash Magic supports fully normalized relational data; "flat" databases; and everything in-between.  Crash Magic does not require a specific table structure or data dictionary.  Crash data is read "in-place" in read only mode.

Pd' Programming usually performs the configuration steps necessary for your data to be read by Crash Magic.  The Configuration chapter provides a detailed description of how to prepare the required settings, queries and other information required for Crash Magic to read your data.