# 3.5.028

## INDEX

* [#inventory](#inventory "mention")
  * [#highlight-connecs-that-will-be-disconnected-on-feature-end-process](#highlight-connecs-that-will-be-disconnected-on-feature-end-process "mention")
  * [#use-hemisphere-change-to-rotate-node-180o](#use-hemisphere-change-to-rotate-node-180o "mention")
* [#om](#om "mention")
  * [#new-functions-to-import-scada-values-and-hydrometer-values-focused-on-waterbalance](#new-functions-to-import-scada-values-and-hydrometer-values-focused-on-waterbalance "mention")
* [#epa](#epa "mention")
  * [#force-reservoirs-on-inlets-when-go2epa-for-ws](#force-reservoirs-on-inlets-when-go2epa-for-ws "mention")
* [#system](#system "mention")
  * [#add-commitchanges-parameter-in-mapzones-function-to-allow-running-it-without-change-feature-table-va](#add-commitchanges-parameter-in-mapzones-function-to-allow-running-it-without-change-feature-table-va "mention")

## INVENTORY

### <mark style="color:blue;">Highlight connecs that will be disconnected on feature end process</mark>

When some arc has to be downgraded but it has connections, a form appear showing a **list of these connecs**. Now, when a row of this list is selected, the **connec will be highlighted** in the map canvas.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FLLtrfNxhdYScRq7FDCcn%2Fimage.png?alt=media&#x26;token=25d899d8-dc87-441c-840c-bab71e1190d6" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">Use hemisphere change to rotate node 180º</mark>

Having '*Disable node rotation on update*' variable of Giswater's Toolbox in FALSE, now is possible to **add 180º to the rotation** value of any node. It's also necessary that the node have TRUE value on choose\_hemisphere column from cat\_feature\_node table.

To do so, you just need to click *Rotation button* on the top of the custom form and then another **click on the map canvas**, near the node.&#x20;

This process will add 180º to the rotation value and also will calculate hemisphere value, as it did before.

{% hint style="warning" %}
You will only **see results** in the canvas if the symbol of the layer is managed by '*rotation*' field.
{% endhint %}

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FOEbKCArB3B3MRpTyn6p2%2Fimage.png?alt=media&#x26;token=90ef8f01-484c-495b-94c6-6737f7f7550e" alt=""><figcaption></figcaption></figure>

## OM

### <mark style="color:blue;">New functions to import scada values & hydrometer values (focused on waterbalance)</mark>

There are 2 new functions on Import CSV tool to import data for scada and hydrometer values.

1. **Import scada values** inputs:
   * **node\_id** - id of the scada feature
   * **value\_date** - date of the value
   * **value** - water volume
2. **Import hydrometer values** inputs:
   * **hydrometer\_id** - id of the hydrometer
   * **cat\_period\_id** - period related to ext\_cat\_period table
   * **value** - water volume
   * **value\_date** - date of the value

These imports will fill **waterbalances tables**, which data is mandatory if you want to use waterbalances processes and reports.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FfU5UmbF634VMw1Nr2Emx%2Fimage.png?alt=media&#x26;token=5a03e266-5a9d-4bd4-a626-0fe16ed3922a" alt=""><figcaption></figcaption></figure>

## EPA

### <mark style="color:blue;">Force reservoirs/tanks on inlets when Go2EPA for WS</mark>

When running Go2EPA on WS project, all features with epa\_type = **INLET** will be transformed to:

* **RESERVOIR** - when there are as many pipes as you want but all are related to same sector.
* **TANK** - when there are as many pipes as you want and there are at least two sectors involved.

## SYSTEM

### <mark style="color:blue;">Add commitChanges parameter in mapzones function to allow running it without change feature table values</mark>

A new variable has been added to *Mapzones analysis* process. In the form of the function, now is possible if you want to **commit changes or not**.&#x20;

Unselecting this checkbox will also run the same process but **not changing inventory values**. It can be very useful to **run a 'test' process**.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FaNQbinshAbGsHQm2MjQN%2Fimage.png?alt=media&#x26;token=164e5829-079c-4a2e-ab7d-8776fbc03989" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
To see the results you can **query** using this values *fid* values and then symbolize using the filled column:&#x20;

SECTOR:130

DQA:144

DMA:145

PRESSZONE:146

STATICPRESSURE:147
{% endhint %}

```sql
SELECT * FROM anl_arc WHERE fid = (XX) AND cur_user=current_user;
SELECT * FROM anl_connec WHERE fid = (XX) AND cur_user=current_user;
```

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FPkrGg51jSPK2gq9859D9%2Fimage.png?alt=media&#x26;token=79ee6bdc-a32d-4925-bb08-15c8bb6b353b" alt=""><figcaption></figcaption></figure>


---

# 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.028.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.