A brief from the client:
Reduce workload for staff doing the Monthly Consent Compliance Report
The Wairoa District Council engaged the Waugh Infrastructure Management to assist them in the automation of reporting from SCADA and other data sources for compliance reporting to the Hawkes Bay Regional Council.
Wairoa District Council feels that the wastewater industry is heading into a period of greater regulation and compliance reporting and now is the time to get the processes in place to make Regional Council consent reporting automated and less burdensome as possible.
A series of meetings were undertaken to gather all relevant data to form a clear view of:
- What is currently happening
- What needs to happen
- What is working well
- What is not working well
Following the initial investigation, we proposed to setup a process to extract data nightly and evaluate and store this in a database ready for reporting.
As much as possible we try and use the software that the Council already owns and supports. We were able to do this with the project as well.
Telemetry data from the sewage treatment plants SCADA was combined with daily rainfall and tidal data from external sources. Each morning the previous day’s data is evaluated automatically according to each condition of the consent. Rainfall and tide times are also automatically downloaded from an approved website to save staff having to interpret or transpose this data.
This daily summary is then available in the report with data highlighted when it does not comply with the condition. Space is provided to comment on the reasons why non-compliance might have occurred.
An annual summary was also provided for Wairoa District Council to identify trends over a longer time period.
The ability to produce a monthly electronic report to the Regional Council within minutes rather than days and also reduced human error or the need for manual intervention.
Below is an example of how the report appears (not actual data)