CIS CDE CSV requirements for Collision Diagrams
-----------------------------------------------

CIS: Collision Information System
CDE: Collision Data Extract, created by CIS from a collision subset
CSV: comma-separated-values text file.

In order to create a collision diagram, a CDE file is required 
containing at least the following fields:

Field Selection Name                CDE Short Heading
--------------------                -----------------
Collision case number                 ACCASE
Collision Date                        CLSNDATE
Segment Number                        SEGNUM
Km Mark                               KMMARK
Node                                  NODE
Total number of people injured        TOTALINJ
Total number of people killed         TOTALKLD
Total number of vehicles involved     TOTALVEH
Vehicle 1 - Direction of travel       VEHDIR1
Vehicle 2 - Direction of travel       VEHDIR2
Vehicle 1 - Pre-collision action      PREACTN1
Vehicle 2 - Pre-collision action      PREACTN2
Primary Occurence                     DIAGRAM
Vehicle 1 - 2nd event                 TYPE2ND1
Location of first contact             LOCN1ST      (Y = On Roadway)

Notes:
  - The fields may be in any order.
  - The first row must contain the shown SHORT field headings
    (CIS generates these if "Short" headings are selected on the CIS CDE screen.)
  - Other fields may be included, and will be ignored.
  - Missing or conflicting information will cause the Collision Diagram
    procedure to list a collision as "unplottable".
  
It is suggested that you create a Collision Extract Profile on the CIS
Collision Data Extract screen, and save it, named CollisionDiagram:
  - select the fields in the Fields Available pane, and move them to
    the Fields Chosen pane with the [>] button.
  - enter "CollisionDiagram" (without the quotes) in the 
    Collision Extract Profile Name field
  - click the Save button.
  
Subsequently, to recall this set of fields:
  - select CollisionDiagram in the drop-down list to the left of the 
    Load button,
  - click the Load button.

Note that if you save a CDE file from Excel it may change the date format.
The format in the CDE file is what will appear on the diagram.
(CIS uses yyyy-mm-dd.)