Ontop of Geospatial Databases

  • Konstantina Bereta
  • Manolis Koubarakis
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 9981)


We propose an OBDA approach for accessing geospatial data stored in relational databases, using the OGC standard GeoSPARQL and R2RML or OBDA mappings. We introduce extensions to an existing SPARQL-to-SQL translation method to support GeoSPARQL features. We describe the implementation of our approach in the system ontop-spatial, an extension of the OBDA system Ontop for creating virtual geospatial RDF graphs on top of geospatial relational databases. We present an experimental evaluation of our system using and extending a state-of-the-art benchmark. To measure the performance of our system, we compare it to a state-of-the-art geospatial RDF store and confirm its efficiency.


Spatial Filter Geospatial Data Triple Pattern Query Response Time Spatial Selection 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.



This work is partially supported by the EU projects Optique (318338) and MELODIES (603525). We would like to thank the Ontop development team for their support.


  1. 1.
    Open Geospatial Consortium: OpenGIS Simple Features Specification For SQL. OGC Implementation Standard (1999)Google Scholar
  2. 2.
    Open Geospatial Consortium: GeoSPARQL - A geographic query language for RDF data. OGC Candidate Implementation Standard (2012)Google Scholar
  3. 3.
    Bereta, K., Smeros, P., Koubarakis, M.: Representation and querying of valid time of triples in linked geospatial data. In: Cimiano, P., Corcho, O., Presutti, V., Hollink, L., Rudolph, S. (eds.) ESWC 2013. LNCS, vol. 7882, pp. 259–274. Springer, Heidelberg (2013)CrossRefGoogle Scholar
  4. 4.
    Brüggemann, S., Bereta, K., Xiao, G., Koubarakis, M.: Ontology-based data access for maritime security. In: Sack, H., Blomqvist, E., d’Aquin, M., Ghidini, C., Ponzetto, S.P., Lange, C. (eds.) ESWC 2016. LNCS, vol. 9678, pp. 741–757. Springer, Heidelberg (2016). doi: 10.1007/978-3-319-34129-3_45 CrossRefGoogle Scholar
  5. 5.
    Calvanese, D., Cogrel, B., Komla-Ebri, S., Kontchakov, R., Lanti, D., Rezk, M., Rodriguez-Muro, M., Xiao., G.: Ontop: answering SPARQL queries over relational databases. Semant. Web J. (2016, to appear)Google Scholar
  6. 6.
    Egenhofer, M.J.: A formal definition of binary topological relationships. In: Litwin, W., Schek, H.-J. (eds.) FODO 1989. LNCS, vol. 367, pp. 457–472. Springer, Heidelberg (1989). doi: 10.1007/3-540-51295-0_148 CrossRefGoogle Scholar
  7. 7.
    Garbis, G., Kyzirakos, K., Koubarakis, M.: Geographica: a benchmark for geospatial rdf stores (long version). In: Alani, H., et al. (eds.) ISWC 2013, Part II. LNCS, vol. 8219, pp. 343–359. Springer, Heidelberg (2013)CrossRefGoogle Scholar
  8. 8.
    Kyzirakos, K., Karpathiotakis, M., Koubarakis, M.: Strabon: a semantic geospatial DBMS. In: Cudré-Mauroux, P., et al. (eds.) ISWC 2012, Part I. LNCS, vol. 7649, pp. 295–311. Springer, Heidelberg (2012)CrossRefGoogle Scholar
  9. 9.
    Kyzirakos, K., Vlachopoulos, I., Savva, D., Manegold, S., Koubarakis, M.: Geotriples: a tool for publishing geospatial data as RDF graphs using R2RML mappings. In: Proceedings of the ISWC 2014 Posters & Demonstrations Track, Riva del Garda, Italy, October 21, 2014, pp. 393–396 (2014)Google Scholar
  10. 10.
    Nikolaou, C., Dogani, K., Bereta, K., Garbis, G., Karpathiotakis, M., Kyzirakos, K., Koubarakis, M.: Sextant: visualizing time-evolving linked geospatial data. J. Web Sem. 35, 35–52 (2015)CrossRefGoogle Scholar
  11. 11.
    Polleres, A.: From SPARQL to rules (and back). In: Proceedings of the 16th International Conference on World Wide Web, WWW 2007, pp. 787–796. ACM, New York (2007)Google Scholar
  12. 12.
    Priyatna, F., Corcho, O., Sequeda, J.: Formalisation and experiences of R2RML-based SPARQL to SQL query translation using Morph. In: Proceedings of the 23rd International Conference on World Wide Web, pp. 479–490. ACM (2014)Google Scholar
  13. 13.
    Randell, D.A., Cui, Z., Cohn, A.G.: A spatial logic based on regions and connection. In: Proceedings of the 3rd International Conference on Principles of Knowledge Representation and Reasoning (KR 1992), Cambridge, MA, October 25–29, 1992, pp. 165–176 (1992)Google Scholar
  14. 14.
    Rodriguez-Muro, M., Rezk, M.: Efficient SPARQL-to-SQL with R2RML mappings. J. Web Semant. 33(1), 141–169 (2015)CrossRefGoogle Scholar
  15. 15.
    Sequeda, J., Miranker, D.P.: Ultrawrap: SPARQL execution on relational data. J. Web Semant. 22, 19–39 (2013)CrossRefGoogle Scholar

Copyright information

© Springer International Publishing AG 2016

Authors and Affiliations

  1. 1.National and Kapodistrian University of AthensAthensGreece

Personalised recommendations