PostGIS
Name
ST_MoveIsoNode — Moves an isolated node in a topology from one point to
another. If new apoint geometry exists as a node an error is thrown.
Returns description of move.
Description
Moves an isolated node in a topology from one point to another. If new
apoint geometry exists as a node an error is thrown.
If any arguments are null, the apoint is not a point, the existing
node is not isolated (is a start or end point of an existing edge), new
node location intersects an existing edge (even at the end points) or
the new location is in a different face (since 3.2.0) then an exception
is thrown.
If the spatial reference system (srid) of the point geometry is not the same as the topology an exception is thrown.
Availability: 2.0.0
Enhanced: 3.2.0 ensures the nod cannot be moved in a different face
This method
implements the SQL/MM specification. SQL-MM: Topo-Net Routines: X.3.2
Examples
-- Add an isolated node with no face --
SELECT topology.ST_AddIsoNode('ma_topo', NULL, ST_GeomFromText('POINT(227579 893916)', 26986) ) As nodeid;
nodeid
--------
7
-- Move the new node --
SELECT topology.ST_MoveIsoNode('ma_topo', 7, ST_GeomFromText('POINT(227579.5 893916.5)', 26986) ) As descrip;
descrip
----------------------------------------------------
Isolated Node 7 moved to location 227579.5,893916.5