R script ESAS used to transform ESAS data from MSAccess database to the single file in ESAS-ICES format

[NunoOliveira24]

Hi all,

Please find attached an r-script we use at SPEA to convert our ESAS data to the single file in ESAS-ICES format. Our ESAS database is now stored as a MSAccess format following the last adviced structure of 4 tables (Campaigns, Samples, Positions and Observations).

The script includes some quality check steps, including to remove observations with SpeciesCode not included in ESAS-ICES database (e.g. marine litter).

Please let me know in case you have any doubt related with the script.

scriptESAS_2_ICES_SPEA_data_2.txt

[peterdesmet]

Thanks @NunoOliveira24, we're planning to create an R package for ESAS next year, see https://github.com/inbo/esas. This might be a functionality we could include (if you agree).

Ping @sannegovaert

[NunoOliveira24]

@peterdesmet that sounds perfect. Please feel free to include that functionality.