EMODnet Chemistry Marine Litter data management TWG Trieste

  • Slides: 27
Download presentation
EMODnet Chemistry Marine Litter data management TWG, Trieste , Italy, 10 March 2020 Matteo

EMODnet Chemistry Marine Litter data management TWG, Trieste , Italy, 10 March 2020 Matteo Vinci Alessandra Giorgetti Maria Eugenia Molina Jack Alexia Cociancich Erik Geletti Elena Partescano OGS

Outline • • Quick recap Tools Databases content Databases • • Set-up & maintenance

Outline • • Quick recap Tools Databases content Databases • • Set-up & maintenance Possible issues Proposed upgrades Further upgrades (seafloor images and floating macro)

Marine litter: quick recap on protocols and formats Approach discussed at the MSFD Technical

Marine litter: quick recap on protocols and formats Approach discussed at the MSFD Technical Group ML BEACH SEAFLOOR Consolidated protocols (OSPAR, UNEP – (ICES, MEDITS, De. Fish. Gear) Marlin, TG ML) New EMODnet format based on OSPAR FLOATING MICRO-LITTER More fragmented and heterogeneous management New EMODnet format Adapted Sea. Data. Net/ based on ICES and EMODnet data formats MEDITS and infrastructure

Available tools Relevant tools available at: https: //www. emodnet-chemistry. eu/tools • Beach and seafloor

Available tools Relevant tools available at: https: //www. emodnet-chemistry. eu/tools • Beach and seafloor litter data conversion tool • Beach and seafloor litter online data validators (web services) • Map of beaches for potential duplicates check before submission… Central submission facility for loading/db population web services Mikado and Nemo metadata and data editor floating microlitter Open access to harmonized information • CDI interface data • Data products catalogue aggregated collections for beach and seafloor litter and marine litter maps

Data sources & databases content KO situation, October 2019 EMODnet format Beach Seafloor Floating

Data sources & databases content KO situation, October 2019 EMODnet format Beach Seafloor Floating micro-litter Marine Litter Database Regular harvesting from OSPAR-MCS EU-Member States through TG ML EMODnet partners and associates Marine Litter Watch EEA data 36 countries 790 beaches ICES DATRAS SOAP Web Service EMODnet partners, De. Fish. Gear 23 countries 3630 surveys Volvo Ocean Race (worldwide) EMODnet partners 3 countries 112 surveys Counts updated at 23/10/2019

Litter Databases content EMODnet format Beach Marine Litter Database OSPAR-MCS JRC collection from Member

Litter Databases content EMODnet format Beach Marine Litter Database OSPAR-MCS JRC collection from Member States EMODnet partners and associates, EEA MLW 36 countries 811 beaches 8398 surveys Seafloor ICES-DATRAS database, De. Fish. Gear, EMODnet partners 23 countries 4333 surveys Floating micro-litter EMODnet partners, Volvo Ocean Race 6 countries 163 surveys Under ingestion process: EEA MLW More data in future: EU MS, EEA Litter Watch, MEDITS, De. Fish. Gear, more from EMODnet partners, VOR, …

Beach litter database • Database: • • Metadata: CDIs Data: • • • Postgre.

Beach litter database • Database: • • Metadata: CDIs Data: • • • Postgre. SQL Relational database (V 11) Post. GIS Spatial capabilities Set-up & maintenance: • • • Database on local server with regular backup Formatting software: Python tool public available at https: //www. emodnet-chemistry. eu/tools/littermanager Validation software: Java web service, public available at https: //www. emodnet-chemistry. eu/tools/beachvalidator? 5 Db population software: Java web service used in command line through user authentication Guidelines regularly updated following format evolution, now quite stable

Beach litter: issues No structured QC loop as for other kind of data Quality

Beach litter: issues No structured QC loop as for other kind of data Quality check is done: • Before db ingestion validation • After db ingestion CDIs generation, data products generation • Quality issues cases: • wrong beaches/surveys coordinates (on land) • EDMOs(originator)/ beach country (excluding MLW) • EDMERP • Duplicates related to data from different collators Delays on data publication, updates and/or deactivation of CDIs • • resources consuming and delays…

Beach litter: proposed upgrades • • Increase as possible QC done before db ingestion

Beach litter: proposed upgrades • • Increase as possible QC done before db ingestion and publication (CDIs) Implement new warnings in the online validation phase so that NODCs can correct before sending data: • • • Beach coordinates valid? (feasible? Distance from the coast make sense? I yes how much? ) Survey length valid? (which the min and max values? ) Beach. VSSurveys coordinates EDMO(originator)VSbeach country (excluding MLW data? ) existing EMDERP Duplicates related to data from different collators…how to fix this? ! Datasets can be slightly different…is it the same? !

Seafloor litter database • Database: • • Metadata: CDIs Data: • • • Postgre.

Seafloor litter database • Database: • • Metadata: CDIs Data: • • • Postgre. SQL Relational database (V 11) Post. GIS Spatial capabilities Set-up & maintenance: • • • Database on local server with regular backup Formatting software: Python tool public available at https: //www. emodnet-chemistry. eu/tools/littermanager Validation software: Java web service public available at https: //www. emodnet-chemistry. eu/tools/beachvalidator? 5 Db population software: Java web service used in command line through user authentication Guidelines regularly updated following format evolution, now quite stable

Seafloor litter: issues • • No structured QC loop as for other kind of

Seafloor litter: issues • • No structured QC loop as for other kind of data Quality check is done: • Before db ingestion validation • After db ingestion CDIs generation, data products generation Quality issues usual cases (ICES, Defishgear): • Doubtful/wrong hauls lengths/coordinates/ trawling distance (zero or too long, on land) • Tracks on land • Haul. Val field (Invalid or Valid) not managed in EMODnet format, seems that until now we ingested the whole Datras dataset (also bad quality) Delays on data publication, updates and/or deactivation of CDIs resources consuming and delays…

Seafloor litter proposed upgrades • • Increase as possible QC done before db ingestion

Seafloor litter proposed upgrades • • Increase as possible QC done before db ingestion and publication (CDIs) Implement new warnings in the online validation phase so that NODCs can correct before sending data: • • • hauls coordinates Tracks on land? (feasible? ) Tracks distance check? (which distance as min and max? ) Tracks distance check. VS coordinates New web service call requested to download Datras seafloor data with date and Haul. Val criteria (recently in contact with Adriana Villamor, ICES) …if not possible…? !. . . suggestions

Floating micro litter • Databases: • SDN system: • • • CDIs, metadata Cloud,

Floating micro litter • Databases: • SDN system: • • • CDIs, metadata Cloud, Centralized ODV, data: • unrestricted Cloud, Centralized • restricted NODC Set-up & maintenance: • Adopting & Adapting of: • • • CDI profile BODC vocabularies ODV agreed litter data format Regular maintenance of Nemo and Mikado by SDN Updates of guidelines (VOR needs, challenging data quality)

Further upgrades: floating macrolitter • • • What is available now!? Seems that the

Further upgrades: floating macrolitter • • • What is available now!? Seems that the main source could be the Mediterranean area OSPAR and HELCOM should not consider FMML as an indicator (…even if some countries are doing monitoring…FMML WS minutes Feb 2019) items> 2, 5 cm following the JRC- FMML-WS held in ISPRA, Rome (February 2019) already identified active communities (Medsealitter, JRC RIMMEL App for sea and river observations). Medsealitter project collected data

Further upgrades: floating macrolitter Format examples kindly provided by ISPRA… • … two kind

Further upgrades: floating macrolitter Format examples kindly provided by ISPRA… • … two kind of files slightly different: • For coastal areas (Italian form): • • 3 tabs for different kind of info: station info, station/sampling, litter items List of items…TGML or not? Not clear. 2 levels list: a more general level with 8 categories (artificial polymers, wood, textile …) and a more specific one with 49 categories (bags, buoys, gloves…) 34 fields collected divided in the 3 tabs For open sea measurements (English form): • • • File with different tabs for each season of survey + tab with items summary, to clarify… List of items…TGML or not? Not clear. 2 levels list: a more general level with 8 categories (artificial polymers, wood, textile …) and a more specific one with 49 categories (bags, buoys, gloves…) 47 fields collected

Further upgrades: floating macrolitter 3 tabs for coastal areas: station sampling items

Further upgrades: floating macrolitter 3 tabs for coastal areas: station sampling items

Further upgrades: floating macrolitter Open seas example: Sampling info Items summary?

Further upgrades: floating macrolitter Open seas example: Sampling info Items summary?

Further upgrades: floating macrolitter • • How to handle? There was a quite clear

Further upgrades: floating macrolitter • • How to handle? There was a quite clear interests in ODV format and software…is it feasible? ? ?

Further upgrades: seafloor litter images • What is available now!? • Input from IFREMER:

Further upgrades: seafloor litter images • What is available now!? • Input from IFREMER: • • In contact for an input example from ISPRA: • • • RAMOGE cruise examples RAMOGE cruise September 2018 with F. Galgani IFREMER Other data from ISPRA…still to see and check… Jamstec data management example: (http: //www. godac. jamstec. go. jp/catalog/dsdebris/e/)

Further upgrades: seafloor litter images Example of Seafloor images from IFREMER, RAMOGE Cruise An

Further upgrades: seafloor litter images Example of Seafloor images from IFREMER, RAMOGE Cruise An example of data extracted from Navigation logs

Further upgrades: examples of seafloor litter images Example of Seafloor images from RAMOGE Cruise

Further upgrades: examples of seafloor litter images Example of Seafloor images from RAMOGE Cruise Fig. 2 - Examples of litter laying on the bottom: A) Can laying on the bottom; B) Discarded sac and bottle and line laying on the bottom. Photo by RAMOGE Exploration 2018 and by Simonepietro Canese. …Changing the habitat anyway, thus having an effect. Ingestion risk. Degradation leads microlitter.

Other examples of seafloor litter images Example of Seafloor images from RAMOGE Cruise Fig.

Other examples of seafloor litter images Example of Seafloor images from RAMOGE Cruise Fig. 7 - Example of Adaptive behavior. A-B) The crab Paromola cuvieri was observed carry plastic on its exoskeleton (yellow arrow), instead of usual sponges or gorgonians (7 C, yellow arrow). Photo by RAMOGE Exploration 2018.

Other examples of seafloor litter images Example of Seafloor images from RAMOGE Cruise Pictures

Other examples of seafloor litter images Example of Seafloor images from RAMOGE Cruise Pictures with interactions

Other examples seafloor litter images • JAMSTEK Deep Sea Marine Debris db (http: //www.

Other examples seafloor litter images • JAMSTEK Deep Sea Marine Debris db (http: //www. godac. jamstec. go. jp/catalog/dsdebris/metadata. List? lang =en)

How to handle the information • Table of possible relevant info: • • •

How to handle the information • Table of possible relevant info: • • • Date Position (lat/lon) Depth Substrate? (Jamstec manages it) Litter items, which protocol/list/codes? (…seems that TGML list is used…) Number of items Entaglements/interactions? (Jamstec seems doesn’t manages it) Link to pictures and/or movies? (Jamstec manages it) Link to map? (Jamstec manages it) Other…?

File system VS db: consequences How to handle information: • • • About images

File system VS db: consequences How to handle information: • • • About images and/or movies linked to data… …images or movies managed in a file system seems a more sustainable option Seems that Jamstec is managing both images and movies, recent email exchanges clarified that metadata and data are managed in a db while images and movies by file system and magnetic tape (only back-up? . . . to clarify…) Movies can be heavy and tricky/costly to manage (…how big can this movies be? !)… …Difficulties (performances) to manage an online service for movies Should we focus on static images in file system linked to data?

@EMODnet www. emodnet. eu Your gateway to marine data in Europe

@EMODnet www. emodnet. eu Your gateway to marine data in Europe