A toolkit for standardizing, integrating, and cleaning biodiversity data

Overview

Handle biodiversity data from several different sources is not an easy task. Here, we present the Biodiversity Data Cleaning (bdc), an R package to address quality issues and improve the fitness-for-use of biodiversity datasets. bdc contains functions to harmonize and integrate data from different sources following common standards and protocols, and implements various tests and tools to flag, document, clean, and correct taxonomic, spatial, and temporal data.

Compared to other available R packages, the main strengths of the bdc package are that it brings together available tools – and a series of new ones – to assess the quality of different dimensions of biodiversity data into a single and flexible toolkit. The functions can be applied to a multitude of taxonomic groups, datasets (including regional or local repositories), countries, or worldwide.

Structure of bdc

The bdc toolkit is organized in thematic modules related to different biodiversity dimensions.


⚠️ The modules illustrated, and functions within, were linked to form a proposed reproducible workflow (see vignettes). However, all functions can also be executed independently.



1. Merge databases

Standardization and integration of different datasets into a standard database.

  • bdc_standardize_datasets() Standardization and integration of different datasets into a new dataset with column names following Darwin Core terminology

2. Pre-filter

Flagging and removal of invalid or non-interpretable information, followed by data amendments (e.g., correct transposed coordinates and standardize country names).

3. Taxonomy

Cleaning, parsing, and harmonization of scientific names against multiple taxonomic references.

  • bdc_clean_names() Name-checking routines to clean and split a taxonomic name into its binomial and authority components
  • bdc_query_names_taxadb() Harmonization of scientific names by correcting spelling errors and converting nomenclatural synonyms to currently accepted names.
  • bdc_filter_out_names() Function used to filter out records according to their taxonomic status present in the column “notes”. For example, to filter only valid accepted names categorized as “accepted”

4. Space

Flagging of erroneous, suspicious, and low-precision geographic coordinates.

  • bdc_coordinates_precision() Identification of records with a coordinate precision below a specified number of decimal places
  • clean_coordinates() (From CoordinateCleaner package and part of the data-cleaning workflow). Identification of potentially problematic geographic coordinates based on geographic gazetteers and metadata. Include tests for flagging records: around country capitals or country or province centroids, duplicated, with equal coordinates, around biodiversity institutions, within urban areas, plain zeros in the coordinates, and suspect geographic outliers

5. Time

Flagging and, whenever possible, correction of inconsistent collection date.

  • bdc_eventDate_empty() Identification of records lacking information on event date (i.e., when a record was collected or observed)
  • bdc_year_outOfRange() Identification of records with illegitimate or potentially imprecise collecting year. The year provided can be out-of-range (e.g., in the future) or collected before a specified year supplied by the user (e.g., 1900)
  • bdc_year_from_eventDate() This function extracts four-digit year from unambiguously interpretable collecting dates

Other functions

Aim to facilitate the documentation, visualization, and interpretation of results of data quality tests the package contains functions for documenting the results of the data-cleaning tests, including functions for saving i) records needing further inspection, ii) figures, and iii) data-quality reports.

  • bdc_create_report() Creation of data-quality reports documenting the results of data-quality tests and the taxonomic harmonization process
  • bdc_create_figures() Creation of figures (i.e., bar plots and maps) reporting the results of data-quality tests
  • bdc_filter_out_flags() Removal of columns containing the results of data quality tests (i.e., column starting with “.”) or other columns specified
  • bdc_quickmap() Creation of a map of points using ggplot2. Helpful in inspecting the results of data-cleaning tests
  • bdc_summary_col() This function creates or updates the column summarizing the results of data quality tests (i.e., the column “.summary”)

Installation

Gnparser installation

Previously to bdc installation is necessary to install GNparser. First, download the binary file of gnparser for your operational system. For example, download the file using R as follow:


download.file(url = "file_link", 
              destfile = "destination_path")

The downloaded file has extensions .zip or .gz.

Mac OS

Extract the binary file gnparser from .zip or .gz files and move it to the folder ~/Library/Application Support/. Move the file manually or using R:


# Extract gnparser file
untar("~/Downloads/gnparser-v1.9.1-linux.tar.gz")

# Move to the path
file.copy("./gnparser", "~/Library/Application Support/")

Linux

Extract the binary file gnparser from .zip or .gz files and move it to the folder ~/bin. Move the file manually or using R:


# Extract gnparser file
untar("~/Downloads/gnparser-v1.9.1-linux.tar.gz")

# Move to the path
file.copy("./gnparser",  "~/bin")

Windows

In Windows, extract the binary file gnparser from .zip. Then, move gnparser file to the folder Appdata. To find the Appdata path, run this in R:


# Unzip the downloaded file
unzip(gnparser.zip, exdir = "destination_path/gnparser")

# Find the AppData path
AppData_path <- Sys.getenv("AppData")

# Copy gnparser to AppData

file.copy("destination_path/gnparser", AppData_path, recursive = TRUE)

bdc installation

After installing Gnparser, you can install bdc from CRAN:

install.packages("bdc")
library(taxadb)

or the development version from GitHub using:

install.packages("remotes")
remotes::install_github("brunobrr/bdc")

Load the package with:

Package website

See bdc package website (https://brunobrr.github.io/bdc/) for detailed explanation on each module.

Getting help

If you encounter a clear bug, please file an issue here. For questions or suggestion, please send us a email ().

Citation

Ribeiro, BR; Velazco, SJE; Guidoni-Martins, K; Tessarolo, G; Jardim, Lucas; Bachman, SP; Loyola, R (2022). bdc: A toolkit for standardizing, integrating, and cleaning biodiversity data. Methods in Ecology and Evolution. doi.org/10.1111/2041-210X.13868