Topic Centre Services


Latest ETC/ICM Announcements

Monday, 02 August 2010 Edited by: Beate Werner

WISE SoE data request 2010

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

Cc: Eionet National Focal Points

From: Beate Werner, EEA

 

Dear Colleague,

The 2010 WISE SoE annual data request is the tenth formal water data collection in Eionet and will run from Monday, 2 August until Sunday, 31 October 2010. It requests water quality data for rivers, lakes, groundwater, marine and coastal environment, emissions to water, water quantity data and biological quality elements in surface waters (rivers, lakes, transitional and coastal waters).

Good reporting and updating or redelivery of old data is this time especially important, since the data will be used for the EEA report on Water in 2012, which will be published by EEA in coordination with the water related report by the Commission (Blueprint incl. WFD). However, biological data from the test data flow will not be used for these reports.

Water quantity reporting is a priority dataflow since last year, but is not using Reportnet features in the same extent as the other priority data flows. Instead of a Data Dictionary, a specifically designed WQ Reporting Tool and Manual for water quantity are provided for the reporting of the data related to water balance, abstraction and use. Please go the folder Water quantity reporting 2010 on the Eionet Circa website and

A table with the content of the WQReportingTool_v.1.1.zip file and the description of the use each of the contained files is as well available. Data delivery for water quantity does not differ from the other priority data flows.

The current version of the WQ Reporting Tool (v.1.1.) is pre-filled with all the "stations characteristics" that were provided by countries last year, and do not need to be entered again.

For viewing and downloading last years' delivery of the WQ data, a user friendly online application has been created. You can access the application on: http://wq.wise-dreams.eu/

Currently this site may be used to search, locate and download water quantity information related to precipitation (only station data), groundwater level and streamflow data reported last year. Please note that this site is still under development and shows only part of the reported data categories. A complete list of all water quantity data reported last year is given in the file WQ_statistics_2009.xls which is released together with this tool.

Reporting of biological quality elements happened last year as a test dataflow. At the freshwater and marine Eionet Workshops in October and November 2009, as well as at the Ecostat workshops in October 2009 and April 2010, it was decided to expand the data request to include further biological quality elements: Phytobenthos in rivers in addition to benthic fauna in rivers and phytoplankton and macrophytes in lakes, as well as coastal waters phytoplankton, macroalgae and angiosperms in addition to benthic invertebrates. Updated and new SoE reporting sheets for biology in rivers and lakes and for biology in TC waters are available on Circa. It was also decided at these workshops that a second test dataflow should happen this year in combination with the WISE SoE data request (Minutes of Freshwater Eionet Workshop and Ecostat workshops). For this purpose, two Data Dictionaries for biology in rivers and lakes, and for biology in transitional and coastal waters have been developed (see links below).

The reporting of biological quality elements can be done by NRCs and/or the Ecostat network, or by the data providers who sent the test data in 2009. The results from this year’s data flow will not be published, but used as a basis for the establishment of priority data flows on biological quality elements from 2011 onwards. Reporting of biological data for the additional quality elements given above is encouraged to provide a basis for a more comprehensive picture of the different components of aquatic ecosystems in Europe. Updating or redelivery of biological test data from 2009 is also encouraged to improve the quality and quantity of these data, (see link below to recent feedback sent to data providers on test data delivered in 2009).

Reporting of 2009 monitoring results for all water categories

In order to facilitate the processing of your data, please only use the data delivery templates as provided through the Data Dictionary. The Data Dictionary should be also used as technical guidelines for reporting. The Data Dictionary is continuously being improved and has been updated for the 2010 WISE SoE data request. Selection criteria for "representative stations" have been included into all Data Dictionaries. The Data Dictionaries for rivers and lakes have the supporting determinands now in a separate table as requested by NRCs. All Data Dictionaries except the ones for biology have a harmonised code list of hazardous substances with selected "preferred substances". The latter will be used for the upcoming EEA report on "Hazardous substances in Europe's waters". A summary of the changes made is given for the Data Dictionary of each water category in the beginning of the methodology section:

For Water quantity reporting, please use the WQ Reporting Tool and Manual for Water Quantity.

Clarification of still unsolved validation questions to countries from last years reporting:

Validation questions (outliers, violations of internal logical rules for the data, errors/gaps in station information) on the data reported by you last year and in previous years, and which have not been answered yet by you, are uploaded to Circa in country folders.

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

Please check also for biological quality elements the feedback on the test data reporting for biology in rivers and lakes and feedback for biology in TC waters.

Redelivery of groundwater quality data

Due to the change from Eionet groundwater bodies to WFD groundwater bodies, some previously reported aggregated data per Eionet groundwater body do not fit to the WFD groundwater bodies. The analysis of inconsistencies in time series for groundwater quality between Eionet and WFD groundwater bodies has been carried out for each country and the results are uploaded to the Circa folder Redelivery of groundwater quality data. We kindly requests those countries, for which we have identified previously reported aggregated data as non consistent to the new WFD groundwater bodies, to redeliver their previous data, preferably in disaggregated way.

Data Delivery

All data 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.

Automatic quality assurance (QA) service

EEA/ETC Water has updated the set of automatic QA procedures for rivers, lakes and groundwater following the changes in the Data Dictionaries regarding hazardous substances and supporting determinands.

Automatic QA procedures for TCM and emissions will be updated by the end of August only. Therefore, we ask you to upload your datasets on TCM and emissions not before September.

For the reporting on water quantity, the automatic QA procedures are included into the WQ reporting tool. No automatic QA will be available for the test data flow on biological quality elements.

The procedures are embedded in the CDR. Results of data checks will immediately be available after data upload. We warmly recommend checking the results, correct problems (if any) and redeliver corrected data. A further level of data quality checks will be carried out by ETC data managers, as usual.

You can find out more about the WISE SoE QA service at: http://cdr.eionet.europa.eu/help/WISE_SoE. The help files were created for one of the previous data flows, but  the content is still valid with just some minor exceptions.

Notifications, manual feedbacks and comments

If you want to stay updated about events in the CDR envelope, subscribe to receive email notifications. The function is directly available from the envelope.

The responsible data reporter is automatically notified if manual feedback is posted to the envelope. Manual feedback is a message from a data requester and it usually contains information about problems detected in the delivery. Since last year data reporters are able directly reply to the manual feedback. After you open a manual feedback if you are logged in to the CDR, you will see a button "Add comment". The button opens a web interface where you can write your reply (rich text format allowed) and also attach additional files if necessary. It is similar to commenting an internet article, forum post or blog.

We strongly recommend using this feature as a superior alternative to email communication. The whole feedback communication – both the original manual feedback and the comments – stays within the respective envelope, so it is easy to find even after some time. It is also publicly available which is important for the transparency of the deliveries and to provide necessary information to understand the data quality issues and solutions.

Progress report 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 purpose of the priority data flow report is to show progress against agreed, stable, well-defined objectives in order to allow countries to focus their resources on putting regular reporting procedures in place.

The scoring criteria for the 2010 data collection are partly updated compared to last year: Criteria for Groundwater and Emissions contain slight changes only (negative smiley specification), on the other hand criteria for rivers and lakes are completely revised. Criteria for TCM waters are updated for one positive and negative smiley. Scoring criteria for water quantity have been newly developed. For biological data, scoring criteria will only be developed next year. We hope that the additional support described will result in high scores for all countries.

Helpdesk service and support

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