# 3.5.021

* [Refactor and enhance Add Layer button](#refactor-and-enhance-add-layer-button)
* [Update QGIS templates](#update-qgis-templates)
* [New columns on sys\_fprocess table](#new-columns-on-sys_fprocess-table)
* [New function to manage data from migrations](#new-function-to-manage-data-from-migrations)
* [Upgrade to EPANET 2.2](#upgrade-to-epanet-2.2)
* [Upgrade to SWMM 5.1.015](#upgrade-to-swmm-5.1.015)
* [Refactor how CRM is used on EPANET](#refactor-how-crm-is-used-on-epanet)
* [New column parent\_id for sector table](#new-column-parent_id-for-sector-table)
* [New colum expl\_id for EPA catalogs](#new-column-expl_id-for-epa-catalogs)
* [Improve the way of INP file is created](#improve-the-way-of-inp-file-is-created)
* [Better manage of Undefined sector (0)](#better-manage-of-undefined-sector-0)
* [Enhance usability of dynamic mapzones algorithm](#enhance-usability-of-dynamic-mapzones-algorithm)
* [Refactor Other Prices tab on psector form](#refactor-other-prices-tab-on-psector-form)
* [Change the pavcat\_id column strategy](#change-the-use-of-pavcat_id-column-strategy)
* [Enhance performance on Plan tab on arc form](#enhance-performance-for-plan-tab-on-arc-form)
* [Drop price columns related to connec and gully catalogs](#drop-price-columns-related-to-connec-and-gully-catalogs)
* [New function gw\_fct\_setchangefeaturetype](#new-function-gw_fct_setchangefeaturetype)

### <mark style="color:blue;">Refactor and enhance Add Layer button</mark>

This button, previously only used to load child layers, now allows to load most of the usual layers that Giswater needs.&#x20;

It's divided in 5 diferent groups. Every one of them also have subgroups where related layers are available to be loaded.

If a layer is already on the ToC, it's checked. To load a new one, just check the box and the layer will be loaded automatically, located in it's related group (only if the name group of the ToC is exactly the same as it is in the button).

![](https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FvscOom1S1wKjVxGzVq0O%2Fimage.png?alt=media\&token=b3363a4e-6406-44dc-ad37-d3663b06885f)

### <mark style="color:blue;">Update QGIS templates</mark>

Taking advantage of the refactor of Add Layer button, QGIS templates have been updated. Now they have less layers, in order to maximize its performance.&#x20;

The groups of Admin and Edit have been deleted. The same way, other not relevant layers have also been removed.

In any moment that a layer is needed, you can use the Add Layer button to load it automatically.

The remaining **available templates** are:

* <mark style="color:blue;">**Inventory**</mark>: Layers for Network, Catalogs, Mapzones and Basemap.
* <mark style="color:blue;">**OM**</mark>: Layers for Mincut (WS) and Flowtrace (UD) (+ Inventory).
* <mark style="color:blue;">**EPA**</mark>: Layers for EPA Catalogs, Hydraulics and EPA Results (+ Inventory + OM).
* <mark style="color:blue;">**Master**</mark>: Layers for Psectors and Prices (+ Inventory + OM + EPA)

![](https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FL8nJ3DaKW8o9vlJLpva2%2Fimage.png?alt=media\&token=87109746-e2c4-4e64-9600-0fe46495fd38)

### <mark style="color:blue;">New columns on sys\_fprocess table</mark>

Two new columns have been added to this table, which acts as a catalog of every process that Giswater execute to check the state of the project or other functionalities that store resulting information. New columns are:

* <mark style="color:blue;">**isaudit**</mark>: To configure which of the processes are auditable or not, related to audit function.
* <mark style="color:blue;">**fprocess\_type**</mark>: To categorize processes in order to allow a better understaing of the results.

### <mark style="color:blue;">New function to manage data from migrations</mark>

To migrate network data from other sources it's necessary to disable some of the configuration variables, in order to allow the insertion of the data even if they have some topological issues.

To make easier the migration process, this new function (gw fct admin manage migra), available on the toolbox, will turn off all these configuration variables at once. This way, the user will be ready to migrate data only by running this function.

![](https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FcSINI9fkMKJxyoMc87Bs%2Fimage.png?alt=media\&token=0060deeb-1de7-498b-a056-876fba28dd0d)

### <mark style="color:blue;">Upgrade to EPANET 2.2</mark>

Upgrade database and driver in order to make compatible with lastest version of EPANET 2.2. Main changes are related to the possibility to use the demand model PDA (presure driven analysis) as well as the owerflow on tanks, among other capabilities.

### <mark style="color:blue;">Upgrade to SWMM 5.1.015</mark>

Upgrade database and driver in order to make compatible with lastest version of EPANET 5.1 (5.1.015). Main changes are new options on dynamic wave as well as new features and options for LIDS analysis, among other capabilities.

### <mark style="color:blue;">Refactor how CRM is used on EPANET</mark>

Full refactor of CRM architecture linked with EPANET tables. The main change is that<mark style="color:blue;">,</mark> to use CRM values, now it is mandatory to create a demand scenario before. By doing this, user has a better traceability and more control of the whole workflow.

### <mark style="color:blue;">New column parent\_id for sector table</mark>

A new column parent\_id have been added to sector table. It will be useful to relate some sectors to a parent (on the same sector table), in order to copy the same configuration or permissions of the parent sector.

### <mark style="color:blue;">New column expl\_id for EPA catalogs</mark>

A new column expl\_id have been added to some EPA catalogs in order to manage its related exploitation and filter data using selectors. Affected tables are:

* rpt\_cat\_result
* cat\_dscenario
* cat\_hydrology (UD)
* cat\_dwf\_scenario (UD)

### <mark style="color:blue;">Improve the way of INP file is created</mark>

Improve the generation of inp file creating another column (linked with the description on EPA canvas) with valuable additional information to trace and debug. Mapzones or feature\_type, among others, are showed in this new column, by using a space separator.

### <mark style="color:blue;">Better manage of Undefined sector (0)</mark>

During the configuration of dynamic sectorization, the use of Undefined sector is usual. Some parts of the network became related to this sector because they aren't well configured yet. To a better manage of this sector and its related network:

* Undefined sector has been added to the selector\_sector
* Undefined sector is forced to DISABLE on running Go2EPA.

![](https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FQkZ0WVOQzPjQ6PBrFPXs%2Fimage.png?alt=media\&token=c423f746-8ae7-44e2-b4ae-c45d9645cd8e)

### <mark style="color:blue;">Enhance usability of dynamic mapzones algorithm</mark>

A new widget on the sectorization dialog has been added. Here the user can assign to every arc and node a value to not let them be disconnected (sector\_id = 0).

![](https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FNdMAADigBfA0Br8bcj47%2Fimage.png?alt=media\&token=2364caec-4291-4d74-b051-27a030d55676)

### <mark style="color:blue;">Refactor Other Prices tab on psector form</mark>

Other prices tab has been improved. Now all the information is displayed in the same tab and the way of Add or Remove additional prices is easier. A more user friendly tool than before.

![](https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FofruRmmQKRI2g11UFsZh%2Fimage.png?alt=media\&token=611f0c5d-aa5c-486b-93aa-a5ed342babed)

### <mark style="color:blue;">Change the use of pavcat\_id column strategy</mark>

Until now to manage the pavament related to the arc was mandatory to fill plan\_arc\_x\_pavement table. In this version pavcat\_id has been added to arc table. Now it's possible to relate the pavement directly to the arc, without filling any other table.&#x20;

The other table will reamain available to manage arcs which have more than one pavement. In this situation, plan\_arc\_x\_pavement will be used the same way as before, assigning a percentage of the arc to every related pavement.

### <mark style="color:blue;">Enhance performance for Plan tab on arc form</mark>

Get info plan function has been revised and as a result the performance of Plan tab for arcs has increased. Also, the way how different prices are loaded to this tab has been related to the use of pavcat\_id on arc table.

![](https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FmrDS0ayONVRN7qwvULhH%2Fimage.png?alt=media\&token=6d52dfc7-4cbe-4c8c-b468-1f87279a7162)

### <mark style="color:blue;">Drop price columns related to connec and gully catalogs</mark>

It's very complicated to calculate a cost of a connec or a gully the same way Giswater does for arcs. So, columns related to cost in catalogs of connec and gully have been deleted:

* cost\_ut
* cost\_ml
* cost\_m3

### <mark style="color:blue;">New function gw\_fct\_setchangefeaturetype</mark>

This new function complements the use of the Change Feature tool. Now, Giswater control if the new feature type has the same posible values on function, location, category and fluid type fields. If not, these values won't be copied.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://giswater.gitbook.io/change-log/3.5.021.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
