WIMPROVEMENT OF THE AUTOMATED PROCESS OF DETERMINING AREAS AND PLACES OF CONCENTRATION OF ROAD AND TRANSPORT ACCIDENTS IN THE URBAN TERRITORIAL COMMUNITY OF IVANO-FRANKIV

Abstract

The article examines the process of improving the automated process of determining areas and places of concentration of traffic accidents located on the territory of the Ivano-Frankivsk Urban Territorial Community (MTG). According to the report provided by the Department of the Patrol Police of Ukraine in the Ivano-Frankivsk region, 1,626 traffic accidents with victims that took place on the territory of the Ivano-Frankivsk urban territorial community from 2017 to 2023 were analyzed. The raw data were transformed into a form convenient for further processing using the C# programming language and entered a relational database. The coordinates of each traffic accident were determined using the Geocoding API service from Google. For the possibility of manual correction of the coordinates, the possibility of clarifying the place of the accident by moving the marker on the map was implemented. Implemented a REST API using ASP .NET and Entity Framework Core for the ability of using data by any web and mobile applications. In order to identify the places of concentration of traffic accidents, clustering of traffic accidents on the map was carried out. A web application was developed, and accidents were visualized by mapping them using the Google Maps Javascript API service. The possibility of filtering road accidents by the year of occurrence, condition of the surface, lighting, weather conditions, the presence of road elements, the involvement of pedestrians or cyclists, the presence of dead or seriously injured people, etc. has been implemented. A statistical analysis of the number of road accidents with fatalities and injuries for each year separately on the territory of the city and OTG was carried out, an analysis of dead/severely injured/slightly injured vulnerable road users (pedestrians and cyclists) was carried out. 18 places of concentration of road accidents in the territory of the city of Ivano-Frankivsk for the years 2021-2023 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 (frontal or side collision, hitting a pedestrian, cyclist, etc). At the meeting of the traffic safety commission of the Ivano-Frankivsk urban territorial community, the provided 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.