NODE
- A Node must have an unique integer ID.
- In a Network of the Spatial type all Nodes must have a Point geometry.
- In a Network of the Logical type all Nodes must have a NULL geometry.
- An isolated Node is a Node not referenced by any Link.
|
ISO SQL functions on isolated NODE only
|
ST_AddIsoNetNode |
ST_AddIsoNetNode( net-name , face-id , point-geom)
Inserts a row into the <network>_NODE corresponding to an isolated Node, returning the generated unique ID. |
|
ST_RemIsoNetNode |
ST_RemIsoNetNode( net-name , node-id )
Removes the row for the Node identified by its ID. |
- the Node to be removed must be isolated.
|
ST_MoveIsoNetNode |
ST_MoveIsoNetNode( net-name , node-id , point-geom )
Updates the geometry for the Node identified by its ID. |
- the Node to be moved must by isolated.
|
|
LINK
- A Link must have an unique integer ID.
- A Link must have a start Node and an end Node identified by their node-ids.
- In a Network of the Spatial type all Links must have a Curve geometry.
- In a Network of the Logical type all Links must have a NULL geometry.
|
ISO SQL functions on LINK only
|
ST_AddLink |
ST_AddLink( net-name , start-node-id , end-node-id, curve-geom)
Inserts a row into the <network>_LINK table, returning the generated unique ID. |
- start-node-id and end-node-id must reference existing Nodes.
- Only in the case of a Spatial Network: the first vertex of curve-geom must equal the geometry of start Node and the last vertex of curve-geom must equal the geometry of end Node.
|
ST_RemoveLink |
ST_RemoveLink( net-name , link-id )
Removes the row for the Link identified by its ID.
The start and end Nodes are not removed from the Network. |
|
ST_ChangeLinkGeom |
ST_ChangeLinkGeom( net-name , link-id , curve-geom )
Updates the geometry for the Link identified by its ID. |
- Only in the case of a Spatial Network: the first vertex of curve-geom must equal the geometry of start Node and the last vertex of curve-geom must equal the geometry of end Node.
|
ISO SQL functions on NODE and LINK
|
ST_NewGeoLinkSplit |
ST_NewGeoLinkSplit( net-name , link-id , point-geom )
Splits a Link by creating a new Node along an existing Link, deleting the original Link and replacing it with two new Links. Returns the generated unique Node ID.
Both new Links will have the same directions as the Link being split. |
- This function only applies to a Network of the Spatial type.
- link-id must identify an existing Link.
- point-geom must intersect the Link geometry.
|
ST_ModGeoLinkSplit |
ST_ModGeoLinkSplit( net-name , link-id , point-geom )
Splits a Link by creating a new Node along an existing Link, modifying the original Link and adding a new Link. Returns the generated unique Node ID.
Both the modified and the added Links will have the same directions as the Link being split. |
- This function only applies to a Network of the Spatial type.
- edge-id must identify an existing Link.
- point-geom must intersect the Link geometry.
|
ST_NewLogLinkSplit |
ST_NewLogLinkSplit( net-name , link-id )
Splits a Link by creating a new Node along an existing Link, deleting the original Link and replacing it with two new Links. Returns the generated unique Node ID.
Both new Links will have the same directions as the Link being split. |
- This function only applies to a Network of the Logical type.
- link-id must identify an existing Link.
|
ST_ModLogLinkSplit |
ST_ModLogLinkSplit( net-name , link-id )
Splits a Link by creating a new Node along an existing Link, modifying the original Link and adding a new Link. Returns the generated unique Node ID.
Both the modified and the added Links will have the same directions as the Link being split. |
- This function only applies to a Network of the Logical type.
- link-id must identify an existing Link.
|
ST_NewLinkHeal |
ST_NewLinkHeal( net-name , link-id1 , link-id2 )
Heals (merges) two Links by deleting the Node connecting them, deleting both Links and replacing them with a new Link whose direction is the same as the first Link provided. Returns the generated unique Link ID. |
- Both link-id1 and link-id2 must identify existing Links.
- The two Links must share a common Node.
- No additional Links must share the common Node, that is being deleted.
|
ST_ModLinkHeal |
ST_ModLinkHeal( net-name , link-id1 , link-id2 )
Heals two Links by deleting the Node connecting them, modifying the first Link provided, and deleting the second Link. |
- Both link-id1 and link-id2 must identify existing Links.
- The two Links must share a common Node.
- No additional Links must share the common Node.
|
|
miscellaneous ISO SQL functions
|
ST_InitTopoNet |
ST_InitTopoNet( net-name )
Creates a new Network and all related tables. |
This SQL function is required by ISO SQL/MM specifications, the usage of which is strongly discouraged in SpatiaLite.
CreateNetwork() represents a more flexible, complete, replacement.
|
ST_SpatNetFromGeom |
ST_SpatNetFromGeom( net-name , geom-collection )
Populates a full Network from the geometry values in a collection. |
This SQL function is required by ISO SQL/MM specifications, anyway its usage is strongly discouraged in SpatiaLite.
TopoNet_FromGeoTable() represents a more flexible, complete, replacement.
|
ST_SpatNetFromTGeo |
ST_SpatNetFromTGeo( net-name , topo-name )
Populates a full Spatial Network from a Topology-Geometry.
- A Topo-Net Node will be created for each Topo-Geo Node.
- A Topo-Net Link will be created for each Topo-Geo Edge.
- A Spatial Network will result, with Nodes and Links having geometry values obtained from their corresponding Topo-Geo primitives.
|
- This function only applies to an existing Network of the Spatial type.
- The Spatial Network must not contain any row.
- The Topology-Geometry must exist.
|
ST_LogiNetFromTGeo |
ST_LogiNetFromTGeo( net-name , topo-name )
Populates a full Logical Network from a Topology-Geometry.
- A Topo-Net Node will be created for each Topo-Geo Node.
- A Topo-Net Link will be created for each Topo-Geo Edge.
- A Logical Network will result, with Nodes and Links having geometry values set to the NULL value.
|
- This function only applies to an existing Network of the Logical type.
- The Logical Network must not contain any row.
- The Topology-Geometry must exist.
|
ST_ValidSpatialNetwork |
ST_ValidSpatialNetwork( net-name )
Returns a table containing possible spatial network inconsistencies.
The temporary table created and populated by this function will be named
TEMP.<network>_valid_spatialnet |
- This function only applies to an existing Network of the Spatial type.
|
ST_ValidLogicalNetwork |
ST_ValidLogicalNetwork( net-name )
Returns a table containing possible logical network inconsistencies.
The temporary table created and populated by this function will be named
TEMP.<network>_valid_logicalnet |
- This function only applies to an existing Network of the Logical type.
|