WSC Hydrometric Workstation

1. WSC Hydrometric Workstation Business Processes Guidance

2. Introduction The role of CIOB Data publication in a continuous approval process Review of the detailed data production work flow Description of WSC business rules, standards and best practices AQUARIUS data structures and hard-coded constraints • Automated approvals and approval overrides • Flags and grades • Notes and data documentation

3. System Architecture

4. System Failsafe

5. Data Acquisition System

6. Overview Standards • National QMS requirements – a commitment to clients Business rules • National, Regional, Local: to optimize program efficiency and effectiveness Best Practices • The best possible data under the circumstances Hard-coded constraints • By omission or commission

7. Business Process Diagram

8. Data Publication

9. Approval levels • ‘Unprocessed’ data is what you see in the gauge house – by the time data gets into AQUARIUS it should already be ‘Preliminary’ • ‘Preliminary’ data needs to be examined : • a) To ensure that auto-processes are working correctly • b) To correct deficiencies that auto-processes cannot handle • The manual corrections applied to the data need to undergo scrutiny to ensure that they are complete, appropriate, and correctly applied • Compliance with QMS objectives must be affirmed by a qualified individual before the data is ready for archive

10. Unprocessed to preliminary

11. Preliminary to Approved

12. Processes by activity

13. AQUARIUS data concepts Primary Signal (e.g. HG Telemetry @ StationID) Working Signal (e.g. HG Working @ StationID) • Contains both telemetry and logger if available, telemetry is, by design, the default RAW signal Derived Signal (e.g. QR Working @ StationID) • Combines a time-series with a HydroML Discrete Signal (e.g. HG Field Visit @ StationID) HydroML (e.g. HG QR rating curve @ Station ID)

14. AQUARIUS data attributes Every time-series is an AQUARIUS Optimized Package (AOP) which has these attributes: • Raw • Corrected • Interpolation type • Grades • Flags • Approvals • Notes

15. Raw The raw signal is sacred - it cannot be edited or deleted The raw signal is the original input - regardless of where the input came from The RAW input to a ‘working’ signal is the CORRECTED primary signal

16. Corrected The CORRECTED signal in an AOP is the RAW signal with all corrections applied to it The corrections are all date-stamped hence corrections can be turned on or off in any order Corrections are applied in sequence according to the date-stamp

17. Interpolation Type Type 1 – Instantaneous value (e.g. HG) Type 2,3,4,5 – Value in preceding interval (e.g. mean, max, min or total for an aggregation interval) Type 6 - Instantaneous total(e.g. TBRG) Type 7 – discrete value – no interpolation Type 8 – Value in succeeding interval (e.g. Gate opening) Type 9 – Direction in preceding interval (e.g. Wind direction) Type 10 – Total in succeeding interval (e.g. Flow volume)

18. Grades Are agency specific and controlled with the admin tool as a definition table In WSC – BEAD - in that order. A is only relevant to daily aggregated values which, in HWS, is a reporting function.

19. Flags Threshold or Rate of Change detection based on: >, >=, <, <=, >< and <>. By design, flags on auto-processes apply to the CORRECTED signal

20. Approvals Are agency specific and controlled with the admin tool as a definition table In HWS the approval states are: • Unprocessed – data upstream of AQUARIUS • Preliminary – have been auto-processed on append into an AOP • Reviewed – have been scrutinized for validity and invalid data has been manually corrected or deleted • Checked – the data have been peer reviewed • Approved – the data have been assured according to national standards by a qualified expert

21. Notes and Comments Notes are attached to an episode of data Comments are attached to any action taken on the data The default comment for any correction includes all details needed for reproducibility Free-form editing • Advantage – you can be specific • Disadvantage – sorting or searching by free-form may be unproductive • Comment list can reduced typing

22. AQUARIUS Propagation and Aggregation rules

23. Approvals: mules and donkeys Bench Mark Analysis – no Approval Field Visit Measurements – Approval but no Propagation Rating Curves – Approval and Propagation Rating Periods of Applicability – Approval and Propagation Shift Corrections – Approval and Propagation

24. Log Log tab in SB Log node in FVT Change history in DCT • Corrections can be undone without affecting history • Undone corrections can be deleted - then they are gone from history

25. User authentication Every action is attributed to the logged in user Change your password Actions can be sorted by creator

26. Attaching supporting documentation Pictures, scanned field notes etc. Original measurement files, logger files

27. Other data modifications Recalculate in FVT • Default = do not calculate – current meter rating tables are not stored in HWS! Override of date in imported measurement – possible - but comment required Override of values, comments – not possible

28. Training  Trial Implementation  National Implementation The HWS is designed to support compliance with Standard Operating Procedures and Business Rules The SOPs and business rules will be in a state of flux for the next little while.

29. Thank you from the AI Team We hope that you enjoy AQUARIUS!