State Office for Nature, Environment and Consumer Protection North Rhine-Westphalia: INSPIRE data harmonization - using FME INSPIRE Solution Pack

  • Author
    Antje KÜGELER
  • Post date: 
    30 Sep 2016
  • Last modified: 
    30 Sep 2016
  • Country: 
    Germany
  • Themes: 
    • Protected sites
  • Content needs review

    Fulfillment of INSPIRE targets, aiming the data harmonization and schema translation from existing data to an INSPIRE compliant data model. The main challenge and project focus was to describe this process semantically and to implement translation rules which can perform the transformation of the entire source dataset. The project covers all essential steps: the data harmonization process in the primary system for data management and storage, the transformation of primary data to INSPIRE compliant data structures and the publishing of INSPIRE View and Download Services for the protected sites data in the geoportal of NRW.

    Based on the INSPIRE Solution Pack for FME the complete schema mapping and translation process for protected sites (full and simple schema) could be described and implemented. Starting with FME Workbench templates which are predefined for the specific INSPIRE Annex theme it was possible to connect the complex OSIRIS source data model of the nature conservation data of NRW to the INSPIRE Geodatabase of ArcGIS for INSPIRE. After completing the data integration process publishing of the INSPIRE View and Download Services could be efficiently authored and administrated using ArcGIS for INSPIRE. This step was technically implemented by IT.NRW, the central IT service provider of the federal state of North Rhine-Westphalia. The services and the underlying data were published in the geoportal of North Rhine Westphalia (www.geoportal.nrw.de).

    Extracting the full information of this complex source data set was easy due to the flexibility of the used FME technology. The semantic aspects of the mappings and the documentation were mainly delivered through an iterative process between the technical specialists and the domain experts which is a common approach for INSPIRE data harmonization projects. For the complex mapping process, a reusable custom OSIRIS format reader was created in FME to encapsulate the format-specific complexity from the semantic mapping of the INSPIRE attributes. After the initial definition of the mapping description, updates can automatically be processed, guaranteeing also that the INSPIRE services based on that data will be up to date.
    ArcGIS for INSPIRE as a commercial of the shelf software provides an easy workflow for publishing INSPIRE network services. It is fully integrated into the existing Esri-based infrastructure and offers many advanced capabilities.
    One of the main benefits is the usage of a standardized database storage which makes INSPIRE data also available for other web and desktop applications, business processes and complex workflows. The data integration part is described and performed at the feature level using the INSPIRE Solution Pack for FME which reduces the complexity of this task. GML creation, validation and Geodatabase design is covered by ArcGIS for INSPIRE, thus hidden from the customer, enormously simplifying the provision and administration of INSPIRE Network services.

    The specified INSPIRE data harmonization workflow is one of the first solutions which describes the complete process from existing data to the annex I theme “protected sites”. It covers all essential steps and greatly reduces the complexity of this task.