Icon Seafood Safety

Online Tools

 

VIBRIO RISK AND PHYLOGENY TOOLS

In partnership with the FAO the Reference Centre is aiming to develop a number of online tools which will help the international community monitor the risk of contamination of bivalve molluscs with Vibrio spp..

The Vibrio Map Viewer, developed in collaboration with the European Centre for Disease Prevention and Control (ECDC) and others, is a near real-time model that uses daily updated remote sensing data to examine worldwide environmental conditions, such as sea surface temperature and salinity for Vibrio spp.. The model used for the Vibrio Map Viewer has been calibrated to the Baltic Region in Northern Europe and might not apply to other worldwide settings prior to validation. The Vibrio Map Viewer is also one of a range of oceanographic data visualisation tools available from the US National Oceanic and Atmospheric Administration (NOAA) as part of its Ocean Viewer platform (select Vibrio Risk from the menu then choose either Daily, Cumulative or Forecast Vibrio Risk).

The Vibrio parahaemolyticus global phylogeny tool, using the Microreact application, shows the phylogenetic relationships, geographic distribution and timeline of a collection of more than 1300 V. parahaemolyticus genomes. The collection comprises genomes available from public databases (NCBI) along with genomes from strains deposited in the Reference Centre's V. parahaemolyticus global culture collection, covering particularly areas of the world underrepresented in the public databases. NOTE: this tool may not work with Microsoft web browsers and is best viewed using Chrome, Firefox or Safari.

CLASSIFICATION PROGRAMME TOOLS

There are numerous examples of specialist open source, free to use, software available online to aid the establishing and running of classification programmes.

For mapping and geospatial data analysis, QGIS is one of the most well-known and is best summed up by the OS Geo organisation:

"QGIS is the leading Free and Open Source Desktop GIS. It allows you to create, edit, visualise, analyse and publish geospatial information on Windows, Mac OS, Linux, BSD and Android (via the QField app)."

QGIS is available to download here and can be used to aid classification programmes in the following ways:

  • Planning of sanitary surveys
  • Creation of professional maps for bivalve classification zones - if necessary these can then be displayed online via HTML interactive web maps
  • Visualisation to allow geospatial analysis on sources of contamination
  • Integrated use of the QField app to capture geospatial data in the field and export to QGIS projects
  • Use of a multitude of plugins to extend functionality, such as direct import of Sentinel satellite imagery into QGIS via the Sentinel Hub plugin

There is a wide range of training resources for QGIS available in a multitude of languages and formats, for example the official QGIS community provides training manuals in English, French, Spanish and Portuguese.

The running of a bivalve classification monitoring programme generates a substantial amount of data and this should ideally be stored in a secure database. ‘Relational’ databases are generally used for this purpose as they offer several advantages:

  • Data Integrity: Relationships between tables reduce redundancy and maintain consistency.
  • Ease of Use: SQL simplifies data retrieval and transformation, making relational databases accessible to non-technical users.
  • Scalability: Modern relational databases support cloud-based scaling and advanced features like read replicas for disaster recovery.
  • Backup and Recovery: Built-in tools allow for seamless data export, import, and mirroring.

The ability to conduct analysis over long term data sets is critical to the management of a successful programme.

It is advantageous for the database to be able to conduct geospatial analysis on submitted results, such as determining the distance a sample was collected from the designated location of a representative monitoring point.

PostgreSQL is a free, open source, relational database builder that enables databases to be created. PostgreSQL is available to download here. PostGIS extends the functionality of PostgreSQL by adding geospatial analysis capabilities. PostGIS is available to download here.

As with QGIS there is a range of learning materials available in different languages and formats to support users of this software. The following training resources are provided by the PostgreSQL and PostGIS official community:

Further considerations and recommendations on the implementation of GIS software and databases can be found in the Technical guidance for the Development of the Growing Area Aspects of Bivalve Mollusc Sanitation Programmes.