# 3.5.033

## INDEX

* [#inventory](#inventory "mention")
  * [#make-element-layer-identifiable-usign-giswater-info](#make-element-layer-identifiable-usign-giswater-info "mention")
  * [#new-fields-on-meter-table](#new-fields-on-meter-table "mention")
  * [#new-function-on-toolbox-to-capture-address-from-closest-street-number](#new-function-on-toolbox-to-capture-address-from-closest-street-number "mention")
  * [#automatic-calcul-of-sander-depth-ud](#automatic-calcul-of-sander-depth-ud "mention")
* [#om](#om "mention")
  * [#new-system-parameter-to-automatically-set-reviewed-data-as-finished](#new-system-parameter-to-automatically-set-reviewed-data-as-finished "mention")
  * [#new-review-status-only-observations-added-no-data-modification](#new-review-status-only-observations-added-no-data-modification "mention")

## INVENTORY

### <mark style="color:blue;">Make Element layer identifiable usign Giswater Info</mark>

Giswater's **info over an Element** will return the same form used in Add Element tool. In this form is possible to view Element information and its Relations with other network elements such as nodes, arcs, connecs...

The same form will be shown when using **Search tool form Elements**. In earlier versions a basic form was shown in this process, where Relations were not possible to visualize.

Manage this form allow users to consult Element's information faster and easily.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2Fln7JBDTwfyRozypuHTky%2Fimage.png?alt=media&#x26;token=60ab342f-89ac-4898-87f1-ac1a2328b9ee" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">New fields on Meter table</mark>

Three new fields have been added to man\_meter table so they are now available on Meter type elements form.

* real\_press\_max: sets the maximum real pressure on that meter getting it from the device.
* real\_press\_min: sets the minimum real pressure on that meter getting it from the device.
* real\_press\_avg: sets the average real pressure on that meter getting it from the device.

{% hint style="info" %}
Difference between these new values and the ones related to pressure that already exist on node:

* **New ones**: they are related to real values from an existing device on that feature.
* **Existing ones**: calculated or functional values used on hydraulic modelization which cannot be real.
  {% endhint %}

### <mark style="color:blue;">New function on Toolbox to capture address from closest street number</mark>

A new function have been added to Giswater's Toolbox. It is useful to set address to punctual network elements (node, connec, gully) getting it from its closest street number.

There are some parameters to be configured before running this process:

* **Input layer:** NODE or CONNEC.
* **Selection type:** Selected features or All features.
* **Type:** To choose whether update ALL NODES, ALL CONNECS or just one feature type.
* **Field to update:** To choose if you want to update POSTNUMBER or POSTCOMPLEMENT field. The most usual is postnumber, but if address number is not numeric, then you will need to update postcomplement.
* **Search buffer:** Maximum distance to look for and address from the point.
* **Elements to update:** To choose whether update ALL ELEMENTS or just the ones with STREETAXIS, POSTNUMBER or POSTCOMPLEMENT with NULL value.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FYo20OGtsJeqvKddkZU4V%2Fimage.png?alt=media&#x26;token=cb5d2835-e40d-4507-a11d-3475c9b0b23a" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">Automatic calcul of sander depth (UD)</mark>

A new function allow the **automatic calcul of sander depth** for Manhole, Wjump and Chamber features.&#x20;

This process is controlled using a variable stored in *config\_param\_system* table named *edit\_node\_automatic\_sander*. If TRUE, the calcul will be done every time INSERT or UPDATE is done on specific features.

Calculation is done setting the **difference between sys\_ymax and sys\_y1** of both node and related downstream arc.

The result will be stored and updated on *sander\_depth* field of node.

## OM

### <mark style="color:blue;">New system parameter to automatically set reviewed data as finished</mark>

When using Review tables, you need to set *field\_checked* as TRUE to send the revision to audit\_review tables.

Now there is a new variable stored in *config\_param\_system* table named *edit\_review\_auto\_field\_checked* that, if TRUE, will **automatically set&#x20;*****field\_checked*****&#x20;as TRUE with any date modification**.

This will prevent field users from forgetting to set this value or simply make it easier to use by automating the process.

### <mark style="color:blue;">New review status: Only observations added, no data modification</mark>

Until now, there were 3 different status to establish the kind of changes that were done on the review. They were automatically set to *review\_status\_id* on audit tables. Now there is a new one:

1. New element.
2. There are changes on the geometry and maybe changes on the data.
3. There are only changes on the data.
4. <mark style="color:blue;">**(New!)**</mark>**&#x20;There are no changes on the data or they are beneath the tolerance value but a there is a comment related to the review.**

The comment when review\_status\_id=4 will be showed on *review\_obs* field on audit tables.
