1. ISTCGCAP
  2. All Volumes and Issues
  3. Volume 91, 2020
  4. INSPIREID implementation in the topographic database of the main state topographic map of Ukraine

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

ISTCGCAP.
2020;
Volume 91, 2020, Number 91
: 20-27
https://doi.org/10.23939/istcgcap2020.91.020
Received: February 03, 2020
Authors:
  1. Yurii Karpinskyi
  2. Nadiia Lazorenko
  3. Danylo Kin
1
Research Institute of Geodesy and Cartography
2
Kyiv National University of Construction and Architecture
3
Kyiv National University of Construction and Architecture

The 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 life-cycle 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.

inspireId
unique identifier
geospatial database
topographic database
SQL
INSPIRE
ERM
geographic information systems
GIS
national spatial data infrastructure
NSDI.
  1. Karpinskyi, Yu., Lazorenko-Hevel, N., & Kin’, D. (2019). Transformation of the model of topographic database from UML-model to SQL Ukrainian scientific-practical conference “Cartographic modelling and geographic information systems”, P. 76–79.
  2. Karpinskyi, Y., Lyashchenko, А., & Runec R. (2010). Reference model of the topographic database Visnik of Geodesy and Cartography, 2, 28-36. Retrieved from: http://nbuv.gov.ua/UJRN/vgtk_2010_2_9.
  3. Preparatory works. Provision of scientific, technical and consulting services to support the execution of works on the creation of a topographic database “Main State Topographic Map”. Creating (updating) digital topographic maps on a scale of 1:50 000. SE “Research Institute of geodesy and cartography”, (2019). Retrieved from: http://nddkr.ukrintei.ua/view/rk/0b4df5632db1aa6313a9ef4bd15c0795.
  4. Armenakis, C., Cyr, I. and Papanikolaou, E. Change detection methods for the revision of topographic databases. Proceedings of the Joint International Symposium (ISPRS IV, SDH, CIG) on Geospatial Theory, Processing and Applications, July 9–12. pp. 792–797.
  5. Craglia, M., Annoni, A., Smith, R., & Smits, P. (2002). Spatial Data Infrastructures: Country Reports. Geographic Information Network in Europe, Retrieved from: https://www.geos.ed.ac.uk/~gisteac/proceedingsonline/Source%20Book%202004/SDI/Continental/Europe/GINIE/Report_SDI_Country%20Reports.pdf.
  6. DIRECTIVE 2007/2/EC OF THE EUROPEAN PARLIAMENT AND OF THE COUNCIL. Official Journal of the European Union, 2007. Retrieved from: https://eur-lex.europa.eu/legal-content/EN/TXT/PDF/?uri=CELEX:32007L0002&from=EN.
  7. Elling, R. (2020). ERM Populating the INSPIRE Unique Identifier and Life-cycle Information. EuroGeographics Association.
  8. Elling, R., & Reichelt, A. (2019). Technical Producer Guide. EuroGeographics Association.
  9. Heipke, C., Kuittinen, R., & Nagel, G. (2003). From OEEPE to EuroSDR: 50 years of European Spatial Data Research and beyond. European Spatial Data Research,  Retrieved from: http://www.eurosdr.net/sites/default/files/uploaded_files/eurosdr_publication_ndeg_46.pdf.
  10. INSPIRE Data Specification on Hydrography – Technical Guidelines. INSPIRE Thematic Working Group Hydrography, 2014. Retrieved from: https://inspire.ec.europa.eu/file/1729/download?token=LfNVPj1X.
  11. ISO 3166-1 alpha-2. IBAN. Retrieved from: https://www.iban.com/country-codes.
  12. Jakobsson, A., & Ilves, R. (2016). Reinventing the National Topographic Database. The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, P. 733–736. 1. Karpinskyi, Yu., Lazorenko-Hevel, N., & Kin', D. (2019). Transformation of the model of topographic database from UML-model to SQL Ukrainian scientific-practical conference "Cartographic modelling and geographic information systems", P. 76-79.
    2. Karpinskyi, Y., Lyashchenko, А., & Runec R. (2010). Reference model of the topographic database Visnik of Geodesy and Cartography, 2, 28-36. Retrieved from: http://nbuv.gov.ua/UJRN/vgtk_2010_2_9.
    3. Preparatory works. Provision of scientific, technical and consulting services to support the execution of works on the creation of a topographic database "Main State Topographic Map". Creating (updating) digital topographic maps on a scale of 1:50 000. SE "Research Institute of geodesy and cartography", (2019). Retrieved from: http://nddkr.ukrintei.ua/view/rk/0b4df5632db1aa6313a9ef4bd15c0795.
    4. Armenakis, C., Cyr, I. and Papanikolaou, E. Change detection methods for the revision of topographic databases. Proceedings of the Joint International Symposium (ISPRS IV, SDH, CIG) on Geospatial Theory, Processing and Applications, July 9-12. pp. 792-797.
    5. Craglia, M., Annoni, A., Smith, R., & Smits, P. (2002). Spatial Data Infrastructures: Country Reports. Geographic Information Network in Europe, Retrieved from: https://www.geos.ed.ac.uk/~gisteac/proceedingsonline/Source%20Book%20200....
    6. DIRECTIVE 2007/2/EC OF THE EUROPEAN PARLIAMENT AND OF THE COUNCIL. Official Journal of the European Union, 2007. Retrieved from: https://eur-lex.europa.eu/legal-content/EN/TXT/PDF/?uri=CELEX:32007L0002....
    7. Elling, R. (2020). ERM Populating the INSPIRE Unique Identifier and Life-cycle Information. EuroGeographics Association.
    8. Elling, R., & Reichelt, A. (2019). Technical Producer Guide. EuroGeographics Association.
    9. Heipke, C., Kuittinen, R., & Nagel, G. (2003). From OEEPE to EuroSDR: 50 years of European Spatial Data Research and beyond. European Spatial Data Research, Retrieved from: http://www.eurosdr.net/sites/default/files/uploaded_files/eurosdr_public....
    10. INSPIRE Data Specification on Hydrography - Technical Guidelines. INSPIRE Thematic Working Group Hydrography, 2014. Retrieved from: https://inspire.ec.europa.eu/file/1729/download?token=LfNVPj1X.
    11. ISO 3166-1 alpha-2. IBAN. Retrieved from: https://www.iban.com/country-codes.
    12. Jakobsson, A., & Ilves, R. (2016). Reinventing the National Topographic Database. The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, P. 733-736.
    https://doi.org/10.5194/isprsarchives-XLI-B4-733-2016
  13. Karpinskyi, Y., & Lazorenko-Hevel, N. (2019). Topographic mapping in the National Spatial Data Infrastructure in Ukraine. THE 9TH INTERNATIONAL SCIENTIFIC-TECHNICAL CONFERENCE ENVIRONMENTAL ENGINEERING, PHOTOGRAMMETRY, GEOINFORMATICS Modern Technologies and Development Perspectives. Retrieved from: https://repositorio.ipbeja.pt/bitstream/20.500.12207/4927/1/Abstrats_284-285_eepg_tech_ksiazkastreszczen.pdf.
  14. The Law of Ukraine “On the National Spatial Data Infrastructure” (bill No. 2370), 13.04.2020. Retrieved from: http://w1.c1.rada.gov.ua/pls/zweb2/webproc34?id=&pf3511=67268&pf35401=525603.
  15. Lüscher, P. (2011). Characterising urban space from topographic databases: cartographic pattern recognition based on semantic modelling. Zurich Open Repository and Archive, University of Zurich. Retrieved from: https://www.zora.uzh.ch/id/eprint/164120/1/20121448.pdf.
  16. OS MasterMap Topographic Identifiers – TOIDs. Ordnance Survey, 2019. Retrieved from: https://www.ordnancesurvey.co.uk/business-government/tools-support/mastermap-topography-support/toids.
  17. Reitz, T. (2018). gml:id, gml:identifier and the InspireId. Clarifications and Best Practices Wetransform, 2018. Retrieved from: https://www.wetransform.to/news/2018/02/12/best-practices-for-inspire-ids/.