Obtain data and metadata

Top  Previous  Next

Obtain and verify the following:

1.A crash report form for the state

2.List of fields and data types        

3.Lookup fields        

a.Make sure lookup values are listed for every lookup field

4.Determine how the tables are linked        

5.Get validation rules from the client

6.Determine number of roadway systems (local vs highway)

7.Determine which study definitions are needed

8.Bring the file into Excel or other SQL viewer

a.Create or use a schema.ini if necessary

9.Browse field values

a.Make sure types are coming across correctly        

10.Compare lookup tables with fields        

11.Check that vehicle type includes Pedestrian and Pedcycle

12.Determine ClickOn GIS

13.At Pd' Programming: If importing from IMW database, Check for * in the street names if applicable. This would indicate potentially corrupt data from IMW v6.60 bug


Check data against Required and Recommended fields