A hydrological information- & data-base

1. A hydrological information- & data-base thedwaf DEPARTMENT OF WATER AFFAIRS AND FORESTRY

2. HYDSTRA: Background................ Commercial off-the-shelf product Originally an Australian company, Now merged with Kisters, Germany Both specialising in Hydrology HYDSTRA used in 22 countries More than 150 installations

3. HYDSTRA: Distribution in SA…. DWAF Head Office 3x DWAF regions 12x DWAF laptops 10x KOBWA Namibia Botswana??

4. HYDSTRA: Supporting............... Data Acquisition from multi-sources Integrated data management Managing long time-series Graphic user interfacing & editing Analysis, modeling & simulation Archiving with quick access Data & information dissemination

5. HYDSTRA: Basic Components.... Archive Structures Workbench Displays Calculations & Conversions Data Dissemination Advanced Functions

6. HYDSTRA: Archive Structures...... • Multiple Versions of Records • Compressed Time Series • Database Tables

7. HYDSTRA: Archive Structures...... • Multiple versions of records: • Infinite number of sites • Up to 250 variables per site • Up to 100 versions per variable • Can store temporary versions in other directories, on server & PC.

8. HYDSTRA: Archive Structures...... • Compressed Time Series: • Water levels • Reservoir components • DWAF evaporation and rainfall • Weather Bureau rainfall • Dam balances • Comments per data item • Up to 100 quality flags per data item

9. HYDSTRA: Archive Structures...... • Database Tables: • Site details • Ratings • Basin surveys • Site History • Statistics on records

10. HYDSTRA: Workbench...... • Used for data editing / archiving • Functions: • Cut and Paste • Time adjustment • Free hand drawing • Reference trace • Zoom • Edit to control readings • etc

11. Graphical View in Workbench

12. HYDSTRA: Displays...... • Customising to: • Specify period per page/s • Combined records • Type of plot • Statistical plots • Different periods on one plot • Destination of output

16. HYDSTRA: Displays………. Box and Whiskers Plot:

17. HYDSTRA: Conversions………. Variable / version Quality codes Rating tables / equations Powerful tools for data conversion Convert to another variable In a string of steps Define once, re-use

18. HYDSTRA: Dissemination…… Many flexible retrieval options Define groups of stations Graphical / text / electronic output Output can be customised DLL for external retrieval of data Data on W W W - refreshed daily

19. HYDSTRA: Dissemination…… Can select station numbers from: group file directory database or defined table combination / filters (and, or / not)

20. HYDSTRA: Dissemination…… HYCSV: useful facility extract data in CSV format multiple columns with variable conversion open in Excel

21. HYDSTRA: Dissemination W W W www.dwaf.gov.za/hydrology/cgi-bin/his/cgihis.exe/station or On DWAF website: HYDROLOGY: Dams Flows and Floods Access Data (new)

22. HYDSTRA: Dissemination W W W

23. HYDSTRA: Dissemination W W W

24. HYDSTRA: Dissemination W W W

25. Mapping Interface

28. HYDSTRA: Advanced………… HYCRSUM: combine two time series add, subtract, multiply or divide time shift variable conversion create new time series

29. HYDSTRA: Advanced………… HYCRSUM - Input screen

30. HYDSTRA: Advanced………… HYCRSUM - plot of result

31. HYDSTRA: Advanced………… MODSYN: powerful modeling language based on vector algebra uses time series as vectors specify time steps do variable conversions

32. MODSYN - example script

34. HYDSTRA: Conclusion Data readily available Easily accessible Multiple formats Multiple media Powerful data manipulation W W W Convenience

35. HYDSTRA: Conclusion…… For more information, please try: WWW.hydstra.com

36. Thank You