Harmonise and integrate heterogeneous areal data with the R package arealDB

[en] 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. Incon sistent 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.

Research center :

Luxembourg Centre for Socio-Environmental Systems (LCSES)

Disciplines :

Environmental sciences & ecology
Earth sciences & physical geography
Computer science

Author, co-author :

Ehrmann, Steffen

SEPPELT, Ralf ; University of Luxembourg > Luxembourg Centre for Socio-Environmental Systems (LCSES)

Meyer, Carsten

External co-authors :

yes

Language :

English

Title :

Harmonise and integrate heterogeneous areal data with the R package arealDB

Publication date :

2020

Journal title :

Environmental Modelling and Software

ISSN :

1364-8152

Publisher :

Elsevier, Nl

Volume :

133

Pages :

104799

Peer reviewed :

Peer Reviewed verified by ORBi

Additional URL :

https://linkinghub.elsevier.com/retrieve/pii/S1364815220307751

Available on ORBilu :

since 23 November 2025

Statistics

Number of views

4 (2 by Unilu)

Number of downloads

0 (0 by Unilu)

More statistics

Scopus citations^®

Scopus citations^®
without self-citations

OpenCitations

OpenAlex citations

Bibliography

Baumer, Benjamin S., A grammar for reproducible and painless extract-transform-load operations on medium data. J. Comput. Graph Stat. 28:2 (2017), 256–264, 10.1080/10618600.2018.1512867.
Bernard, Camille, Plumejeaud-Perreau, Christine, Villanova-Oliver, Marlène, Gensel, Jérôme, Dao, Hy, An ontology-based algorithm for managing the evolution of multi-level territorial partitions. Proceedings of the 26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, 2018, ACM, 456–459, 10.1145/3274895.3274944.
Codd, E.F., The Relational Model for Database Management: Version 2. 1990, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, USA 0-201-14192-2.
De Giacomo, Giuseppe, Lembo, Domenico, Lenzerini, Maurizio, Poggi, Antonella, Rosati, Riccardo, Using ontologies for semantic data integration. A Comprehensive Guide through the Italian Database Research over the Last 25 Years, 2018, Springer 978-3-319-61892-0, 187–202, 10.1007/978-3-319-61893-7_11 05.
Debroy, Vidroha, Brimble, Lance, Matt, Yost, Newtl: engineering an extract, transform, load (etl) software system for business on a very large scale. Proceedings of the 33rd Annual ACM Symposium on Applied Computing, 2018, ACM, 1568–1575.
Du, Heshan, Alechina, Natasha, Jackson, Mike, Hart, Glen, Matching formal and informal geospatial ontologies. Geographic Information Science at the Heart of Europe, 2013, Springer, 155–171, 10.1007/978-3-319-00615-4_9 https://link.springer.com/chapter/10.1007/978-3-319-00615-4_9.
Ehrmann, Steffen, Rümmler, Arne, tabshiftr: Reshape Disorganised Messy Data. https://cran.r-project.org/web/packages/tabshiftr/index.html, 2020 R package version 0.1.2.
Ehrmann, Steffen, geometr: Generate and Modify Interoperable Geometric Shapes. https://cran.r-project.org/web/packages/geometr/index.html, 2020 R package version 0.2.5.
Faostat FAO. http://www.fao.org/faostat, 2019.
Geonames GeoNames, http://www.geonames.org, 2019.
Guralnick, Robert, Walls, Ramona, Walter, Jetz, Humboldt core–toward a standardized capture of biological inventories for biodiversity monitoring, modeling and assessment. Ecography 41:5 (2018), 713–725 https://onlinelibrary.wiley.com/doi/full/10.1111/ecog.02942.
Henzen, Christin, Mäs, Stephan, Bernard, Lars, Provenance information in geodata infrastructures. 05 Geographic Information Science at the Heart of Europe, vol. 2013, 2013, Springer International Publishing 978-3-319-00615-4, 133–151, 10.1007/978-3-319-00615-4_8 doi: 10.1007/978-3-319-00615-4_8.
Hijmans, Robert J., Global administrative areas. www.gadm.org, 2019.
Horridge, M., A Practical Guide to Building Owl Ontologies Using Protégé 4 and Co-ode Tools Edition 1.3. 2011 retrieved march 10, 2013.
Horton, T., Kroh, A., Ahyong, S., Bailly, N., Boyko, C.B., Brandão, S.N., Gofas, S., Hooper, J.N.A., Hernandez, F., Holovachov, O., Mees, J., Molodtsova, T.N., Paulay, G., Decock, W., Dekeyzer, S., Lanssens, T., Vandepitte, L., Vanhoorne, B., Verfaille, K., Adlard, R., Adriaens, P., Agatha, S., Ahn, K.J., Akkari, N., Alvarez, B., Anderson, G., Angel, M.V., Arango, C., Artois, T., Atkinson, S., Bank, R., Barber, A., Barbosa, J.P., Bartsch, I., Bellan-Santini, D., Bernot, J., Berta, A., Bezerra, T.N., Bieler, R., Blanco, S., Blasco-Costa, I., Blazewicz, M., Bock, P., Böttger-Schnack, R., Bouchet, P., Boury-Esnault, N., Boxshall, G., Bray, R., Breure, B., Bruce, N.L., Cairns, S., Cárdenas, P., Carstens, E., Chan, B.K., Chan, T.Y., Cheng, L., Churchill, M., Coleman, C.O., Collins, A.G., Corbari, L., Cordeiro, R., Cornils, A., Coste, M., Costello, M.J., Crandall, K.A., Cremonte, F., Cribb, T., Cutmore, S., Dahdouh-Guebas, F., Daly, M., Daneliya, M., Dauvin, J.C., Davie, P., De Broyer, C., De Grave, S., de Mazancourt, V., de Voogd, N.J., Decker, P., Decraemer, W., Defaye, D., d'Hondt, J.L., Dippenaar, S., Dohrmann, M., Dolan, J., Domning, D., Downey, R., Ector, L., Eisendle-Flöckner, U., Eitel, M., Encarnação, S.C.d., Enghoff, H., Epler, J., Ewers-Saucedo, C., Faber, M., Feist, S., Figueroa, D., Finn, J., Fišer, C., Fordyce, E., Foster, W., Frank, J.H., Fransen, C., Furuya, H., Galea, H., Garcia-Alvarez, O., Garic, R., Gasca, R., Gaviria-Melo, S., Gerken, S., Gibson, D., Gibson, R., Gil, J., Gittenberger, A., Glasby, C., Glover, A., Gómez-Noguera, S.E., González-Solís, D., Gordon, D., Grabowski, M., Gravili, C., Guerra-García, J.M., Guidetti, R., Guiry, M.D., Hadfield, K.A., Hajdu, E., Hallermann, J., Hayward, B.W., Hendrycks, E., Herbert, D., Herrera Bachiller, A., Ho, J.s., Hodda, M., Høeg, J., Hoeksema, B., Houart, R., Hughes, L., Hyžný, M., Iniesta, L.F.M., Iseto, T., Ivanenko, S., Iwataki, M., Janssen, R., Jarms, G., Jaume, D., Jazdzewski, K., Jersabek, C.D., Jóźwiak, P., Kabat, A., Kantor, Y., Karanovic, I., Karthick, B., Kim, Y.H., King, R., Kirk, P.M., Klautau, M., Kociolek, J.P., Köhler, F., Kolb, J., Kotov, A., Kremenetskaia, A., Kristensen, R.M., Kulikovskiy, M., Kullander, S., Lambert, G., Lazarus, D., Le Coze, F., LeCroy, S., Leduc, D., Lefkowitz, E.J., Lemaitre, R., Liu, Y., Lörz, A.N., Lowry, J., Ludwig, T., Lundholm, N., Macpherson, E., Madin, L., Mah, C., Mamo, B., Mamos, T., Manconi, R., Mapstone, G., Marek, P.E., Marshall, B., Marshall, D.J., Martin, P., Mast, R., McFadden, C., McInnes, S.J., Meidla, T., Meland, K., Merrin, K.L., Messing, C., Miljutin, D., Mills, C., Moestrup, Ø., Mokievsky, V., Monniot, F., Mooi, R., Morandini, A.C., Moreira da Rocha, R., Moretzsohn, F., Morrow, C., Mortelmans, J., Mortimer, J., Musco, L., Neubauer, T.A., Neubert, E., Neuhaus, B., Ng, P., Nguyen, A.D., Nielsen, C., Nishikawa, T., Norenburg, J., O'Hara, T., Opresko, D., Osawa, M., Osigus, H.J., Ota, Y., Páll-Gergely, B., Patterson, D., Paxton, H., Peña-Santiago, R., Perrier, V., Perrin, W., Petrescu, I., Picton, B., Pilger, J.F., Pisera, A.B., Polhemus, D., Poore, G.C., Potapova, M., Pugh, P., Read, G., Reich, M., Reimer, J.D., Reip, H., Reuscher, M., Reynolds, J.W., Richling, I., Rimet, F., Ríos, P., Rius, M., Rogers, D.C., Rosenberg, G., Rützler, K., Sabbe, K., Saiz-Salinas, J., Sala, S., Santagata, S., Santos, S., Sar, E., Satoh, A., Saucède, T., Schatz, H., Schierwater, B., Schmidt-Rhaesa, A., Schneider, S., Schönberg, C., Schuchert, P., Senna, A.R., Serejo, C., Shaik, S., Shamsi, S., Sharma, J., Shear, W.A., Shenkar, N., Shinn, A., Short, M., Sicinski, J., Sierwald, P., Simmons, E., Sinniger, F., Sivell, D., Sket, B., Smit, H., Smit, N., Smol, N., Souza-Filho, J.F., Spelda, J., Sterrer, W., Stienen, E., Stoev, P., Stöhr, S., Strand, M., Suárez-Morales, E., Summers, M., Suppan, L., Suttle, C., Swalla, B.J., Taiti, S., Tanaka, M., Tandberg, A.H., Tang, D., Tasker, M., Taylor, J., Taylor, J., Tchesunov, A., ten Hove, H., ter Poorten, J.J., Thomas, J.D., Thuesen, E.V., Thurston, M., Thuy, B., Timi, J.T., Timm, T., Todaro, A., Turon, X., Tyler, S., Uetz, P., Uribe-Palomino, J., Utevsky, S., Vacelet, J., Vachard, D., Vader, W., Väinölä, R., Van de Vijver, B., van der Meij, S.E., van Haaren, T., van Soest, R.W., Vanreusel, A., Venekey, V., Vinarski, M., Vonk, R., Vos, C., Walker-Smith, G., Walter, T.C., Watling, L., Wayland, M., Wesener, T., Wetzel, C.E., Whipps, C., White, K., Wieneke, U., Williams, D.M., Williams, G., Wilson, R., Witkowski, A., Witkowski, J., Wyatt, N., Wylezich, C., Xu, K., Zanol, J., Zeidler, W., Zhao, Z., World register of marine species (worms). http://www.marinespecies.org, 2019 http://www.marinespecies.org Accessed: 2019-09-11.
IUCN. The iucn red list of threatened species. http://www.iucnredlist.org, 2019.
Keil, Petr, Chase, Jonathan M., Global patterns and drivers of tree diversity integrated across a continuum of spatial grains. Nat. Ecol. Evol., 3(3), 2019, 390, 10.1038/s41559-019-0799-0.
Kreft, Holger, Walter, Jetz, Global patterns and determinants of vascular plant diversity. Proc. Natl. Acad. Sci. Unit. States Am., 2007, 10.1073/pnas.0608361104 https://www.pnas.org/content/104/14/5925.
Lemmen, Christiaan, Van Oosterom, Peter, Bennett, Rohan, The land administration domain model. Land Use Pol. 49 (2015), 535–545, 10.1016/j.landusepol.2015.01.014 https://www.sciencedirect.com/science/article/pii/S0264837715000174?via%3Dihub.
Lowndes, Julia S Stewart, Best, Benjamin D., Scarborough, Courtney, C Afflerbach, Jamie, Frazier, Melanie R., O'Hara, Casey C., Jiang, Ning, Halpern, Benjamin S., Our path to better science in less time using open data science tools. Nat. Ecol. Evol. 1:6 (2017), 1–7, 10.1038/s41559-017-0160.
Otto, Ilona M., Biewald, Anne, Coumou, Dim, Feulner, Georg, Köhler, Claudia, Nocke, Thomas, Anders, Blok, Albert, Gröber, Sabine Selchow, Tyfield, David, et al. Socio-economic data for global environmental change research. Nat. Clim. Change, 5(6), 2015, 503, 10.1038/nclimate2593 https://www.nature.com/articles/nclimate2593.pdf.
Pebesma, Edzer, Simple features for R: standardized support for spatial vector data. The R Journal 10:1 (2018), 439–446, 10.32614/rj-2018-009 doi: 10.32614/RJ-2018-009.
Petersen, Anne Helby, Ekstrøm, Claus Thorn, datamaid: your assistant for documenting supervised data quality screening in r. J. Stat. Software 90:1 (2019), 1–38.
The Plant List. The plant list. http://www.theplantlist.org, 2013 Version 1.1.
van den Brink, Linda, Janssen, Paul, Quak, Wilko, Stoter, Jantien, Towards a high level of semantic harmonisation in the geospatial domain. Comput. Environ. Urban Syst. 62 (2017), 233–242, 10.1016/j.compenvurbsys.2016.12.002.
Wickham, Hadley, Tidy data. J. Stat. Software 59:10 (2014), 1–23, 10.18637/jss.v059.i10 https://www.jstatsoft.org/article/view/v059i10.
Wieczorek, John, Bloom, David, Guralnick, Robert, Blum, Stan, Döring, Markus, Giovanni, Renato, Robertson, Tim, Vieglais, David, Darwin core: an evolving community-developed biodiversity data standard. PloS One, 7(1), 2012, 10.1371/journal.pone.0029715 e29715 https://journals.plos.org/plosone/article/file?id=10.1371/journal.pone.0029715&type=printable.