Explanation

Crash Magic Collision Fields:

Crash Magic has no requirements for specific data types from collision data. It is possible to configure the program using text or numeric fields. However, any text fields must be consistent in order to produce reliable results. Non-validated, free-form data entry is not conducive to producing quality diagrams and reports. For example it can be impossible to determine a vehicle direction from an officer notes field. While large format fields are supported by Crash Magic(BLOBS and CLOBS), they should not be used for the required and recommended fields. The ideal structure is numeric or short text fields drawn from a predefined set of values like a lookup table.

Fields that are absolutely required to generate a minimal diagram:

• Unique crash field name(s): A field or list of fields that can uniquely identify a crash across the entire database. This is used to be able to reference crashes within the diagram, as well as to provide feedback when “clicking on” a diagram graphic to obtain more information.
• Date (a valid date field)
• Location of crash (at least one of the following – all can be used simultaneously):
  • Primary and nearest cross street names: This is the most common means of identifying locations in urban and rural city settings. Jurisdiction information may be required for analysis on multiple locations with the same name. (For example jurisdiction information would be required for a database that contains information from the cities of Denver and Boulder, and both cities have an intersection location named Broadway and Arapahoe).
  • Intersection node: a unique identifier for a location
  • Route and Mile marker: Usually used in county or state DOT agencies
  • Street and hundred block / address: Usually used in urban settings as a supplement to “Primary and nearest cross street names”
  • XY coordinates for a collision
• Vehicle sequence: Crash Magic must be able to identify the first and second vehicles involved in a collision.
• Direction of travel: Each of the vehicles involved in the crash must have a direction of travel prior to the collision. Direction of travel is used to place the crashes on the diagram schematic. It is also used to align the arrows within the collision graphic.

Fields that are required for a complete, readable diagram:

• Type of collision field that indicates that a collision was a sideswipe or rear-end. This is used when the first two vehicles are traveling in the same direction. Without it, all such crashes are rendered as rear-end collisions.
• Vehicle movements for each of the first two vehicles involved in the collision. Values such as “left turn”, “slowing”, “backing”, “straight”, etc. are used to create the appropriate arrows for each graphic. Without this information, all vehicles will have to be represented with straight arrows.

Fields that are strongly recommended in order to properly annotate each collision graphic:

• Time of collision. Used for charts within Crash Magic. Without a valid time field charts will display all collisions as unhandled data.
• Crash severity. Used to render an injury or fatality symbol associated with a collision graphic. This field should indicate at least “property damage”; “injury”; “fatality” across the entire crash. (i.e. all vehicles combined) A less convenient means of determining this is by examining each vehicle individually.
• Indication of pedestrian, bicycle or fixed object. Used to render an appropriate annotation to the graphic. If these values are represented as vehicle types, and given direction and movement, a more accurate diagram can be created with bicycle and pedestrian collisions. Otherwise a pedestrian or bike symbol is simply located in front of the first vehicle with no indication of direction or movement.
• Lighting condition. Used to render a “nighttime” symbol associated with the collision graphic.
• Driver or DUI condition(s). Used to a render DUI annotation on the crash, or for each appropriate vehicle.

Additional useful information:

• Distance and direction from the nearest cross street. These fields are used to place crashes in the appropriate positions in the diagram.  Without it, many assumptions need to be made about vehicles in or near an intersection.
• Lookup tables. These tables will be used to convert raw data values to user readable values.
• Collision images. Scanned images of police reports, collision photos, and collision location photos can be included within Crash Magic
• Roadway section order. The creation of corridor diagrams schematics requires information to place roadway sections in their correct order. Street milepost studies order roadway sections by tenth of a mile sections based on the milepost number. Street address corridors order roadway sections by 100th block based on the block number.
• List of engineer-desired fields to be shown for labels, filters, etc.