The peculiarities of the integration of spatial data of roads using the JOIN operation

The purpose of the article is to research the integration of attributes of the set of geospatial data “Roads”, which was created on the basis of the topographic database of the Main State Topographic Map, and the geoinformation system of roads of the State Agency of Roads of Ukraine (hereinafter – Ukravtodor) for the creation and maintenance of core reference data of roads of the national spatial data infrastructure (hereinafter – NSDI) using an operation Theta-JOIN in object-relational database management systems (hereinafter referred to as DBMS). Method. The basis of the research is the analysis of the possibilities of applying the theory of spatial databases and knowledge bases, international and national harmonized standards in the field of Geographic Information/Geomatics to solve the issue of integration of spatial data using the Theta-JOIN operation in object-relational database management systems. The results. The article analyzes the geo-information model of the road, based on the data of which it is possible to make management decisions during planning, design, operation, management, organization of road safety, etc. The requirements for the presentation of this model are defined in the GDF 5.1 standard, which is used for modeling road infrastructure in a geographic information environment using the Unified Modeling Language (UML) and Model Management Architecture (MDA) technologies. This allows for data interoperability at different levels, for example, national and pan-European. The geoinformation model of a public road of state importance in the topographic database is a continuous feature that is an aggregation of the features of the road and transport network through which this model passes. Also, on the basis of regulatory and technical support, the geographic identifier of the highway was established – the road index, the structure and principles of which are defined in the draft of the national standard DSTU xxx:20xx “Geoinformation system of public highways. Part 1. Composition, content and requirements for the database”. Two sets of spatial data TDB of the Main state topographic map and GIS roads of Ukravtodor were combined using the theta-JOIN operation in the PostgreSQL/PostGIS. The scientific novelty and practical significance is in the fact that the integration of sets of core reference and thematic spatial data of roads was investigated using the theta-join operation of relational algebra, which is implemented in modern GIS and DBMS for the development of the national spatial data infrastructure. This will make it possible to expand the attributes of road features contained in TDB, due to the official data of Ukravtodor, joining these sets with a geographic identifier, road index.