water balances - Giswater/giswater_dbmodel GitHub Wiki

Giswater is capable of generating water balances according to IWA standards by joining information from CRM values ​​and SCADA values ​​using GIS topology.

To work with CRM data, the rtc_hydrometer, ext_cat_period and ext_rtc_hydrometer_x_data tables must be populated. On the rtc_hydrometer table by using customer_code, this data can be linked to connecs, which are the objects in Giswater that the customers belong to. To relate tha connecs to the water network, Giswater uses links that connect connec to nodes and arcs with many possibilities. Finally, by using the ext_rtc_hydrometer_x_data with cat_period_id column, you can fill in the volume of water billed for each period and customer.

In order to maje easy the syncronization with CRM data, it is enabled to fill tables ext_cat_period and ext_rtc_hydrometer_x_data by using import CSV file. Please take a look on csv example (\plugins\giswater\resources\example\csv [ext_cat_period & ext_rtc_hydrometer_x_data])

Once we have customers and his data related to the network, it is time to integrate the SCADA values. To work with it, we need to populate the [ext_rtc_scada_x_data] (https://github.com/Giswater/giswater_dbmodel/wiki/ext_rtc_scada_x_data) table using as many values as you like, but we recommend one value per day. This table can be filled by using csv file. Please take a look on csv example (\plugins\giswater\resources\example\csv [ext_cat_period & ext_rtc_scada_x_data])

Furthermore, the [Processes][Master] toolbox Mapzone analysis process we can create DMA and link it with nodes, arcs and connections by setting the dma_id column. In addition, the algorithm defines the direction of flow for network water meters using the om_waterbalance_dma_graph table.

Finally, when we have CRM data and SCADA data with synchronized period values, it is time to calculate the IWA indicators. To do this execute the [Processes][Master] toolbox Water balance by Exploitation, Dma and period fills on the om_waterbalances table values from CRM and SCADA values ​​for each DMA and Period.

As result, reports are available on [Reports][Om] toolbox LOsses % NRW by Exploitation, Dma & Period, Total Losses & NRW by Dma and Total Losses & NRW by Exploitation are ready to fit your needs of reporting in terms of water balances.