Automation of Determination of areas and places of concentration of traffic accidents at the Ivano-Frankivsk urban territorial community using geocoding

Abstract

The article examines the approach of determining areas and places of traffic accidents  concentration at the territory of the Ivano-Frankivsk urban territorial community. According to the report provided by the Department of the Patrol Police of Ukraine in the Ivano-Frankivsk region, 324 traffic accidents with victims that took place on the territory of the Ivano-Frankivsk urban territorial community from 2020 to 2022 were analyzed. The raw data were transformed into a form convenient for further processing using macros written in the VBA (Visual Basic for Application) language. After determining the coordinates of each traffic accident using the Geocoding API service from Google, the accidents were visualized by plotting them on a map using the Google Maps Javascript API service. In order to identify the places of concentration of traffic accidents, clustering of traffic accidents on the map was carried out. 16 areas and 6 places of concentration of road accidents in the territory of the city of Ivano-Frankivsk were identified, for each of them an analysis of the number of road accidents in the last calendar year and in the last three years and the predominant type of road accident (head-on or side collision, collision with a pedestrian, cyclist, etc.) was carried out. .At a meeting of the traffic safety commission of the Ivano-Frankivsk urban territorial community, the submitted report was reviewed and it was recommended to develop measures to improve the conditions and organization of road traffic to ensure its safety and measures to eliminate the causes of road accidents, in particular, the installation of road signs 1.39 or 1.41 with plates 7.12, 7.13, 7.21.1-7.21.5. depending on the type of accident type.