T2.2 – Integration with external geospatial databases
This task implements ETL flows for importing data from external GIS. The GIS may be accessed via Virtuoso SQL federation, RDB-RDF mapping tools, such as Sparqlify, or web services or by simple file loading from a staging area. The goal is to make import of diversely standards compliant and diversely modelled geodata as nearly automatic as possible. Thereby possible workflows for dealing with updates on the source datasets will be analysed. For example, updates on small datasets may be published as files containing the complete new version of the dataset in monthly intervals. In contrast, providers of large datasets, such as OpenStreetMap, additionally publish files with minutely incremental changes. Alternatively, datasets may for instance already be published in SPARQL endpoints. This analysis will from a basis for the establishment of update processes that serve use cases of the project. In the process, performance of the Virtuoso GIS implementation will be tested and improvement targets identified.
Deliverables
D2.2.1 | Integration of external geospatial databases |