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.
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.
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 terminologyFlagging and removal of invalid or non-interpretable information, followed by data amendments (e.g., correct transposed coordinates and standardize country names).
bdc_scientificName_empty()
Identification of records lacking names or with names not interpretablebdc_coordinates_empty()
Identification of records lacking information on latitude or longitudebdc_coordinates_outOfRange()
Identification of records with out-of-range coordinates (latitude > 90 or -90; longitude >180 or -180)bdc_basisOfRecords_notStandard()
Identification of records from doubtful sources (e.g., fossil or machine observation) impossible to interpret and not compatible with Darwin Core recommended vocabularybdc_country_from_coordinates()
Derive country name from valid geographic coordinatesbdc_country_standardized()
Standardization of country names and retrieve country codebdc_coordinates_transposed()
Identification of records with potentially transposed latitude and longitudebdc_coordinates_country_inconsistent()
Identification of coordinates in other countries or far from a specified distance from the coast of a reference country (i.e., in the ocean)bdc_coordinates_from_locality()
Identification of records lacking coordinates but with a detailed description of the locality associate with records from which coordinates can be derivedCleaning, 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 componentsbdc_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”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 placesclean_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 outliersFlagging 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 datesAim 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 processbdc_create_figures()
Creation of figures (i.e., bar plots and maps) reporting the results of data-quality testsbdc_filter_out_flags()
Removal of columns containing the results of data quality tests (i.e., column starting with “.”) or other columns specifiedbdc_quickmap()
Creation of a map of points using ggplot2. Helpful in inspecting the results of data-cleaning testsbdc_summary_col()
This function creates or updates the column summarizing the results of data quality tests (i.e., the column “.summary”)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
.
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 the binary file gnparser
from .zip
or .gz
files and move it to the folder ~/bin
. Move the file manually or using R:
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)
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:
See bdc package website (https://brunobrr.github.io/bdc/) for detailed explanation on each module.
If you encounter a clear bug, please file an issue here. For questions or suggestion, please send us a email (ribeiro.brr@gmail.com).
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