Design of Geospatial Database for Analysis of Road Traffic Accidents in Aichi Prefecture

Design of Geospatial Database for Analysis of Road Traffic Accidents in Aichi Prefecture

연구 분야: Databases

학회: 2022 Joint 12th International Conference on Soft Computing and Intelligent Systems and 23rd International Symposium on Advanced Intelligent Systems (SCIS&ISIS)

In Japan, police and researchers work together to reduce the incidence of road traffic accidents by analyzing space and time information such as the occurrence of traffic accidents and traffic volumes. Traffic safety studies have analyzed data on traffic accidents adopting various approaches to reduce the number of traffic accidents. However, there is no common database that can be used in such studies, because each study has a different focus of analysis and different granularity of the geographic area. Here we show a database for traffic accident analysis that we designed based on the requirements of previous traffic safety studies. Traffic accidents are spatiotemporal events. Therefore, the database requires the manipulation of spatiotemporal data. In this paper, we represent accident situations by geospatial objects to enable manipulation of the spatiotemporal data. The designed database maintains information as a geospatial object. All non-spatial data depend on spatial data according to the design of the relation. The database combines tables representing traffic accident information using spatial predicates defined in Simple Feature Access. Thus, the database provides capabilities for the manipulation of any items necessary to analyze accident situations spatiotemporally. The study developed a database and scripts that register the data and analyze the data to evaluate the designed database. The results show that the designed database has good operational performance in terms of scalability and efficiency. The designed database is thus useful for the analysis of traffic accident data.