Integrated Hydrological Data Management Software Systems for Hydrological

Integrated Hydrological Data Management - Software Systems for Hydrological Data Archives, Water Observation and Information Systems by Grad. Geographer Matthias Egeling Germany KISTERS AG * von x

Demands on Software Systems in Hydro. Meteorology (1) Demands • todays information technology represents an ideal base for hydrological information systems • integrated views to: - Data acquisition - Data evaluation - Dissemination of verified hydrological and ecological data sets • with interfaces to: - hydrological modeling - water management techniques - geographical localisation (GIS) - public information (Web) - water quality measurements 2

Integration and Interfaces Monitoring systems WISKI Hydrometeorological workbench Central Database Model Integration Management and Supply of Information by Web Water Quality Data Management 3 Interface to Geographical Information Systems (GIS)

Demands on Software Systems in Hydro. Meteorology (2) Demands • linked informations of different measured hydrometeorological and environmental parameters …knowing the dataflow from the origin of the measured values until the presentation of the results… • the user must be supplied with significantly information about data quantity and quality and the processing history of data values in addition to the value itself …every calculation is only as good as their source values… • user-acceptance of the software through userinterfaces which follows the daily workflow 4

Hydrological Workbench WISKI Hydrological Workbench longterm values maximum monthly maxmimum longterm values mean monthly mean longterm values minimum monthly minimum 5

WISKI Explorer Hydrological Workbench Control center WISKI-Explorer • hierarchic structure • sorting by - station name - station number - station types…. • efficient management and adaption of single values and mass data f. i. context menu stations: 6 f. i. context menu time series:

Data Collection and Import Hydrological Workbench WISKI Automatic Import DIGIT Scanning of import folder, converting and importing Analog / Mechanical Strip Charts BIBER Manual File Import & & over 60 various data formats Discharge Measurements Import devices SODA (OTT Vota, SEBA HT 100, Aqua. Calc, PSION) Telemetry System 8 WISKI Manual input Excel/Access or clipboard

Standardised Hydrological Correction Tools Hydrological Workbench Graphical Correction Tools: • Gap filling algorithms • Interpolation • Filtering algorithms • Formulas • Regression and Statistics • Models • Comparison to neighbouring stations All tools are available in a standardised interface, the time-series-graph 10

Working with a Second Gauge Hydrological Workbench Quality Control Graph with • 1 st Gauge (blue) • 2 nd Gauge (red) • Difference (green) • Observer gauge reading (yellow points) • Standard Remarks by the Observer Graph and Data by Baden-Württemberg Institute For Environmental Protection (Lf. U) 11

Multi-Tier architecture for Time Series Management Solutions Web-Tier Application/module -Tier Webclient 1 Printer TCA 1 TCA 2 TCA 3 AIS & Report Server-Tier Webclient 2 Webclient 3 Webserver TCA SODA Telemetry System Central server TSM Calculation Server TSM Storage-Tier Database 1 12 Database 2 File server process control systems with real-time data

References (1) References 13 • WISKI is present now in Germany, Austria, Switzerland, Sweden, Scotland, England Wales, Ireland, Netherlands, Belgium, Luxemburg, Kosovo, Italy, Spain, Canada and the United States of America • Our basic technology is used by more than 300 different installations and more than 2000 users. • Such a large number of customers and requirements can only be handled with a special strategy: - Concentrate on product development - Keep the product modular and flexible - Keep in close touch with the customers and the technological development

References (2) References The HARP Project the Weofhave Environment Agency, National Clients from 1 User and 70 Archive 32, 000 Stations measuring points and stations up 2. 6 to… Billion data points 60 GB database the new national hydrometric archive of England Wales 14 WISKI 300 concurrent user 600 in total

Many thanks indeed! Thank you very much for your patience and attention! 15