Topic Centre Services

Latest ETC/ICM Announcements

Thursday, 01 August 2013 Edited by: Anita Künitzer, Miroslav Fanta, Marek Staron

WISE SoE data request 2013

To: Eionet PCPs and NRCs for Rivers and Lakes
To: Eionet PCPs and NRCs for Groundwater
To: Eionet PCPs and NRCs for Marine and Coastal Environment
To: Eionet PCPs and NRCs for Water emissions
To: Eionet PCPs and NRCs Water Quantity and Use
To: Ecostat network and national contact points who provided biological test data in 2009 - 2012

Cc: Eionet National Focal Points

From: Beate Werner, EEA

Dear Colleague,

The 2012 WISE SoE annual data request will run from Thursday 1 August until Thursday, 31 October 2013. Data are requested for:

  • water quality including biological quality elements in:
    • rivers
    • lakes
    • marine and coastal environment
  • groundwater quality
  • emissions to water
  • water quantity

The datasets from last years submission are available at the Water Data Centre browse catalogue:

Reporting of 2012 data

Use only the latest versions of data delivery templates downloaded from DD.

The Reporting Obligation Database (ROD) has been updated for this data request.

Detailed definitions of the requested data for all water category datasets, except for Water quantity, are available in the Reportnet Data Dictionary (DD):

Data Dictionary downloads

In order to facilitate the processing of your data, please use only the latest versions of data delivery templates downloaded from the DD. The available reporting formats are:

  • MS Excel - please use only the original .xls format, don't change it to the newer .xlsx

  • XML files - for more technically inclined

  • MS Access - database template with data entry control, quality checks and export functions. It can be used for delivery only in combinations with one of the other formats. Detailed instructions are included in the template.

The Data Dictionary is continuously being improved and has been updated for the 2013 WISE SoE data request after consultation with NFPs and NRCs for water (see Summary of NFP/NRC consultation on Data Dictionary and Scoring criteria update).

Due to the implementation of the 2009/90/EC Directive (QA/QC Directive) into WISE SoE reporting and the resulting data processing, the option of reporting values below the Limit of Detection was removed from all data dictionaries.

The code lists of nutrients and hazardous substances for all reporting categories in the DDs are nearly identical to the 2012 status, few changes were implemented only this year.

Water Quantity reporting

Please download and use only the newest version of the WQ Reporting Tool.

Water quantity data are strongly recommended to be reported by using the WQ Reporting Tool and Manual. Please download and use only the newest version (v.1.4) of the WQ Reporting Tool which you will find under the above link. Do not use older versions from previous years.

If you have long-time series for certain Water Quantity parameters, which are difficult to report via the WQ Reporting Tool, you can report them by providing the specific internet URL link from where the data can be easily retrieved. You need to make sure that the parameters reported this way are following the WQ data manual definition. In the case of small discrepancies, you need to describe them clearly, please. The WQ Reporting Tool itself provides a space for entering the internet link for streamflow and precipitation data. Should you choose another parameter, you can insert the corresponding link into the comments field provided.

Biological quality elements reporting

Please provide data on biological quality elements in rivers/lakes in one template together with data on water quality in rivers/lakes.

Please provide biological quality elements in rivers / lakes data in one template together with water quality data in rivers / lakes, as described in the Data dictionaries for Rivers and Lakes. If you need to fill and report the template separately for water quality and biological elements, then provide biological quality elements together with relevant stations in a copy of the template. Both files should be uploaded to the same envelope. In case Biological elements data are not available in your country, please provide an explanation why biological data cannot be delivered (see examples in the introductory text to the Scoring criteria for Rivers / Lakes ).

The structure of tables for reporting of Biological elements in Lakes has been updated this year. Up to 2012, the "Biology in lakes - aggregated data" table contained two different types of data: (1) the main data in the EQR (Ecological Quality Ratio) scale and (2) additional data in original metric scale form. The use of two scales in the same table seems to cause some confusion for data providers. Therefore the splitting up of the current Biology in lakes - aggregated data table into two tables has been implemented as follows:

(1) "Biology in lakes - EQR data". For this table, related information should be given in the table ClassificationSystemLakes, linked by WaterbodyTypeNCS.

(2) "Biology in lakes - additional metrics data". For this table, no information on the classification system is requested.

Clarification of unsolved validation questions

Replying on critical QA issues is needed to achieve the highest evaluation score.

The general QA rules for each reporting category are available in the folder on Validation questions (outliers, violations of internal logical rules for the data, errors/gaps in station information) and are specified for each reporting category. Data reported in previous years which were violating these rules, and for which validation questions have not been answered, clarified and corrected by countries, are uploaded to Forum in country folders. The most important validation questions (critical QA issues) are also specified for each reporting category. Replying on these critical QA issues is needed to achieve the highest evaluation score.

Please check these validation questions for water all water categories and update/resubmit your datasets where necessary together with the new data. You may report separately, if identified potential outliers are indeed correct values.

Water quantity validation questions contain this year also findings from the comparison with reportings to EUROSTAT through the OECD/EUROSTAT Joint Questionnaire on Inland Waters 2012 (see common documentation and country specific files).

Validation questions and country files for all reporting categories will be available by mid August 2013.

Data Delivery and Automatic QA

Please check the results of the automatic QA, correct problems and redeliver corrected data.

All delivery files should be uploaded either to the Central Data Repository (CDR) or to your national Eionet server, depending on the choice of your country for delivering Eionet priority data. Please, use the proper formats formats (MS Excel, XML files or MS Access) for delivery of your datasets. Automatic QA procedures have been updated following the changes in the Data Dictionaries.

For the reporting on water quantity, the automatic QA procedures are included into the WQ reporting tool.

You can find out more about the Automatic QA service for WISE SoE data flows at: The help files were created for one of the previous data flows and show the main elements of standard procedure.

Automatic QA procedures for all. reporting categories will be finalised by mid September 2013. You will be informed by an additional letter when the implementation of all procedures is finished.

Evaluation and scoring criteria

EEA has reported to EEA Management Board on country responses to the Eionet water data collection since 1999 (see archive of EIONET Progress reports).

The scoring criteria for the 2013 data collection have been updated for the 2013 WISE SoE data request after consultation with NFPs and NRCs for water (see Summary of NFP/NRC consultation on Data Dictionary and Scoring criteria update). The most important changes in scoring criteria are:

  • Focus on delivery of the most recent data (sampled in 2012) has been emphasized

  • Criteria for Emissions to water reporting category were simplified and clarified, in order to reflect the automatic addition of data from the E-PRTR into the SoE Emissions database which reduces the reporting load for countries

No scoring criteria for reporting of data on Biology in TC waters have been developed yet, but will be considered after this year's data reporting.

Helpdesk and support

  • In case of login problems or any other technical difficulties with Eionet web services, please contact Eionet helpdesk

  • In case of questions related to the content of the data requested, please contact the responsible person as specified in the updated Data Dictionary guidelines (see there under Methodology).

I would like to take this opportunity to thank you for your continued support and look forward to another successful annual data flow.

Beate Werner
Head of Group - Water
European Environment Agency