POPs GMP data visualization and analysis
 

Global Monitoring Plan Data Warehouse:
online tool to store and visualize data on levels of POPs in core matrices

Introduction

The POPs Global Monitoring Plan Data Warehouse (GMP DWH) has been developed by the Stockholm Convention Regional Centre in the Czech Republic through the Research Centre for Toxic Compounds in the Environment and the Institute of Biostatistics and Analyses, Masaryk University, Brno, Czech Republic, under the guidance of the GMP Global Coordination Group, and based on Chapter 6 of the Guidance on the Global Monitoring Plan for Persistent Organic Pollutants relevant to data handling (UNEP/POPS/COP.6/INF/31).

The data reporting model involves compiling and archiving primary GMP data within a “regional data repository” in the GMP DWH for each of the five regional organization groups. In addition, the GMP DWH compiles and archives aggregated data, including supplementary data, in cases where no primary data is made available.

Attributes of the GMP DWH

The following attributes are embedded in the multi-modular GMP DWH:

  • Fully parametric data sheets - harmonized data and information structure to improve the quality of information reported from particular monitoring activities, supporting their broader comparability;
  • Standardized data structure, handling and outputs - the GMP DWH is designed to work with data from a wide range of heterogeneous sources, such as national monitoring programmes or large international monitoring networks, without compromising incoming information;
  • Compatibility check - GMP DWH contains only completed and validated data records;
  • Regional data repositories- automatic tools for storage, archiving of both primary and aggregated data;
  • Multilayer data validation procedure - compatible data records stored in the GMP DWH are considered by members of the respective regional organization group and validated for further use in the publication;
  • Data visualization- presentation of data in a uniform format;
  • Public access to the data once the validation process and preparation of regional reports is completed.

Structure and content of the GMP DWH

The GMP DWH is composed of three layers:

  • Data layer for data import, online data collection, data standards (code lists) and archiving.
  • Core layer for data management, validation, recoding, transformation, and background for data services (GIS, analytical and statistical tools, data processing, workflow);
  • Presentation layer for visualization portal, presentation tools and web services.

The GMP data visualization portal facilitates user friendly browsing and analysis of POPs data from all over the world. There are several possible visualization options for the selected data and their analysis:

  • Spatial distribution
  • Data availability
  • Summary statistics
  • Time series analysis
  • Data exports

It contains information on POPs concentrations in ambient air, human tissues (breast milk and maternal blood) and surface water for water-soluble POPs (perfluorooctane sulfonic acid, its salts and perfluorooctane sulfonyl fluoride) collected in the framework of the GMP and validated by the regional organization groups of the five UN regions. These data are presented also in the regional monitoring reports.

Note: not all data presented in the regional monitoring reports were made available by the monitoring programmes for inclusion into the GMP DWH.

The following monitoring programmes contributed data on ambient air:
AMAP, China National POPs Monitoring Project, EMEP, Environmental Survey of Dioxins and Chemicals Japan, GAPS, GAPS-GRULAC, GMP-UNEP, Košetice, LAPAN, MONET, POPs Monitoring Project in East Asian Countries Japan, TOMPS

The following monitoring programmes contributed data on human milk:
UNEP/WHO Human Milk Survey, China National POPs Monitoring Project

The following programmes contributed data on water monitoring:
Alcor (Kirchgeorg et al. 2010), Amundsen (Benskin et al. 2012), ANTXXVII/1 (Zhao et al. 2012), ANTXXVII/2 (Zhao et al. 2012), ANTXXV (Ahrens et al. 2010), ARK-XXIV/3 (Zhao et al. 2012), Endeavor (Benskin et al. 2012), Ga 442 (Theobald et al. 2011), Ga 446 (Theobald et al. 2011), Malaspina (González-Gaya et al. 2014), Maria S. Merian 2007 (Ahrens et al. 2009), Maria S. Merian 2008 (Kirchgeorg et al. 2010), Oden 2005 (Benskin et al. 2012), Oden 2007 (Benskin et al. 2012), Polarstern 2007 (Ahrens et al. 2009), Polarstern 2008 (Ahrens et al. 2010), Snow Dragon (Cai et al. 2012), Thailand PFOS Survey (Boontanon et al., 2013)