CREATION OF A CONCEPTUAL MODEL OF A GEOSPATIAL DATA BASE FOR COMPLEX AUTOMATION OF INFORMATION SUPPORT OF THE ACTIVITIES OF THE PATROL POLICE OF UKRAINE

Abstract

The process of creation of the relational model of the geospatial data base of the web-portal "Information-analytical center of accident monitoring" is considered in accordance with the current requirements, which today are being advanced to modern software products.

The database of the "Information and Analytical Center for the Monitoring of Accidents" Web Portal was created for informational servicing of patrols and road accident victims. Eight entities of the created model of the database of the investigated branch are defined, their primary keys, attributes and key fields are characterized.

The conceptual model of the base of geospatial data of the web-portal "Information-analytical center of accident monitoring" is presented, which is based on three types of connections between such entities as: Accident Protocol, patrol policeman, participant in an accident, driver's license, vehicles, insurance company, data on traffic accidents, aerial photos, DTP-files and their attributes (for example, the name of the insurance company, the policy number, the name of the patrol policeman, the driver's name, road accident, telephone, country, etc.).

The created geospatial database of the web-portal includes data on traffic accidents (patrols, traffic accident participants, carriers, insurance companies, general road accident information, aerial material), and provides the opportunity to receive various reports on the location of an accident on the basis of stored files.

Author (co-authors)
First name Last name Institutional affiliation E-mail Phone number ORCID ID Institution address Author contribution(s) Institutional affiliation
Olha Yevhenivna
Kulikovska
Lviv National University of Nature Management
kulikovskaja13@ukr.net
0000-0002-2168-1445
St. V. Velikoho, 1, Dublyany, Lviv district, Lviv region, 80381
Investigation
Software
Visualization
Writing – Review & Editing
Yuliia Yuriiivna
Atamanenko
Donetsk State University of Internal Affairs
julia.atamanenko@ukr.net
0000-0001-7423-9880
St. Stepan Tilha, building 21, Kryvyi Rih, Dnipropetrovsk Region, 50065
Investigation
Software
Visualization
Writing – Review & Editing