HELCOM/OSPAR - ICES data flows CORESET II /BALSAM WP2 meeting, - - PowerPoint PPT Presentation
HELCOM/OSPAR - ICES data flows CORESET II /BALSAM WP2 meeting, - - PowerPoint PPT Presentation
HELCOM/OSPAR - ICES data flows CORESET II /BALSAM WP2 meeting, Helsinki 2-4 February 2015 Agenda item 3 on Long term data-arrangements for the core indicators Hans Mose Jensen (ICES) Present situation of the HELCOM/OSPAR hazardous substances
HELCOM/OSPAR - ICES data flow
National
- National collection
- QC (HELCOM COMBINE/
OSPAR guidelines and manuals)
- Data formatting to ICES
format
ICES
- Registration of data
submission in the ICES accession system (DAD)
- QC (DATSU) on input
- Data storage in central
database (DOME)
- Connection point to other
systems (OBIS, SDN, EMODNET, EIONET)
- Open online access to data
(CSV, ODV, web-service, shp, kml)
- Predefined dataviews for
assessment purposes (assessment input)
Assessment
- Assessment processing by
working groups (HELCOM CORESET indicators, OSPARMIME)
- Assessment report products
and online assessment application (HELCOM CORESET indicators, OSPARMIME)
- Storage of processed
assessment data (OSPAR, HELCOM)
QC – DATSU
http://dome.ices.dk/datsu/ ICES Data Screening Utility
- For hazardous substances the exchange format is
Environmental Reporting Format (ERF32)
- Data can be read according to ERF32
- Submitted concepts in vocabularies used, e.g. ICES
Reference Codes (RECO), taxonomic vocabularies (WoRMS/ITIS/PEG-biovolume) and SeaDataNet platform vocabulary
- Data is in line with the requirements as defined for the
monitoring programme (HELCOM, OSPAR)
ICES Reference Codes
http://vocab.ices.dk/
QC – DATSU
QC – DATSU
QC – DATSU
DATSU checks overview
http://dome.ices.dk/datsu/rptChk.aspx
New! Automatic upload of resubmissions
- Extension to DATSU
– if no critical errors – if accession is identified in DOME
- Submitter identification: individual password is
required
- Comparison to existing DOME submission
- Comparison criteria must be met
- Submitter replaces the original submission
- Accession database (DAD) is updated
Automatic upload of resubmissions
Parameter group summary /comparison
Automatic upload of resubmissions
Station summary /comparison
Automatic upload of resubmissions
Taxonomic summary /comparison
Data output format from DOME for assessment input
Country RLABO MSFD_region OSPAR_region OSPAR_subregion OSPAR_shore StationName SD_StationName MYEAR DATE Latitude Longitude PURPM FINFL Species SpeciesType SEXCO NOINP PARAM MATRX BASIS MUNIT Value Value_std DETLI DETLI_std LMQNT LMQNT_std UNCRT UNCRT_std METCU QFLAG VFLAG ALABO SMTYP SUBNO tblAnalysisID tblParamID tblBioID tblSampleID
OSPAR MIME example
Standard units: Contaminants in biota: µg/kg Effects in Biota: none Contaminants in sediment:
- Metals mg/kg
- Everything else µg/kg
OSPAR MIME example
Standard basis Fish Bivalves / Gastropods Crustacean s Metals W D W Organotins W D W All other
- rganics
L D L Standard basis: W (wet weight), L (lipid weight), D (dry weight)
METCU Description Convert to SD % percent uncertainty Uncertainty (%) * measured value /100 SD standard deviation (+/-)
- U2
expanded uncertainty (U) coverage factor 2 Uncertainty (U2) / 2
OSPAR MIME example
Uncertainty convertions:
METCU Description Convert to SD % percent uncertainty Uncertainty (%) * measured value /100 SD standard deviation (+/-)
- U2
expanded uncertainty (U) coverage factor 2 Uncertainty (U2) / 2
OSPAR MIME example
Uncertainty convertions:
OSPAR MIME station name allocation
Critical for the grouping of time series data
- Station name in submitted data must
match ICES Station Dictionary
- Data submitted without a station
name will be matched with ICES Station Dictionary – if inside spatial/temporal/thematic window
- f the defined monitoring station
Fixed station vocabulary
ICES lead initiative together with SeaDataNet, EMODnet and EEA (WFD, MSFD and INSPIRE) to develop a model on harmonization of the monitoring station concept
- Distributed network
- Through ICES vocab system
- One station, multiple applications (HELCOM, OSPAR, WFD,
MSFD, National, …)
- Governance coded as EDMO entries
Station name “Monitoring type (HELCOM, OSPAR, WFD, MSFD, national)” Geographic position “Type of data” Governance “Purpose” Date from “HELCOM fields” Date until …
Input data Processing (R- script) according to defined methodology Assessment product application
OSPAR MIME “automated” assessment
http://dome.ices.dk/osparmime/main.html
Dataset availability input/output
Coming
New! DOME standard views in test
Spatial assessment units
- HELCOM sub-
basins/sub-divisions
- WFD
- MSFD assessment
units
New update of ICES Ecoregions
Indicator data flows non-fisheries
WISE SoE – transitional coastal and marine data flows
BALSAM Action Plan
Action points to improve reporting infrastructure and data flows
- 3.1
- Development of data management guidelines “toolkit”, including
inventory of standards and tools available, e.g. unit conversion tables (ICES)
- 3.2
- Harmonization of station concepts and practice of labelling of data to
regional/national (ICES/CP)
- Labelling automatically all data points to HELCOM assessment units
when adding to database (ICES)
- 3.3
- Accepting data in ODV format to HELCOM database (ICES)
- Accepting data via web services from SDN/EMODnet to be
incorporated to HELCOM database (ICES/EMODnet?)
- Explore opportunities where CP have systems in place to harvest data
provided as XML outputs to be imported to HELCOM database (ICES/CP)
BALSAM Action Plan
Action points to improve reporting infrastructure and data flows
- 3.4
- Definition of data requirements for core indicators and proposals for
improvements (CORESET II)
- Modification of reporting format(CORESET II, ICES)
- 3.5
- Data reported to EIONET would be incorporated in HELCOM
assessment products (with possible duplicate removal)(ICES)
- Explore funding opportunities to expand the automated
submission/resubmission of COMBINE datasets (ICES/HELCOM)
- 3.6
- Defining data view for data extraction and processing for core
indicator requirements (CORESET II)
- Cataloguing the data products used in the indicatiors to the ICES
geoportal (ICES/HELCOM secretariat)