| START Conference Manager |
(Submission #274)
In the European Location Framework (ELF) project, several INSPIRE compatible download services have been implemented in various countries. Finnish ELF services currently cover 11 INSPIRE themes.
In the National Land Survey of Finland, the key idea was to develop ELF download services without using any commercial software. We selected PostgreSQL with PostGIS as the database solution. The download services were published with Deegree, an open source software providing a ready-made INSPIRE template.
However, a suitable open source tool for complex data model transformations was not available. Thus, we developed ELFLoader, a Java based software executing an Extract-Transform-Load (ETL) process. The information stored in the National Topographic Database is transformed to match the INSPIRE schemas and loaded into an empty PostgreSQL database.
Adding new feature types to ELFLoader is easy and does not require changes in the core code. The ETL process is executed once a week to keep the database up-to-date. Only new, removed and modified features are handled in the weekly updates. ELFLoader will be developed further to be used when implementing the national INSPIRE services.
In this presentation, lessons learned during the implementation of ELF download services are discussed. Furthermore, both successful and unsuccessful steps in the development of ELFLoader are presented.
Topic Area: [2.2] Technologies and tools required to deliver INSPIRE Abstract Type: Oral Presentation
Comments: data model transformation, download service, ELF, WFS
START Conference Manager (V2.61.0 - Rev. 4195)