date/ event: author: overview of etc water data outputs 2010 miroslav fanta etc water data manager...

Date/ event: Date/ event: Author:Author:

Overview Overview of of

ETC Water data outputs 2010ETC Water data outputs 2010

Miroslav FantaMiroslav Fanta

ETC Water data managerETC Water data manager

7. - 8. 6. 2010 WISE TG Meeting Madrid

Miroslav Fanta ETC Water


Content of the PresentationContent of the Presentation1)1) WISE-SoE reportingWISE-SoE reporting - - Rivers Water QualityRivers Water Quality - Lakes Water Quality- Lakes Water Quality - Groundwater quality- Groundwater quality - - Transitional, Coastal and Marine Waters QualityTransitional, Coastal and Marine Waters Quality - Emissions to water- Emissions to water - Water quantity- Water quantity

2) Directives reporting2) Directives reporting - - Urban Waste Water Treatment Directive Urban Waste Water Treatment Directive - Bathing Water Directive- Bathing Water Directive

3) GIS reference layers3) GIS reference layers

4) Plans, on-coming changes4) Plans, on-coming changes




ETC-Water webETC-Water web




Rivers water quality – reported Rivers water quality – reported datadata




Rivers – published European Rivers – published European datasetdataset




Rivers – structure of published Rivers – structure of published data data




Rivers – content of the published Rivers – content of the published datadata

Nutrients and organic matter, most important for Nutrients and organic matter, most important for rivers, used for indicatorsrivers, used for indicators

– BOD5 (BOD7)BOD5 (BOD7)– Total Ammonium Total Ammonium – Orthophosphate Orthophosphate – Nitrate Nitrate – NitriteNitrite– Chlorophyl aChlorophyl a– Chemical oxygen demand, Dissolved oxygenChemical oxygen demand, Dissolved oxygen– Others (cca 25 substances in total, see list in Data Others (cca 25 substances in total, see list in Data Dictionary)Dictionary)

Water quality data are aggregated by station, Water quality data are aggregated by station, substance and yearsubstance and year




Rivers – Quality AssuranceRivers – Quality Assurance - Primary key tests- Primary key tests - Data type and codes tests- Data type and codes tests - Cross – table relations tests- Cross – table relations tests - Logical rules violation tests- Logical rules violation tests - Detection of outliers- Detection of outliers - Stations tests- Stations tests

Quality control documentation publishedQuality control documentation published




Lakes water quality Lakes water quality

Analogical structure and content of Analogical structure and content of reported and published data as in the reported and published data as in the case of riverscase of rivers

Data from different depths can be Data from different depths can be reportedreported




Groundwater quality – reported Groundwater quality – reported data data




Groundwater – published Groundwater – published datasetdataset




Groundwater – example of Groundwater – example of published table structure published table structure

descriptiondescription




Groundwater – content of Groundwater – content of published datapublished data

Nutrients and most important pesticidesNutrients and most important pesticides– NitratesNitrates– NitritesNitrites– AmmoniumAmmonium– Dissolved OxygenDissolved Oxygen– Lindane, Simazine, AtrazineLindane, Simazine, Atrazine

Groundwater quality data are aggregated by Groundwater quality data are aggregated by groundwater body, substance and yeargroundwater body, substance and year




TransitionaTransitional, Coastal l, Coastal

and Marine and Marine water water

quality – quality – reported reported

data data




TCM – published dataTCM – published data10 tables:10 tables:

- WISE-SoE monitoring stations- WISE-SoE monitoring stations

- WISE-SoE flux stations- WISE-SoE flux stations

- ICES and MEDPOL stations- ICES and MEDPOL stations

- Hazardous substances in sediments / biota / - Hazardous substances in sediments / biota / seawaterseawater

- N- Nutrients, oxygen and organic matter in seawaterutrients, oxygen and organic matter in seawater- PProxy pressures roxy pressures on the upstream catchment or drainage basin on the upstream catchment or drainage basin of theof the transitional watertransitional water

- Discharges - Discharges (yearly direct discharges to the TCM water)(yearly direct discharges to the TCM water)

- Input- Input ( (yearly riverine input loads toyearly riverine input loads to TCM water) TCM water)




Emissions to water - reported Emissions to water - reported data data




Emissions – overviewEmissions – overview

Nutrients and Hazardous substances data are Nutrients and Hazardous substances data are reported as aggregated by spatial unit, substance reported as aggregated by spatial unit, substance and yearand year

Spatial unit types: RBD, SubUnit, coastal / Spatial unit types: RBD, SubUnit, coastal / transitional / transitional / ground / surface water bodyground / surface water body

2009 = first year of regular reporting (14 countries)2009 = first year of regular reporting (14 countries)

5 tables published:5 tables published:

- Spatial Unit Characteristics and pressures- Spatial Unit Characteristics and pressures

- Nutrients Emission Discharges from Point / DiffuseNutrients Emission Discharges from Point / Diffuse SourcesSources

- Hazardous Substances Emission Discharges from Hazardous Substances Emission Discharges from Point /Point / Diffuse SourcesDiffuse Sources




Water Quantity - principlesWater Quantity - principles




Water Quantity – simplified data Water Quantity – simplified data schemescheme




Water Quantity – overviewWater Quantity – overview

2009 = first year of regular renewed reporting2009 = first year of regular renewed reporting

Data not published up to now, structure of data for Data not published up to now, structure of data for publication is consulted with expertspublication is consulted with experts

Expected publication: July 2010Expected publication: July 2010




UWWTD reportingUWWTD reportingBi-annual reporting periodBi-annual reporting period

2007 data published (8 tables), 2009 reporting in 2007 data published (8 tables), 2009 reporting in processingprocessing

Full-range and careful QA process, incl. spatial data Full-range and careful QA process, incl. spatial data (coordinates) checking(coordinates) checking

Data relations and linksData relations and links::

Agglomerations Agglomerations

-> Uwwtp_Agglo -> Uwwtp_Agglo

-> UWWTPs-> UWWTPs

-> Discharge points-> Discharge points

-> Receiving areas-> Receiving areas7. - 8. 6. 2010 WISE TG Meeting Madrid



UWWTD – published 2007 dataUWWTD – published 2007 data




Bathing Water Directives Bathing Water Directives reportingreporting

Status of bathing waters reported by countries, Status of bathing waters reported by countries, including abnormal situations, short term pollution including abnormal situations, short term pollution and concentrations of most important pollutantsand concentrations of most important pollutants




BWD reporting – data viewerBWD reporting – data viewer




GIS Reference LayersGIS Reference Layers

WISE Large Rivers and Large Lakes WISE Large Rivers and Large Lakes (version 1.1, (version 1.1, February 2009)February 2009)

WISE River Basin Districts WISE River Basin Districts (ver(ver.. 1.3, June 2008, ver. 1.4 1.3, June 2008, ver. 1.4 withwith SubUnits planned in July ?? 2010 SubUnits planned in July ?? 2010 (Atkins))(Atkins))

WFD Art.5 groudwater bodies WFD Art.5 groudwater bodies (upper horizon) (upper horizon) – Autumn – Autumn 20102010

UWWTD Sensitive AreasUWWTD Sensitive Areas – first working version with – first working version with correctcorrect topology updated with 2009 reporting data finished last topology updated with 2009 reporting data finished last weekweek




Planned Planned activities activities

– – Biological Biological reportingreporting




Planned activities – Priority Planned activities – Priority Hazardous Substances Hazardous Substances

publicationpublicationAggregated concentrations of priority hazardous Aggregated concentrations of priority hazardous substances in rivers, lakes, groundwater, TCM substances in rivers, lakes, groundwater, TCM

33 hazardous substances according to the EQS 33 hazardous substances according to the EQS directivedirective

10 – 20 additional most important substances 10 – 20 additional most important substances relevant for each water categoryrelevant for each water category

Data are still checked and quality assured, Data are still checked and quality assured, publication in 2010 not confirmed yet for all water publication in 2010 not confirmed yet for all water categoriescategories

2011 -> regular publication2011 -> regular publication7. - 8. 6. 2010 WISE TG Meeting Madrid



Planned activities – web map Planned activities – web map servicesservices

Data structure modification for new GIS technology Data structure modification for new GIS technology planned in EEA for map publication in 2011 (ArcGIS planned in EEA for map publication in 2011 (ArcGIS Server, FLEX API client interface), web map services Server, FLEX API client interface), web map services and web feature servicesand web feature services

Link of tabular data to spatial objects (GIS layers of Link of tabular data to spatial objects (GIS layers of monitoring stations, groundwater bodies)monitoring stations, groundwater bodies)

Loading of published data into clientLoading of published data into client’’s map s map composition will be available (-> analysis, composition will be available (-> analysis, corelations of water quality with other data)corelations of water quality with other data)




Thank you for attentionThank you for attention



date/ event: author: overview of etc water data outputs 2010 miroslav fanta etc water data manager...

Documents

water slide

water emissions

water web

water data outputs

water data manager

date event

water quantity overview

water quantity principles