In order to employ the Web as a medium for data and information integration, comprehensive datasets and vocabularies are required as they enable the disambiguation and alignment of other data and information. Many real-life information integration and aggregation tasks are impossible without comprehensive background knowledge related to spatial features of the ways, structures and landscapes surrounding us. One of the central projects in this area is LinkedGeoData, in which data from OpenStreetMap is converted to RDF and linked to other knowledge bases. We designed a virtual mapping approach that allows to rewrite an incoming SPARQL query into a single SQL query potentially containing virtual spatial predicates. At that time, this was novel and allowed us to scale to a dataset with more than 30 billion facts, more than 1000 updates per minute and a semi-automatically generated ontology. Later on, in the GeoKnow EU project, we – together with other partners – build a landscape of tools to facilitate the entire life cycle of spatial data including the stages shown below.
Figure: The Linked Data Life Cycle implemented in the GeoKnow EU project (2012-2015)