This repository contains the FishGlob database, including the methods to load, clean, and process the public bottom trawl surveys in it. The database is described in the manuscript, "An integrated database of fish biodiversity sampled with scientific bottom trawl surveys" by Aurore A. Maureaud, Juliano Palacios-Abrantes, Zoë Kitchel, Laura Mannocci, Malin L. Pinsky, Alexa Fredston, Esther Beukhof, Daniel L. Forrest, Romain Frelat, Maria L.D. Palomares, Laurene Pecuchet, James T. Thorson, P. Daniël van Denderen, and Bastien Mérigot.
This database is a product of the CESAB working group, FishGlob: Fish biodiversity under global change – a worldwide assessment from scientific trawl surveys.
Main contacts: Aurore A. Maureaud, Juliano Palacios-Abrantes, Zoë J. Kitchel, and Malin L. Pinsky
Anyone interested in reusing this data or its outputs should read this readme as well as our Data Disclaimer in full.
This work is licensed under a Creative Commons Attribution 4.0 International License.
- cleaning_codes includes all scripts to process and perform quality control on the trawl surveys.
- data_descriptor_figures contains the R script to construct figures 2-4 for the data descriptor manuscript.
- functions contains useful functions used in other scripts
- length_weight contains the length-weight relationships for surveys where weights have to be calculated from abundance at length data (including NOR-BTS and DATRAS)
- metadata_docs has a README with notes about each survey. This is a place to document changes in survey methods, quirks, etc. It is a growing list. If you have information to add, please open an Issue.
- outputs contains all survey data processed .RData files and flagging outputs
- QAQC contains the additional QAQC performed on surveys that required supplementary checks (DATRAS-sourced surveys)
- standard_formats includes definitions of file formats in the FishGlob database, including survey ID codes.
- standardization_steps contains the R codes to run a full survey standardization and a cross-survey summary of flagging methods
- summary contains the quality check plots for each survey
Data processing and cleaning is done on a per survey basis unless formats are similar across a group of surveys. The current repository can process 29 scientific bottom-trawl surveys, according to the following steps.
Steps
- Merge the data files for one survey
- Clean & homogenize column names following the format described in standard_formats/fishglob_data_columns.xlsx
- Create missing columns and standardize units using the standard format standard_formats/fishglob_data_columns.xlsx
- Integrate the cleaned taxonomy by applying the function clean_taxa() and apply expert knowledge on taxonomic treatments
- Perform quality checks, including the output in the summary folder and specific QAQC for other surveys detailed in the QAQC folder
Data standardization and flags are done on a per survey basis and per survey_unit basis (integrating seasons and quarters). Flags are performed both on the temporal occurrence of taxa and the spatio-temporal sampling footprint according to the following steps.
Steps
- Taxonomic quality control: run flag_spp() for each survey region
- Apply methods to identify a standard spatial footprint through time for each survey-season/quarter (the survey_unit column). Use the functions apply_trimming_per_survey_unit_method1() and apply_trimming_per_survey_unit_method2()
- Display and integrate results in the summary files
Options Users can either use the single survey data products in outputs/Cleaned_data/ and work with survey .RData files including flags or not (inclusion of flags is specified by XX_std_clean.RData), or generate their own compiled version of the data by running the cleaning_codes/merge.R which will write local versions of the database in outputs/Compiled_data/
Contributors to code
- Cleaning taxonomy: Juliano Palacios-Abrantes
- Cleaning surveys: Juliano Palacios-Abrantes, Aurore Maureaud, Zoë Kitchel, Dan Forrest, Daniël van Denderen, Laurene Pecuchet, Esther Beukhof
- Summary of surveys: Juliano Palacios-Abrantes, Aurore Maureaud, Zoë Kitchel, Laura Mannocci
- Merge surveys: Aurore Maureaud
- Standardize surveys: Laura Mannocci, Malin Pinsky, Aurore Maureaud, Zoë Kitchel, Alexa Fredston
- QAQC of DATRAS surveys: Aurore Maureaud, Daniël van Denderen, Esther Beukhof, Laurene Pecuchet
- QAQC of the Barents Sea surveys: Laurene Pecuchet
- QAQC of North American surveys: Zoë Kitchel, Malin Pinsky, Daniel Forrest
Our full citation policy is described in the Fishglob_data disclaimer. Briefly, users should cite Maureaud et al. 2021, Maureaud et al. 2024, and relevant primary SBTS sources referenced in the FISHGLOB data files and source data tables of the two Maureaud et al. papers. Users integrating multiple surveys are encouraged to cite additional studies on data integration.
5/06/2024: A warning about CSVs Datasets are available for download in outputs/Cleaned_data/ as .Rdata files. We do not recommend saving FishGlob data in .csv format. For at least some surveys, the
haul_id
column is composed of a long string of numerics, which is incorrectly rounded if loaded from a .csv programmatically in R (withread_csv()
orread.csv()
). As documented in issue #49, this leads to errors in thehaul_id
column, and may occur regardless of the "class" assigned to this column. The most robust way to prevent this error is to write to / read from other data types such as .Rdata or .rds. Packages exist for users to import these into Python and other programming languages.
23/11/2023: FishGlob_data v2.0. This fixes issue #29.
05/09/2023: Norwegian survey is erroneous and will be replaced with a Barents Sea centered survey over 2004-onwards which will change the spatio-temporal coverage of the region (coordinated by Laurene Pecuchet with IMR), see issue #29