# 3.6.007

## **INDEX**

* [#inventory](#inventory "mention")
  * [#add-new-field-plot\_code-to-connecs](#add-new-field-plot_code-to-connecs "mention")
  * [#drop-not-null-for-dmas-ud-and-ws](#drop-not-null-for-dmas-ud-and-ws "mention")
  * [#set-epa\_type-not-null-in-connecs](#set-epa_type-not-null-in-connecs "mention")
* [#epa](#epa "mention")
  * [#enable-setting-the-outlet\_id-of-subcatchments-by-editing-the-view-v\_edit\_inp\_subc2outlet](#enable-setting-the-outlet_id-of-subcatchments-by-editing-the-view-v_edit_inp_subc2outlet "mention")
  * [#use-copy-paste-on-non-visual-objects-and-dscenario-demand-dialogs](#use-copy-paste-on-non-visual-objects-and-dscenario-demand-dialogs "mention")
  * [#refresh-epa-world-view-if-networkmode-changed](#refresh-epa-world-view-if-networkmode-changed "mention")
  * [#add-selector-period-strategy-on-selector](#add-selector-period-strategy-on-selector "mention")
  * [#new-checks-on-epa-data-consistency](#new-checks-on-epa-data-consistency "mention")
* [#admin](#admin "mention")
  * [#add-import-dwf-to-import-csv](#add-import-dwf-to-import-csv "mention")
  * [#refactor-of-the-creation-of-projects-empty-inventory-full-and-import-inp](#refactor-of-the-creation-of-projects-empty-inventory-full-and-import-inp "mention")
  * [#add-show-inactive-checkbox-on-managers](#add-show-inactive-checkbox-on-managers "mention")
  * [#enable-the-possibility-to-delete-all-selected-rows-in-managers](#enable-the-possibility-to-delete-all-selected-rows-in-managers "mention")

## **INVENTORY**

### <mark style="color:blue;">Add new field 'plot\_code' to connecs</mark>

A new field has been added (plot\_code) to connecs in order to show the code of the plot where they belong. It can be useful to store the cadastral referency code for those connecs inside buildings or parcels.

### <mark style="color:blue;">Drop not null for dma's (ud and ws)</mark>

The NOT NULL constraint for parent tables on column "dma\_id" has been removed to ease the management of those elements that don't necessary belong to any DMA.

### <mark style="color:blue;">Set epa\_type not null in connecs</mark>

The connecs have now a NOT NULL constraint in epa\_type column in order to strengthen the hydraulic modelling data.

## **EPA**

### <mark style="color:blue;">Enable setting the outlet\_id of subcatchments by editing the view v\_edit\_inp\_subc2outlet</mark>

Now, it is possible to set the outlet\_id of any subcatchment by pointing the arrow of the table view Subcatchment2Outlet (v\_edit\_inp\_subc2outlet) to the outlet to which the subcatchment has to drain the water.

It is necessary to select the layer "Subcatchment2Outlet" (inside the layer group "Hydrology") and use the Toggle Editing tool of QGIS. Then, the vertex of the line that points out to the outlet can be modified by the user and therefore set the vertex to another outlet of choice (junction or subcatchment)

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FXH5PSkJjIwux4NUuQc0L%2Fimage.png?alt=media&#x26;token=ac4247b4-880b-42b0-9e32-921ad5253947" alt=""><figcaption></figcaption></figure>

By doing this, the outlet\_id of the subcatchment will be updated without needing to type the outlet\_id on its attribute table.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FpyIiav80G27VbARYa0id%2Fimage.png?alt=media&#x26;token=11b1bae5-2544-4c88-b9c4-0c7056d37e33" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">Use copy-paste on non-visual objects and dscenario demand dialogs</mark>

Now, it is possible to manage objects by copy-paste them.&#x20;

### <mark style="color:blue;">Refresh EPA world view if networkmode changed</mark>

Having the EPA World button activated, the elements shown can change according to the selected network mode in Go2Epa Options dialog. The user can choose whether to show arcs and nodes (BASIC NETWORK) or additionally show connecs (NETWORK & CONNECS).

### <mark style="color:blue;">Add selector period strategy on selector</mark>

A new selector has been added to table config\_form\_tabs in order to filter data by periods of time. It can be found in table config\_form\_tabs by searching for "**selector\_basic\_**" in column "formname". By default, it is not enabled. To do so, it is necessary to rename the parameter "selector\_basic\_" to "selector\_basic" in table config\_form\_tabs. Then, the tab Period will appear in the Selector.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FqAu8Uvpf8uBSOMSWbOLE%2Fimage.png?alt=media&#x26;token=34159d46-552a-42da-8f95-e6ae30a4eddc" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">New checks on EPA data consistency</mark>

New checks according to EPA rules have been done. These are the following:

* Check if outlet\_id exists in table view v\_edit\_inp\_junction (in case the outlet is a junction) or in v\_edit\_inp\_subc2outlet (in case the outlet is a subcatchment)
* Check null values on columns "weir\_type", "cd", geom1", "geom2", offsetval" from table inp\_weir
* Check null values on columns "ori\_type", "geom1" and "offsetval" from table inp\_orifice

## **ADMIN**

### <mark style="color:blue;">Add Import DWF to Import CSV</mark>

Now, it is possible to import DWF data through the Import CSV Button.&#x20;

### <mark style="color:blue;">Refactor of the creation of projects (empty, inventory, full and Import inp)</mark>

A huge refactor has been made for the process of creating a new Giswater schema. Now, the SQL files of updates to 3.5 have been refactored into a database backup file which is being restored during the process of creating an schema. This refactor is aimed to enhance velocity and simplify the code.

### <mark style="color:blue;">Add 'Show inactive' checkbox on managers</mark>

The checkbox "Show Inactive" has been added to all manager buttons in order to standardize their structure.

### <mark style="color:blue;">Enable the possibility to delete all selected rows in managers</mark>

Now, it is possible to select multiple rows from a managers' button and delete them.
