giswater link crm scada

In order to connect Giswater with CRM and SCADA values there are some tips you need to know:

Giswater arquitecture is enabled to work with CRM and SCADA values. On database there some tables and views to work with:

Link GIS with CRM enables to:

- To show customer information using GIS dialogs
- To generate water balances to identify losses
- To create EPANET files using real data from specific period

GENERATE WATER BALANCES TO IDENTIFY LOSSES Giswater is capable of generate water balances joining information from CRM values and SCADA values. The main issues to known are:

The mapzones analysis algorithm is enable to relate hydrometers & connecs with dma. To do this you need to configure and trigger it:

Creating Schema and project using Giswater plugin on Qgis:

Hereafter you can find how to create an easy fast-start, considering you have all the programs, and an adequate DB connection (all required extensions for the plugin to work were added on the particular DB):

Values from SCADA can be stored on ext_rtc_hydrometer_state

2- DATABASE TABLES

Values from CRM can be stored pn ext_rtc_hydrometer ext_rtc_hydrometer_x_data

3- QGIS FEATURES