INSPIREID implementation in the topographic database of the main state topographic map of Ukraine

Simple item page
dc.citation.epage27
dc.citation.issue91
dc.citation.journalTitleГеодезія, картографія і аерофотознімання
dc.citation.spage20
dc.contributor.affiliationНауково-дослідний інститут геодезії і картографії
dc.contributor.affiliationКиївський національний університет будівництва і архітектури
dc.contributor.affiliationResearch Institute of Geodesy and Cartography
dc.contributor.affiliationKyiv National University of Construction and Architecture
dc.contributor.authorКарпінський, Ю. О.
dc.contributor.authorЛазоренко-Гевель, Н. Ю.
dc.contributor.authorКінь, Д. О.
dc.contributor.authorKarpinskyi, Yurii
dc.contributor.authorLazorenko-Hevel, Nadiia
dc.contributor.authorKin, Danylo
dc.coverage.placenameЛьвів
dc.coverage.placenameLviv
dc.date.accessioned2023-03-02T08:01:37Z
dc.date.available2023-03-02T08:01:37Z
dc.date.created2020-03-12
dc.date.issued2020-03-12
dc.description.abstractДосліджено принципи побудови та присвоєння унікального ідентифікатора inspireId об’єктам класів у базі топографічних даних (БТД), яку розроблено на основі концепції модельно-керованої архітектури. Розглянуто питання автоматичної генерації унікального ідентифікатора inspireId та правила його життєвого циклу. Мета роботи – дослідити принципи та вимоги до структури і присвоєння унікального ідентифікатора inspireId об’єктам класів БТД та реалізувати автоматичну його генерацію у мові структурованих запитів (SQL) для забезпечення зв’язку з наборами Інфраструктури геопросторових даних Європейського Союзу (Infrastructure for Spatial Information in the European Community – INSPIRE) та EuroRegionalMap (ERM). Відповідно до загальних принципів та вимог ЕRM до структури унікального ідентифікатора inspireId об’єктам класів бази топографічних даних, розроблено його структуру для ідентифікації об’єктів БТД “Основна державна топографічна карта”. Розроблено функцію для автоматичної генерації inspireId у середовищі об’єктно-реляційної системи керування базами даних (ОР СКБД) PostgreSQL. Детально розглянуто правила життєвого циклу унікального ідентифікатора у БГД, що забезпечує його стабільність. Використання унікального ідентифікатора inspireId у базі топографічних даних “Основна державна топографічна карта” забезпечує зв’язок із наборами інфраструктури геопросторових даних ЄС та EuroRegionalMap.
dc.description.abstractThe article researches the principles of creation and assignment of a unique identifier inspireId to objects of classes in the topographic database (TDB), which is developed on the basis of the concept of model-driven architecture. The issue of automatic generation of a unique identifier inspireId and the rules of its life-cycle is researched. The goal of the work is to study the principles and requirements for the structure and assignment of a unique identifier inspireId objects of classes of TDB and the implementation of its automatic generation in SQL to provide interoperability with datasets of European Union Geospatial Data Infrastructure (INSPIRE) and EuroRegionalMap (ERM). Methods. In accordance with the general principles and requirements of the ERM to the structure of the unique identifier inspireId objects of classes of the topographic database, developed its structure for the identification of objects in the TDB “Main State Topographic Map”. The function for automatic generation of inspireId in the object-relation database management system (ORDBMS) PostgreSQL has been developed. The lifecycle rules of a unique identifier in TDB, which ensures its stability, are considered in detail. Results. The developed structure of the unique inspireId identifier and the proposed rules of its life-cycle can be used in any geospatial databases. The use of the unique identifier inspireId in the Topographic Database “Main State Topographic Map” provides a link to the Infrastructure for Spatial Information in the European Community and EuroRegionalMap datasets. Scientific novelty and practical significance. The method of assigning a unique identifier inspireId to the objects of the topographic database classes “Main State Topographic Map” is proposed, which will further provide a link to the sets of the Infrastructure for Spatial Information in the European Community and EuroRegionalMap.
dc.format.extent20-27
dc.format.pages8
dc.identifier.citationKarpinskyi Y. INSPIREID implementation in the topographic database of the main state topographic map of Ukraine / Yurii Karpinskyi, Nadiia Lazorenko-Hevel, Danylo Kin // Geodesy, cartography and aerial photography. — Lviv : Lviv Politechnic Publishing House, 2020. — No 91. — P. 20–27.
dc.identifier.citationenKarpinskyi Y. INSPIREID implementation in the topographic database of the main state topographic map of Ukraine / Yurii Karpinskyi, Nadiia Lazorenko-Hevel, Danylo Kin // Geodesy, cartography and aerial photography. — Lviv : Lviv Politechnic Publishing House, 2020. — No 91. — P. 20–27.
dc.identifier.doidoi.org/10.23939/istcgcap2020.91.020
dc.identifier.urihttps://ena.lpnu.ua/handle/ntb/57444
dc.language.isoen
dc.publisherВидавництво Національного університету “Львівська політехніка”
dc.publisherLviv Politechnic Publishing House
dc.relation.ispartofГеодезія, картографія і аерофотознімання, 91, 2020
dc.relation.ispartofGeodesy, cartography and aerial photography, 91, 2020
dc.relation.referencesKarpinskyi, Yu., Lazorenko-Hevel, N., & Kin’, D. (2019).
dc.relation.referencesTransformation of the model of topographic database
dc.relation.referencesfrom UML-model to SQL Ukrainian scientificpractical conference “Cartographic modelling and
dc.relation.referencesgeographic information systems”, P. 76–79.
dc.relation.referencesKarpinskyi, Y., Lyashchenko, А., & Runec R. (2010).
dc.relation.referencesReference model of the topographic database Visnik
dc.relation.referencesof Geodesy and Cartography, 2, 28–36. Retrieved
dc.relation.referencesfrom: http://nbuv.gov.ua/UJRN/vgtk_2010_2_9.
dc.relation.referencesPreparatory works. Provision of scientific, technical and
dc.relation.referencesconsulting services to support the execution of
dc.relation.referencesworks on the creation of a topographic database
dc.relation.references“Main State Topographic Map”. Creating
dc.relation.references(updating) digital topographic maps on a scale
dc.relation.referencesof 1:50 000. SE “Research Institute of geodesy
dc.relation.referencesand cartography”, (2019). Retrieved from:
dc.relation.referenceshttp://nddkr.ukrintei.ua/view/rk/0b4df5632db1aa6313a9ef4bd15c0795.
dc.relation.referencesArmenakis, C., Cyr, I. and Papanikolaou, E. Change
dc.relation.referencesdetection methods for the revision of topographic
dc.relation.referencesdatabases. Proceedings of the Joint International
dc.relation.referencesSymposium (ISPRS IV, SDH, CIG) on Geospatial
dc.relation.referencesTheory, Processing and Applications, July 9–12.
dc.relation.referencespp. 792–797.
dc.relation.referencesCraglia, M., Annoni, A., Smith, R., & Smits, P. (2002). Spatial Data Infrastructures: Country Reports. Geographic
dc.relation.referencesInformation Network in Europe, Retrieved from:
dc.relation.referenceshttps://www.geos.ed.ac.uk/~gisteac/proceedingsonline/Source%20Book%202004/SDI/Continental/Europe/GINIE/Report_SDI_Country%20Reports.pdf.
dc.relation.referencesDIRECTIVE 2007/2/EC OF THE EUROPEAN
dc.relation.referencesPARLIAMENT AND OF THE COUNCIL.
dc.relation.referencesOfficial Journal of the European Union, 2007.
dc.relation.referencesRetrieved from: https://eur-lex.europa.eu/legalcontent/EN/TXT/PDF/?uri=CELEX:32007L0002&from=EN.
dc.relation.referencesElling, R. (2020). ERM Populating the INSPIRE
dc.relation.referencesUnique Identifier and Life-cycle Information.
dc.relation.referencesEuroGeographics Association.
dc.relation.referencesElling, R., & Reichelt, A. (2019). Technical Producer
dc.relation.referencesGuide. EuroGeographics Association.
dc.relation.referencesHeipke, C., Kuittinen, R., & Nagel, G. (2003). From
dc.relation.referencesOEEPE to EuroSDR: 50 years of European
dc.relation.referencesSpatial Data Research and beyond. European
dc.relation.referencesSpatial Data Research, Retrieved from:
dc.relation.referenceshttp://www.eurosdr.net/sites/default/files/uploadedfiles/eurosdr_publication_ndeg_46.pdf.
dc.relation.referencesINSPIRE Data Specification on Hydrography –
dc.relation.referencesTechnical Guidelines. INSPIRE Thematic Working
dc.relation.referencesGroup Hydrography, 2014. Retrieved from:
dc.relation.referenceshttps://inspire.ec.europa.eu/file/1729/download?token=LfNVPj1X.ISO 3166-1 alpha-2. IBAN. Retrieved from:
dc.relation.referenceshttps://www.iban.com/country-codes.
dc.relation.referencesJakobsson, A., & Ilves, R. (2016). Reinventing the
dc.relation.referencesNational Topographic Database. The International
dc.relation.referencesArchives of the Photogrammetry, Remote Sensing
dc.relation.referencesand Spatial Information Sciences, P. 733–736.
dc.relation.referencesKarpinskyi, Y., & Lazorenko-Hevel, N. (2019).
dc.relation.referencesTopographic mapping in the National Spatial
dc.relation.referencesData Infrastructure in Ukraine. THE 9TH
dc.relation.referencesINTERNATIONAL SCIENTIFIC-TECHNICAL
dc.relation.referencesCONFERENCE ENVIRONMENTAL ENGINEERING,
dc.relation.referencesPHOTOGRAMMETRY, GEOINFORMATICS
dc.relation.referencesModern Technologies and Development
dc.relation.referencesPerspectives. Retrieved from:
dc.relation.referenceshttps://repositorio.ipbeja.pt/bitstream/20.500.12207/4927/1/Abstrats_284-285_eepg_tech_ksiazkastreszczen.pdf.
dc.relation.referencesThe Law of Ukraine “On the National Spatial Data
dc.relation.referencesInfrastructure” (bill No. 2370), 13.04.2020. Retrieved
dc.relation.referencesfrom: http://w1.c1.rada.gov.ua/pls/zweb2/webproc34?id=&pf3511=67268&pf35401=525603.
dc.relation.referencesLüscher, P. (2011). Characterising urban space from
dc.relation.referencestopographic databases: cartographic pattern recognition
dc.relation.referencesbased on semantic modelling. Zurich Open Repository
dc.relation.referencesand Archive, University of Zurich. Retrieved from:
dc.relation.referenceshttps://www.zora.uzh.ch/id/eprint/164120/1/20121448.pdf.
dc.relation.referencesOS MasterMap Topographic Identifiers – TOIDs.
dc.relation.referencesOrdnance Survey, 2019. Retrieved from:
dc.relation.referenceshttps://www.ordnancesurvey.co.uk/businessgovernment/tools-support/mastermap-topographysupport/toids.
dc.relation.referencesReitz, T. (2018). gml:id, gml:identifier and the InspireId.
dc.relation.referencesClarifications and Best Practices Wetransform, 2018. Retrieved from: https://www.wetransform.to/news/2018/02/12/best-practices-for-inspire-ids
dc.relation.referencesenKarpinskyi, Yu., Lazorenko-Hevel, N., & Kin’, D. (2019).
dc.relation.referencesenTransformation of the model of topographic database
dc.relation.referencesenfrom UML-model to SQL Ukrainian scientificpractical conference "Cartographic modelling and
dc.relation.referencesengeographic information systems", P. 76–79.
dc.relation.referencesenKarpinskyi, Y., Lyashchenko, A., & Runec R. (2010).
dc.relation.referencesenReference model of the topographic database Visnik
dc.relation.referencesenof Geodesy and Cartography, 2, 28–36. Retrieved
dc.relation.referencesenfrom: http://nbuv.gov.ua/UJRN/vgtk_2010_2_9.
dc.relation.referencesenPreparatory works. Provision of scientific, technical and
dc.relation.referencesenconsulting services to support the execution of
dc.relation.referencesenworks on the creation of a topographic database
dc.relation.referencesen"Main State Topographic Map". Creating
dc.relation.referencesen(updating) digital topographic maps on a scale
dc.relation.referencesenof 1:50 000. SE "Research Institute of geodesy
dc.relation.referencesenand cartography", (2019). Retrieved from:
dc.relation.referencesenhttp://nddkr.ukrintei.ua/view/rk/0b4df5632db1aa6313a9ef4bd15c0795.
dc.relation.referencesenArmenakis, C., Cyr, I. and Papanikolaou, E. Change
dc.relation.referencesendetection methods for the revision of topographic
dc.relation.referencesendatabases. Proceedings of the Joint International
dc.relation.referencesenSymposium (ISPRS IV, SDH, CIG) on Geospatial
dc.relation.referencesenTheory, Processing and Applications, July 9–12.
dc.relation.referencesenpp. 792–797.
dc.relation.referencesenCraglia, M., Annoni, A., Smith, R., & Smits, P. (2002). Spatial Data Infrastructures: Country Reports. Geographic
dc.relation.referencesenInformation Network in Europe, Retrieved from:
dc.relation.referencesenhttps://www.geos.ed.ac.uk/~gisteac/proceedingsonline/Source%20Book%202004/SDI/Continental/Europe/GINIE/Report_SDI_Country%20Reports.pdf.
dc.relation.referencesenDIRECTIVE 2007/2/EC OF THE EUROPEAN
dc.relation.referencesenPARLIAMENT AND OF THE COUNCIL.
dc.relation.referencesenOfficial Journal of the European Union, 2007.
dc.relation.referencesenRetrieved from: https://eur-lex.europa.eu/legalcontent/EN/TXT/PDF/?uri=CELEX:32007L0002&from=EN.
dc.relation.referencesenElling, R. (2020). ERM Populating the INSPIRE
dc.relation.referencesenUnique Identifier and Life-cycle Information.
dc.relation.referencesenEuroGeographics Association.
dc.relation.referencesenElling, R., & Reichelt, A. (2019). Technical Producer
dc.relation.referencesenGuide. EuroGeographics Association.
dc.relation.referencesenHeipke, C., Kuittinen, R., & Nagel, G. (2003). From
dc.relation.referencesenOEEPE to EuroSDR: 50 years of European
dc.relation.referencesenSpatial Data Research and beyond. European
dc.relation.referencesenSpatial Data Research, Retrieved from:
dc.relation.referencesenhttp://www.eurosdr.net/sites/default/files/uploadedfiles/eurosdr_publication_ndeg_46.pdf.
dc.relation.referencesenINSPIRE Data Specification on Hydrography –
dc.relation.referencesenTechnical Guidelines. INSPIRE Thematic Working
dc.relation.referencesenGroup Hydrography, 2014. Retrieved from:
dc.relation.referencesenhttps://inspire.ec.europa.eu/file/1729/download?token=LfNVPj1X.ISO 3166-1 alpha-2. IBAN. Retrieved from:
dc.relation.referencesenhttps://www.iban.com/country-codes.
dc.relation.referencesenJakobsson, A., & Ilves, R. (2016). Reinventing the
dc.relation.referencesenNational Topographic Database. The International
dc.relation.referencesenArchives of the Photogrammetry, Remote Sensing
dc.relation.referencesenand Spatial Information Sciences, P. 733–736.
dc.relation.referencesenKarpinskyi, Y., & Lazorenko-Hevel, N. (2019).
dc.relation.referencesenTopographic mapping in the National Spatial
dc.relation.referencesenData Infrastructure in Ukraine. THE 9TH
dc.relation.referencesenINTERNATIONAL SCIENTIFIC-TECHNICAL
dc.relation.referencesenCONFERENCE ENVIRONMENTAL ENGINEERING,
dc.relation.referencesenPHOTOGRAMMETRY, GEOINFORMATICS
dc.relation.referencesenModern Technologies and Development
dc.relation.referencesenPerspectives. Retrieved from:
dc.relation.referencesenhttps://repositorio.ipbeja.pt/bitstream/20.500.12207/4927/1/Abstrats_284-285_eepg_tech_ksiazkastreszczen.pdf.
dc.relation.referencesenThe Law of Ukraine "On the National Spatial Data
dc.relation.referencesenInfrastructure" (bill No. 2370), 13.04.2020. Retrieved
dc.relation.referencesenfrom: http://w1.P.1.rada.gov.ua/pls/zweb2/webproc34?id=&pf3511=67268&pf35401=525603.
dc.relation.referencesenLüscher, P. (2011). Characterising urban space from
dc.relation.referencesentopographic databases: cartographic pattern recognition
dc.relation.referencesenbased on semantic modelling. Zurich Open Repository
dc.relation.referencesenand Archive, University of Zurich. Retrieved from:
dc.relation.referencesenhttps://www.zora.uzh.ch/id/eprint/164120/1/20121448.pdf.
dc.relation.referencesenOS MasterMap Topographic Identifiers – TOIDs.
dc.relation.referencesenOrdnance Survey, 2019. Retrieved from:
dc.relation.referencesenhttps://www.ordnancesurvey.co.uk/businessgovernment/tools-support/mastermap-topographysupport/toids.
dc.relation.referencesenReitz, T. (2018). gml:id, gml:identifier and the InspireId.
dc.relation.referencesenClarifications and Best Practices Wetransform, 2018. Retrieved from: https://www.wetransform.to/news/2018/02/12/best-practices-for-inspire-ids
dc.relation.urihttp://nbuv.gov.ua/UJRN/vgtk_2010_2_9
dc.relation.urihttp://nddkr.ukrintei.ua/view/rk/0b4df5632db1aa6313a9ef4bd15c0795
dc.relation.urihttps://www.geos.ed.ac.uk/~gisteac/proceedingsonline/Source%20Book%202004/SDI/Continental/Europe/GINIE/Report_SDI_Country%20Reports.pdf
dc.relation.urihttps://eur-lex.europa.eu/legalcontent/EN/TXT/PDF/?uri=CELEX:32007L0002&from=EN
dc.relation.urihttp://www.eurosdr.net/sites/default/files/uploadedfiles/eurosdr_publication_ndeg_46.pdf
dc.relation.urihttps://inspire.ec.europa.eu/file/1729/download?token=LfNVPj1X.ISO
dc.relation.urihttps://www.iban.com/country-codes
dc.relation.urihttps://repositorio.ipbeja.pt/bitstream/20.500.12207/4927/1/Abstrats_284-285_eepg_tech_ksiazkastreszczen.pdf
dc.relation.urihttp://w1.c1.rada.gov.ua/pls/zweb2/webproc34?id=&pf3511=67268&pf35401=525603
dc.relation.urihttps://www.zora.uzh.ch/id/eprint/164120/1/20121448.pdf
dc.relation.urihttps://www.ordnancesurvey.co.uk/businessgovernment/tools-support/mastermap-topographysupport/toids
dc.relation.urihttps://www.wetransform.to/news/2018/02/12/best-practices-for-inspire-ids
dc.rights.holder© Національний університет “Львівська політехніка”, 2020
dc.subjectinspireId
dc.subjectунікальний ідентифікатор
dc.subjectбаза геопросторових даних
dc.subjectбаза топографічних даних
dc.subjectБТД
dc.subjectSQL
dc.subjectINSPIRE
dc.subjectERM
dc.subjectгеоінформаційні системи
dc.subjectГІС
dc.subjectнаціональна інфраструктура геопросторових даних
dc.subjectНІГД
dc.subjectinspireId
dc.subjectunique identifier
dc.subjectgeospatial database
dc.subjecttopographic database
dc.subjectSQL
dc.subjectINSPIRE
dc.subjectERM
dc.subjectgeographic information systems
dc.subjectGIS
dc.subjectnational spatial data infrastructure
dc.subjectNSDI
dc.subject.udc528.4
dc.titleINSPIREID implementation in the topographic database of the main state topographic map of Ukraine
dc.title.alternativeВпровадження INSPIREID у базі топографічних даних основної державної топографічної карти України
dc.typeArticle

Files

Original bundle
Now showing 1 - 2 of 2
No Thumbnail Available
Name:
2020n91_Karpinskyi_Y-INSPIREID_implementation_20-27.pdf
Size:
584.69 KB
Format:
Adobe Portable Document Format
Download
No Thumbnail Available
Name:
2020n91_Karpinskyi_Y-INSPIREID_implementation_20-27__COVER.png
Size:
545.12 KB
Format:
Portable Network Graphics
Download
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.87 KB
Format:
Plain Text
Description:
Download

Collections

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