Crash Data Analysis and Engineering Solutions for Local Agencies

This report introduces the development process of an Internet-based, GIS-compatible software tool for Illinois local road crash analysis. This state-of-the-art tool is capable of performing crash information query, trend analysis, statistical analysis, color-coded mapping, and other safety information display within the web-based GIS compatible environment. The Internet-accessible user interface allows users to inquire about detailed information on vehicle crashes associated with road segments and intersections for any geographical regions or jurisdictions in the state of Illinois via query forms or zoom-enabled interactive maps. In addition, users can specify a data aggregation type, time range, and information type to display crash information in formats of tables, charts, or maps. This system helps the state and local transportation agencies in Illinois to screen dangerous highway segments, diagnose safety performance of the selected roads, and identify the most costeffective countermeasures for safety improvements. This report addresses three major technical issues of the system design: (1) system architecture design and software development technologies, (2) supportive databases and data structure, and (3) user interfaces and system functionality. The report introduces system architecture and background components with used technologies for the full-scale implementation. In addition, descriptions on required datasets, their structures, and data-related issues are presented to explain the characteristics of databases. The system functionality section introduces functional definitions and explains the development purposes of all modules in the system. The report also explains how to utilize each module and provide required inputs for online crash data query and the decision support process based on web-based GIS applications.ICT R27-18published or submitted for publicationnot peer reviewe