Should EU Land Use and Land Cover Data Be Managed with a NoSQL Document Store?

Should EU Land Use and Land Cover Data Be Managed with a NoSQL Document Store?

J.T. Navarro-Carrión B. Zaragozí A. Ramón-Morte N. Valcárcel-Sanz 

Instituto Interuniversitario de Geografía, Universidad de Alicante, Spain

Geodesy and Cartography Department, National Geographic Institute of Spain

| |
| | Citation



Land cover (LC) is a scientific landscape classification based on physical properties of earth materials. This information is usually retrieved through remote sensing techniques (e.g. forest cover, urban, clay content, among others). In contrast, Land use (LU) is defined from an anthropocentric point of view. It describes how a specific area is used (e.g. it is usual to indicate whether a territory supports an intensive, extensive use or it is unused). Both geospatial layers are essential inputs in many socio-economic and environmental studies. The INSPIRE directive provides technical data specifications for harmonization and sharing of voluminous LU/ LC datasets across all countries of the EU. The INSPIRE initiative proposes Object-Oriented Modelling as a data modelling methodology. However, the most used Geographic Information Systems (GIS) are built upon relational databases. This may jeopardize LU/LC data usability, since GIS practitioners will eventually face the object-relational impedance mismatch. In this paper, the authors introduce the SIOSE database (Spanish Land Cover and Land Use Information System), which was the first implementation of an object-oriented land cover and Land-use datamodel, in line with the recommendation of the INSPIRE Directive, separating both themes. SIOSE data can be downloaded as relational database files, where information describing each single LU/LC object is divided among several related tables, so database queries can be complex and time consuming. The authors show these technical complexities through a computational experience, comparing SQL and NoSQL databases for querying spatial data downloaded from SIOSE. Finally, the authors conclude that NoSQL geodatabases deserve to be further explored because they could scale for LU/LC data, both horizontally and vertically, better than relational geodatabases, improving usability and making the most of the EU harmonization efforts.


 Land Use, Land Cover, document store, SIOSE, geodatabase, PostgreSQL, jsonb


[1] Roces-Díaz, J.V., Díaz-Varela, E.R. & Álvarez-Álvarez, P., Analysis of spatial scales for ecosystem services: application of the lacunarity concept at landscape level in Galicia (NW Spain). Ecological Indicators, 36, pp. 495–507, 2014.

[2] Manakos, I. & Braun, M., Land Use and Land Cover Mapping in Europe, Springer London, 18, p. 411, 2014.

[3] Arnold, S., Kosztra, B., Banko, G., Smith, G., Hazeu, G. & Bock, M., The eagle concept a vision of a future European land monitoring framework. EARSeL Symposium Proceedings 2013, “Towards Horizon 2020”, 2013.

[4] Ireland, C., Bowers, D., Newton, M. & Waugh, K., A classification of object-relational impedance mismatch. Proceedings – 2009 1st International Conference on Advances in Databases, Knowledge, and Data Applications, DBKDA, pp. 36–43, 2009.

[5] Bartunov, O. & Sigaev, T., Binary storage for nested data structures and application to hstore data type. PostgreSQL Conference Europe 2013 Tals, 2013. Available at: http://www.sai.msu. su/~megera/postgres/talks/hstore-dublin-2013.pdf.

[6] Ray, S., Simion, B. & Demke Brown, A., Jackpine: a benchmark to evaluate spatial database performance. Proceedings International Conference on Data Engineering, pp. 1139–1150, 2011.

[7] Hellerstein, J.M., Stonebraker, M. & Hamilton, J., Architecture of a database system. Foundations and Trends in Databases, 1(2), pp. 141–259, 2007.

[8] Wang, J., Li, J. & Butler, G., Implementing the PostgreSQL query optimizer within the OPT++ framework. Proceedings Asia-Pacific Software Engineering Conference, APSEC, pp. 262–272, 2003.

[9] Boettiger, C., An introduction to Docker for reproducible research. ACM SIGOPS Operating Systems Review, 49(1), pp. 71–79, 2015.