3.5.022

INDEX

• INVENTORY

  • Add Open/Close valve quick access

  • Delete PLANIFIED state on State Selector

  • Add QML style to Add Giswater Layers tool

  • New report: Water consumption by period and DMA

  • Enable the possibility to create a custom mapzone constructor

  • New rule to control 0 and -1 values on mapzones

  • Add possibility of using Macrosector Selector

  • Manage rasters and bug fix on layers with more than one field as Primary Key on Add Layers tool

• O&M

  • Mincut Hydrometer filters are now customizable

• EPA

  • New button Dscenario Manager

  • Timeseries and patterns added to UD

  • Curves, Patterns and Timeseries filtered by exploitation

  • New tables to define LID controls

• MASTERPLAN

  • Add info box in Psector Manager

  • Manage the duration of the rubberband around one psector

INVENTORY

Add Open/Close valve quick access

Now is possible to open or close a valve with no need of open its form. A new access is provided when right-clicking the valve using Giswater Info tool. If the valve is open, the tool will close it. Otherwise, the tool will open it.

Delete PLANIFIED state on State Selector

Until now, State Selector has displayed the three diferent states of Giswater. Now only OBSOLETE and OPERATIVE are displayed. To show PLANIFIED network is mandatory to use Psector Selector, where all the complexity about planified network is used.

To allow this usability to every user, Psector Selector now is visible for every role of Giswater. Before this versions Psector Selector was only displayed for role_master or role_admin users.

Add QML style to Add Giswater Layers tool

When adding new layers using Add Giswater Layers tool, these will be loaded using a QML style defined in the DB.

The default value of these styles is the same that is used in QGIS templates provided by Giswater.

These values are defined in sys_style table. If you want to customize the values, it's possible to modify stylevalue field. You need to previously save the QML style of the layer you want to change and then update this field with all the text of the QML file where idval = the name of the layer.

Obiously this QML style has to had logical relation with the layer (fields used to symbolize or geometry type).

New report: Water consumption by period and DMA

A new default report is provided on the Report section of Giswater's Toolbox, returning information about water consumption sumed by DMA and period. Also these default filters (period and DMA) are available to enhance the usability of the tool.

Enable the possibility to create a custom mapzone constructor

It enables the possibility to the users to create a new customized method to generate the geometry when the dynamic mapzone algorithm is triggered.

As you may know, this functionality is available on Giswater's Toolbox. To configure this new method there are two main things to do:

• Configure geometry value with a query on utils_grafanalytics_custom_geometry_constructor parameter of config_param_system table. A default example is provided.

• Configure a new comboId=5 and a new comboName on the inputparams from table config_toolbox where id=2768 (Mapzones analysis)

One useful example is to draw the mapzone merging some CRM polygonal values. It will allow you to clearly visualize which mapzone is related to every CRM zone.

New rule to control 0 and -1 values on mapzones

Every functional mapzone (https://github.com/Giswater/giswater_dbmodel/wiki/Functional-mapzones-basics) need to have two values that its dynamic algorithm needs to run properly. These values are always id's 0 and -1.

A new rule has been added to avoid the elimination of these values, because if it happens then dynamic zonification crashes.

Add possibility of using Macrosector Selector

Giswater Hydraulic Sectors can be related to a bigger Macrosector, which is an aggregation of different Sectors.

To manage its visualization easily, now is possible to use the Macrosector Selector. It will allow the user to choose which Macrosector wants to visualize and, automatically, all the related sectors (the ones with selected macrosector_id value) will be also selected on Sector Selector.

The configuration must be done enabling (isenabled=TRUE) the parameter basic_selector_tab_macrosector on config_param_system table. It's also possible to change the order of the selector on config_form_tabs table, orderby column.

Manage rasters and bug fix on layers with more than one field as Primary Key on Add Layers tool

Now raster layers, like raster DEM layer on Giswater sample, are ready to load using Add Layers tool.

A bug has been fixed on loading layers with more than one field used as primary key.

O&M

Mincut Hydrometer filters are now customizable

Until now, to do a mincut only related to hydrometers, users have to search them using filter by connec customer code and hydrometer customer code. A new variable allows to configure which values will be used as filters to search the hydrometers.

Using om_mincut_hydrometer_filter parameter of config_param_system table, user could define field1 (from v_edit_connec table) and field2 (from v_rtc_hydrometer table). It's also possible to define the labels to show in the form (label1, label2).

EPA

New button Dscenario Manager

A new button has been added in the EPA toolbar to manage Demand Scenarios . All the existing Dscenarios will be available there, showing some of its information.

Besides being a table to consult existing information, this tool allow users to perform some actions:

• Create new demand from ToC - Create demand dscenarios from CONNEC or JUNCTION.

  It moves demand & pattern data from source to inp_dscenario_demand. Works with epa layers (v_edit_inp_connec or v_edit_inp_junction) which means these layers has to be loaded.

• Create empty dscenario - Function to create empty dscenario.

• Create from CRM - Create dscenarios from CRM. This function store values on CONNEC features. When the network geometry generator works with NODE, demands are moved 50% to node_1 and node_2.

• Create from ToC - Function to create network dscenarios from ToC.

• Manage values - Manage values of one dscenario catalog (delete or copy from another one).

Selecting one of these values and clicking Execute button a new form will be opened to define final parameters of the action before running it.

Timeseries and patterns added to UD

New views has been added to UD schemas to manage Timeseries and Patterns.

• v_edit_inp_timeseries

• v_edit_inp_pattern

Curves, Patterns and Timeseries filtered by exploitation

Tables related to Curves, Patterns and Timeseries are filtered using exploitation instead of sector.

• inp_curve

• inp_pattern

• inp_timeseries (UD only)

It is so because filter by sector is very restrictive and has been proved that one curve, pattern or timeserie can be used in different sectors within the same exploitation.

New tables to define LID controls

Two new tables have been created in the UD schema to manage Low Impact Development (LID) controls. As you may know, LID controls are used to intercept stormwater and control it through detention, infiltration or evapotranspiration. They are available in SWMM 5.1 and now also in Giswater.

• inp_lid - Catalog of LID controls like BIO-RETENTION, VEGE-SWALE, RAIN-GARDEN, etc.

• inp_lid_value - To manage different variable values of the lid catalog.

MASTERPLAN

Add info box in Psector Manager

To enhance the visualization of psector data without opening its form, a new info box have been added to Psector Manager .

It'll show the main information of the selected row in the table, making much more easier to read descripting fields of the psector.

Manage the duration of the rubberband around one psector

Giswater draws a rubberband around the psectors when they are opened using Psector Manager or Psector searcher. Now, the duration of this rubberband is customizable by user. To modify this value, open the Advanced Menu on the Giswater Menu, find show_psector_ruberband_duration variable and modify its value. The default value is 5 seconds.