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.
|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|
|Dominique Laurent||Schema Browser||1.5||Video|
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.
|Just van den Broecke||XSLT||14||Video|
|Just van den Broecke||Stetl||6||n/a|
|Pedro Mendive Lerendigui||GeoConverter||2.6||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.
|Richard Rombouts||Snowflake Software||1.4||Video|
|Helen Eriksson||Altova MapForce||1.29||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.
|Sandrine Balley||Involving semantics||3||Video|
|all||Minutes discussion day 2||41||Video|