Integration of geospatia l data based on the application of the JOIN operation of relative algebra

Simple item page
dc.citation.epage128
dc.citation.journalTitleГеодезія, картографія і аерофотознімання
dc.citation.spage113
dc.citation.volume95
dc.contributor.affiliationКиївський національний університет будівництва і архітектури
dc.contributor.affiliationKyiv National University of Construction and Architecture
dc.contributor.authorЛазоренко, Надія
dc.contributor.authorLazorenko, Nadiia
dc.coverage.placenameЛьвів
dc.coverage.placenameLviv
dc.date.accessioned2023-06-07T08:41:40Z
dc.date.available2023-06-07T08:41:40Z
dc.date.created2022-02-22
dc.date.issued2022-02-22
dc.description.abstractМета цієї роботи – дослідження інтеграції наборів базових і тематичних геопросторових даних на основі операції з’єднання (JOIN) реляційної алгебри та її взаємодії з геокодуванням геопросторових об’єктів, яку реалізовано в сучасних геоінформаційних системах (далі – ГІС) та системах керування базами даних (далі – СКБД) для розвитку національної інфраструктури геопросторових даних (далі – НІГД). Методика. Основою дослідження є аналіз можливостей застосування теорії баз геопросторових даних і баз знань, міжнародних і національних гармонізованих стандартів у сфері Географічна інформація/Геоматика для вирішення питання інтеграції геопросторових даних за допомогою операції з’єднання JOIN реляційної алгебри в об’єктно-реляційних системах керування базами даних (ОР СКБД). Результати. В статті досліджено моделі операції з’єднання Join реляційної алгебри, які лежать в основі геокодування об’єктів і створення електронних газетирів, і доведено її ефективність: операція з’єднання Join забезпечує інтеграцію наборів базових і тематичних геопросторових даних. Для її виконання необхідно визначити обов’язкові географічні ідентифікатори, які мають бути наявні серед атрибутів наборів базових та тематичних геопросторових даних та за якими виконується з’єднання. Різноманітність видів застосування операції з’єднання Join охоплює всі можливі випадки, які виникають при їх практичному застосуванні. Таким чином, використання операції з’єднання Join передбачає на етапі проектування баз геопросторових даних визначити ці обов’язкові географічні ідентифікатори. Зокрема, доцільним є визначення обов’язкових географічних ідентифікаторів (кодів) об’єктів за офіційними загальнодержавними системами класифікації (кодифікації) об’єктів у відповідних галузевих тематичних реєстрах, за які відповідають визначені держателі тематичних даних відповідно до додатку 2 Постанови Кабінету Міністрів України “Про затвердження Порядку функціонування національної інфраструктури геопросторових даних” від 26 травня 2021 р. № 532. Досліджено інтеграцію наборів базових і тематичних геопросторових даних на основі моделей операції з’єднання (JOIN) реляційної алгебри та їх взаємодії з геокодуванням геопросторових об’єктів, яку реалізовано в сучасних ГІС та СКБД для розвитку національної інфраструктури геопросторових даних. Дослідження виконано на наборі базових геопросторових даних, а саме: відомостей про адміністративно-територіальні одиниці Черкаської області, в тому числі їх меж; за тематичні обрано дані зі статистичного бюлетеня соціально-економічного становища Черкаської області за січень 2021 року Головного управління статистики у Черкаській області Державної служби статистики України. Доведено, що операцію з’єднання (JOIN) реляційної алгебри можна використовувати для інтеграції інших тематичних геопросторових даних з базовими геопросторовими даними за допомогою географічних ідентифікаторів, які містять ці набори даних.
dc.description.abstractThe purpose of this work is to study the integration of sets of core reference and thematic geospatial data based on the JOIN operation of relational algebra and its interaction with geocoding of geospatial features, which is implemented in modern geographic information systems (GIS) and database management systems (hereinafter – DBMS) for the development of the national spatial data infrastructure (hereinafter – NSDI). Method. The research is based on the analysis of the possibilities of applying the theory of geospatial databases and knowledge bases, international and national harmonized standards in the field of Geographic Information/ Geomatics to solve the problem of integration of geospatial data using the operation JOIN relational algebra in object-relational database management systems (OR DBMS). Results. The paper examines the models of the Join operation of relational algebra, which underlie the geocoding of features and the creation of electronic gazetteers, and proves its effectiveness: the Join operation integrates of core reference and thematic geospatial datasets. There is a need to define the required geographic identifiers, which must be present among the attributes of the core reference and thematic geospatial datasets to perform the join. The variety of uses of the Join operation covers all possible cases that arise in their practical application. Thus, the use of the Join operation involves identifying these required geographic identifiers at the geospatial database design stage. In particular, it is expedient to determine mandatory geographical identifiers (codes) of features according to the official national systems of features classification (codification) in the relevant sectoral thematic registers, which are responsible for certain holders of thematic data in accordance with Annex 2 of the Decree of Cabinet of Ministers “The order for the functioning of the national spatial data infrastructure” of May 26, 2021, No. 532. Scientific novelty and practical significance. The integration of core reference data and thematic geospatial datasets based on JOIN operation models of relational algebra and their interaction with geocoding of geospatial features is researched, which is implemented in modern GIS and DBMS for the development of national spatial data infrastructure. The research was performed on a set of core reference spatial data, namely: information on administrative-territorial units of the Cherkasy region, including their borders; the data from the statistical bulletin of the socio-economic situation of the Cherkasy region for January 2021 of the Main Department of Statistics in Cherkasy region of the State Statistics Service of Ukraine were selected as thematic data. It has been shown that relational algebra join (JOIN) operations can be used to integrate other thematic geospatial data with core reference data using geographic identifiers that contain these datasets.
dc.format.extent113-128
dc.format.pages16
dc.identifier.citationLazorenko N. Integration of geospatia l data based on the application of the JOIN operation of relative algebra / Nadiia Lazorenko // Geodesy, Cartography and Aerial photography. — Lviv : Lviv Politechnic Publishing House, 2022. — Vol 95. — P. 113–128.
dc.identifier.citationenLazorenko N. Integration of geospatia l data based on the application of the JOIN operation of relative algebra / Nadiia Lazorenko // Geodesy, Cartography and Aerial photography. — Lviv : Lviv Politechnic Publishing House, 2022. — Vol 95. — P. 113–128.
dc.identifier.doidoi.org/10.23939/istcgcap2022.95.113
dc.identifier.urihttps://ena.lpnu.ua/handle/ntb/59183
dc.language.isoen
dc.publisherВидавництво Львівської політехніки,
dc.publisherLviv Politechnic Publishing House
dc.relation.ispartofГеодезія, картографія і аерофотознімання (95), 2022
dc.relation.ispartofGeodesy, Cartography and Aerial photography (95), 2022
dc.relation.referencesBhattacharya, D., & Painho, M. (2017). Smart cities
dc.relation.referencesintelligence system (smacisys) integrating sensor web
dc.relation.referenceswith spatial data infrastructures (sensdi). ISPRS
dc.relation.referencesAnnals of Photogrammetry, Remote Sensing and
dc.relation.referencesSpatial Information Sciences, 4, 21–28.
dc.relation.referenceshttps://run.unl.pt/handle/10362/28046.
dc.relation.referencesBrandeis Library. Geographic Information Systems
dc.relation.references(GIS). URL: https://guides.library.brandeis.edu/
dc.relation.referencesgis/geocoding (дата звернення: 20.04.2022)..
dc.relation.referencesBui, D. & Glushko, I. (2015). Expansion of the signature
dc.relation.referencesof Codd’s relational (table) algebras: current
dc.relation.referencesstate NaUKMA Research Papers. Computer Science
dc.relation.references(177), 95–107. (in Ukrainian).
dc.relation.referencesClassifier of objects of administrative-territorial
dc.relation.referencesorganization of Ukraine. (in Ukrainian).
dc.relation.referenceshttp://www.ukrstat.gov.ua/klasf/st_kls/op_koatuu_2016.htm.
dc.relation.referencesCodd, E. F. (2002). A relational model of data for large
dc.relation.referencesshared data banks. In Software pioneers (pp. 263–294). Springer, Berlin, Heidelberg.
dc.relation.referencesCodd, E. F. (1990). The relational model for database
dc.relation.referencesmanagement: version 2. Addison-Wesley Longman
dc.relation.referencesPublishing Co., Inc.
dc.relation.referencesConnolly, Thomas, & Caroline Begg (2003). Database.
dc.relation.referencesDesign, implementation and maintenance. Theory and
dc.relation.referencesPractice. Moscow: Williams, 2003. 1436 p., 145–149.
dc.relation.referencesDecree to the Cabinet of Ministers of Ukraine “On Approval
dc.relation.referencesof the Procedure for the Functioning of the National
dc.relation.referencesGeospatial Data Infrastructure” No. 532 dated May 26, 2021. https://zakon.rada.gov.ua/laws/show/532-2021-%D0%BF#Text.
dc.relation.referencesESRI’s Geodatabase Website. URL:
dc.relation.referenceshttp://support.esri.com/datamodels (дата звернення: 20.04.2022).
dc.relation.referencesESRI’s Download Website. URL:
dc.relation.referenceshttp://www.esri.com/data/download/census2000_tigerline/index.html (дата звернення: 20.04.2022).
dc.relation.referencesFranci, F., Lambertini, A., & Bitelli, G. (2014, August).
dc.relation.referencesIntegration of different geospatial data in urban areas:
dc.relation.referencesa case of study. In Second International Conference
dc.relation.referenceson Remote Sensing and Geoinformation of the
dc.relation.referencesEnvironment (RSCy2014) (Vol. 9229, p. 92290P).
dc.relation.referencesInternational Society for Optics and Photonics.
dc.relation.referenceshttps://doi.org/10.1117/12.2066614.
dc.relation.referencesGao, D., Jensen, C. S., Snodgrass, R. T., & Soo, M. D.
dc.relation.references(2005). Join operations in temporal databases.
dc.relation.referencesThe VLDB Journal, 14(1), 2–29.
dc.relation.referenceshttps://link.springer.com/article/10.1007/s00778-003-0111-3.
dc.relation.referencesGeocoding: Longitude and Latitude by Address. URL:
dc.relation.referenceshttps://gisgeography.com/geocoding/ (дата звернення: 20.04.2022).
dc.relation.referencesGeographic information. Spatial referencing by
dc.relation.referencesgeographic identifiers] (2017). DSTU ISO 19112-2017(ISO 19112:2003, IDT) from 1d October 2019.
dc.relation.referencesKyiv. DP “UkrNDNTs” (in Ukrainian).
dc.relation.referencesGeoportal “Administrative and territorial organization of
dc.relation.referencesUkraine”. (in Ukrainian). http://atu.gki.com.ua/
dc.relation.referencesGlushko, I. (2013). Calculation and extension of
dc.relation.referencessignatures of tabular algebras. (PhD dissertation).
dc.relation.referencesAvailable from Taras Shevchenko National
dc.relation.referencesUniversity of Kyiv. URL: (in Ukrainian).
dc.relation.referenceshttp://csc.knu.ua/uk/library/dissertations/hlushko.pdf.
dc.relation.referencesHansen, H. S. (1999, April). Integrating digital maps and
dc.relation.referencesadministrative registers-Danish experiences. In 21 st
dc.relation.referencesUrban Data Management Symposium (pp. 21–23).
dc.relation.referencesHow to Geocode in ArcMap. URL:
dc.relation.referenceshttps://libraries.mit.edu/files/gis/geocoding.pdf (дата
dc.relation.referencesзвернення: 20.04.2022).
dc.relation.referencesKarpinsky, Y., & Lazorenko-Hevel, N. (2018). The
dc.relation.referencesmethods of geospatial data collection for topographic
dc.relation.referencesmapping. Modern achievements of geodesic science and
dc.relation.referencesindustry. (in Ukrainian). http://gki.com.ua/ua/metodizbirannja-geoprostorovih-danih-dlja-topografichnogokartografuvannja.
dc.relation.referencesKarpinskyi, Y., Lazorenko-Hevel, N. (2020). The system
dc.relation.referencesmodel of topographic mapping in the national spatial
dc.relation.referencesdata infrastructure in Ukraine. Geodesy, Cartography
dc.relation.referencesand Aerial Photography, 92, 24–36.
dc.relation.referenceshttps://doi.org/10.23939/istcgcap2020.92.024.
dc.relation.referencesKarpinskyi, Y., & Lazorenko-Hevel, N. (2020).
dc.relation.referencesTopographic mapping in the National Spatial Data
dc.relation.referencesInfrastructure in Ukraine. In E3S Web of
dc.relation.referencesConferences (Vol. 171, p. 02004). EDP Sciences.
dc.relation.referenceshttps://doi.org/10.1051/e3sconf/202017102004.
dc.relation.referencesKarpinskyi Y., Lazorenko-Hevel N., Kin
dc.relation.referencesD. (2020). INSPIREID implementation in the
dc.relation.referencestopographic database of the main state topographic
dc.relation.referencesmap of Ukraine. Веб ISTCGCAP, 91, 20–27.
dc.relation.referenceshttps://doi.org/10.23939/istcgcap2020.91.020.
dc.relation.referencesKarpinskyi, Y. & Lyashchenko A. (2006). Strategia
dc.relation.referencesformuvannia natsionalnoi infrastruktury geoprostorovych
dc.relation.referencesdanych v Ukraini, (108 p.). Kyiv: NDIGK. (Ser.
dc.relation.references“Geodesy, cartography, cadastre”) (in Ukrainian).
dc.relation.referencesLaw of Ukraine About National Geospatial Data
dc.relation.referencesInfrastructure from April 13 2020, No. 554-IX
dc.relation.references(2020). Vidomosti Verkhovnoi Rady Ukrainy.
dc.relation.referencesBulletin of Verkhovna Rada of Ukraine. (in Ukrainian).
dc.relation.referencesLazorenko-Hevel N. (2021). Geographic identifiers as
dc.relation.referencesa basis for integration of geospatial data.
dc.relation.referencesMistobuduvannya ta terytorialʹne planuvannya,
dc.relation.references(78), 312–326. (in Ukrainian).
dc.relation.referenceshttps://doi.org/10.32347/2076-815x.2021.78.312-326.
dc.relation.referencesLemenkova, P. (2020). Integration of geospatial data for
dc.relation.referencesmapping variation of sediment thickness in the North
dc.relation.referencesSea. Scientific Annals of the Danube Delta Institute, 25, 129-138. https://doi.org/10.7427/DDI.25.14.
dc.relation.referencesLyashchenko, A. & Cherin, A. (2019). Basic models and
dc.relation.referencesmethods of geospatial data integration in GIS of
dc.relation.referencesurban-planning cadastre. Mistobuduvannya ta
dc.relation.referencesterytorialʹne planuvannya, (70), 351-365. (in Ukrainian).
dc.relation.referenceshttp://repositary.knuba.edu.ua//handle/987654321/6199.
dc.relation.referencesLyashchenko, A., Havryliuk, Y., & Smilka, V. (2020).
dc.relation.referencesAnalysis of methods of unique identification of
dc.relation.referencesobjects in geospatial data sets. Mistobuduvannya ta
dc.relation.referencesterytorialʹne planuvannya, (75), 217–232.
dc.relation.referenceshttp://repositary.knuba.edu.ua//handle/987654321/9512.
dc.relation.referencesLyashchenko, A., Karpinskyi Y., Havryliuk, Y. &
dc.relation.referencesCherin, A. (2021). Methods and means of ensuring
dc.relation.referencesthe interoperability of the components of the national
dc.relation.referencesgeospatial data infrastructure. Mistobuduvannya ta
dc.relation.referencesterytorialʹne planuvannya, (77), 309–319. (in Ukrainian).
dc.relation.referenceshttps://doi.org/10.32347/2076-815x.2021.77.309-319.
dc.relation.referencesMardani, M., Mardani, H., De Simone, L., Varas, S.,
dc.relation.referencesKita, N., & Saito, T. (2019). Integration of machine
dc.relation.referenceslearning and open access geospatial data for land
dc.relation.referencescover mapping. Remote Sensing, 11(16), 1907.
dc.relation.referenceshttps://doi.org/10.3390/rs11161907.
dc.relation.referencesMaksymova Y. (2016). Creating a database of
dc.relation.referenceselectronic catalog of object classes for sets of
dc.relation.referencesprofile geospatial data of urban planning
dc.relation.referencesdocumentation. Mistobuduvannya ta terytorialʹne
dc.relation.referencesplanuvannya, (62 (1)), 367–376. (in Ukrainian).
dc.relation.referenceshttps://repositary.knuba.edu.ua/bitstream/handle/987654321/6932/62a-368-377.pdf?sequence=1.
dc.relation.referencesOrder of the Ministry of Agrarian Policy and Food of
dc.relation.referencesUkraine “On approval of technical requirements for
dc.relation.referencesgeospatial data, metadata and geoinformation
dc.relation.referencesservices of the national geospatial data infrastructure”
dc.relation.referencesfrom10.11.2021 No. 345. (in Ukrainian).
dc.relation.referencesPilicheva, M., Kin, D., & Pomortseva, O. (2018).
dc.relation.referencesIntegration of topographical and cadastral data of the
dc.relation.referencesbasic dataset of a land parcel. Mistobuduvannya ta
dc.relation.referencesterytorialʹne planuvannya, (66), 523-531. (in Ukrainian).
dc.relation.referencesResolution of the Cabinet of Ministers of Ukraine “On
dc.relation.referencesapproval of the Order for national topographic and
dc.relation.referencesthematic mapping” from 04.09.2013 No. 661. (in
dc.relation.referencesUkrainian).
dc.relation.referencesRayordan, R. (2001) Relational database fundamentals.
dc.relation.referencesМ.: Publishing house “Russian edition”.
dc.relation.referencesShypulin, V. (2021). Integrated real estate information
dc.relation.referencessystem. Concept for Ukraine: monograph. O. M. Beketov
dc.relation.referencesNational University of Urban Economy in Kharkiv. (in
dc.relation.referencesUkrainian). http://eprints.kname.edu.ua/57436/.
dc.relation.referencesSilberschatz, A., Korth, H. F., & Sudarshan, S.
dc.relation.references(2002). Database system concepts (Vol. 5).
dc.relation.referencesNew York: McGraw-Hill. 1376 p.
dc.relation.referenceshttps://snscourseware.org/snsctnew/files/1581236100.pdf
dc.relation.referencesStankevich, S., Titarenko, O., & Golubov, S. (2021).
dc.relation.referencesMathematical model of integration of heterogeneous
dc.relation.referencesdata in assessing the oil and gas prospects of
dc.relation.referencesterritories. Kherson –2021, 86. (in Ukrainian).
dc.relation.referencesStatistical bulletin “Socio-economic situation of
dc.relation.referencesCherkasy region”. Main Department of Statistics
dc.relation.referencesin Cherkasy Oblast. (2021). (in Ukrainian).
dc.relation.referenceshttp://www.ck.ukrstat.gov.ua/?p=bul_soc_ek.
dc.relation.referencesSun, K., Zhu, Y., Pan, P., Hou, Z., Wang, D., Li, W., &
dc.relation.referencesSong, J. (2019). Geospatial data ontology: the
dc.relation.referencessemantic foundation of geospatial data integration
dc.relation.referencesand sharing. Big Earth Data, 3(3), 269–296.
dc.relation.referenceshttps://doi.org/10.1080/20964471.2019.1661662.
dc.relation.referencesThe National Standard of Ukraine DSTU 8774:2018
dc.relation.references“Geographic information. Geospatial data modeling
dc.relation.referencesrules”. (in Ukrainian).
dc.relation.referenceshttp://gki.com.ua/ua/prinjatonacionalni-standartukraiini-dstu-87742018-geografichna-informacijapravila-modeljuvannjageoprostorovih-danih.
dc.relation.referencesenBhattacharya, D., & Painho, M. (2017). Smart cities
dc.relation.referencesenintelligence system (smacisys) integrating sensor web
dc.relation.referencesenwith spatial data infrastructures (sensdi). ISPRS
dc.relation.referencesenAnnals of Photogrammetry, Remote Sensing and
dc.relation.referencesenSpatial Information Sciences, 4, 21–28.
dc.relation.referencesenhttps://run.unl.pt/handle/10362/28046.
dc.relation.referencesenBrandeis Library. Geographic Information Systems
dc.relation.referencesen(GIS). URL: https://guides.library.brandeis.edu/
dc.relation.referencesengis/geocoding (Date of appeal: 20.04.2022)..
dc.relation.referencesenBui, D. & Glushko, I. (2015). Expansion of the signature
dc.relation.referencesenof Codd’s relational (table) algebras: current
dc.relation.referencesenstate NaUKMA Research Papers. Computer Science
dc.relation.referencesen(177), 95–107. (in Ukrainian).
dc.relation.referencesenClassifier of objects of administrative-territorial
dc.relation.referencesenorganization of Ukraine. (in Ukrainian).
dc.relation.referencesenhttp://www.ukrstat.gov.ua/klasf/st_kls/op_koatuu_2016.htm.
dc.relation.referencesenCodd, E. F. (2002). A relational model of data for large
dc.relation.referencesenshared data banks. In Software pioneers (pp. 263–294). Springer, Berlin, Heidelberg.
dc.relation.referencesenCodd, E. F. (1990). The relational model for database
dc.relation.referencesenmanagement: version 2. Addison-Wesley Longman
dc.relation.referencesenPublishing Co., Inc.
dc.relation.referencesenConnolly, Thomas, & Caroline Begg (2003). Database.
dc.relation.referencesenDesign, implementation and maintenance. Theory and
dc.relation.referencesenPractice. Moscow: Williams, 2003. 1436 p., 145–149.
dc.relation.referencesenDecree to the Cabinet of Ministers of Ukraine "On Approval
dc.relation.referencesenof the Procedure for the Functioning of the National
dc.relation.referencesenGeospatial Data Infrastructure" No. 532 dated May 26, 2021. https://zakon.rada.gov.ua/laws/show/532-2021-%D0%BF#Text.
dc.relation.referencesenESRI’s Geodatabase Website. URL:
dc.relation.referencesenhttp://support.esri.com/datamodels (Date of appeal: 20.04.2022).
dc.relation.referencesenESRI’s Download Website. URL:
dc.relation.referencesenhttp://www.esri.com/data/download/census2000_tigerline/index.html (Date of appeal: 20.04.2022).
dc.relation.referencesenFranci, F., Lambertini, A., & Bitelli, G. (2014, August).
dc.relation.referencesenIntegration of different geospatial data in urban areas:
dc.relation.referencesena case of study. In Second International Conference
dc.relation.referencesenon Remote Sensing and Geoinformation of the
dc.relation.referencesenEnvironment (RSCy2014) (Vol. 9229, p. 92290P).
dc.relation.referencesenInternational Society for Optics and Photonics.
dc.relation.referencesenhttps://doi.org/10.1117/12.2066614.
dc.relation.referencesenGao, D., Jensen, C. S., Snodgrass, R. T., & Soo, M. D.
dc.relation.referencesen(2005). Join operations in temporal databases.
dc.relation.referencesenThe VLDB Journal, 14(1), 2–29.
dc.relation.referencesenhttps://link.springer.com/article/10.1007/s00778-003-0111-3.
dc.relation.referencesenGeocoding: Longitude and Latitude by Address. URL:
dc.relation.referencesenhttps://gisgeography.com/geocoding/ (Date of appeal: 20.04.2022).
dc.relation.referencesenGeographic information. Spatial referencing by
dc.relation.referencesengeographic identifiers] (2017). DSTU ISO 19112-2017(ISO 19112:2003, IDT) from 1d October 2019.
dc.relation.referencesenKyiv. DP "UkrNDNTs" (in Ukrainian).
dc.relation.referencesenGeoportal "Administrative and territorial organization of
dc.relation.referencesenUkraine". (in Ukrainian). http://atu.gki.com.ua/
dc.relation.referencesenGlushko, I. (2013). Calculation and extension of
dc.relation.referencesensignatures of tabular algebras. (PhD dissertation).
dc.relation.referencesenAvailable from Taras Shevchenko National
dc.relation.referencesenUniversity of Kyiv. URL: (in Ukrainian).
dc.relation.referencesenhttp://csc.knu.ua/uk/library/dissertations/hlushko.pdf.
dc.relation.referencesenHansen, H. S. (1999, April). Integrating digital maps and
dc.relation.referencesenadministrative registers-Danish experiences. In 21 st
dc.relation.referencesenUrban Data Management Symposium (pp. 21–23).
dc.relation.referencesenHow to Geocode in ArcMap. URL:
dc.relation.referencesenhttps://libraries.mit.edu/files/gis/geocoding.pdf (data
dc.relation.referencesenzvernennia: 20.04.2022).
dc.relation.referencesenKarpinsky, Y., & Lazorenko-Hevel, N. (2018). The
dc.relation.referencesenmethods of geospatial data collection for topographic
dc.relation.referencesenmapping. Modern achievements of geodesic science and
dc.relation.referencesenindustry. (in Ukrainian). http://gki.com.ua/ua/metodizbirannja-geoprostorovih-danih-dlja-topografichnogokartografuvannja.
dc.relation.referencesenKarpinskyi, Y., Lazorenko-Hevel, N. (2020). The system
dc.relation.referencesenmodel of topographic mapping in the national spatial
dc.relation.referencesendata infrastructure in Ukraine. Geodesy, Cartography
dc.relation.referencesenand Aerial Photography, 92, 24–36.
dc.relation.referencesenhttps://doi.org/10.23939/istcgcap2020.92.024.
dc.relation.referencesenKarpinskyi, Y., & Lazorenko-Hevel, N. (2020).
dc.relation.referencesenTopographic mapping in the National Spatial Data
dc.relation.referencesenInfrastructure in Ukraine. In E3S Web of
dc.relation.referencesenConferences (Vol. 171, p. 02004). EDP Sciences.
dc.relation.referencesenhttps://doi.org/10.1051/e3sconf/202017102004.
dc.relation.referencesenKarpinskyi Y., Lazorenko-Hevel N., Kin
dc.relation.referencesenD. (2020). INSPIREID implementation in the
dc.relation.referencesentopographic database of the main state topographic
dc.relation.referencesenmap of Ukraine. Veb ISTCGCAP, 91, 20–27.
dc.relation.referencesenhttps://doi.org/10.23939/istcgcap2020.91.020.
dc.relation.referencesenKarpinskyi, Y. & Lyashchenko A. (2006). Strategia
dc.relation.referencesenformuvannia natsionalnoi infrastruktury geoprostorovych
dc.relation.referencesendanych v Ukraini, (108 p.). Kyiv: NDIGK. (Ser.
dc.relation.referencesen"Geodesy, cartography, cadastre") (in Ukrainian).
dc.relation.referencesenLaw of Ukraine About National Geospatial Data
dc.relation.referencesenInfrastructure from April 13 2020, No. 554-IX
dc.relation.referencesen(2020). Vidomosti Verkhovnoi Rady Ukrainy.
dc.relation.referencesenBulletin of Verkhovna Rada of Ukraine. (in Ukrainian).
dc.relation.referencesenLazorenko-Hevel N. (2021). Geographic identifiers as
dc.relation.referencesena basis for integration of geospatial data.
dc.relation.referencesenMistobuduvannya ta terytorialʹne planuvannya,
dc.relation.referencesen(78), 312–326. (in Ukrainian).
dc.relation.referencesenhttps://doi.org/10.32347/2076-815x.2021.78.312-326.
dc.relation.referencesenLemenkova, P. (2020). Integration of geospatial data for
dc.relation.referencesenmapping variation of sediment thickness in the North
dc.relation.referencesenSea. Scientific Annals of the Danube Delta Institute, 25, 129-138. https://doi.org/10.7427/DDI.25.14.
dc.relation.referencesenLyashchenko, A. & Cherin, A. (2019). Basic models and
dc.relation.referencesenmethods of geospatial data integration in GIS of
dc.relation.referencesenurban-planning cadastre. Mistobuduvannya ta
dc.relation.referencesenterytorialʹne planuvannya, (70), 351-365. (in Ukrainian).
dc.relation.referencesenhttp://repositary.knuba.edu.ua//handle/987654321/6199.
dc.relation.referencesenLyashchenko, A., Havryliuk, Y., & Smilka, V. (2020).
dc.relation.referencesenAnalysis of methods of unique identification of
dc.relation.referencesenobjects in geospatial data sets. Mistobuduvannya ta
dc.relation.referencesenterytorialʹne planuvannya, (75), 217–232.
dc.relation.referencesenhttp://repositary.knuba.edu.ua//handle/987654321/9512.
dc.relation.referencesenLyashchenko, A., Karpinskyi Y., Havryliuk, Y. &
dc.relation.referencesenCherin, A. (2021). Methods and means of ensuring
dc.relation.referencesenthe interoperability of the components of the national
dc.relation.referencesengeospatial data infrastructure. Mistobuduvannya ta
dc.relation.referencesenterytorialʹne planuvannya, (77), 309–319. (in Ukrainian).
dc.relation.referencesenhttps://doi.org/10.32347/2076-815x.2021.77.309-319.
dc.relation.referencesenMardani, M., Mardani, H., De Simone, L., Varas, S.,
dc.relation.referencesenKita, N., & Saito, T. (2019). Integration of machine
dc.relation.referencesenlearning and open access geospatial data for land
dc.relation.referencesencover mapping. Remote Sensing, 11(16), 1907.
dc.relation.referencesenhttps://doi.org/10.3390/rs11161907.
dc.relation.referencesenMaksymova Y. (2016). Creating a database of
dc.relation.referencesenelectronic catalog of object classes for sets of
dc.relation.referencesenprofile geospatial data of urban planning
dc.relation.referencesendocumentation. Mistobuduvannya ta terytorialʹne
dc.relation.referencesenplanuvannya, (62 (1)), 367–376. (in Ukrainian).
dc.relation.referencesenhttps://repositary.knuba.edu.ua/bitstream/handle/987654321/6932/62a-368-377.pdf?sequence=1.
dc.relation.referencesenOrder of the Ministry of Agrarian Policy and Food of
dc.relation.referencesenUkraine "On approval of technical requirements for
dc.relation.referencesengeospatial data, metadata and geoinformation
dc.relation.referencesenservices of the national geospatial data infrastructure"
dc.relation.referencesenfrom10.11.2021 No. 345. (in Ukrainian).
dc.relation.referencesenPilicheva, M., Kin, D., & Pomortseva, O. (2018).
dc.relation.referencesenIntegration of topographical and cadastral data of the
dc.relation.referencesenbasic dataset of a land parcel. Mistobuduvannya ta
dc.relation.referencesenterytorialʹne planuvannya, (66), 523-531. (in Ukrainian).
dc.relation.referencesenResolution of the Cabinet of Ministers of Ukraine "On
dc.relation.referencesenapproval of the Order for national topographic and
dc.relation.referencesenthematic mapping" from 04.09.2013 No. 661. (in
dc.relation.referencesenUkrainian).
dc.relation.referencesenRayordan, R. (2001) Relational database fundamentals.
dc.relation.referencesenM., Publishing house "Russian edition".
dc.relation.referencesenShypulin, V. (2021). Integrated real estate information
dc.relation.referencesensystem. Concept for Ukraine: monograph. O. M. Beketov
dc.relation.referencesenNational University of Urban Economy in Kharkiv. (in
dc.relation.referencesenUkrainian). http://eprints.kname.edu.ua/57436/.
dc.relation.referencesenSilberschatz, A., Korth, H. F., & Sudarshan, S.
dc.relation.referencesen(2002). Database system concepts (Vol. 5).
dc.relation.referencesenNew York: McGraw-Hill. 1376 p.
dc.relation.referencesenhttps://snscourseware.org/snsctnew/files/1581236100.pdf
dc.relation.referencesenStankevich, S., Titarenko, O., & Golubov, S. (2021).
dc.relation.referencesenMathematical model of integration of heterogeneous
dc.relation.referencesendata in assessing the oil and gas prospects of
dc.relation.referencesenterritories. Kherson –2021, 86. (in Ukrainian).
dc.relation.referencesenStatistical bulletin "Socio-economic situation of
dc.relation.referencesenCherkasy region". Main Department of Statistics
dc.relation.referencesenin Cherkasy Oblast. (2021). (in Ukrainian).
dc.relation.referencesenhttp://www.ck.ukrstat.gov.ua/?p=bul_soc_ek.
dc.relation.referencesenSun, K., Zhu, Y., Pan, P., Hou, Z., Wang, D., Li, W., &
dc.relation.referencesenSong, J. (2019). Geospatial data ontology: the
dc.relation.referencesensemantic foundation of geospatial data integration
dc.relation.referencesenand sharing. Big Earth Data, 3(3), 269–296.
dc.relation.referencesenhttps://doi.org/10.1080/20964471.2019.1661662.
dc.relation.referencesenThe National Standard of Ukraine DSTU 8774:2018
dc.relation.referencesen"Geographic information. Geospatial data modeling
dc.relation.referencesenrules". (in Ukrainian).
dc.relation.referencesenhttp://gki.com.ua/ua/prinjatonacionalni-standartukraiini-dstu-87742018-geografichna-informacijapravila-modeljuvannjageoprostorovih-danih.
dc.relation.urihttps://run.unl.pt/handle/10362/28046
dc.relation.urihttps://guides.library.brandeis.edu/
dc.relation.urihttp://www.ukrstat.gov.ua/klasf/st_kls/op_koatuu_2016.htm
dc.relation.urihttps://zakon.rada.gov.ua/laws/show/532-2021-%D0%BF#Text
dc.relation.urihttp://support.esri.com/datamodels
dc.relation.urihttp://www.esri.com/data/download/census2000_tigerline/index.html
dc.relation.urihttps://doi.org/10.1117/12.2066614
dc.relation.urihttps://link.springer.com/article/10.1007/s00778-003-0111-3
dc.relation.urihttps://gisgeography.com/geocoding/
dc.relation.urihttp://atu.gki.com.ua/
dc.relation.urihttp://csc.knu.ua/uk/library/dissertations/hlushko.pdf
dc.relation.urihttps://libraries.mit.edu/files/gis/geocoding.pdf
dc.relation.urihttp://gki.com.ua/ua/metodizbirannja-geoprostorovih-danih-dlja-topografichnogokartografuvannja
dc.relation.urihttps://doi.org/10.23939/istcgcap2020.92.024
dc.relation.urihttps://doi.org/10.1051/e3sconf/202017102004
dc.relation.urihttps://doi.org/10.23939/istcgcap2020.91.020
dc.relation.urihttps://doi.org/10.32347/2076-815x.2021.78.312-326
dc.relation.urihttps://doi.org/10.7427/DDI.25.14
dc.relation.urihttp://repositary.knuba.edu.ua//handle/987654321/6199
dc.relation.urihttp://repositary.knuba.edu.ua//handle/987654321/9512
dc.relation.urihttps://doi.org/10.32347/2076-815x.2021.77.309-319
dc.relation.urihttps://doi.org/10.3390/rs11161907
dc.relation.urihttps://repositary.knuba.edu.ua/bitstream/handle/987654321/6932/62a-368-377.pdf?sequence=1
dc.relation.urihttp://eprints.kname.edu.ua/57436/
dc.relation.urihttps://snscourseware.org/snsctnew/files/1581236100.pdf
dc.relation.urihttp://www.ck.ukrstat.gov.ua/?p=bul_soc_ek
dc.relation.urihttps://doi.org/10.1080/20964471.2019.1661662
dc.relation.urihttp://gki.com.ua/ua/prinjatonacionalni-standartukraiini-dstu-87742018-geografichna-informacijapravila-modeljuvannjageoprostorovih-danih
dc.rights.holder© Національний університет “Львівська політехніка”, 2022
dc.subjectінтеграція геопросторових даних
dc.subjectінтероперабельність
dc.subjectоперація з’єднання (JOIN)
dc.subjectнаціональна інфраструктура геопросторових даних
dc.subjectбазові геопросторові дані
dc.subjectтематичні геопросторові дані
dc.subjectgeospatial data integration
dc.subjectinteroperability
dc.subjectJOIN operation
dc.subjectnational spatial data infrastructure
dc.subjectcore reference data
dc.subjectthematic geospatial data
dc.subject.udc528.001
dc.subject.udc681.518
dc.titleIntegration of geospatia l data based on the application of the JOIN operation of relative algebra
dc.title.alternativeІнтеграція геопросторових даних на основі застосування операції з’єднання (JOIN) реляційної алгебри
dc.typeArticle

Files

Original bundle
Now showing 1 - 2 of 2
No Thumbnail Available
Name:
2022v95_Lazorenko_N-Integration_of_geospatia_113-128.pdf
Size:
821.41 KB
Format:
Adobe Portable Document Format
Download
No Thumbnail Available
Name:
2022v95_Lazorenko_N-Integration_of_geospatia_113-128__COVER.png
Size:
1.45 MB
Format:
Portable Network Graphics
Download
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.77 KB
Format:
Plain Text
Description:
Download

Collections

Геодезія, картографія і аерофотознімання. – 2022. – Випуск 95