Exporting Model Results
Exporting Model Results for model elements mapped to real sensors
To export model results for the model elements which are mapped to real sensors, go to the Network Monitoring >> Graphs view, and make sure to turn on Model results toggle inside the eye icon:
Model results will then be displayed with a blue line in the graphs. To export the model results just click in the download button located on the top right:
Two excel files will be generated per each sensor (or zone or large customer), one with the model results and another one with the signal and confidence bands (pattern) results. By default results will be exported only for the most recent days, but user can change the period by selecting another period on the calendar icon, and then clicking export to CSV again, as shown below.
Exporting Model Results for any pipe
Model results for any pipe can be exported into a shapefile format (and from there user can easily copy to excel format if required). The steps are the following:
1- Make sure that an hydraulic model already exists in WaterSight and it is successfully running (go to Admin >> Numerical Models >> Simulation history),
2 - Go to Admin >> GIS and upload a pipes shapefile. Make sure that at least a column labelled ID exists and that a zip file is uploaded containing at least the five extensions: cpg, dbf, prj,shp, shx. More information available here - GIS.
3- After successful upload of the shapefile, make click on the "Append Model Results" button located on top of the table.
4- Select a period and select the field in WaterGEMS which will map with the ID column in the GIS shapefile. You can either choose the Label or GIS ID field that exists in the WaterGEMS.
5 - After the process finishes, export the pipes shapefile, by clicking in the export button located in the pipes row. When opening the pipes shapefile you will see that additional fields were created for each pipe (max flow, min flow, max pressure, min pressure, change in pressure, max velocity, min velocity, max head loss and min head loss)
6 - You can also check those fields by directly accessing the Maps page and clicking in any pipe. The new model properties, directly calculated from the model, are displayed in the information side panel.
Please note that if the ID in the GIS pipe shapefile does not match the one from the model (either Label or GIS ID fields) the mapping will fail and model values of zero will be instead considered for each pipe
Creating Model Thematic Maps
If a successful model run exists in WaterSight, a GIS pipe shapefile is uploaded, and the "Append Model Results" button is pressed (see above section), then it is possible to create your own modeled thematic maps with the maximum pressure or minimum pressures or flows by accessing the Capital Planning Module and then by creating Aspects. More information is available here.
It is also possible to use PowerBI to connect with modeled data and produce other thematic maps. More information here - Creating PowerBI reports
See Also
Mapping Model elements with Sensors
Comparing Modelled data with Measured data
OpenFlows WaterSight TechNotes and FAQ's
WaterSight - Learning Resources Guide