Design and Development of an Analytical Framework for the Analysis and Management of Accident and Traffic Data on Motorways No. 7 and No. 9

Abstract

This research is the design and development of an analytical framework to enhance data management efficiency and systematically support the analysis of traffic and accident data. This research received accident and traffic data from the database of the Inter-City Motorway Division of the Department of Highways, explicitly focusing on Motorway No. 7 and No. 9. The relevant data include traffic volume data, accident data from Highway Accident Information Management System (HAIMS) database, accident data from Incident Management System (IMS) database, physical characteristics of road, vehicle speed from speed camera detected and Bluetooth signal receivers, and construction area data (Work Zone). The study focuses on the process of managing accident and traffic data from various sources, such as the diversity of data formats stored in various databases, which are not fully integrated. Moreover, the absence of tools that support effective data visualization, and long time-consuming data processing are supporting reasons for this study. The study results showed that the analytical framework developed by the researcher consists of four main steps. Step 1: Data Source Identification, Step 2: Data Management, Step 3: Data Analysis, and Step 4: Data Visualization. The Performance evaluation comparing operations before and after the framework’s implementation demonstrated that applying the analytical framework reduced processing time and increased operational efficiency by 55 %.