AWT have developed H2KnOw-How, a cloud based web platform that focuses on providing solutions for the water sector. MiPlant data management system has been specifically developed to bridge the gap between wastewater and water planning and plant operations. The system provides necessary information to make management decisions, identify and respond to trends that require attention and minimize treatment plant operational costs. The system is designed by experts in water industry with excellent knowledge of treatment plants and their operation. The core functionality includes:
- Real time and static monitoring of treatment plants;
- Real time decision support combining monitoring data and data analysing techniques that allow the user to identify events that require immediate attention;
- Management and reporting of effluent quality data; and
- Mobile access to data and reporting.
The key areas where MiPlant can add value to the day to day operations include:
- Allows user to work continuously from a common data set avoiding the need of maintaining different spreadsheets and software packages
- Users with permission can access the service freely from anywhere, anytime
- AWT Water Ltd are able to provide seamless updates and bug fixes on a ongoing basis
- Provides flexibility with the benefit of data protection, centralised data management and analysis
- The platform can be continually expanded and is fully customisable at every level to suit specific needs with no licensing issue
- Minimised treatment plant operational cost through data access, data analysis, transparency and benchmarking
- Driving down the costs through automation of systems and reporting
- User friendly interface and geospatial view of plant operations makes it logical and easy to locate and work on the data nodes
MiPlant data management system (DMS) is a cloud based platform that allows quick storage and analysis of wastewater treatment plant operational data. The unit processes can be displayed as a geospatial view or as a schematic process diagram. Data can be uploaded to corresponding data nodes along with additional features to generate graphs and reports of any collected data set. The system can store virtually any type of data at any resolution including but not limited to SCADA data, field samples, lab results, pictures, reports and much more.
As the system is based on open source technology MiPlant is freely accessible for user with permission and internet access and doesn't require any additional software installation or licenses.
MIPLANT DMS-Start Guide
What follows below is the step by step procedure on how to operate MiPlant data management system.
Logging on and Understanding the DMS
To view MiPlant data management system for a particular site, Login to H2KnOw-how with your provided credentials. Then select Process design to view your treatment plant. MiPlant displays the treatment plant on a geospatial interface where the unit processes and plant features are shown on their respective location.
The treatment facility can be displayed either on an aerial photograph of the physical location or as a schematic view of the treatment plant. Aerial view of the treatment facility can be viewed by clicking on ‘Map’ and schematic diagram of the plant can be viewed by clicking on ‘Schematic’ as shown on Figure 3 (top right corner).
Individual data nodes can be created for each process unit by selecting the ‘add to map’ icon () on the top left end side of the map and placing it on the desired location. It will open ‘Add a new asset to map' icon.
To save a new asset, select the type of process unit, add its name and description and click 'Save'.
An interactive pop up window will appear on the screen if you hover or click over an icon. A description of the process unit or sample point will be displayed on this interactive icon (Figure 7).
To perform additional operations or view further information click on ‘more details’ or double click the data node. A pop up window will appear on the screen (Figure 8).
The bottom left side of the popup window has the lists of activities that can be performed on each of those pins (Figure 8; the asset description and attributes are also available on the top of the window). The various actions include:
- View data (): View data icon allows the user to view the uploaded data.
- View graphs (): View graph icon displays the data as a graphical representation.
- Edit node (): Edit node button enables editing of existing asset. User can modify the asset and then click ’save' to save the changes.
- Delete Node (): Delete node button can be used to delete any particular data node. It should be noted that if any asset is removed the system will remove all the related information and this cannot be undone.
There is also an option to add notes and relevant documents to each data node and user can also control the visibility of the uploaded files.
View and Import Data
The data stored on the data management system is stored within the relevant nodes. This allows the user to get access to the data of each unit process in the quickest way possible. The view data icon at the bottom left side of the window allows the user to view the uploaded data (Figure 9). Additional functions on this data page include option to view the data over a required period of time. User can also adjust the variables they wish to be displayed. A standard set of statistical calculations is performed on the data set and will be displayed alongside this dataset.
To import data to the selected node, the user clicks the import data icon on the top right side of the view data window. This will open ‘import data’ popup window and the user can select the appropriate data file and follow the instructions described below.
Click the 'Browse' button and direct the software towards your CSV data file. Then click the 'Upload' button. The spreadsheet data must be mapped to appropriate variables. The user can do this by clicking the drop down menu beside each data heading and selecting the appropriate data type (Figure 12). Once the variables are mapped click ‘confirm mapping’ which will upload the dataset to the website.
When the data is imported successfully a window will pop up with the message showing ‘data points successfully imported along with the number of data point uploaded. The uploaded list can be viewed by refreshing the page.
Format for Data Importing
It should be noted that the data file should be saved in a CSV format. Data uploading for each node should be done separately. It should be noted that while uploading data CSV file should only contain the data set of that particular node. The first row of the file shall contain the column names and at least one column of data in the file needs to be the date and time of recording in the “dd-mm-yyyy hh:mm:ss” format.
There is an option to add threshold value for each variable. User can select the variable from the drop down menu and, if there is no existing threshold value, click on ‘add new’ button. This will display a new line under the Thresholds bar where values can be entered and saved. To delete an existing threshold click on delete button () on the right end of the line.
Graphical Data VIewing
In order to view the graphical representation of the data click on the 'View graph' icon on the top right side of the view data screen.
User can select the sampling point and the required parameter(s) and the graphical view will change accordingly. A standard set of statistical parameters is also displayed on the screen along with the parameter. Additional features are available in this page and these features include Add trace (), View data (), Download Data (), Breach events () and Scatter Plot ().
View data icon () will redirect the user to the view data home page (Figure 9). Add trace icon () provides the functionality to add a trace from any other sampling point. If the user click on ‘add trace' icon a popup window will appear on the screen. The sampling point can be selected from the drop down menu. Once the sampling point and parameter are selected click Done button.
A new graph will be plotted along with the existing one. This will help the user to compare two sampling points.
Breach events icon () on the top right end side of the view chart window (appears only if a threshold has been created on the View Data page) will display threshold breach events for the particular data node. A standard set of statistical parameter will also be displayed along with the parameter. Breach event will display the breach events page where time and date of events, event duration and value will be shown as well. There is also an option to download () the page.
This will help to analyse whether parameters are within their consent or operating limits. There is an option to download data from the website using download button (). A confirmation pop up box will appear on the screen so that the user can check the desired date range and resolution have been selected on the main Breach events page (Figure 18). Click the 'Download' button to create the breach events report in the Documents section of MiPlant. From this page, all documents can be downloaded onto the user's computer.