Open data on road traffic accidents accumulation, processing and analysis
https://doi.org/10.26518/2071-7296-2023-20-5-574-585
EDN: SGIFUS
Abstract
Introduction. An urgent task for any municipality is the development of an Integrated Traffic Management Scheme, which is based on an analysis of the current situation. At the same time, the most important element is the analysis of road traffic accidents (RTA). The purpose of this study is to develop a methodology for accumulating, processing and analyzing the data on road accidents from the main official source - the State Inspectorate for Road Safety (GIBDD).
Description of the problem. The data can be uploaded from the traffic police portal in two formats, but none of them allows for automated analysis of road accidents and presentation of its results using geographic information systems (GIS).
Proposed methodology. The paper proposes a methodology for analyzing traffic accidents, including the following steps: uploading data from the site, converting data into convenient formats, entering data into a geographic information system, analyzing data using geographic information systems.
Methodology approbation. Using the proposed methodology, an analysis of traffic accidents in the Cheboksary agglomeration was made and its visualization was made using GIS.
Conclusions. The use of information about road accidents in the formats offered on the traffic police website is impossible either for analysis or for visualization in a GIS. The proposed method for accumulating, processing and analyzing accidents based on data from an official source using GIS makes it possible to automate the process and improve the quality of accident analysis.
About the Authors
N. K. Goryaev
South Ural State University (SUSU)
Russian Federation
Russian Federation
Cand. of Sci., Associate Professor of the Road Transport Department
Chelyabinsk
S. P. Lyubetskii
South Ural State University (SUSU)
Russian Federation
Russian Federation
Postgraduate student of the Mathematical and Computer Modelling Department
Chelyabinsk
References
1. Kurakina E.V., Sklyarova V.A. Road safety improvement in road traffic participant – vehicle – road – external environment system. The Russian Automobile and Highway Industry Journal. 2020;17(4):488–499. (In Russ.) https://doi.org/10.26518/2071-7296-202017-4-488-499
2. Kolyshkina D.V. Analiz avarijnosti po regionam v zavisimosti ot vremeni sutok [Analysis of accidents by region depending on the time of day]. Tekhnicheskoe regulirovanie v transportnom stroitelstve. 2020; 3(42): 225–228. (In Russ.)
3. Nazarov D. M., Nazarov A. D. Power Query: formirovanie professional’nyh kompetencij biznes-analitika [Power Query: formation of professional competencies of a business analyst]. Informatika i obrazovanie, 2020; 2(311): 30–40. (In Russ.)
4. Zhmakin I. A. Osnovnye harakteristiki DTP s postradavshimi v Tverskoj oblasti za 2015-2019 gody [The main characteristics of road accidents with victims in the Tver region for 2015-2019]. Tverskoj medicinskij zhurnal. 2020; 4: 44–54. (In Russ.)
5. Mironov V. L. Social’nyj risk kak odin iz pokazatelej bezopasnosti dorozhnogo dvizhenija [Social risk as one of the indicators of road safety]. Upravlenie deyatelnostyu po obespecheniyu bezopasnosti dorozhnogo dvizheniya: sostoyanie, problemy, puti sovershenstvovaniya. 2019; 1(2): 311–315. (In Russ.)
6. Kuzmenko E. A., Donchenko D. S., Ragozin V. O. Analiz dannyh dlja prognozirovanija verojatnosti dorozhno-transportnyh proisshestvij s uchastiem peshehodov [Data analysis for predicting the probability of traffic accidents involving pedestrians]. Inzhenernyj vestnik Dona. 2020; 6(66): 10. (In Russ.)
7. Nguyen T. T. Х [A comparative analysis of elimination of violations and road safety in Europe and Russia]. Colloquium-Journal. 2019; 18-7(42): 5–7. (In Russ.)
8. Jung A.A., Shevtsova A.G. The result of an evaluation for traffic flow characteristics considering the movement of personal mobility equipment by modeling a road traffic section. The Russian Automobile and Highway Industry Journal. 2022;19(5):716-726. (In Russ.) https://doi.org/10.26518/2071-7296-202219-5-716-726
9. Kurakina E. V. Ob jeffektivnosti provedenija issledovanij mest koncentracii DTP [On the effectiveness of studies carried out at places of road traffic accident concentration]. Bulletin of Civil Engineers. 2018; 2(67): 231–237. DOI 10.23968/1999-5571-2018-15-2231-237. (In Russ.)
10. Mikhaylidi I. M., Kishko D. I. Vyjavlenie mest koncentracii DTP v industrial’nom rajone goroda Barnaula s primeneniem geoinformacionnyh tehnologij [Identification of places of concentration of accidents in the industrial district of the city of Barnaul with the use of geoinformation technologies]. Polzunovskij almanah. 2019; 2-2: 33–36. (In Russ.)
11. Mikheeva T. I. Sistemnyj analiz ob’ektov transportnoj infrastruktury v geoinformacionnoj srede [System analysis of transport infrastructure objects in the geoinformation environment]. Programmnye produkty i sistemy. 2018; 1:12–18. (In Russ.)
12. Pugachev I. N. Analiz geometricheskih jelementov dorog s pomoshh’ju sovremennyh geoinformacionnyh sistem pri ocenke ih avarijnosti [Analysis of geometric elements of roads when assessing their accident rate by means of modern geoformation systems]. Bulletin of Civil Engineers. 2021; 3(86): 127– 133. DOI 10.23968/1999-5571-2021-18-3-127-133. (In Russ.)
Review
For citations:
Goryaev N.K., Lyubetskii S.P. Open data on road traffic accidents accumulation, processing and analysis. The Russian Automobile and Highway Industry Journal. 2023;20(5):574-585. (In Russ.) https://doi.org/10.26518/2071-7296-2023-20-5-574-585. EDN: SGIFUS
Views:
464
Email this article 