3.6.012
INVENTORY
New style manager & style change button
A new way to manage layer styles has been added to Giswater core. There are two new tools:
Giswater styles
This new tool is located above the ToC and allow users to change the symbology for all configurated layers with only one click. It replaces the EPA World tool that change the default visualization for an hydraulic point of view.
Now, not only you can change to an EPA visualization, but also customize your own style configurations that could be interesting for you. By default, Giswater sample has added example styles to categorize the arcs by DMA, Presszone or Sector.
By clicking any style on the list, all layers that have been previously configured will change its style. It won’t delete previous style. It will add the selected to a new one for the layer.
This behaviour allow users to switch styles easily for multiple layers, changing the whole visualitzation context if needed.
Style manager
This new tools is located in the Utils manager button. It opens a form where you can manage existing styles and add new ones.
The table shows every existing style configured for layers. Here it is important to filter by symbology Category to reduce the number of layers. There are some buttons with different uses:
Button +: Allow add a new symbology category. You need to choose a Category ID (for custom categories id above 900 is recomended), Category name, Description and Role. The new category will appear with no layers related.
Button -: To delete the selected style category.
Add style: Allow add any selectable layer to the selected category. At the beginning, the style will be the same as the GwBasic. The goal is to relate the layer with the style category.
Update style: Allow change style for selected row (be certain at the style configuration to which is related). The update will take the current symbology of the layer on our project and set it as the style for this layer when using Giswater styles button. Its the only way to set a style different from GwBasic for new style configurations.
Delete style: To delete the selected row.
Refresh all: It will refresh symbology for all layers that have any Giswater configuration symbology on its styles. It is useful to refresh our project if someone else has changed the style configuration but our layers have this style already loaded.
New strategy for dynamic filter by joined use of sector-expl-muni
Now, when a sector, exploitation or municipality is selected in a selector, its related sector, exploitation or municipality is also selected. This works dinamically with the aim of showing all the different mapzones in a selected mapzone.
Add the option to set geometry to a document (it can automatically get coordinates from the document's metadata)
A new button has been added inside the Add Document button in order to add geometry to the document. If not, the geometry can be taken from the document's metadata.
Add "name" field for documents
A column "name" has been added to Documents in order to better identify them by using a customizable name for them.
Add workcat, psector & visit tabs in document dialog
New tabs "Workcat·, "Psector" and "Visit have been added to the Add Document button. The aim of these tabls i to relate the document to a workcat (previously defined in table "cat_workcat"), an existing psector or a visit.
Create workcat manager
A new button has been created in order to manage the catalog of works. When clicking on a workcat, its information is showed in detail.
Remove duplicated vertex generated because of the fusion. Use st_removerepeatedpoints function for the new geom
In previous versions, when performing a new arc fusion, a duplicated vertex was created on the point where the affected node was. It happened because the start and end points of the old arcs were merged.
Now, after performing this process, the function ST_RemoveRepeatedPoints is executed for the new arc to avoid the creation of this vertex duplicity.
Add new fields on inventory tables for UD node, connec, gully: placement_type, access_type
New fields have been added to UD node, connec, gully tables. These are: placement_type and access_type which aim is to show if the feature is inside another element (i.e a well inside a shed) and how it is accessible.
Add new field on inventory tables for WS and UD node, arc, connec, gully: label_quadrant
A new field has been introduced under the name of "label_quadrant" which aim is to store the position of the label by typing its quadrant. The letters available are the following: T for "top middle", B for "bottom middle", L for "left middle" and R for "right middle".
Add new fields on inventory tables for WS node, arc, connec: brand, model, serial_number
New fields have been added to parent tables of WS: brand, model and serial_number which aim is to show on the parent tables this information and relate this information to the feature itself.
New field for UD arc: visitability
A new field has been added to table "arc" from UD: visitability, which aim is to show the capability of the "arc" to be visitable or accessible (for example, when carrying out maintainance tasks or cleaning of the network).
New field for UD connec: n_hydrometer
A new field has been added to connecs from UD: n_hydrometer. This column shows the number of hydrometers associated to a specific connec.
New mapzone columns for different tables
The new columns for the mapzones are the following:
For UD projects, new column "muni_id" have been added to table "raingage".
For UTILS schema, columns "muni_id" and "sector_id" have been added to tables "samplepoint", "element", "link" and "dimensions".
For WS projects, column "muni_id" have been added to tables "pond" and "pool". Additionally, column "sector" has been added to tables "presszone", "dma" and "dqa".
OM
New mapzone for WS: macrominsector with new colums for arc, node, connec, link
A new mapzone has been created under the name of "macrominsector". This is a group of minsectors which aim is to represent topologically connected network features. This mapzone represents the continuity of the network and it is useful to determine connected and unconnected areas of the network.
New mapzones for UD: minsector and macrominsector with new columns for arc, node, connec
Minsectors and macrominsectors have also been added to UD projects like it happens in WS projects. The concept of minsectors and macrominsectors in UD is the same as in WS. Two new tables have been added (tables "minsector" and "macrominsector") and columns for both mapzones have been added to parent tables (minsector_id, macrominsector_id).
New columns for WS mapzones: dma_type and dqa_type
New columns "dma_type" and "dqa_type" have been added to mapzone tables of WS projects. The domain of values for these columns can be configured in table "edit_typevalue" where typevalue is "dma_type" or "dqa_type" respectively.
New columns for UD mapzones: drainzone_type, dma_type, sector_type
New columns "drainzone_type", "dma_type" and "sector_type" have been added to mapzone tables of UD projects. The domain values for these columns can be configured in table "edit_typevalue" the way is explained in the previous point.
New column for UD dma and sector: graphconfig
A new column "graphconfig" has been added to tables "dma" and "sector" with the purpose of configuring a mapzones analysis like WS.
New column for UD cat_feature_node: graph_delimiter
A new column "graph_delimiter" has been added to table "cat_feature_node" for UD projects with the same purpose of the same column in WS.
Improve mincut dialog by ordering the toolbar actions
The buttons inside the Mincut button have been ordered in a better way to improve the usage of the Mincut tool. Now, the buttons have been grouped into 3 groups and each group of buttons gets enabled sequently according to the steps of creating a mincut.
EPA
New button "Show INP data" in Go2Epa Manager
A new button has been developed inside Go2Epa in order to show the results of the selected "result_id". These are loaded into the QGIS project on temporal layers.
New behaviour for inlets as a junctions when they are on the end of a sector without continuity with the next one
A new behaviour has been added to inlets that consist of acting as junctions when they are located at the end of a sector which doesn't have continuity with the next sector. Thus, 3 new columns "demand", "demand_pattern_id" and "emitter_coeff" have been added to table "inp_inlet".
Change "Set archive" button to "Toggle archive" (go2epa manager)
The button "Set archive" inside Go2Epa Manager has been renamed to "Toggle Archive".
Show the dates when an EPA result has been corporate
When an EPA result becomes "corporate" in WS projects, the info of that EPA results show the timestamp from which it has been corporate.
MASTER
New function gw_fct_setpsectorcostremovedpipes (associated fid 523)
A new function has been developed in order to calculate the cost of removing the pipes of a specific material. It is necessary to select the exploitation, the material of choice and write the price code to be used to calculate the price of removal. This code has to exist in table "plan_price". When the process is finished, a temporal layer is loaded showing the pipes involved and its removal cost.
ADMIN/SYSTEM
Change all columns code from varchar(30) to text
code from varchar(30) to textThe data type of columns "code" have been replaced from varchar(30) to text in order to allow big number of characters.
Allow tab ordering in GwInfo (via config_form_tabs)
Now, it is possible to order the tabs of the info form by editing column "orderby" from table "config_form_tabs".
Last updated
