Publication Details

Category Text Publication
Reference Category Journals
DOI 10.1016/j.envsoft.2020.104799
Document author version
Title (Primary) Harmonise and integrate heterogeneous areal data with the R package arealDB
Author Ehrmann, S.; Seppelt, R.; Meyer, C.
Source Titel Environmental Modelling & Software
Year 2020
Department CLE
Volume 133
Page From art. 104799
Language englisch
Keywords Interoperability; Census data; Indicator data; Polygon data; Data warehouse; Provenance documentation

Many relevant applications in the environmental and socioeconomic sciences use areal data, such as biodiversity checklists, agricultural statistics, or socioeconomic surveys. For applications that surpass the spatial, temporal or thematic scope of any single data source, data must be integrated from several heterogeneous sources. Inconsistent concepts, definitions, or messy data tables make this a tedious and error-prone process. To date, a dedicated tool to address these challenges is still lacking.

Here, we introduce the R package arealDB that integrates heterogeneous areal data and associated geometries into a consistent database, in an easy-to-use workflow. It is useful for harmonising language and semantics of variables, relating data to geometries, and documenting metadata and provenance. We illustrate the functionality by integrating two disparate datasets (Brazil, USA) on the harvested area of soybean. arealDB promises quality-improvements to downstream scientific, monitoring, and management applications but also substantial time-savings to database collation efforts.

Persistent UFZ Identifier
Ehrmann, S., Seppelt, R., Meyer, C. (2020):
Harmonise and integrate heterogeneous areal data with the R package arealDB
Environ. Modell. Softw. 133 , art. 104799 10.1016/j.envsoft.2020.104799