INSPIRE KEN & EuroSDR workshop

 

INSPIRE KEN and EuroSDR workshop « schema transformation »

 

INSPIRE KEN ad EroSDR held a workshop about schema transformation tools and methods in Marne-la-Vallée (France) on 8 and 9 October 2013. This workshop was supported by EuroGeographics and EuroSDR.

Schema transformation will be the main way to make NMCA data compliant with INSPIRE rules regarding interoperability of spatial data sets. Consequently, choice of relevant method and tool(s) is a key topic for NMCAs and more generally to any public body having data within scope of INSPIRE.

More than 50 persons attended the workshop, both data producers (NMCAs) and software providers.

 

The first morning was devoted to general presentations, mainly about methods. Marie-Lise Vautier presented general concepts about schema transformation (at conceptual or logical/physical level, on-line / off-line / combined methods, examples of elementary transformations).Thorsten Reitz (Humboldt project) presented a state-of-play of schema transformation languages with their assessment against various criteria (expressivity, verbosity, primary representation graphical or textual, …). Frank Arnsten presented the different methods to make schema transformation from internal database to WFS with their advantages and drawbacks.

Lassi Lehto presented the results of the ESDIN project regarding schema transformation /download services. One of the methods more widely used was to make transformation under DataBase Management System to a relational pseudo-INSPIRE database and then to export the result to WFS. The export to WFS has to be specified: this may be done using the APP schema, a plug-in of GeoServer, presented by Marie Lambois. The structure of the relational pseudo-INSPIRE database has also to be defined: this may be done by the Map Builder tool, a tool developed by the Politecnico di Milano and presented par Dominique Laurent.

During the ESDIN project, degree was widely used as WFS. Sebastian Goerke presented more in details how degree may be used for INSPIRE.

 

 Presenter  Title  Size [MB]  YouTube
Dominique Laurent Introduction 4 Video
Marie-Lise Vautier Schema transformation concepts 8 Video
Thorsten Reitz Schema transformation languages 2.5 Video
Morten Borrebaek, Frank Arnsten TransformationArchitecture 4 Video
Lassi Lehto ESDIN results 9 Video
Marie Lambois GeoServer-AppSchema 1.5 Video
Dominique Laurent Schema Browser 1.5 Video
Sebastian Goerke Deegree 1.9 n/a

 

The first afternoon was devoted to non-commercial tools. Just van den Broecke presented XSLT, a widely used transformation language and Stetl a tool used by Kadaster and encapsulating several other tools (XLST, ogr2ogr, PostGre). Jean-Loup Delaveau presented his experience about making French data compliant with INSPIRE theme Land Use, using Talend. Edith Vautard presented her experience, using GeoKettle to transform IGN data into INSPIRE Administrative Units schema.

Thosten Reitz presented HALE (Humboldt Alignment Editor). François Tertre presented exoMS, a tool developed by BRGM (French Geological Survey). Pedro Mendive Lerendigui presented GeoConcerter, a tool developed by TRACASA. Tatjana Kutzner presented mdWFS, a tool under development by a research project.

The day ended by a discussion about “what should be the main drivers for schema transformation” and by a summary of the main findings of the day.

 Presenter  Title  Size [MB]  YouTube
Just van den Broecke XSLT 14 Video
Just van den Broecke Stetl 6 n/a
Jean-Loup Delaveau Talend 1 Video
Edith Vautard GeoKettle 1.31 Video
Thorsten Reitz HALE 1.63 Video
François Tertre eXows 2.32 Video
Pedro Mendive Lerendigui GeoConverter 2.6 Video
Tatjana Kutzner mdWFS 1.9 Video
all Minutes discussion day 1 .32 Video
Marie Lambois Conclusions-day 1 .1 Video

 

The second morning was devoted to commercial tools. Ken Bragg (SAFE software) presented FME and its new functionalities regarding INSPIRE. Paul Hardy (ESRI) presented the suite Arc GIS for INSPIRE. Richard Rombouts presented the tool Go Publisher of Snowflakes.

Helen Eriksson presented the use of AltovaMapForce by Lantmateriät during the test of INSPIRE specifications. Yohann Ly presented the Intergraph solution for mass data harmonization process; his presentation was followed by an example of use from Gugik (Poland). Bob Chell presented the 1Spatial solution: the rule based tool RadiusStudio.

 Presenter  Title  Size [MB]  YouTube
Ken Bragg FME_K 4.19 Video
Paul Hardy ESRI 12 Video
Richard Rombouts Snowflake Software 1.4 Video
Helen Eriksson Altova MapForce 1.29 Video
Yohann Ly Intergraph_Y.Ly 3 Video
Zenon Parzynski Intergraph-Gugik 1.3  
Bob Chell RadiusStudio 3 Video

  

The second afternoon was devoted to research and future. It included a presentation from Sandrine Balley about the projects of COGIT (the IGN research laboratory  on vector data) that aim to involve semantics in schema transformation and a presentation from Robin Smith (JRC) about the ARE3NA project that aims to register the reusable components to implement INSPIRE and to identify the missing ones. This was followed by a discussion about what is missing regarding schema transformation and then, more generally, what is missing to implement INSPIRE.

Conclusion of second day was provided by Nathalie Delattre.

 Presenter  Title  Size [MB]  YouTube
Sandrine Balley Involving semantics 3 Video
Robin Smith ARE3NA_R 2 Video
all Minutes discussion day 2 41 Video
Nathalie Delattre Day2Conclusions 41 Video