WVDOH Web-Accessible Crash Database Deployment

Electronic crash reports that are completed by state, county, and local police officers in West Virginia are transmitted electronically to a central system provided by VS Visual Statement Incorporated. The crash reports can be accessed using their ReportBeam collision reporting system. Due to the limitations of the ReportBeam system for analyzing the crash data for safety applications, the West Virginia Division of Highways downloads the crash records from ReportBeam and utilizes Microsoft Access to generate various reports and conduct analysis. As the amount of crash records in the database continue to increase, the ability of Microsoft Access to manage this data decreases. In order to maximize the value and accessibility of the available crash data, the West Virginia Department of Highways (WVDOH) has initiated this project to deploy an online relational Structured Query Language (SQL) database.

Language

• English

Project

• Status: Active
• Funding: $328847.00
• Contract Numbers:

  212112

• Sponsor Organizations:

  West Virginia Department of Highways

  1900 Kanawha Building East
  Charleston, WV  United States  25365
• Performing Organizations:

  Rahall Appalachian Transportation Institute

  Marshall University
  Huntington, WV  United States  25755
• Principal Investigators:

  Nichols, Andrew

• Start Date: 20110901
• Expected Completion Date: 0
• Actual Completion Date: 20140630
• Source Data: RiP Project 29376

Subject/Index Terms

• TRT Terms: Crash analysis; Crash reports; Databases; Highway safety
• Identifier Terms: Structured Query Language (SQL)
• Geographic Terms: West Virginia
• Subject Areas: Data and Information Technology; Highways; Operations and Traffic Management; Safety and Human Factors;

Filing Info

• Accession Number: 01515933
• Record Type: Research project
• Source Agency: Rahall Appalachian Transportation Institute
• Contract Numbers: 212112
• Files: UTC, RIP
• Created Date: Feb 26 2014 1:00AM