Releases | Open Sustainable Technology

GISWATER - v4.14.5

🔽 Read the summarized changelog here 🔽

Fixed

Fix get_major_version function on tools_qgis to return the correct major version.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.14.4...v4.14.5

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 19 days ago

GISWATER - cli-v0.3.0

🔽 Read the summarized changelog here 🔽

Added

Manifest-driven schema kinds (engine/manifest_registry.py): addon/main kinds, update paths, integrate profiles, and register_version context are discovered from dbmodel/manifests/*.yaml instead of hardcoded Python lists.
New satellite schemas (e.g. publi) work with gw schema addon create|integrate|update|drop as soon as a manifest and SQL tree exist — no CLI code changes required.

Changed

gw schema addon --type accepts any kind listed by gw manifest list (no fixed choices= whitelist).
schema_catalog treats any non-ws/ud project_type as an addon for network discovery and inventory.
network update resolves addon patch roots via convention schemas/addon/{kind}/updates and orders kinds from manifests (unknown addons default between cibs and ws).
create derives integrate/register behavior from manifest profile names (integrate_ws, integrate_ud, integrate, activate, …) instead of per-kind if branches.
prepare_cli_release.py runs ruff check on giswater_admin/ and scripts/ before tagging or publishing.

Fixed

Lockstep network updates when the dbmodel tree has SQL patches but no manifest files (tests / minimal fixtures).

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/cli-v0.2.0...cli-v0.3.0

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 25 days ago

GISWATER - v4.14.4

🔽 Read the summarized changelog here 🔽

Fixed

Fix gw_fct_setselectors and gw_fct_getselectors functions using cat_manager configuration.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.14.3...v4.14.4

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 25 days ago

GISWATER - cli-v0.2.0

🔽 Read the summarized changelog here 🔽

Added

Persistent database connection in user config: gw config set database.conn URL or database.config /path/to/conn.yaml (used when --conn / --config are omitted).

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/cli-v0.1.1...cli-v0.2.0

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 25 days ago

GISWATER - cli-v0.1.1

🔽 Read the summarized changelog here 🔽

Fixed

Schema builds failing on legacy update patches that use DISABLE TRIGGER ALL when the manifest profile skips reload_fct_ftrg (e.g. ci, empty): reset the database role to the installer after load_base so updates and load_sample run as superuser.

Added

ci and dev as valid --profile choices for gw schema main create.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/cli-v0.1.0...cli-v0.1.1

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 26 days ago

GISWATER - cli-v0.1.0

🔽 Read the summarized changelog here 🔽

Added

PyPI package giswater-cli with gw console entrypoint (Python 3.9+).
Headless schema engine shared with the QGIS plugin (SchemaBuilder, YAML manifests under dbmodel/manifests/).
gw db init — install PostGIS, pgRouting and required PostgreSQL extensions per database.
gw schema main create|update|drop — ws/ud project schemas with manifest profiles (empty, test, demo, …).
gw schema addon create|integrate|update|drop — satellite schemas (utils, cibs, audit, …) and parent wiring.
gw schema list — list schemas configured in the active dbmodel.
gw network show|update — inspect linked topology and run lockstep network upgrades.
gw dbmodel install|list|use|status — download, cache and switch Giswater SQL releases from plugin ZIPs.
gw config get|set — persistent user settings (~/.config/giswater/config.yaml or %APPDATA%/giswater/).
gw manifest validate|list — validate and enumerate manifest YAML files.
gw version — report CLI package version and active dbmodel/schema version.
Dbmodel resolution via --dbmodel-path, GW_DBMODEL_PATH, user config, or sibling checkout (gw dbmodel use dev).
Offline --check mode to print the SQL execution plan without connecting to PostgreSQL.
Timing reports and structured log output for automation and CI.
Legacy command aliases (create, update, drop, status, init-db, update-network, audit …) with stderr deprecation warnings.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/releases/tag/cli-v0.1.0

📃 Check the official documentation here: ⛓️‍💥 Giswater CLI Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 26 days ago

GISWATER - v4.14.3

🔽 Read the summarized changelog here 🔽

Fixed

Fix add_demand_check, initialize cur_step correctly.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.14.2...v4.14.3

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 29 days ago

GISWATER - v4.14.2

🔽 Read the summarized changelog here 🔽

Fixed

Fix gw_fct_graphanalytics_mapzones_v1 function to set expl_visibility and expl_id in mapzones expl_ids.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.14.1...v4.14.2

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by ArnauUrgeles about 1 month ago

GISWATER - v4.14.1

🔽 Read the summarized changelog here 🔽

Fixed

Fix config_form_fields dv_querytext to use ve_exploitation instead of vf_exploitation for macroexpl_id filter column.
Enable and require sector_id and muni_id on netscenario mapzone forms plan_netscenario_dma and plan_netscenario_presszone.
Fix netscenario mapzone Create/Update in mapzone_manager to upsert into plan_netscenario_* (not operative ve_*) and refresh the netscenario table after accept.
Fix gw_fct_graphanalytics_mapzones_v1 function to filter by expl_id in the graphconfig.
Fix gw_fct_graphanalytics_mapzones_v1 function to use expl_visibility with expl_id in the views.
Add missing cur_user filter to config_param_user queries for epa_dscenario_percent_hydro_threshold parameter.
Fix netscenario views to use vf_exploitation to filter with permissions.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.14.0...v4.14.1

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by ArnauUrgeles about 1 month ago

GISWATER - v4.14.0

🔽 Read the summarized changelog here 🔽

Added

Add "Filter by selector" checkbox to mapzone manager to toggle between exploitation-permission scope and user selector scope.
Persist mapzone manager "Filter by selector" checkbox state per user session (defaults to checked on first open).
Add vf_exploitation view (based on cat_manager and admin_exploitation_x_user).
Add v_ui_*_sel mapzone views for selector-based filtering (selector_sector, selector_macrosector, selector_expl).
New tests for vf_exploitation view and mapzones _sel views.

Changed

Refactor mapzone v_ui_* views to filter by vf_exploitation instead of inline selector filters.
Improve gw_fct_graphanalytics_manage_temporary now uses the new vf_exploitation view to filter with permissions.

Fixed

Fix gw_fct_getprofilevalues function to use the correct columns for ud and ws.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.13.1...v4.14.0

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG about 1 month ago

GISWATER - v4.13.1

🔽 Read the summarized changelog here 🔽

Fixed

Fix graphanalytics_mapzones function by adding mapzone_type filter to graph delete queries in order to avoid deleting graph records belonging to other mapzone types stored in the same table.
Fix cibs.cat_hydrometer_category table by changing the id type to int4 and add foreign key constraint for cat_period_id in hydrometer_period table.
Fix graphanalytics_mapzones mapzones for ud can also be in SelfConflict, fix small bugs.
Fix graphanalytics_omunit function by resetting omunit_id to 0 when the referenced omunit no longer exists.

Removed

Remove default value for dataquality_obs columns.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.13.0...v4.13.1

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG about 1 month ago

GISWATER - v4.13.0

🔽 Read the summarized changelog here 🔽

Added

Add new key sys_limit to config_param_system to set the limit of the search results, modify the gw_fct_getsearch function to use the new key, default to 10.
Add new columns dataquality and dataquality_obs to the node, arc, connec, link, element and gully tables.
Add new column turns_count to the man_valve table.

Changed

Ignore TCV valves on sys_fprocess process 368.

Fixed

Update messages for arcs without start/final nodes.
Update gw_fct_admin_manage_fields function to use the correct schema name and table name.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.12.0...v4.13.0

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG about 1 month ago

GISWATER - v4.12.0

🔽 Read the summarized changelog here 🔽

Added

Manage Schemas dialog (GwManageSchemasDialog): single UI to inventory network anchors and manage satellite schemas (utils, cibs, AM, CM, audit) with contextual actions, fixed geometry, and refresh after admin load.
Connection selector and read-only system info panel in Manage Schemas (PostgreSQL / PostGIS / PgRouting versions and missing extensions); switch DB connection without closing the dialog (reload_connection_for_manage_schemas).
Rename and delete actions for network (WS/UD) schemas from Manage Schemas, wired to existing admin rename/delete flows.
_admin_catalog module and AdminLoadTask: fast pg_catalog inventory (schemas with sys_version, aux flags, pending updates) instead of repeated information_schema round-trips.
GwSchemaBuilderTask: generic QgsTask around giswater_admin.engine.SchemaBuilder, replacing legacy per-schema create threads (project_schema_*_create).
New cibs schema and manifest; sys_version on cibs; WS/UD integration SQL and admin actions to create, update, adapt, and copy hydrometer data from a selected network parent.
Hydrometer model refresh (4.12.0): ext_hydrometer_period, v_/ve_ hydrometer views, editable ve_hydrometer_period, and v_cat_* catalogue views; sample dumps and forms updated.
AM/CM manifests and parent-schema creation stubs from Manage Schemas (WS-only AM).
pgTAP tests for UD link views (ve_link, ve_link_vlink, ve_link_pipelink).
CI/dbmodel: PostGIS matrix, Docker/Podman test runner, parallel pg_prove, and stricter SQL folder validation in sql_runner.
libs: show_warning_box, configurable DB connection timeout, and message boxes that respect message_parent (modal child of admin dialogs).
Add column is_twin and parent_id to rpt_cat_result
Add column vnom to man_tank
Recreate triggers for pol tables

Changed

Manage Schemas CM panel: Create/Integrate/Sample/QGIS actions replace the old admin_cm_create launcher dialog. schemas grouped under dbmodel/schemas/main and addons; network updates consolidated into patch.sql per version (drop separate ddl/dml/ddlview/trg files for new bumps).
Admin: utils/cibs/audit flows consolidated; schema SQL paths point at main/; build logs list SQL files only; progress/time labels on schema builder tasks.
Hydrometers: rename ext_rtc_hydrometer → ext_hydrometer, ext_rtc_hydrometer_data → ext_hydrometer_period; sum → billed_volume; form/list queries use v_/ve_ views; ext_cat_hydrometer_category id type integer.
SCADA tables: ext_rtc_scada / ext_rtc_scada_x_data naming aligned across imports, functions, and tests.
ws_gw_fct_create_dscenario_from_crm: joins and hydrometer_id references updated for the new hydrometer tables (no pattern_id).
Manage Schemas: cibs adapt/copy pass the selected network schema directly (no dlg_readsql.cmb_cibs workaround); info messages use show_info_box when opened from the dialog.
Mapzone type columns (sector_type, drainzone_type, omzone_type, dwfzone_type) widened to varchar(30) in tests and patches.

Removed

Deprecated ext_cat_hydrometer_category_x_pattern table and related tests.
Legacy admin threads: project_schema_create, project_schema_utils_create, project_schema_cm_create, project_schema_audit_create, project_schema_asset_create, project_schema_update.
Standalone cibs “copy data” button from the main admin UI (copy remains available from Manage Schemas).
Obsolete dbmodel per-version changelog/SQL trees under old updates/ layout (superseded by schemas/main/.../updates).

Fixed

gw_fct_anl_arc_* pgTAP tests: drop leftover temp tables between cases.
UD schema tests and link view definitions after hydrometer / structure refactors.
WS schema tests after hydrometer catalogue and view renames.
om_mincut_hydrometer FK targets ext_hydrometer; mincut hydrometer views rebuilt on v_hydrometer / v_hydrometer_period.
Plugin/schema path resolution (plugin_version, cibs integration SQL, manifests).

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.11.2...v4.12.0

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG about 1 month ago

GISWATER - v4.11.2

🔽 Read the summarized changelog here 🔽

Fixed

Improve UD checks in getvisit and setvisit
Update mincut selector config in config_param_system (basic_selector_tab_mincut): add typeaheadFilter so filter in web works.
Rename columns in tbl_mincut_manager tableview: expl_id to exploitation, muni_id to municipality.
Fix gw_fct_setselectors: use selector_municipality (muni) instead of selector_sector to update selector_expl.
gw_fct_setmincut: set expl_id from arc and macroexpl_id from exploitation on om_mincut.
Fix visit dialog: unify parameter_id combo fill logic and refresh it after visit load and on Event tab entry.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.11.1...v4.11.2

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG about 2 months ago

GISWATER - v4.9.2

🔽 Read the summarized changelog here 🔽

Fixed

gw_trg_edit_psector trigger to set obsolete features where psector_x_* state is 0 before setting on service features.
gw_fct_graphanalytics_mapzones_v1 check if there are any nodes/arcs in the graphconfig that are not in the operative network (only for connected networks).

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.9.1...v4.9.2

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG about 2 months ago

GISWATER - v4.11.1

🔽 Read the summarized changelog here 🔽

Fixed

Update reference function id for gw_fct_anl_node_topological_consistency.
gw_fct_graphanalytics_omunit function to disable edit_disable_arc_fkarray when updating omunits.
Optimize gw_trg_array_fk_array_table: pg_catalog type lookup and global edit_disable_arc_fkarray bypass.
Fix function id references in sys_function and config_function tables.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.11.0...v4.11.1

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG about 2 months ago

GISWATER - v4.11.0

🔽 Read the summarized changelog here 🔽

Added

Algorithm to calculate omunits and macroomunits gw_fct_graphanalytics_omunit.
has_access column to node table.
ve_omunit and ve_macroomunit views with edit triggers.
New function gw_fct_admin_manage_view_dependencies to manage view dependencies.

Removed

sector_id and muni_id from exploitation table.
psector_status typevalue 4 (EXECUTED).

Fixed

gw_trg_edit_psector trigger to set obsolete features where psector_x_* state is 0 before setting on service features.
gw_fct_graphanalytics_mapzones_v1 check if there are any nodes/arcs in the graphconfig that are not in the operative network (only for connected networks).
config_form_fields dv_querytext for muni_id in mincut form to use correct alias.
visit insert correctly the records on om_visit_x_* tables.
correct signal for rejected visit dialog.
recreate the triggers for the mapzones when the utility scheme is activated.
fix visit dialog to show the correct features when the dialog is accepted.
fix update of omunit and macroomunit geometry type to multipolygon.
add work_order, forecast_start, and forecast_end columns to temp_t_mincut table.
Improve performance of gw_fct_getinfofromcoordinates function.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.10.0...v4.11.0

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG about 2 months ago

GISWATER - v4.10.1

🔽 Read the summarized changelog here 🔽

Fixed

config_form_fields dv_querytext for muni_id in mincut form to use correct alias.
visit insert correctly the records on om_visit_x_* tables.
correct signal for rejected visit dialog.
recreate the triggers for the mapzones when the utility scheme is activated.
fix visit dialog to show the correct features when the dialog is accepted.
fix update of omunit and macroomunit geometry type to multipolygon.
add work_order, forecast_start, and forecast_end columns to temp_t_mincut table.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.10.0...v4.10.1

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG about 2 months ago

GISWATER - v4.10.0

🔽 Read the summarized changelog here 🔽

Added

stable gw_id custom map layer property when adding layers to the TOC so lookup and removal do not rely on the layer display name alone.
add_layer_provider with URI builders (WMS, WFS, OAPIF, XYZ, GeoJSON) for loading non-PostGIS layers from providerConfig.
gw_fct_getaddlayervalues: return providerConfig from sys_table for add-layer value lists.
Add basic_search_v2_tab_visit in config_param_system for web and desktop search

Changed

child-layer menu, temporal and snapshot layers, mincut/psector overlap layers, EPA dscenario/netscenario removal, Go2Iber imports, ValueRelation layers in HIDDEN, and backend query layers updated for the new TOC APIs.
Profile algorithm: now accept mid features (arcs) in addition to nodes.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.9.1...v4.10.0

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG about 2 months ago

GISWATER - v4.9.1

🔽 Read the summarized changelog here 🔽

Fixed

Fix functions and triggers to use v_raster_dem instead of ext_raster_dem.
Fix mincut offline result layer names and styles.
Align mincut plan address fields in config_form_fields (muni_id, streetaxis_id, postnumber on lyt_plan_address).
Update mincut default JSON in config_param_system add forecast_start/end.
Set default list sorting for tbl_mincut_manager in config_form_list (device 5).
Fix mincut snapping and related signals on mincut buttons.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.9.0...v4.9.1

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG about 2 months ago

GISWATER - v4.9.0

🔽 Read the summarized changelog here 🔽

Added

New dscenario pattern and pattern value tables (inp_dscenario_pattern, inp_dscenario_pattern_value).
New typevalue for dscenario type: CALIBRATION.
New visibility tables node_x_sector_visibility, node_x_municipality_visibility, element_x_sector_visibility, element_x_municipality_visibility.
New trigger gw_trg_update_element_mapzones to update mapzone columns on element.
has_treatment column on UD node, connec, and gully tables, related triggers, and ve_node, ve_connec, and ve_gully views.
drainzone_outfall calculation and updates to dwfzone_outfall in graph analytics mapzones.
v_recalculate_macromapzones parameter and related macro mapzone logic in gw_fct_graphanalytics_mapzones.
Temporary table and view for element management inside graph analytics.
Drainzone handling in graph analytics extended so addfields / addparam.drainzone receive aggregated results where applicable.
provider_config column on sys_table plus related catalogue checks.
View v_type_street and updated config_form_fields references for street types.
CSO overflow mapping table for storm overflow workflows.

Changed

Config toolbox: SQL input parameters for graph class and exploitation options.
sys_style: improved line symbology for fluid types.
Municipality assignment for nodes when several municipalities lie nearby (selection logic refined).
Upstream/downstream analysis: traverse network regardless of is_operative on elements.
fct_cm_check_progress: exposes percentage of executed nodes per campaign.
Network mincut: streamlined SQL queries and address autofill usable from web and desktop.
Multiple SQL functions: sector_id conditions normalized for clearer integrity rules.
i18n: labels, tooltips, and descriptions (graph tools, exploitation, and general wording).
Optional dependencies resolved via tools_os.get_dep instead of bare imports.

Fixed

inp_dscenario_demand: move id column to first position for stable column ordering.
Composer: logo image path resolution.
gw_fct_graphanalytics_mapzones_v1: drainzone insert/update; correct expl_id[], muni_id[], sector_id[] arrays for mapzones; ignore sector_id = 0 when aggregating sectors; create temp_pgr_mapzone_graph only when running graphanalytics mapzones.
Graph analytics visibility: WS/UD compatibility for node_x_sector_visibility-related flows.
gw_fct_getfeatureupsert: default value handling for filter combo widgets when updating features in Info.
gw_fct_cm_setcheckproject: GeoJSON payload handling for check results.
gw_fct_cm_check_data_context: expanded checks and clearer error texts; QC output limited to rows with status = 1 and action <> 3.
gw_fct_pg2epa_check_network: sector_id and dma_id behaviour on disconnected networks.
gw_fct_pg2epa_export WS dscenario path: tank parameters updated correctly on inlet links.
gw_fct_getsearch: optional JSON key to target a specific layer in the search call.
gw_fct_setelevfromdem: propagate detailed errors back to the client on failure.
om_check_data: use catalogued t_tables instead of ad hoc target tables.
Asset Manager: insert into sys_version uses schema SRID (SCHEMA_SRID) for EPSG.
gw_fct_getprofilevalues: cast JSON descript through text for stable typing.
Lot/campaign selectors: ON CONFLICT handling for campaign/lot selectors to avoid duplicate key failures.
inp_subcatchment: enforce foreign keys referencing municipality where defined in utils/tablect DDL.
temp_anl_arc / temp_anl_node: drop redundant duplicate index DDL where the index already existed.

Full Changelog: https://github.com/Giswater/giswater_qgis_plugin/compare/v4.8.4...v4.9.0

📃 Check the official documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 2 months ago

GISWATER - v4.8.4

🔽 Read the summarized changelog here 🔽

Fixed

Improve composer warning handling and correct coverage.
Fix ve_plan_psector and v_plan_psector references.
Fix hardcoded logo.png path.
Improve psector manager performance.
Fix psector other_prices tab bug with ',' and '.' as decimal separator.
Fix problem with psector pca calculation.
Fix dscenario manager to check columns from views instead of tables.

Changed

Performance profiling in get_psector method when open existing one.
References from ve_plan_psector to v_plan_psector in sys_table and sys_style tables.

Removed

Deprecated code on psector manager to improve performance.
Hide pump additional tab in dscenario manager.

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/v4.8.3...v4.8.4
Full Changelog (Database): https://github.com/Giswater/giswater_dbmodel/compare/v4.8.3...v4.8.4

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by ArnauUrgeles 2 months ago

GISWATER - v4.8.3

🔽 Read the summarized changelog here 🔽

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/v4.8.2...v4.8.3
Full Changelog (Database): https://github.com/Giswater/giswater_dbmodel/compare/v4.8.2...v4.8.3

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 2 months ago

GISWATER - v4.8.2

🔽 Read the summarized changelog here 🔽

PYTHON

Removed dependency on chardet

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/v4.8.1...v4.8.2

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by smaspons 3 months ago

GISWATER - v4.8.1

🔽 Read the summarized changelog here 🔽

PYTHON

refactor(GwProjectCheckCMTask): mark functions for removal and improve JSON response handling
feat(GwMapzoneManager): enhance search functionality to filter by name, id, or code
refactor(toc): streamline context menu level handling in add_child_layer_btn and style_manager
refactor(workspace_manager): update table model configuration in workspace manager
fix(tools_gw): add missing layer directly if not on thread
chore: add support for Qt6 in metadata
fix(file_transfer, mapzones_manager): remove map movement on mapzones config selections and save user selections in file_transfer

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/v4.8.0...v4.8.1

DATABASE

Fix gw_trg_arc_node_values trigger on ws schemas.
Fix gw_fct_graphanalytics_macromapzones streamline temporary table management.
Fix gw_fct_pg2epa_export_inp add alias for emitter_coeff.
Fix gw_fct_graphanalytics_mapzones_v1 function.
Performance of dscenario views for ws and ud
Fix gw_trg_gully_proximity , gw_trg_connec_proximity triggers to use ve_gully and ve_connec tables instead of gully and connec tables.
Fix gw_fct_getfeatureupsert function to use ve_node , ve_connec and ve_gully tables instead of node , connec and gully tables.
Recreate ve_connec and ve_gully views.
Add new indexes on anl_* tables.
Remove losses dscenario.
Improve inp_family table and result_families function.
Fix gw_fct_setfeaturereplaceplan function.
Fix ud_gw_trg_topocontrol_node trigger.
Fix ud_gw_trg_topocontrol_arc trigger.
Fix gw_fct_psector_merge function.
Fix ud_pg2epa noew export undefined nodes connected to not undefined arcs.

Full Changelog (Database): https://github.com/Giswater/giswater_dbmodel/compare/v4.8.0...v4.8.1

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by ArnauUrgeles 3 months ago

GISWATER - v4.8.0

🔽 Read the summarized changelog here 🔽

PYTHON

Refactor getlist and tableviews header with alias management.
Add tab supplyzone on mapzone manager.
Changed QGIS maximum version to 4.0.
Fix getting style for some layers.
Fix QGIS crash with toolbox processes.
Fix QGIS project creation.
Various CM bug fixes.

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/v4.7.1...v4.8.0

DATABASE

refactor(doc): convert doc_id to integer
feat(graphanalytics): improve fluid_type and treatment_type temporal layers
feat(graphanalytics): show warning when commitchange and use psector are true
refactor(pg2epa_check_result): use sys_fprocess logic to execute ud epa result checks
feat(setmincut): don't allow deleting mincut if it's not planified
feat(cm): new function to build topology of a selected Lot
feat(gettoolbox): create cm group on toolbox
feat(cm): wip new function massive arc divide
feat(epa): export valve and shortpipe as reservoir or junction
enhan (go2epa): Enhan performance

Full Changelog (Database): https://github.com/Giswater/giswater_dbmodel/compare/v4.7.1...v4.8.0

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by smaspons 4 months ago

GISWATER - v4.7.1

🔽 Read the summarized changelog here 🔽

PYTHON

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/v4.7.0...v4.7.1

DATABASE

fix(sys_param_user): set is_mandatory true on some variables
fix(mapzones): fix mapzone check

Full Changelog (Database): https://github.com/Giswater/giswater_dbmodel/compare/v4.7.0...v4.7.1

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by ArnauUrgeles 5 months ago

GISWATER - v4.7.0

🔽 Read the summarized changelog here 🔽

PYTHON

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/v4.6.0...v4.7.0

DATABASE

refactor(topology): refactor UD tepology fields
remove: sys_code unique
fix: graphinundation
fix: getprofilevalues
feat: add function to export EPA result families
refactor(mincut): use pgr_linegraph instead of arrange_network
feat(profile): load temporal layers when getprofilevalues
feat(mapzones): add checks before execute mapzones
feat(pg2epa): add new checks on export inp

Full Changelog (Database): https://github.com/Giswater/giswater_dbmodel/compare/v4.6.0...v4.7.0

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by ArnauUrgeles 6 months ago

GISWATER - v4.6.0

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 7 months ago

GISWATER -

🔽 Read the summarized changelog here 🔽

PYTHON

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/v4.5.3...v4.5.4

DATABASE

Fix gw_trg_config_control, add missing condition
Fix gw_trg_connec_proximity
Fix gw_trg_connect_update
Fix config_form_fields use correct dv_query_text on man_type_* columns.
Delete obsolete function gw_trg_edit_plan_psector_x_connect, and related views:
- ve_plan_psector_x_connec
- ve_plan_psector_x_gully
Fix deleting psectors with to_arc property
Fix getmessage call on some trgs
Fix gw_fct_getchangefeaturetype, correct syntax on some selects
Fix gw_fct_pg2epa_vnodetrimarcs, update links connected to node2arc
Fix gw_fct_setfeaturereplace, filter by schema_name
Fix 'gw_trg_topocontrol_arc`, capture node sys_values
Fix gw_fct_setendfeature, show error if downgrade arc connected to connecs
Fix gw_fct_pg2epa_export_inp, avoid exporting disconnected network demand

Full Changelog (Database): https://github.com/Giswater/giswater_dbmodel/compare/v4.5.3...v4.5.4

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 8 months ago

GISWATER -

🔽 Read the summarized changelog here 🔽

PYTHON

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/v4.5.2...v4.5.3

DATABASE

fix: cat_arc area translation on es_CR
translate(config_param_system) admin_currency
fix: config_fprocess add rpt_arc_stats and rpt_node_stats entries
fix: gw_fct_pg2epa_check_network use -2 as dma_id to not use Undefined value

Full Changelog (Database): https://github.com/Giswater/giswater_dbmodel/compare/v4.5.2...v4.5.3

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 9 months ago

GISWATER -

🔽 Read the summarized changelog here 🔽

PYTHON

fix: widget type compatibility and checking across UI
fix: psector topology validation and error handling

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/v4.5.1...v4.5.2

DATABASE

fix: psector translations
fix: initproject
fix: config_form_fields dma
fix: canva refresh

Full Changelog (Database): https://github.com/Giswater/giswater_dbmodel/compare/v4.5.1...v4.5.2

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 9 months ago

GISWATER - v4.5.1

🔽 Read the summarized changelog here 🔽

PYTHON

fix: apply GwPlan when a psector is current
remove: chk_enable_all funcionality
fix: psignals on psector_manager and play/pause button
remove: delete from selector_psector when psector is set to inactive

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/v4.5.0...v4.5.1

DATABASE

fix: psector merge
fix: psector duplicate
fix: psector topology when duplicated nodes are found
fix: psignals on psector_manager and play/pause button
fix: some rows on sys_message
fix: selector_psector, add new messages to be more clear
fix: adding connecs into a psector without arc_id
fix: log order on audit_check_data

Full Changelog (Database): https://github.com/Giswater/giswater_dbmodel/compare/v4.4.0...v4.5.1

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by danimarinBG 9 months ago

GISWATER - Version 4.5.0

🔽 Read the summarized changelog here 🔽

PYTHON

refactor: rename all v_edit_* views to ve_* prefix across entire plugin
refactor: setfields - use database setfields instead of QGIS insert for feature creation
refactor: remove legacy docker references and "show on top" / "zoom to selection" buttons from psector
refactor: consolidate psector loading and signal management into dedicated methods

feat: add new CM toolbar to Giswater - CRUD operations for campaigns, lots, organizations, teams, users with role-based permissions
feat: add new AM toolbar to Giswater - priority calculation, breakage analysis, and result management
feat: implement new translation logic - complete i18n overhaul with new schema, JSON management, and type-ahead search
feat: psector mode toggle in status bar with context menu and upward popup
feat: connect link - implement psector double-insert logic (state=0 and state=1)
feat: go2iber integration - full IBER model export with DAT file generation and RPT import
feat: import EPANET/SWMM - add save to psector functionality
feat: selection by expression - unified selection class with point/polygon/expression methods
feat: elements - add ve_genelem and ve_frelem support with multiple tabs
feat: dscenario manager - add frshortpipe tab and flow regulator add/remove functionality
feat: mapzone manager - dynamic mapzone support with save last active tab
feat: nonvisual managers - implement ctrl+z logic in curves and patterns
feat: markdown generator for documentation
feat: hiddenForm logic to suppress form on create feature
feat: pgRouting version compatibility check in load project
feat: GitHub workflow templates and flake8 CI configuration

perf: optimize selectors, table refresh logic, and map rendering
perf: improve SQL query performance for i18n, CM, and EPA imports
perf: enhance form change detection and caching

fix: project creation for es_CR and other locales with malformed JSON
fix: psector - toggle doable in new psectors and refresh on table relations
fix: mincut - proper deletion of conflicts and result selector updates
fix: import EPANET - time options (HH:MM), diameters as mm, node catalogs
fix: import SWMM - flow regulators methodology and enable triggers
fix: selection tools - improve snapping precision and map/table interaction
fix: macOS - avoid blocking main QGIS window with dialogs
fix: feature_replace - catalog_id combobox and arc snapping in psector mode
fix: info docker - double click functionality and crosssection image display
fix: signal and thread handling for psector, CM, and selection tools

chore: add flake8 configuration and CI workflow for Python compatibility checks
chore: refactor hundreds of files to meet flake8 and typing standards

Full Changelog (Python): https://github.com/Giswater/giswater_qgis_plugin/compare/mv3.6.023...v4.5.0

DATABASE

refactor: parent tables, node_id, arc_id, connec_id, link_id, gully_id, element_id now are integer
refactor: parent tables, reorder all fields
refactor: add uuid column to parent tables: node, arc, connec, element, link, gully
refactor: add [feature]uuid columns to element_x[feature], doc_x_[feature], om_visit_x_[feature]
refactor: parent views, v_edit_node, v_edit_arc, v_edit_connec, v_edit_link, v_edit_gully, v_edit_element now are ve_*
refactor: change psectors strategy for better manageability, enhanced topology
refactor: rename staticpress to staticpressure, pression to pressure
refactor: recreate dma table with updated structure (UD)
refactor: recreate inp_inlet with updated structure (UD)
refactor: recreate inp_frshortpipe tables (WS)

feat: new type of elements, ve_man_genelem and ve_man_frelem
feat: links now are visitables, adapt logic to include links in the om_visit...
feat: new configured templates of qgis using sys_table
feat: create new algorithm to calculate mapzones from zero
feat: add new column 'crm_number' on 'ext_rtc_hydrometer_x_data' to store values from the device where the data has been taken. Eventually, it could be different from hydrometer_id
feat: create dma table (UD)
feat: change macrodma/macrodqa/macroomzone expl_id to integer arrays
feat: drop macrominisector table (UD)
feat: add element_add table
feat: create archived_psector_link table
feat: set expl_id as NOT NULL on mapzone tables (dma, dqa, omzone, presszone, dwfzone)
feat: add help_domain parameter to config_param_system for custom documentation domain
feat: add shorterThan and biggerThan to gw_fct_anl_arc_length
feat: add new psector mode
feat: add missing ON CASCADE constraint to element_x_gully
feat: add missing 0 (Undefined) and -1 (Conflict) values to some mapzones tables
feat: update config_form_tableview for nonvisual manager forms (patterns, curves, controls, rules, roughness, timeseries)
feat: add missing tableview configurations for cat_mat_roughness and ve_inp_timeseries
feat: update foreign key constraint on plan_psector_x_connec.link_id to include CASCADE and SET NULL options

perf: recreate views refactorizing join of selectors
perf: new mapzones algorithm (with pgrouting)
perf: new mincut algorithm (with pgrouting)
perf: new minsector algorithm (now massive mincut use the new mincut core)

fix: graphical error log of go2epa
fix: staticpressure in presszone netscenario
fix: minsectory analysis now can handle exceptions correctly
fix: trg_edit_municipality to manage expl_id
fix: fct_setarcfusion to better manage arc directions. Allow any combination on WS and restrict logical directions on UD
fix: edit_control trigger to handle deleting 0 and -1 mapzones (remove unnecessary rules)
fix: ve_inp_dwf definition
fix: objectname references from v_edit_* to ve_inp_* for better form integration

chore: add new CI for tests

Full Changelog (Database): https://github.com/Giswater/giswater_dbmodel/compare/mv3.6.023...v4.5.0

📃 Check the oficial documentation here: ⛓️‍💥 Giswater Documentation

Natural Resources - Water Supply and Quality - PLpgSQL
Published by FerranMart 9 months ago

GISWATER - Version 3.6.023

🔽 Read the summarized changelog here 🔽

EPA

Calculate avg_press grouped in exploitation only when a INP becomes corporate
Add status "RUN FAILED" for INP results

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 1 year ago

GISWATER - Version 3.6.022

🔽 Read the summarized changelog here 🔽

ADMIN/SYSTEM

Bug fix on toolbox

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 1 year ago

GISWATER - Version 3.6.021

🔽 Read the summarized changelog here 🔽

INTENTORY

Add id column to doc_x_* views
Bug fix on setselectors for multi network projects
Bug fix on query to update ext_municipality

OM

Bug fix on selector mincut config values and always order by desc
Add variable to choose if mincuts could be only deleted by its creator or by all users

EPA

Bug fix on import_inp_timeseries

MASTER

Bug fix on trg_edit_psector when execute without set operative

ADMIN/SYSTEM

Bug fix on getsearch for empty combo values
Sanitize config_toolbox to avoid errors when setting default values

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 1 year ago

GISWATER - Version 3.6.020

🔽 Read the summarized changelog here 🔽

INTENTORY

Bug fix on manage multiple addfields when insert feature
Minor bug fix for non-superusers on go2epa

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 1 year ago

GISWATER - Version 3.6.019

🔽 Read the summarized changelog here 🔽

INTENTORY

Set not null and default value for muni_id on parent layers
Set not null value for macromapzones and set to 0 if null

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 1 year ago

GISWATER - Version 3.6.015

Check out our extended change log on Gitbook 🛠️

🔽 Read the summarized changelog here 🔽

INVENTORY

Change layer of QGIS template from ext_municipality to v_ext_municipality, which is filtered by user selector.

EPA

Manage non numeric values in curves editor.
Replace scenario_id for dwf csv file.
Bug fix in Non visual objects manager: sometimes the table don't have rows.

ADMIN/SYSTEM

Show warning message if scipy/numpy packages are not available.

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 1 year ago

GISWATER - Version 3.6.018

🔽 Read the summarized changelog here 🔽

INTENTORY

Add dqa_style on v_edit_* tables

OM

Improve waterbalance function and create scenario from CRM
Bug fix on calculation of label position coords

Natural Resources - Water Supply and Quality - PLpgSQL
Published by mguzman14 over 1 year ago

GISWATER - Version 3.6.017

🔽 Read the summarized changelog here 🔽

OM

Enable inserting a node at the vertex of an arc to correct its topology.
New columns streetname & streename2 for arc, node, connec, gully to materialise values and increase the performance for big projects.
New columns road_type, surface, maxspeed, lanes, oneway, pedestrian, access_info to enhance the capabilities of om_streetaxis table.
Bug fix

Natural Resources - Water Supply and Quality - PLpgSQL
Published by mguzman14 over 1 year ago

GISWATER - Version 3.6.016

Check out our extended change log on Gitbook 🛠️

🔽 Read the summarized changelog here 🔽

INVENTORY

Enhance performance for v_edit_node
Enable see expl_id2 objects when only expl_id is selected by managing sector_id
Add columns brand_id, model_id and serial_number for node and arc UD
Delete column serial_number on man_element UD
Change columns brand and model for brand_id and model_id on cat_arc, cat_node and cat_grate UD
Change name on config_param_system variable from edit_link_check_arcdnom to edit_link_link2network. Add maxDistance as a value and use it on linktonetwork
Enable the automatic calculation of label coordinates, label rotation and label quadrant according to a user defined distance from the geometry and the rotation of the feature when inserting or updating a node

EPA

Update timser_id combo of raingage showing only active timeseries with Rainfall type

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 1 year ago

GISWATER - Version 3.6.014

🔽 Read the summarized changelog here 🔽

INVENTORY

Fix zoom & highlight to workcat features
Fix double-click on hydrometer table in info
Disable "Run" button on toolbox if no input layers found

EPA

Fix "Shape to PNG" button in Non-Visual Objects
Bug fix on 'Set junctions as outlet' toolbox function

SYSTEM

Bug fix on the use of specific sequence for feature codes

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill almost 2 years ago

GISWATER - Version 3.6.013

🔽 Read the summarized changelog here 🔽

INVENTORY

Configure 'Change feature type' form in config_form_fields and add 4 new widgets: Fluid, Location, Category & Function.

OM

Add 'ignore' to mapzone config.

SYSTEM

Add project variable 'gwCurrentStyle'

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill almost 2 years ago

GISWATER - Version 3.6.012

Check out our extended change log on Gitbook 🛠️

🔽 Read the summarized changelog here 🔽

INVENTORY

New style manager & style change button
New strategy for dynamic filter by joined use of sector-expl-muni
Add the option to set geometry to a document (it can automatically get coordinates from the document's metadata)
Add name field for documents
Add workcat, psector & visit tabs in document dialog
Create workcat manager
Remove duplicated vertex generated because of the fusion. Use st_removerepeatedpoints function for the new geom
Add new fields on inventory tables for UD node, connec, gully: placement_type, access_type
Add new field on inventory tables for WS and UD node, arc, connec, gully: label_quadrant
Add new fields on inventory tables for WS node, arc, connec: brand, model, serial_number
New field for UD arc: visitability
New field for UD connec: n_hydrometer
New mapzone columns for different tables:
- UD
  - raingage (muni_id)
- UTILS
  - samplepoint (muni_id, sector_id)
  - element (muni_id, sector_id)
  - link (muni_id, sector_id)
  - dimensions (muni_id, sector_id)
- WS
  - pond & pool (muni_id)

OM

New mapzone for WS: macrominsector with new colums for arc, node, connec, link
New mapzone for UD: minsector and macrominsector with new colums for arc, node, connec
New tables for UD: minsector and macrominsector
New columns for WS mapzones: dma_type, dqa_type
New columns for UD mapzones: drainzone_type, dma_type, sector_type
New column for UD dma and sector: graphconfig
New column for UD cat_feature_node: graph_delimiter
Improve mincut dialog by ordering the toolbar actions

EPA

New button "Show INP data" in go2epa manager
New behaviour for inlets as a junctions when they are on the end of a sector without continuity with the next one
Change "Set archive" button to "Toggle archive" (go2epa manager)
Show the dates when an EPA result has been corporate

MASTERPLAN

New function gw_fct_setpsectorcostremovedpipes
Remove prices manager

ADMIN/SYSTEM

Change all columns code from varchar(30) to text
Allow tab ordering in GwInfo (via config_form_tabs)

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill almost 2 years ago

GISWATER - Version 3.6.011

Check out our extended change log on Gitbook 🛠️

🔽 Read the summarized changelog here 🔽

INVENTORY

Add tab muni on Selector showing as many exploitations as the municipality has (disabled by default)
Enable the possibility to use a specific sequence on code for every feature type
Relate connec.plot_code with table by using plot code if variable edit_connec_autofill_plotcode is true
Add new field expl_id2 in mapzones
New field on ext_municipality, ext_region, ext_province: ext_code
Add utils table ext_province_x_region with double fk to ext_municipality
Do not modify geometry of link when arc_id is changed but link remains on same node as endpoint
Add combo for feature_type on dimensions dialog [ARC, NODE, CONNEC {GULLY}]

OM

Rename config_graph_inlet to config_graph_mincut
Remove expl_id from config_graph_mincut
Disable mincut if user hasn't any inlet on canvas to work with
Remove config_graph_valve strategy by using graph_delimiter column from cat_feature
Add '%' symbol on profile's slope

EPA

Remove to_arc and status on inp_shortpipe. Instead, now inventory values are used

MASTERPLAN

New variable plan_node_replace_code in config_param_system. When a node replace in planification is performed, choose if new arcs will have the same code as the replaced one or not
New field on plan_netscenario_presszone: presszone_type
New fields on plan_netscenario_presszone and plan_netscenario_dma: stylesheet, expl_id2

ADMIN/SYSTEM

Enhance cat_manager by working with system users and roles
Clean dbmodel: Drop views vi_parent_arc, and v_anl_flow_*

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 2 years ago

GISWATER - Version 3.6.010

Check out our extended change log on Gitbook 🛠️

🔽 Read the summarized changelog here 🔽

INVENTORY

Refactor database structure to manage additional fields:
- Remove man_addfields_value table.
- Create new tables for addfields.
- Improve database organization and efficiency.
Change qgis templates: add direction arrow on links and delete flowtrace layers for UD
CAD tools: Show a preview of what will be drawn & change circle geometry type to MultiCurve
Add layers button: ask before removing a layer
Refactor of gw_trg_link_connecrotation_update. Drop not necessary code and make it useful for QGIS latest versions (quadrant has change to position priority)
New field meter_code on man_meter (WS)

OM

Allow using the selected exploitations on mapzones analysis

EPA

Import rpt results: if there are velocities >50 they will get replaced in-memory, instead of changing the .rpt file
Enable tab 'Additional pump' in Dscenario and add/edit controls & rules with proper dialog
Calculate avg_press on mapzones for corporate results

ADMIN/SYSTEM

PG_SERVICE: Improve management of credentials when using pgservice file

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 2 years ago

GISWATER - Version 3.6.009

🔽 Read the summarized changelog here 🔽

OM

Set graphconfig and stylesheet as text on v_edit_drainzone (ud)

EPA

Bug fix: changing epa network mode with epa point of view active
Removing now() and fixing date with value '2001-01-01' on time column for views v_rpt_arc_all and v_rpt_node_all
Check links over nodarcs only when export mode > 2 for ws projects

ADMIN/SYSTEM

Bug fix: manage info accept so widget values are not lost
Epa world: only apply to parent layers
Improve automatic extension creation & version management
Don't show backup files on advanced options menu

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 2 years ago

GISWATER - Version 3.6.008

🔽 Read the summarized changelog here 🔽

INVENTORY

Add action "rotation" on node custom form for UD

OM

Add new option in Minsector Analysis to ignore broken valves
Add action "mincut_export_hydro_csv" on mincut form

EPA

Refactor of inp_options_networkmode by using only [BASIC NETWORK, NETWORK & CONNECS]
Add info form to edit dscenario items

MASTER

Allow setting geometry to psector other prices
Set style for netscenario layers when loaded

ADMIN/SYSTEM

Refactor schema creation to be much more efficient and faster

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 2 years ago

GISWATER - Version 3.6.007

🔽 Read the summarized changelog here 🔽

INVENTORY

Add new field 'plot_code' to connecs
Drop not null for dma's (ud and ws)
Enhance the simbology of mapzones
Set epa_type not null in connecs

EPA

Enable setting the outlet_id of subcatchments by editing the view v_edit_inp_subc2outlet
Use copy-paste on non-visual objects and dscenario demand dialogs
Refresh epa world view if networkmode changed
Add selector period strategy on selector
New checks on EPA data consistency

ADMIN/SYSTEM

Add Import DWF to Import CSV
Refactor of the creation of projects (empty, inventory, full and mport inp)
Add 'Show inactive' checkbox on managers
Enable the possibility to delete all selected rows in managers
Add QGIS variable 'gw_dev_mode' to manage various developer options

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 2 years ago

GISWATER - Version 3.6.006

🔽 Read the summarized changelog here 🔽

INVENTORY

New variable to open Hydrometer tab on Connec instead of Basic Form when searching an hydrometer
Creation of example data for inventory

OM

Simplify reports for water balance

EPA

Manage Hydrology scenarios and dwf scenarios (ud)
Add Roughness catalog on Non-visual
Hug enhancement of performance by creating rpt_arc & rpt_node stats table with materialized results

MASTER

Enhance button execute netscenario on netscenario_manager
New function to merge psectors (gw_fct_psector_merge)
New function setreapirpsector to be used to repair psectors when they has wrong topology
Enhance import rpt results in order to load it when they are generated by EPANET ui

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 2 years ago

GISWATER - Version 3.6.005

Check out our extended change log on Gitbook 🛠️

🔽 Read the summarized changelog here 🔽

INVENTORY

Add a Default macroexploitation even for Empty new projects
New fields on link: connecat_id, drainzone_id, workcat_id, workcat_id_end, startdate, enddate.

EPA

New button to delete items from curve (non-visual objects)
New field sector_id on inp_transects (UD).
New view v_edit_inp_transects with trigger.

MASTER

Enhancement: highlight features with state 0 in psector
Add new button to info right-click menu to open/close valves in netscenario
New button "toggle active" in netscenario
New fields on plan_netscenario_dma and plan_netscenario_presszone: active, lastupdate, lastupdate_user
New table plan_netscenario_valve and editabl view v_edit_plan_netscenario_valve
New function (3278) gw_fct_import_netscenario_valve_closed to import closed valves into netscenario configuration.

ADMIN

Fix snapping when inserting features
Add date of creation in schema properties

Natural Resources - Water Supply and Quality - PLpgSQL
Published by mariaguzman-bgeo over 2 years ago

GISWATER - Version 3.5.041

🔽 Read the summarized changelog here 🔽

INVENTORY

Minor bug fix. Wrong order on insert on trg_edit_dma (UD)
Enhance trg_edit_element to correctly manage polygon geometry, no matter if it is automatic or not
Managing tab_exploitation_add on selectors
Enhance setfeaturedelete by managing tab log
Update trigger edit link enabling values for exit_elev and exit_topelev

OM

Enhance fct_mincut_connec setting anl_feature_type, anl_the_geom and anl_feature_id
manage non priority profile features - new parameter om_profile_nonpriority_statetype

ADMIN/SYSTEM

Reset QSqlDatabase connection if lost

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 2 years ago

GISWATER - Version 3.6.004

🔽 Read the summarized changelog here 🔽

INVENTORY

New field trace_featuregeom on element and polygon to enable or disable their movement according to the movement of its node/connec/gully/element
Modify edit triggers to check that inserted streetname exists on ext_streetaxis

OM

New function (3270) gw_fct_config_mapzones for configurating mapzones using manager
New button: Utils manager (mapzones manager & prices manager)
Add config_visit_parameter and om_visit_cat tables to Giswater Load Layers button

EPA

Epa results manager: add "Archive" button
New function (3266) gw_fct_set_rpt_archived that moves data related to selected result_id from rpt and rpt_inp tables to archived tables
New function (3268) gw_fct_pg2epa_setinitvalues that updates initlevel of inlets and tanks using values from selected simulation
Enhance views (vi_t_) to export timeseries, patterns and curves from project to inp file only when they are used

MASTER

New button: Netscenario manager
New tables: plan_netscenario, plan_netscenario_dma, plan_netscenario_presszone, plan_netscenario_arc, plan_netscenario_node, plan_netscenario_connec for storing data related to mapzone netscenario.
New function gw_fct_graphanalytics_mapzones_plan for creating mapzones for netscenario.
New function gw_fct_mapzones_dscenario_pattern for inserting features and it's patterns into dscenario demanda based on values assigned to each netscenario mapzone.
New functions: gw_fct_create_netscenario_empty, gw_fct_create_netscenario_from_toc, gw_fct_duplicate_netscenario for creating new netscenarios.
New field is_waterbal on ext_rtc_hydrometer to mark hydrometers which values enter into water balance calculations

ADMIN/SYSTEM

Manage tabs editability on insert new feature
Bug fix: toolbox dialogs' titles now show function name

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill almost 3 years ago

GISWATER - Version 3.5.040

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Enhance setclosestaddress function allowing to insersect the results with a polygon layer

ADMIN/SYSTEM

Bug fix: saving project sometimes crashed qgis

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill almost 3 years ago

GISWATER - Version 3.6.003

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Change layers style when activating/deactivating epa world
Add new function to make massive interpolation for nodes

EPA

Go2Epa multistep approach
Add properties button in dscenario dialog
Improvements & fixes to flowregulator & demand actions

ADMIN/SYSTEM

Drop config_visit_class_x_feature (unused table)
Reduce the time it takes to open the info form
Fix highlight for polygons

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill almost 3 years ago

GISWATER - Version 3.6.002

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

EPA

Add styles for EPA world for parent layers
Add isoperative = true and use strategy of v_sector_node for inp views

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill almost 3 years ago

GISWATER - Version 3.6.001

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Info is now fully configurable via database (widgets from all tabs, actions, tableviews, etc.)
New variable edit_link_check_arcdnom to check if new link is connected to an arc with smaller diameter than defined value (WS)
New process to check existing connecs related to arcs with diameter bigger than defined value (WS)
New process to check existing connects with more than 1 link on service
Add region and province tables and add region_id and province_id fields to municipality and inventory tables
Add new fields on inventory tables for UD:
- node, arc, connec, gully: adate, adescript
- gully: siphon_type, odorflap
- man_manhole, man_conduit: bottom_mat
- man_chamber: bottom_mat, slope
- cat_arc: visitability
New functionality: get address and postnumber automatically when inserting node and connec
Add staticpressure update on trg_edit_connec (harmonize with node)
Add lastupdate and lastupdate_user to v_edit_element

OM

New function: gw_fct_mincut_show_current to show mincuts that are currently beeing executed in a field.

EPA

New button: Toggle EPA World. Toggle an "EPA Point of View" to show the network as it would be exported to EPA software
Added tab EPA in info
Full refactor of inp database objects
Create new object ws-virtualpump and remove import inppump and import inpvalves
New function setoptimunoutlet and refactor of sutchament view for ud projects
Added new actions in info to manage flow regulators & demands for EPA objects

MASTER

Do not allow to insert features with diferent expl_id than the psector

ADMIN/SYSTEM

Drop obsolete table selector_plan_psector

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill almost 3 years ago

GISWATER - Version 3.5.039

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

OM

Mapzones - return polygons of created zones and disconnect elements as temporal layer if commit chages is false
Force arcvidide function to move mapzones values from arc to inserted node

EPA

Add nodeinflow for detailed rpt node on UD results
Don't load epa result/compare layers by default
Set raingage geometry column not null

ADMIN/SYSTEM

Massive performance improvement of get_feature_by_id. Now the tools that search for features should be faster
Improve handling of config files.
Change querytext for *_type columns on v_edit_element form. Don't use featurecat_id
Various bug fixes

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill almost 3 years ago

GISWATER - Version 3.5.038

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Correct management of inventory field on edit_triggers

EPA

Add user variables to auto load or not go2epa selector layers

ADMIN/SYSTEM

Enhance trg_config_control adding element_type to allowed values on featurecat_id field
Enhance performance for check projects
Fix duplicated widgets on config_form_fields for not sample new projects
Various bug fix

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 3 years ago

GISWATER - Version 3.5.037

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

EPA

Bug fix in Dscenario Manager.
Fix section title in go2epa options dialog.
Enhance options for go2epa (ws & ud)

ADMIN/SYSTEM

Bug fix with config files. If they break the plugin will still load.

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 3 years ago

GISWATER - Version 3.5.036

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Minor bug fix when arc_id is not null and link does not exists
Keep the scrolled amount on selector
Enhance stats for minsector table adding num_border, num_connec, num_hydro and length

EPA

Add new source pattern from inp_connec when new scenario is created
Add "Show only active" checkbox to non-visual objects manager
Epa result manager: "Set corporate" button is now "Toggle corporate"

MASTER

Refactor strategy of execute psector. New traceability tables for executed and canceled psectors

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 3 years ago

GISWATER - Version 3.5.035

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Add new field expl_id2
New field on WS man_netwjoin - wjoin_type;
New vdefault on config for workcat_id_plan

EPA

Add button "print" on NonVisualObject for export SHAPES png

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 3 years ago

GISWATER - Version 3.5.034

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Bug fix from refactor links. Insert connects with state 0 on psector when planified node over operative node
Enhance v_ui_arc_x_relations (UD)

MASTERPLAN

Rename v_plan_current_psector_* views to v_plan_psector_*

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 3 years ago

GISWATER - Version 3.5.033

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Make Element layer identifiable with Giswater info
Add new editable fields on man_meter: real_press_max, real_press_min, real_press_avg
New function on toolbox to capture address values from closest street number
New table node_border_sector, that stores relation between node and it's additional sectors
New function gw_fct_calculate_sander for UD - calculates the depth of sander depending on node sys_ymax and arc sys_y1

OM

New system parameter edit_review_auto_field_checked - If true, at saving review data, it would be automatically set as finished
Add new review status - only review observations added, no data modifications

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 3 years ago

GISWATER - Version 3.5.032

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

Bug fix from last release (search address, links behaviour when update arc_id)

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 3 years ago

GISWATER - Version 3.5.031

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

New fields related to steps and cover on man_manhole table and in the reviews
New field on review tables - insert_date
Improve address search returning values even if writing mismatch (fuzzystrmatch extension)
New fields on UD node - parent_id, arc_id
New fields on WS node, arc, connec - om_state, conserv_state
New fields on WS connec - priority, valve_location, valve_type, shutoff_valve, access_type, placement_type, crmzone_id
New fields on WS node - access_type, placement_type
New fields on WS man_valve - valve_type; man_wjoin - wjoin_type; man_greentap - greentap_type, cat_valve; man_hydrant - hydrant_type
Deep refactor on links to enhance usability and performance. Main changes:
- Add link features on "Add arc" toolbar button
- Links are right now Giswater objects with same capabilities in terms of map than arc, node, connec, gully
- Remove vnode table and any references
- Change exit_type and pjoint_type. New values are: ARC, NODE, CONNEC, GULLY
- It is possible to create planned links related to planned connects by using qgis tools
- it is possible to relate any planned connect no any other object of network
- Connects mapzones has consistency againts related arc, not only on operative state also on planned state
Allow basic info editable
Enhance "Check all" widget on selector form with help button and new functionalities

EPA

New function gw_fct_epa2data (WS) that copies results from EPA to data form
New field on UD inp_timeseries - active
Enhancement for patterns managmement by using pattern method only to fill null values for pattern features

MASTERPLAN

Refactor trg_edit_psector merging different execution modes
Add button "Toggle active" and checkbox "Show inactive" on psector manager form
Add button "Toggle state / Toggle doable" on psector form (tab_relations)
Update button "set_to_arc" on psector form, now there are two possibilities, closing point or user click coordinates (tab_relations)

ADMIN/SYSTEM

New parameter on config_param_system 'admin_isproduction' (If true, deleting the schema using Giswater button will not be possible)
New system parameter 'admin_node_code_on_arc' - If true, codes of final nodes will be visible on arc's form. If false, node_id would be displayed
Add system variable to skip audit in massive processes
Reset dialog positions when load Giswater

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 3 years ago

GISWATER - Version 3.5.030

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Allow searching for catalog_id in change feature type & replace feature tools
Add editing action in dimensioning dialog
Get district_id when new feature is inside a district

OM

Add type & streetaxis filters in mincut manager
Add chlorine & turbidity fields in mincut

EPA

Add forcetanksoninlet for pg2epa export
New function gw_graphanalytics_upstream_section_control (UD) to control of sections inconsistencies between consecutive conduits
Minor enhancement on pg2epa for gullies on 1D/2D coupled model

ADMIN/SYSTEM

Add 'Open plugin folder' action in Giswater menu
Major bug fix in info. The first time saving worked fine but then it didn't work properly.
Allow QLineEdit & QTextEdit to have tooltips via Qt translation
Add field 'iseditable' on cat_manager

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 3 years ago

GISWATER - Version 3.5.029

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Bug fix from previous release
New toolbox function to check T candidate nodes with wrong topology

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 3 years ago

GISWATER - Version 3.5.028

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Highlight connecs/gullys that will be disconnected on feature end process
Use hemisphere change to rotate node 180º
Bug fix: insert document from another dialog (info/visit)
Bug fix: don't allow role_basic/role_om users to edit in info

OM

New functions to import scada values & hydrometer values (focused on waterbalance)

EPA

Force reservoirs on inlets when go2epa for ws
Remove pg2epa_inlet_flowtrace function
Enhance dscenario_id value domain for dscenario relations by using qgis table
Improve dscenario filter

ADMIN/SYSTEM

Enhance setselector for undefined mapzone when expl2sector and sector2expl is enabled
Add commitChanges parameter in mapzones function to allow running it without change feature table values
Improve performance for inserting features in large tables
Allow adding filters as additional columns in toolbox reports

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill over 3 years ago

GISWATER - Version 3.5.027

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Send messages to dialogs instead of to the canvas
Add node rotation logics on UD projects
Create edit_custom_link variable with google maps style and harmonize edit_feature_usefid_on_linkid the same way
Enhance delete feature: allow delete nodes connected to obsolete arcs (bug fix) and show on_service/obsolete arcs on getfeaturerelation

OM

Allow starting a mincut from another point when a planified mincut is active
New table of ws - om_streetaxis for tramified streeter
New function gw_fct_graphanalytics_hydrant & gw_fct_graphanalytics_hydrant_recursive for finding calculating reach of hydrants

EPA

Show message if curve is invalid (non-visual)
Add the_geom on v_om_waterbalance views

MASTERPLAN

Plan check - control number of rows on plan_price (fid:465)

ADMIN/SYSTEM

Add widget to hide querytext in toolbox report
Add new db variable to manage snapping configuration
Sort temporary layers by geometry type
Improve management of json keys
Refactor graf to graph

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill almost 4 years ago

GISWATER - Version 3.5.026

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Allow users to input init/end nodes in arc forms when they are NULL
Check redundant values for elevation fields (UD)
Allow hyperlinks in custom form to be editable
Manage static pressure automatically
New default value for ymax on UD
New default value for users to search municipality

OM

Recalculate mincut when execute start process
New columns on node and connec mincut result

EPA

1D/2D coupled model in combination with SWMM-IBER
Enhance valve management for ws go2epa exportation
Enable work with CRM values also on nodes (netwjoin)
Improvements on Dscenario manager
New system parameter to update inventory tables when change EPA values

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 4 years ago

GISWATER - Version 3.5.025

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

EPA

New buttons: New Non-Visual object and Non-Visual object manager
New triggers to edit data related to hydrology and dwf_scenario (UD)

ADMIN/SYSTEM

New function to import configuration of cat features from csv files

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 4 years ago

GISWATER - Version 3.5.024

Check out our extended change log on Gitbook 🛠️

🔽 Or read the summarized changelog here 🔽

INVENTORY

Add editable views for cat_feature objects
Use gully Units field to draw related polygon
Orphan node function runs with all kind of nodes (divide or not)
Divide Check Project processes related to orphan nodes in OM or EPA

OM

New trigger to update modification_date field on Mincut

EPA

Add waterbalance strategy according IWA standards with om_waterbalance reports, functions, tables and views
Improve usability of Dscenario tables
Editable view v_edit_inp_coverages
New table inp_dscenario_rules and editable view v_edit_inp_dscenario_rules (WS)
New table inp_dscenario_controls and editable view v_edit_inp_dscenario_controls

ADMIN/SYSTEM

Add Execution Time to different processes' dialog
Add Update button to Workspace Manager and minor improvement on delete
Improve reporting tool of Giswater Toolbox
New variable added to config_param_system to manage lastupdate field when using dynamic mapzones

Natural Resources - Water Supply and Quality - PLpgSQL
Published by albertbofill about 4 years ago