Wise-soE#3 data request on Water Quantity 2nd Regional workshop of etc/icm with West Balkan countries

WISE-SoE#3 data request on Water Quantity

• 2nd Regional workshop of ETC/ICM with West Balkan countries

• Skopje, 14.09.2011

Presentation Outline

• WQ Reporting needs and drivers

• WISE-SoE#3 development process

• Overview of WISE-SoE#3 requested data

• Water Availability
• Water Abstraction
• Water Use

• WISE-SoE#3 Reporting Tool

• Overview of 2010 reporting

• Assessment of reporting

• Data flow to support water assets accounts

WQ Reporting – Drivers and Needs

WISE-SoE#3 reporting – development process

Overview of WISE-SoE#3 requested data

Overview of WISE-SoE#3 requested data

Overview of WISE-SoE#3 requested data

Overview of WISE-SoE#3 requested data

Overview of WISE-SoE#3 requested data

Overview of WISE-SoE#3 requested data

HOW TO REPORT???

“Traditional” approach for data reporting

• The traditional approach is based on simple Excel sheets

• Advantages

• Well known tool
• Wide range of interfaces

• Disadvantages

• Not the appropriate format for representing complex data structures and interrelations
• No data quality testing at the source
• No online help
• Limitations of MS-Excel

• Such approach often leads to inappropriate working database design

Complexity of WISE-SoE#3 data

• Wide range of temporal (annual, monthly, seasonal, daily) and spatial scales (Country, RBD, Sub-Unit, NUTS) since MS requested flexibility in reporting

• Combination of point and areal data

• Time series and non time series data

• Numerous variables related to different geographical entities (stations, reservoirs, river basins etc.)

Water Quantity Reporting Tool

• Windows application

• No installation required (portable)

• Minimal hardware requirements

• Data from supportive files are loaded on start-up

• Regional files (RBD, SU, NUTS)
• Reported stations

• Data entry Wizard

• Bulk data import

• Export utilities

• Help manual & Online Help

• Pre-filling (for next reporting years)

• 24/7 support   

Water Quantity Reporting Tool

Water Quantity Reporting Tool

Overview of reporting (March 2011)

Spatial coverage of WQ reported data

Average number of reported regional data (water balance (WB), water abstraction (WA), water use (WU))

Average number of reported point data (stream flow, reservoir inflow-outflow, GW levels)

Assessment of reporting

Assessment of 2010 reporting

Smiley criteria

Smiley criteria

Smiley criteria

Data flow to support water assets accounts

Statistics on stream flow stations reported under the 2010 WISE-SoE#3 data request on water quantity

• 19 countries have reported stream flow data so far, namely: Austria, Belgium, Bulgaria, Croatia, Cyprus, Czech Republic, Estonia, Finland, Ireland, Latvia, Lithuania, Macedonia (FYR), Republic of Serbia, Slovakia, Slovenia, Spain, Sweden, Switzerland, Turkey.

• 6 of which did not have valid station coordinates (non projected)

• that makes 612 stream flow stations in total

• 567 of which have (at least some) discharge data

• all in all 1000 discharge time series have been reported (some countries report up to three time series per station for different time scales) of which:

• 431 are daily time series
• 289 are monthly time series
• 280 are annual time series

• Most data refer to the year 2009.

Statistics on stream flow stations reported under the 2010 WISE-SoE#3 data request on water quantity

Drivers and Needs

• Enhance the topic of water efficiency by development of water accounts at the centre of the assessments of water quantity

• Europe 2020 Strategy
• EEA AMP 2011
• European Commission “Blueprint to safeguard Europe’s waters” accompanied by
• EEA extended report on the “State of Europe’s water”

• Data needs to support the water assets accounting

• Stream flow stations and mean daily stream flow data from the past 15 years

Thank you !