Appendix A
Web Crash Data Minimums
Below describes the minimum data required to successfully submit a crash report to the State repository using the Web Crash reporting tool.
If your agency is interested in using the web crash reporting application, and have not yet been contacted by Vermont Agency of Transportation staff, please contact the Crash Help Line at 1-888-374-3011.
Vermont Data Exchange Standard – Crash Data Validation Business Rules
February 11, 2008
Background
Crash reports generated for the State of Vermont are validated using two documents; The XSD or schema definition file which enforces format such as data typing and organization and the XSL or transfer document, which enforces business rules as defined by the Agency of Transportation. This document will focus on business rule validation (XSL) that determines an acceptable crash report.
Each crash report is categorized to one of three crash types; Property, Injury, or Fatal. These types form the basis of how the business rules are organized. The business rules are grouped by crash report section (i.e. header, vehicle, commercial, etc.) and by the crash type: General, Property Damage, Injury and Commercial, and Fatal.
This document will focus on the elements (or data) of the crash report that is being validated from a business rule perspective. Each validation section is broken down by the type of crash and the section of the crash report.
All Crashes - Header: Report Identification, Location, Environment)
Note: The following is a list of rules that apply to all crashes, regardless of the crash type.
Reporting Agency (ORI) – Required.
Report Number – Required.
Crash Date – Required.
Crash Time – Required data field UNLESS the time unknown data field is checked
Time Unknown – Time unknown can ONLY be checked if there is NO crash time.
City or Town – Required.
Posted Speed – Required.
Crash Type – Required.
Reporting Officer – Required.
Reporting Officer Date – Required.
Last Modified –Required. This field is set by the application and not by the user.
Reporting Officer Email – Required. This field is normally set by the application and not by the user.
Operator Report Required – Required.
Crash Date greater than Reporting officer date – The Crash date cannot be greater than the reporting officer date.
Location Validation:
- Level - 1: Latitude and Longitude
- Lat/Long Units, Latitude, Longitude are required. EITHER Street Address, TH Number, VT Number, US Number, or I Number is ALSO required.
- Valid NAD 1927 and NAD 1983 Formats:
- Longitude/Easting - 99.99999 or 999.99999 or 99.99999W
- Latitude/Northing - 99.99999 or 99.99999N
- Valid VT State Plane Formats:
- Longitude/Easting - 999999 or 999-99-999 or 999-99-999E
- Latitude/Northing – 999999 or 999-99-999 or 999-99-999N
- Level - 2 and 3: Intersection or Along Street
- Street Address, Distance from Nearest Street, Distance from Units , and Direction from Nearest intersecting streets are all required. EITHER Intersection With, TH Number, VT Number, US Number, or I Number is ALSO required.
- Level – 4: Along Highway
- Intersection With, Distance from Nearest Street, Distance from Units, and Direction from nearest intersection are all required. EITHER TH Number, VT Number, US Number, or I Number is ALSO required.
- Level – 5: Mile Marker
- Mile Marker s (1-3), Distance from Nearest Street, Distance From Units, and Direction from Nearest Intersection are all required.
Mile Marker information incomplete – If ANY mile marker is entered, then ALL three mile markers are required.
Latitude/Longitude information incomplete – If either the latitude, longitude or Lat/Long units are entered, then ALL three values are required.
Property Only Damage Crash Type – A crash report with a “PROPERTY” crash type cannot have any injuries or fatalities.
Injury Crash Type – A crash report with an “INJURY” crash type must have at least one injury and No Fatalities.
Fatal Crash Type – a crash report with a “FATAL” crash type must have at least one fatality.
Unit Existence – A crash report must have at least one vehicle (or unit).
Fatal or (Commercial and Injury) Crashes - (Header: Report Identification, Location, Environment)
Note: A commercial crash is any crash where Commercial Vehicle is set to yes on at least one vehicle.
Direction of Collision – Required.
Traffic Signals – Required.
Weather Condition – Required.
Light Condition – Required.
Road Characteristics – Required.
Road Align – Required.
Road Design – Required.
Road Type – Required.
Surface Condition – Required.
Police Photo Video Taken – Required.
Summary – Required.
Injury Crashes - (Header: Report Identification, Location, Environment)
Summary – Required.
Fatal or Injury Crashes - (Header: Report Identification, Location, Environment)
Road Condition – Required.
All Crashes (Vehicle )
Note: Last Known driver is a person with a person type of 1 (driver), 6 (driver/owner), or 9 (Last Known driver) with a last name of “UNKNOWN”. Person type (6) driver /owner is derived when the “Same as operator” is checked.
More than 1 driver – Only one driver is allowed per vehicle.
More than 1 driver or more than 1 Last Known driver – Only one driver is allowed per vehicle.
Driver and Last known driver exist – Either a driver OR Last Known driver is allowed per vehicle.
Driver and Unoccupied – A driver cannot exist if Unoccupied is true for a given vehicle.
More than 1 owner – Only one owner or driver/owner is allowed per vehicle.
Occupied Vehicle must have a driver – Occupied vehicles (Unoccupied is false) must have a driver.
Vehicle must have an owner – Each vehicle must have and owner.
Vehicle (Unit) Number – Required (Can be derived by the application).
Vehicle (Unit) Number cannot be 0 – The vehicle number cannot be 0 for a vehicle type unit.
Vehicle Registration Number – Required UNLESS Last Known Driver is true.
Vehicle Registration Plate Type – Required UNLESS Last Known Driver is true).
Vehicle Registration State Code – Required UNLESS Last Known Driver is true.
VIN – Required UNLESS Last Known Driver is true.
Vehicle Year – Required UNLESS Last Known Driver is true.
Vehicle Make – Required UNLESS Last Known Driver is true.
Vehicle Model – Required UNLESS Last Known Driver is true.
Estimated Speed – Required UNLESS Last Known Driver is true.
Direction of Travel – Required UNLESS Last Known Driver is true.
Unoccupied – Required UNLESS Last Known Driver is true.
Citation/Violation information incomplete – If EITHER the citation or a violation is entered, then both values are required (true for all three citation/violation data fields).
Trailer information incomplete – if ANY of the trailer information data fields are entered, then all of the trailer information data fields are required.
Commercial Vehicle – Required UNLESS Last Known Driver is true.
Commercial Vehicle Information not found – Commercial information must exist when the Commercial Vehicle data field is true.
Fatal or Injury Crashes (Vehicle)
Vehicle 1 Collided with (1) – Required for Vehicle 1 only.
Alcohol Test – Required UNLESS Last Known Driver or Unoccupied)
Alcohol Test Result – Required UNLESS Last Known Driver, Unoccupied, OR Alcohol Test is 1 (none given), 2 (refused), or blank
Alcohol Test Result exists when Test is 1 or 2 or blank – The Alcohol test result must be blank if the test was either 1 (none given) , 2 (refused), or blank .
Drug Test - Required UNLESS Last Known Driver or Unoccupied.
Drug Test Result (1) – Required UNLESS Last Known Driver or Unoccupied or drug test is 1 (None Given), 2 (refused), or blank.
Drug Test Result (1) or (2) exists when test is 1 or 2 or blank - The drug test result (1)(2) must be blank if the test was either 1 (none given) , 2 (refused), or blank.
Apparent Operator Condition (1) – Required UNLESS Last Known Driver or Unoccupied.
Fatal or (Commercial and Injury) Crashes (Vehicle)
Defective Equipment (1)– Required.
Contributing Circumstances (1) – Required UNLESS Last Known Operator or Unoccupied.
Property Crashes (Vehicle)
Alcohol Test Result – Required when Alcohol Test is not 1 (none given), 2 (refused), or blank.
Alcohol Test Result – must be blank when Alcohol Test is 1 (none given), 2 (refused), or blank.
Drug Test Result (1) – Required UNLESS Last Known Driver or Unoccupied or drug test is 1 (None Given), 2 (refused), or blank.
Drug Test Result (1) or (2) exists when test is 1 or 2 or blank - The drug test result (1)(2) must be blank if the test was either 1 (none given) , 2 (refused), or blank.
Fatal, Injury, Towed Crashes (Commercial)
Note: This section validates commercial data when the crash is fatal, injury, or at least one vehicle was towed and the driver is not “Last Known Operator”.
Carrier Number US DOT – Required UNLESS Carrier Unknown is true.
Inter State Carrier – Required.
Carrier Name – Required.
Carrier Address – Required.
City – Required.
Carrier State Code – Required.
Sources – Required (At least one source must be selected).
Total Number of Axles – Required.
Gross Vehicle Weight Rating – Required.
Gross Vehicle Weight Rating Units – Required.
Vehicle Length – Required.
Vehicle Length Units – Required.
Commercial Trailer Information Incomplete – If ANY of the trailer data fields (Length, Units, License Number, State, or Trailer Id), then all trailer data fields are required.
Hazmat Placard – Required.
Hazmat Spilled – Required when Hazmat Placard is true.
Hazmat Number – Required when Hazmat Placard is true.
Hazmat Class Number – Required when Hazmat Placard is true.
Vehicle Configuration – Required.
Cargo Body Type – Required.
Sequence of Event (1) – Required.
All Crashes (Operators, Owners, Pedestrians, Bicyclist, Witnesses, Occupants)
Person Type – Required.
Last Name - Required.
First Name – Required UNLESS person is an Owner or Last Known Operator or Unoccupied.
Age – WARNING if age is either less than 16 or greater than 90 for Operator.
General Rules (Operators only)
License – Required UNLESS Last Known Operator.
License State Code - Required UNLESS Last Known Operator.
License Class - Required UNLESS Last Known Operator.
Address – Required UNLESS Last Known Operator.
City – Required UNLESS Last Known Operator.
State – Required UNLESS Last Known Operator.
Sex – Required UNLESS Last Known Operator.
DOB – Required UNLESS Last Known Operator.
Seat Belt- – Required UNLESS Last Known Operator.
CDL – Required UNLESS Last Known Operator.
Fatal/Injury Crashes (Operators only)
Age – Required UNLESS Last Known Operator.
All Crashes (Owners only)
Address – Required UNLESS Last Known Operator.
City – Required UNLESS Last Known Operator.
State – Required UNLESS Last Known Operator.
Insurance Company – Required UNLESS Last Known Operator.
Insurance Policy – Required UNLESS Last Known Operator.
Injury/Fatal Crashes (Operators, occupants)
Seat Location – Required UNLESS Last Known Operator.
Injury - Required UNLESS Last Known Operator.
Ejected - Required UNLESS Last Known Operator.
Restraint - Required UNLESS Last Known Operator.
Air Bag Deployed - Required UNLESS Last Known Operator.
Extracted - Required UNLESS Last Known Operator.
All Crashes (Operators, Occupants)
Seat Location not consistent with Plate Type – Plate type G (motorcycles) can only have a seat location of 11 or 12.
Seat Location not consistent with Plate Type – Plate type other than G (motorcycles) can not have a seat location of 11 or 12.
Seat Location not consistent with Operator – Operator seat location must be either 1 or 11 (for motorcycles)
Seat Location not consistent with occupant – Occupant seat location cannot be 1 or 11.
All Crashes (Last Known operator only)
Injury – must be blank.
Ejected – must be blank.
Restraint – must be blank.
Air Bag Deployed – must be blank.
Extracted – must be blank.
All Crashes (Pedestrians, Bicyclist)
Pedestrian or Bike indicator – Required (usually set by application).
Injury/Fatal Crashes (Pedestrians, Bicyclist)
Sex – Required.
Age – Required.
Injury – Required.
Pedestrian/Cycle Action – Required.
Pedestrian/Cycle Location – Required.
All Crashes (Property)
Owner Name – Required.
Address – Required.
Damage Description – Required.
All Crashes (Images)
Number of Diagrams – Only 1 image identified as the diagram is allowed.
Image or Image type incomplete – If EITHER the image or the image type has been entered, then both the image and image type are required.