[Qgis-user] network building tool

[Tim Michelsen]

>    I've used a relational database with a table of nodes (with lat, lon) 
> and a table of connections (from_node, to_node), then created a view to 
> represent lines in well-known-text.  Move a node and all the lines would 
> move along with it since they're defined as a view.   The line movement 
> was not dynamic; it would require a pan/zoom/refresh in the web app as 
> the graphics were rendered on the server (via Mapserver).
This is exactly what I am looking for.

But rather on the desktop than on a server.
Maybe using the sqlite.
Also, I was thinking to let the automatic updater just change update the
last vertex once the network is created.

See the following use case:

1) nodes are entered as assumed from geocoding
2) the connection lines are created by the described procedure
3) the lines are manually fine-tuned by adding vertices in order to move
around settlements, bridges, barriers, etc.
4) then, stakeholder provide feedback on the correct placement of the nodes
5) the location of some nodes have to be shifted
6) then, the procedure would need to update the lines. In the ideal case,
the line would just be updated after the last vertex in order to maintain
the manual corrections on step (3).

Thanks for the good discussion and regards.