Topic Centre Services


Latest ETC/ICM Announcements

Monday, 02 July 2012

Preparation of the WISE SoE data request 2012

To: Eionet National Focal Points

Cc: Eionet PCPs and NRCs for Rivers and Lakes
Cc: Eionet PCPs and NRCs for Groundwater
Cc: Eionet PCPs and NRCs for Marine and Coastal Environment
Cc: Eionet PCPs and NRCs for Water Emissions
Cc: Eionet PCPs and NRCs Water Quantity and Use

From: Beate Werner, EEA

Dear Colleague,

The 2012 WISE SoE annual data request will be launched on the 1st August 2012. It has been agreed with NFPs that in the preparation phase for this data request changes to Data Dictionaries and Scoring criteria will be consulted with you to allow for comments to be made.

  • Annex 1 provides the overview of significant changes to the Data Dictionaries.
  • Annex 2 provides the overview of changes to the scoring criteria (smileys).

You are welcome to comment on the suggested updates to the Data Dictionaries and scoring criteria by the 17th July to ETC/ICM data manager Miroslav Fanta (Miroslav.Fanta@cenia.cz).

Beate Werner
Head of Group - Water
European Environment Agency

 

Annex 1: Important Data Dictionary Updates

Significant changes only are described.

1. Merge of Data Dictionary on Biological data in Rivers and Lakes with Rivers and Lakes

The specific Data Dictionary for Biological data in Rivers and Lakes is integrated into the overall Data Dictionaries on Rivers and Lakes according to the scheme for Rivers water quality below (scheme for Lakes is analogous to Rivers).The specific Data Dictionary for Biological elements in Transitional and Coastal waters remains separated from TCM waters, keeping it as a separate and additional dataflow (WISE SOE Biol_TC).

Data model - Rivers

Table Biology in Rivers / Lakes – aggregated data:

The Field Mean Value is deleted. The 3 following fields are added instead

  • MeanValueOriginal
    Mean value of metric in the original metric scale (lakes only)
    This field is required for all records with DeterminandBiology NOT containing "EQR" and MetricScale = "Original" (e.g. Chlorophyll a).
  • MeanValueEQR
    Mean value of metric converted to national EQR scale (Ecological Quality Ratio).
    This field is required for all records with DeterminandBiology containing "EQR" and MetricScale = EQR.
    EQR is usually calculated as metric value divided by reference value, but different methods are used depending on the metric and the country.
  • MeanValueNormEQR
    Mean value of metric converted from national EQR scale to normalised EQR scale.
    This field is optional for all records with a MeanValueEQR reported. MeanValueNormEQR will also be calculated by EEA.

 

2. Update of list of Preferred hazardous substances for Data Dictionaries on Rivers, Lakes, Groundwater and TCM waters quality and definition of preferred nutrients for TCM data

According to the draft Hazardous substances added in the new EQS directive, the watch list of substances or hazardous substances suggested by NRCs, additional substances are supposed to be included into the list of Preferred hazardous substances for Rivers, Lakes, Groundwater and TCM waters reporting categories.

Overall list of Preferred SoE hazardous substances including the reason why the substance was added to this list is available on Forum here

Proposed 2012 updates (extracted from the above mentioned list) are available in table 1 and 2, further below.

EEA´s indicators based on TCM data have recently undergone an internal review process, in order to better consolidate them as well as ensuring better alignment with current policy processes (namely MSFD and WFD). In addition to the abovementioned update of the list of preferred hazardous substances this lead to the definition of preferred nutrient determinand groups. These are: 1) Chl-a, 2) Total Ammonium/Ammonium, 3) Total Phosphorus, 4) Orthophosphate, 5) Nitrate/Total Oxidised Nitrogen. This list has been defined to strengthen and improve EEA´s indicators on nutrients and chlorophyll-a, but it might be revised when necessary (e.g. change in policy needs, methodological improvements).

 

Table 1:
Substances already present in Data Dictionaries, but non included into Preferred Hazardous substances in 2011; proposal for new Preferred Hazardous substances:

CAS Name Gw code DDs_RiversLakes DD_Gw DD_TCM PrefHazSubst_RiversLakes PrefHazSubst_Gw PrefHazSubst_TCM seawater PrefHazSubst_TCM sediments PrefHazSubst_TCM biota
62-73-3 Dichlorvos 914 x x x x        
886-50-0 Terbutryn 855 x x x x x      
115-32-2 Dicofol   x   x x        
32598-13-3 PCB77 920 x x x       x x
32598-14-4 PCB105   x   x       x x
38380-08-4 PCB156   x   x       x x
32774-16-6 PCB169 921 x x x       x x
1746-01-6 2,3,7,8-tetrachlorodibenzo-p-dioxin   x   x       x x
262-12-4 Dibenzodioxin   x   x       x x
no CAS 17 TCDD (dioxins and furans)   x   x       x x
no CAS 9 Polychlorinated dibenzodioxins (PCDD)   x   x       x x
76-44-8 Heptachlor 837 x x x x     x x
1024-57-3 Heptachlor epoxide 838 x x x x     x x
100-02-7 Nitrophenol 1215 x x x x        
12002-48-1 Trichlorobenzenes 908 x x x x        

 

Table 2:
substances not available in any Data Dictionary yet; proposal for new substances which should be added into DDs as Preferred Hazardous substances:

CAS Name Gw code DDs_RiversLakes DD_Gw DD_TCM PrefHazSubst_RiversLakes PrefHazSubst_Gw PrefHazSubst_TCM seawater PrefHazSubst_TCM sediments PrefHazSubst_TCM biota
74070-46-5 Aclonifen x x
42576-02-3 Bifenox x x
28159-98-0 Cybutryne x x
52315-07-8 Cypermethrin x x
57-63-6 17alpha-ethinylestradiol x x
50-28-2 17beta-estradiol x x
15307-86-5 Diclofenac x x
1763-23-1 PFOS and its derivatives x x
124495-18-7 Quinoxyfen x x
PCB81 x x x
PCB114 x x x
PCB123 x x x
PCB126 x x x
PCB157 x x x
PCB167 x x x
PCB170 x x x
PCB189 x x x
3194-55-6 Hexabromocyclododecane (HBCDD) x x
29122-68-7 Atenolol x x
83905-01-5 Azitromycin x x
95-14-7 Benzotriazol x x
41859-67-0 Bezafibrate x x
298-46-4 Carbamazepin x x
81103-11-9 Clarithromycin x x
333-41-5 Diazinon x x
15687-27-1 Ibuprofen x x
136-85-6 Methylbenzotriazol x x
37350-58-6 Metoprolol x x
22204-53-1 Naproxen x x
723-46-6 Sulfamethoxazol x x
738-70-5 Trimethoprim x x
3115-49-9 Nonylphenoxyacetic acid (NPE1C) x x
58-08-2 Caffeine x x
13351-73-0 Tolyltriazole x x
335-67-1 PFOA x x

 

Annex 2: Important Scoring Criteria Updates

General update for all reporting categories, excluding Water quantity:

The rule „Timely data delivery to national repository and country feedback to reported data issues" is deleted from the list of individual criteria for 3 and 2 positive points. Instead of this, in the case of late delivery, delivery in non-proper data format or structure and / or missing country feedback, the scoring is reduced by one point (from 3 to 2 or from 2 to 1 point).

Rivers and Lakes:

Reporting of Biological elements in Rivers / Lakes or explanation for why biological data in correct format cannot be delivered was added to 3 positive points criteria

Water quantity:

Original 2011 criteria were updated by EEA for final evaluation purposes. In comparison to this already implemented update, the 2012 criteria are nearly identical. Negative point criterion is modified only to reflect if any Water Quantity data aer reported via the Eurostat/OECD Joint Questionnaire on Inland Waters.

Emissions to Water:

Evaluation of countries reported emissions data under other reporting obligations (E-PRTR, UWWTD, …) has been clarified.
In order to harmonise the differences between 2-3 and 1-2 possitive points requests, the criterion „At least two determinands for Nutrients and Organic Matter Emission Discharges from Diffuse Sources (if not delivered in past years)" has been removed from set of criteria for 2 smileys.
Minimal number of reported hazardous substances was increased from 2 to 3 substances for evaluation by 2 and 3 positive points.

TCM waters:

As a result of the internal review process of EEA´s indicators based on TCM data (nutrients, chlorophyll-a and hazardous substances in biota), elements in the data reporting which need improvement have been identified, hence becoming conditional for getting the maximum score. These are the following:

  • Delivery of data for at least one substance from each of the 5 preferred SoE TCM nutrient determinand groups: 1) Chl-a, 2) Total Ammonium/Ammonium, 3) Total Phosphorus, 4) Orthophosphate, 5) Nitrate/Total Oxidised Nitrogen;
  • Delivery of data on hazardous substances in biota for substances from the list of Preferred SoE TCM Hazardous Substances.

 

EWN1: River quality

Scoring criteria are based on data deliveries for the current year and focus on the provision of quality data for preferred SoE nutrients and physical characteristics of monitoring stations. Further criteria, important for achieving the maximum score, are the time-lines of the delivery, the provision of hazardous substances data, long time series of quality data for substances from 5 preferred SoE nutrient groups - 1. BOD5/BOD7/Dissolved Organic Carbon, 2. Total Ammonium/Ammonium, 3. Total Phosphorus, 4. Orthophosphate, 5. Nitrate/Total Oxidised Nitrogen - and data on proxy pressures and the response of a country to data validation questions.

:) :) :)

1. Reply to critical QA issues on previously reported data as specified in the 'Validation questions'; and
2. Delivery of river monitoring stations with coordinates (if not delivered in the past years); and
3. Delivery of data for at least one substance from each of the 5 preferred SoE nutrient groups; and
4a. Delivery of hazardous substances data and especially from Preferred SoE Hazardous Substances list; or
4b. Delivery of proxy pressures data for all reported monitoring stations (if not delivered in past years), and available time series for preferred SoE nutrients data are long at least 5 years if continuous, or 10 years if broken; and
5a. Delivery of biology data for at least one of the two river BQEs (phytobenthos and macroinvertebrates) in correct format: national EQR values and associated information on national classification system which allows for calculation of normalised EQR values; or
5b, An explanation for why biological data in correct format cannot be delivered.

In the case of late data delivery, delivery in non-proper data format or structure and/or missing country feedback, the scoring is reduced from 3 to 2 points.

:) :)

1. Delivery of river monitoring stations with coordinates (if not delivered in past years); and
2. Delivery of data for at least one substance from not less than 3 of the 5 preferred SoE nutrient groups.

In the case of late data delivery, delivery in non-proper data format or structure and/or missing country feedback, the scoring is reduced from 2 to 1 point.

:)

Delivery can be used, but does not meet the above mentioned requirements.

:(

No data delivery under WISE-SoE data collection 2012, no communication, or data could not be processed because it was not delivered in a requested format or did not follow the basic quality criteria or was delivered after the data processing period.

 

EWN2: Lake quality

Scoring criteria are based on data deliveries for the current year and focus on the provision of quality data for preferred SoE nutrients and physical characteristics of monitoring stations. Further criteria, important for achieving the maximum score, are the time-lines of the delivery, the provision of hazardous substances data, long time series of quality data for substances from 5 preferred SoE nutrient groups - 1. BOD5/BOD7/Dissolved Organic Carbon, 2. Total Ammonium/Ammonium, 3. Total Phosphorus, 4. Orthophosphate, 5. Nitrate/Total Oxidised Nitrogen - and data on proxy pressures and the response of a country to data validation questions.

:) :) :)

1. Reply to critical QA issues on previously reported data as specified in the 'Validation questions'; and
2. Delivery of lake monitoring stations with coordinates (if not delivered in the past years); and
3. Delivery of data for at least one substance from each of the 5 preferred SoE nutrient groups; and
4a. Delivery of hazardous substances data and especially from Preferred SoE Hazardous Substances list; or
4b. Delivery of proxy pressures data for all reported monitoring stations (if not delivered in past years), and available time series for preferred SoE nutrients data are long at least 5 years if continuous, or 10 years if broken; and
5a. Delivery of biology data for at least one of the two river BQEs (phytobenthos and macroinvertebrates) in correct format: national EQR values and associated information on national classification system which allows for calculation of normalised EQR values; or
5b, An explanation for why biological data in correct format cannot be delivered.

In the case of late data delivery, delivery in non-proper data format or structure and/or missing country feedback, the scoring is reduced from 3 to 2 points.

:) :)

1. Delivery of lake monitoring stations with coordinates (if not delivered in past years); and
2. Delivery of data for at least one substance from not less than 3 of the 5 preferred SoE nutrient groups.

In the case of late data delivery, delivery in non-proper data format or structure and/or missing country feedback, the scoring is reduced from 2 to 1 point.

:)

Delivery can be used, but does not meet the above mentioned requirements.

:(

No data delivery under WISE-SoE data collection 2012, no communication, or data could not be processed because it was not delivered in a requested format or did not follow the basic quality criteria or was delivered after the data processing period.

 

EWN3: Groundwater quality

Scoring criteria are based on data deliveries for the current year and the provision of quality data for a variety of determinands. A further criterion is the identification of groundwater bodies according to the criteria in the Document No.3: WFD reporting on River Basin Management Plans: Guidance on reporting spatial data v3.0 and Guidance No 22 - Updated WISE GIS guidance (Nov. 2008). Important for achieving the maximum score are the provision of disaggregated data of the 5 requested chemical substances or group of substances: 1. Ammonium, 2. Nitrates, 3. Nitrites, 4. Dissolved Oxygen, 5. priority pesticides from Preferred SoE Hazardous Substances: Atrazine (most important), Lindane, Simazine - and provision of GIS polygon data of groundwater bodies, provision of monitoring stations with coordinates and their link to groundwater bodies (if not delivered in past years). Link to groundwater bodies delineated according to the WFD Art. 5 and reported according to the WFD Art. 13 is mandatory for EU countries.

:) :) :)

1. Reply to critical QA issues on previously reported data as specified in the 'Validation questions'; and
2. At least 3 of the 5 requested chemical substances data reported in disaggregated structure; and
3. Monitoring stations with coordinates and their link to groundwater bodies (if not delivered in past years); and
4. GIS polygon data of groundwater bodies including the most important attribute fields mentioned in the methodology for GW body characteristics and the pressure table in the Data Dictionary (if not delivered up to now within WISE SoE reporting or WFD reporting).

In the case of late data delivery, delivery in non-proper data format or structure and/or missing country feedback, the scoring is reduced from 3 to 2 points.

:) :)

1. At least 2 of the 5 requested chemical substances data; and
2a. If disaggregated data are reported, monitoring stations with coordinates and groundwater bodies including the most important attribute fields mentioned in the methodology for GW bodies table (if not delivered in the past years); or
2b. If aggregated data are reported, groundwater bodies including the most important attribute fields mentioned in the methodology for the GW bodies table (aggregated data), (if not delivered in past years).

In the case of late data delivery, delivery in non-proper data format or structure and/or missing country feedback, the scoring is reduced from 2 to 1 point.

:)

1a. Quality data for at least 1 out of the 5 requested chemical substances; or
1b. GIS polygon data of groundwater bodies (if not delivered in past years); or
1c. Groundwater monitoring stations (sampling sites) with coordinates (if not delivered in past years).

:(

No data delivery under WISE-SoE data collection 2012, no communication; or data could not be processed because it was not delivered in a requested format or did not follow the basic quality criteria or was delivered after the data processing period.

 

EWN4: Water quantity

Scoring criteria are based on data deliveries for the current year. In order to receive a higher positive score (3 or 2 points) countries need to fulfil at least 2 requested minimum requirement criteria: criterion 1 plus one of the criteria 2 (2a, 2b or 2c) regarding the assessment of the reporting of regional parameters and point data.

Regional parameters are the parameters for the regional requested data (water balance, water abstraction, water use).

Point data are the individual measurements requested for stream flow, reservoir inflow/outflow, and groundwater level. All 4 sub-criteria need to be fulfilled to receive higher score for point data. The sub-criterion on available stations refers to a representative selection made by the country per RBD (river basin district) or SU (sub-unit) with reference to the reporting sheets for SoE data and information (Part 3, section 2) in the guidance document. It is understood that some of the point data may not be available for reporting due to force-majeure (i.e. security purposes for reservoirs) and in such cases (when stated in the comments field) this will be considered accordingly.

:) :) :)

1. Timely data delivery to the national repository in the requested format, reported both regional and point parameters, country feedback to reported data issues; and
2a. 45 regional parameters reported at RBD or SU scale for 75% of the RBDs or SUs of the country, 50% in monthly scale; or
2b. Point data for 75% of the RBDs or SUs reported as follows:

  • 50% of the available streamflow stations located in the RBD (or SU), 50% of the time series in daily scale, the remaining in monthly scale
  • 30% of the available groundwater wells located in the RBD (or SU), 50% of the time series in monthly scale, the remaining in seasonal or annual scale
  • 70% of the available reservoirs located in the RBD (or SU), 50% of the time series in monthly scale, the remaining in annual scale
  • total number of all available streamflow stations, groundwater wells and reservoirs located in the RBD (or SU), and reporting of their characteristic data (name, ID, coordinates etc. as included in the WQ reporting tool) for at least 75% of them
:) :)

1. Timely data delivery to the national repository in the requested format, reported both regional and point parameters, country feedback to reported data issues; and
2a. 15 regional parameters reported at RBD or SU scale for 40% of the RBDs or SUs of the country, 50% in monthly scale; or
2b. 45 regional parameters reported at country level in monthly (preferable) or annual scale; or
2c. Point data for 40% of the RBDs or SUs reported as follows:

  • 25% of the available streamflow stations located in the RBD (or SU), 50% of the time series in daily scale, the remaining in monthly scale
  • 15% of the available groundwater wells located in the RBD (or SU), 50% of the time series in monthly scale, the remaining in seasonal or annual scale
  • 35% of the available reservoirs located in the RBD (or SU), 50% of the time series in monthly scale, the remaining in annual scale
  • total number of all available streamflow stations, groundwater wells and reservoirs located in the RBD (or SU), and reporting of their characteristic data (name, ID, coordinates etc. as included in the WQ reporting tool) for at least 40% of them
:)

1a. Delayed data delivery under WISE-SoE data collection 2012; or
1b. Timely delivery, but the delivered data are not meeting the above mentioned requirements for obtaining a higher score; or
1c. Relevant Water Quantity data reported via the Eurostat/OECD Joint Questionnaire on Inland Waters (Tables 1, 1aIF, 1aOF, 2.1, 2.2, 3.1, 3.2, Summary Table and 7)

:(

No data delivery under WISE-SoE data collection 2012, no communication and no relevant Water Quantity data reported via the Eurostat/OECD Joint Questionnaire on Inland Waters.

 

WISE1: Emissions to Water

Scoring criteria are based on data deliveries for the current year and the provision of data for a variety of sources and determinands. Important for achieving the maximum score is the provision of a more detailed source of emission data (if not delivered in past years).

If emission data have already been provided under E-PRTR, UWWTD, WFD, SoE Quantity or SoE TCM reporting obligations and are flagged as such in the SoE emission reporting, then 1 or 2 smileys will be scored (1 if point source emissions data are provided via another reporting source, and flagged, 2 if point and diffuse are provided, and flagged.) It is not possible to attain 3 smileys simply through flagging other reporting streams which cover only part of the total emissions requested. However, the flagging of data or a possible transfer of reported total emissions (point and diffuse source, respectively) reported under other reporting streams at EU level with reference to reporting sheet EMI_SW_GW, will ensure at least one point is scored

Reported information "no change with regard to previous delivery" is accepted for diffuse emissions only; 2 following years maximum; identical evaluation for the whole period.

:) :) :)

1. Reply to critical QA issues on previously reported data as specified in 'Validation questions'; and
2. At least two determinands for Nutrients and Organic Matter Emission Discharges from Point Sources; and
3. At least two determinands for any Emission Discharges from Diffuse Sources (if not delivered in past years); and
4. At least three determinands for Hazardous substances Emission Discharges from Point Sources; and
5a. Emission values for any Emission Discharges from Point Sources split at least for Urban and Industrial discharges; or
5b. Emission values for any Emission Discharges from Point Sources split at least for non E-PRTR facilities or for both E-PRTR and non-E-PRTR Facilities. (for countries reporting under E-PRTR only).

In the case of late data delivery, delivery in non-proper data format or structure and/or missing country feedback, the scoring is reduced from 3 to 2 points.

:) :)

1. At least two determinands for Nutrients and Organic Matter Emission Discharges from Point Sources; and
2. At least three determinands for Hazardous substances Emission Discharges from Point Sources; and
3a. Emission values for any Emission Discharges from Point Sources split at least for Urban and Industrial discharges; or
3b. Emission values for any Emission Discharges from Point Sources split at least for non E-PRTR facilities or for both E-PRTR and non-E-PRTR Facilities (for countries reporting under E-PRTR only).

In the case of late data delivery, delivery in non-proper data format or structure and / or missing country feedback, the scoring is reduced from 2 to 1 point.

:)

1a. At least one determinand for any Emission Discharges from Point Sources; or
1b. At least one determinands for any substance from Diffuse Sources (if not delivered in past years); or
1c. At least one determinant for total emission discharges from sum of point and diffuse sources, respectively, is directly available at RBD level from other reporting at EU level.

:(

No data delivery under WISE-SoE data collection 2012, no communication or no sufficient emission data available for transfer from other reporting at EU level.

 

ME1: Marine data

Scoring criteria are based on data deliveries for the current year and focus on the provision of quality data for preferred SoE TCM nutrient determinand groups and preferred SoE TCM hazardous substances in biota. Further criteria, important for achieving the maximum score, is the response of a country to the data validation questions. Any data already submitted to the Marine Conventions need not be re-supplied. Countries are therefore asked to submit only missing or additional data.

:) :) :)

1. Reply to critical QA issues on previously reported data as specified in the 'Validation questions'; and
2. Delivery of data for at least one substance from each of the 5 preferred SoE TCM nutrient determinand groups: 1) Chl-a, 2) Total Ammonium/Ammonium, 3) Total Phosphorus, 4) Orthophosphate, 5) Nitrate/Total Oxidised Nitrogen;
3. Delivery of data on hazardous substances in biota for substances from the list of Preferred SoE TCM Hazardous Substances..

In the case of late data delivery, delivery in non-proper data format or structure and/or missing country feedback, the scoring is reduced from 3 to 2 points.

:) :)

Delivery of data on either at least one substance from each of the 5 preferred SoE TCM nutrient determinand groups listed above, or on hazardous substances in biota for substances from the list of preferred SoE TCM Hazardous Substances. In the case of late data delivery, delivery in non-proper data format or structure and / or missing country feedback, the scoring is reduced from 2 to 1 point.

In the case of late data delivery, delivery in non-proper data format or structure and / or missing country feedback, the scoring is reduced from 2 to 1 point.

:)

Delivery can be used, but does not meet the above mentioned requirements.

:(

No data delivery under WISE SoE collection 2012, no communication, or data could not be processed because it was not delivered in a requested format or did not follow the basic quality criteria or was delivered after the data processing period.