giswater / giswater_qgis_plugin Goto Github PK

Function to connect points to virtual nodes (no topological entities). The connection line goes to "link" table.

I think we should create a folder called doc for the documentation. For São Caetano we will need the database model in Portuguese Language, except the field numbers, of course. We could have the file names with ptBr at the end indicating the language.

We want to enhance audit schema in order to log&audit function execution and its results

Add new schema related to current one, to audit any table modification (Insert, Update, Delete)

Internationalization of menus, toolbars and forms

PostgreSQL result after point insert:

PostGIS error while adding features: ERROR: column "node_tolerance" does not exist
LINE 1: SELECT node_tolerance FROM config

Automatically insert arc endpoint into nodes.

Generic issue to commit minor updates in functions and triggers

Forms for EPANET and SWMM

Some observation
giswater 0.4, QGIS 2.14.0-Essen on Windows 7

Button to track the flow until it reach network outlet. It returns nodes and arc along the path.

SELECT test_ws.gw_fct_mincut('2093', 'arc');
get_row: llave duplicada viola restricción de unicidad «temp_mincut_arc_pkey»
DETAIL: Ya existe la llave (arc_id)=(2093).
CONTEXT: sentencia SQL: «INSERT INTO temp_mincut_arc VALUES(element_id_arg)»
función PL/pgSQL test_ws.gw_fct_mincut(character varying,character varying) en la línea 62 en sentencia SQL

We have to check SQL files too

• User selects nodes with QGIS tools (snapping)
• Move these nodes to desired location
• User press button 16

Couldn't load plugin giswater due to an error when calling its initGui() method
Steps to reproduce

1. First
2. Second
3. Third

Traceback (most recent call last):
  File "C:/QGIS/Essen/apps/qgis/./python\qgis\utils.py", line 315, in startPlugin
    plugins[packageName].initGui()
  File "C:/Users/David/.qgis2/python/plugins\giswater\giswater.py", line 238, in initGui
    self.project_read()
  File "C:/Users/David/.qgis2/python/plugins\giswater\giswater.py", line 332, in project_read
    self.current_layer_changed(self.iface.activeLayer())
  File "C:/Users/David/.qgis2/python/plugins\giswater\giswater.py", line 338, in current_layer_changed
    print www
NameError: global name 'www' is not defined

giswater 0.4, QGIS 2.14.0-Essen on Windows 7

Workflow:

• User select one node.
• A form is opened showing current node_type.type
• Combo to select new node_type.type
• Combo to select catalog id
• Trigger 'gw_trg_edit_node' has to be disabled temporarily
• Change node_type
• Enable trigger again

Please, review it and made any changes you desire

Search upstream nodes and pipes until basin headers.

Already working in branch 'issue-66'

Update links from connect to end_connect. when arc is updated

When the arc INSERT includes adding end node the fields "arc.node_1", "arc.node_2" are empty.

Customer's request on 24/05/2016.

When dma is updated, dma_id of node, arc, connec & gully must be updated automaticlly if it's needed.

Overlap control between polygon it's needed

Commits done to the same branch than #58.

Xavier needs to know how to export GIS water, wastewater and sewer to CAD.

Mincut polygon.

Toolbars Epanet, SWMM and Analysis
Main plugin menu

Inside the folder i18n we will find translation files (*.ts)
We need to translate text to portuguese. The file to update is: Giswater_pt.ts (inside i18n folder)

Customer's request on 24/05/2016.

When sector is updated, sector_id of node, arc, connec & gully must be updated automaticlly if it's needed.

Overlap control between polygon it's needed (TODO check "sector" topology).

Function that deletes nodes joining the pipes sharing the node. Longest pipe data is kept in the new pipe.

Renato needs to know to to query from one database to another.

We will do an initial import from Giswater repository.
Then we will commit changes only in this repository. When we decide to make a new release of Giswater, we will copy this changes (in one 'big' commit) in the "main" repository.

Configure and implement map tools for water supply