3.5.026

INDEX

INVENTORY

Allow users to input init/end nodes in arc forms when they are NULL

When somehow the value of node_1 or node_2 on arcs is NULL, users are now capable of just write down the node_id in the custom form widget and the arc will be reconnected to such node and topology recovered.

Check redundant values for elevation fields (UD)

There are three main columns on UD schemas to manage elevation data:

  • top_elev

  • ymax

  • elevation

Even they are all editable, it's mandatory to only fill two of them, otherwise values will be redundant. In this version this redundancy begin to be controlled, in two steps:

System variable to control values on forms

A new variable edit_check_redundance_y_topelev_elev have been added to config_param_system table. If true, node and arc forms will show a warning message every time a redundant value appears (it will also show warning for existing values even the form is not in editing mode).

New parameter on check project

A new parameter related to redundant values have been added to check project (and OM check data). Every time these processes are executed redundant values will be checked, returning if there are some or not.

In this version, widgets configured as hyperlinks in element's custom form are editable. This is only possible when form is in edition, otherwise, the hyperlink will work as always, redirecting to the URL on click.

This propery isn't configured by default. To allow the hyperlink edition, config_form_fields table must be properly configured: column 'iseditable' must be TRUE for the desired formname and columnname.

Manage static pressure automatically

When inserting a new node or connec, the value for static pressure will be automatically calculated. This will only happen when:

  • Elevation value of the element is already filled or user fill it before Accept.

  • Presszone related to the element is filled and its 'head' field on presszone table has value.

The result value of static pressure is: presszone.head - elevation.

This value will always be recalculated when presszone of the element change.

New default value for ymax on UD

A new default value is now available on Configuration tool of Giswater to manage a default value for ymax on nodes. This value will appear automatically on node forms when inserting a new one. As always, this value is manually modificable inside the form.

New default value for users to search municipality

To search in the Address tab, now is possible to set a default value for the first widget, Municipality. This can be useful on networks distributed within many different municipalities, because some users may need to search always in the same municipality and they can configure this value to be already defined.

It needs to be set on the Configuration tool of Giswater, in the Basic first tab.

OM

Recalculate mincut when execute start process

Now is possible to enable the automatic recalculation of a mincut when click the Start process button.

The resulting mincut could be different if the affected network have suffered changes from the moment that mincut was planified. For example:

  • Some valves have been closed

  • Some arcs have been changed

  • Some connecs have been added or removed

This recalculation is not enabled by default. To use it, redoOnStart variable from Mincut settings on Configuration tool of Giswater needs to be set 'true'. It's also possible to configure the number of past days from the mincut planification to execute this automatic recalculation or not.

New columns on node and connec mincut result

Two columns have been added on node and connec mincut result views, to provide some additional information when a mincut is calculated. These columns are:

  • Mincut result node: node_type (type of node affected by the mincut).

  • Mincut result connec: customer_code (code used to relate connecs to other DB).

EPA

1D/2D coupled model in combination with SWMM-IBER

This feature have been developed according the agreement of Giswater Association with BarcelonaTech University in order to connect Giswater-SWMM with IBER enabling a real drainage coupled model 1D/2D. The goal is to generate a gully CSV file at th same time as the INP file is generated. This CSV file contains all the information that IBER needs to work with 1D/2D coupled model.

Many improvement have been done in this release to work with the 1D/2D coupled model. It is possible to emphasize:

  • New parameters have been added on gis-side for gullies as well as groove dimensions or grate_location.

  • New two epa-type objects have been defined on epa-side: gully and netgully with all parameteres that IBER needs to work with 1D/2D coupled model as well as outlet_type, method, a,b weir_cd o orifice_cd.

  • New widget on go2epa options dialog have been create in order to control this exportation network geometgry generator with two options (1D-SWMM / 1D-2D SWMM-IBER)

In case of the new object epa_type: gullies, only will be exported on the csv file used by IBER to load gully. SWMM file will not have it.

In case of the new object epa_type: netgullies, as well as it will be exported as JUNCTION on inp file, will be also exported on the CSV file as another gully.

Enhance valve management for ws go2epa exportation

The valve management on ws inp export files have been simplified. In fact, widget have disappeared. The status on gis-side acts as primary status (only open or closed) and the status of epa-side acts as secondary status which it means that when the gis-side is open the status of valve will be the status defined on epa-tables.

At the same time the mincut_result strategy have been removed from this side and have been added on the dscenario manager as well as one scenario more.

Enable work with CRM values also on nodes (netwjoin)

Until now, CRM values could only be related to connec features. In this version, the possibility to establish CRM values related to a Netwjoin -a specific kind of node which acts like a connec but breaking the network- have been enabled.

Netwjoin table has customer_code column, which will relate this node to hydrometer values and so is possible to create Dscenario demands using both connecs and netwjoins.

Improvements on Dscenario manager

Among some bug fix, some improvements have been done on the dscenario manager button. It is possible to emphasize:

  • New button in dscenario to add layers to ToC easily. By click on this button, new layer will appear on ToC in order to make easy the massive edition of rows by using the native attribute table editor of QGIS.

  • Enable dscenario strategy for controls and rules. On this version it is possible to create also scenarios for controls and rules, enabling new borders on the dscenario strategy.

  • New actions and buttons. Duplicate scenario button and create dscenario valve from mincut action have been added on this version.

New system parameter to update inventory tables when change EPA values

A new parameter have been added to system configuration. It's goal is to automatically update values on inventory tables whenever values are changed on epa tables (inp).

To use it, status on parameter EPA auto update inventory tables on the Configuration tool of Giswater must be 'true'. Then, it's also mandatory to configure the SQL query which will be executed if changes are made in the different available sourceTables. For example (the alias on the query are mandatory):

UPDATE man_tank t SET hmax=maxlevel FROM inp_tank s

It's important to know that columns from both tables are deeply related, which just happen in some cases.

Last updated