Case Histories - Data Management

Project: Water / Waste Water Treament Plant Data Integration System

Client: City of Hamilton

Objectives:

Develop a customized integrated database system for water and waste water treatment information that will assist with the efficient operation of the water/ waste water treatment systems.

Outcomes:

higher level of review of water/ waste water quality data
automation of many routine calculations and equations
savings in time by having immediate access to all data

Key Aspects:

singular interface for managing LIMS, SCADA and Operational Data
automated notification of system exceedances
automated reporting tools for regulatory requirements

Project Description:

The operation of the City of Hamilton’s water and waste water treatment plants produces three main sources of data: LIMS (Laboratory Information Management System), SCADA (Supervisory, Control And Data Acquisition) and operational log data. To efficiently evaluate the operation of the treatment plants it is necessary to have all three sources of data present.

The City of Hamilton retained EarthFx to develop a data integration system that pulls relevant LIMS and SCADA data from their respective databases into a single interface that is used to manipulate and review the data. It also provides tools for the electronic storage of operational log data. Using the interface, staff will be able to quickly review, query, graph and report data from all three data sources.

Conclusion:

The data integration system will become a hub for future data sources such as waste haulage, plant modelling results and equipment information and calibration data.