Bend MPO Crash Database Architecture

KAI led the development of the Bend MPO Crash Database. The purpose of the project was to replace the DOS-based program with a Windows interface, while retaining the existing system functionality. As the team reviewed the existing database and procedures, it became evident that significant improvements could be provided despite the limited project budget.

Google Earth screen captures, illustrating the geocoded crashes throughout Deschutes County, were sorted by crash severity. This graphic was built on a database that could be altered to highlight trends by crash type, participants, or any other available field. The project deliverable provided a simple user interface with robust behind-the-scenes programming to identify, compile, and summarize crashes. The program allowed the City of Bend to customize the selection of any time period to review the safety benefits that specific projects provide, and provided a graphical and tabular output that summarized the intersection or segment crashes by type, severity, weather, roadway, and other typical conditions.

In addition, KAI created a second output format that summarized pertinent crash data in a tabular format which could be directly imported into GIS systems. The project deliverable went well beyond updating the database into a Windows operating environment by implementing analytical graphics and features that save considerable review and analysis time. The team also worked with the ODOT Crash Analysis Reporting Unit to build in not only the Deschutes County database, but the entire Statewide database, making the grant efforts available to jurisdictions Statewide.

This project provided the ability to directly display the crashes in geospatial systems, include volume table to calculate crash rates, and compile Citywide crash data for use in network screening applications. Currently about half of the year 2006–2009 Deschutes County crash data is geocoded.