| Topology and TopoGeometry Management |
|---|
AddTopoGeometryColumn
Adds a topogeometry column to an existing table, registers this new column as a layer in topology.layer and returns the new layer_id.- topology_name, schema_name, table_name, column_name, feature_type
- topology_name, schema_name, table_name, column_name, feature_type, child_layer
|
| DropTopology
(topology_schema_name)
Use with caution: Drops a topology schema and deletes its reference from topology.topology table and references to tables in that schema from the geometry_columns table.
|
| DropTopoGeometryColumn
(schema_name, table_name, column_name)
Drops the topogeometry column from the table named table_name in schema schema_name and unregisters the columns from topology.layer table.
|
| TopologySummary
(topology_schema_name)
Takes a topology name and provides summary totals of types of objects in topology
|
| ValidateTopology
(topology_schema_name)
Returns a set of validatetopology_returntype objects detailing issues with topology
|
| Topology Constructors |
|---|
CreateTopology
Creates a new topology schema and registers this new schema in the topology.topology table.- topology_schema_name
- topology_schema_name, srid
- topology_schema_name, srid, tolerance
- topology_schema_name, srid, tolerance, hasz
|
| CopyTopology
(existing_topology_name, new_name)
Makes a copy of a topology structure (nodes, edges, faces, layers and TopoGeometries).
|
| ST_InitTopoGeomm
(topology_schema_name)
Creates a new topology schema and registers this new schema in the topology.topology table and details summary of process.
|
| ST_CreateTopoGeomm
(atopology, acollection)
Adds a collection of geometries to a given empty topology and returns a message detailing success.
|
| TopoGeo_AddPoint
(toponame, apoint, tolerance)
Adds a point to an existing topology using a tolerance and possibly splitting an existing edge.
|
| TopoGeo_AddLineString
(toponame, aline, tolerance)
Adds a linestring to an existing topology using a tolerance and possibly splitting existing edges/faces. Returns edge identifiers
|
| TopoGeo_AddPolygon
(atopology, apoly, atolerance)
Adds a polygon to an existing topology using a tolerance and possibly splitting existing edges/faces.
|
| Topology Editors |
|---|
| ST_AddIsoNodemm
(atopology, aface, apoint)
Adds an isolated node to a face in a topology and returns the nodeid of the new node. If face is null, the node is still created.
|
| ST_AddIsoEdgemm
(atopology, anode, anothernode, alinestring)
Adds an isolated edge defined by geometry alinestring to a topology connecting two existing isolated nodes anode and anothernode and returns the edge id of the new edge.
|
| ST_AddEdgeNewFacesmm
(atopology, anode, anothernode, acurve)
Add a new edge and, if in doing so it splits a face, delete the original face and replace it with two new faces.
|
| ST_AddEdgeModFacemm
(atopology, anode, anothernode, acurve)
Add a new edge and, if in doing so it splits a face, modify the original face and add a new face.
|
| ST_RemEdgeNewFacemm
(atopology, anedge)
Removes an edge and, if the removed edge separated two faces,
delete the original faces and replace them with a new face.
|
| ST_RemEdgeModFacemm
(atopology, anedge)
Removes an edge and, if the removed edge separated two faces,
delete one of the them and modify the other to take the space of both.
|
| ST_ChangeEdgeGeommm
(atopology, anedge, acurve)
Changes the shape of an edge without affecting the topology structure.
|
| ST_ModEdgeSplitmm
(atopology, anedge, apoint)
Split an edge by creating a new node along an existing edge, modifying the original edge and adding a new edge.
|
| ST_ModEdgeHealmm
(atopology, anedge, anotheredge)
Heal two edges by deleting the node connecting them, modifying the first edge
and deleting the second edge. Returns the id of the deleted node.
|
| ST_NewEdgeHealmm
(atopology, anedge, anotheredge)
Heal two edges by deleting the node connecting them, deleting both edges,
and replacing them with an edge whose direction is the same as the first
edge provided.
|
| ST_MoveIsoNodemm
(atopology, anedge, apoint)
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.
|
| ST_NewEdgesSplitmm
(atopology, anedge, apoint)
Split an edge by creating a new node along an existing edge, deleting the original edge and replacing it with two new edges. Returns the id of the new node created that joins the new edges.
|
| ST_RemoveIsoNodemm
(atopology, anode)
Removes an isolated node and returns description of action. If the node is not isolated (is start or end of an edge), then an exception is thrown.
|
| Topology Accessors |
|---|
| GetEdgeByPoint
(atopology, apoint, tol)
Find the edge-id of an edge that intersects a given point
|
| GetFaceByPoint
(atopology, apoint, tol)
Find the face-id of a face that intersects a given point
|
| GetNodeByPoint
(atopology, point, tol)
Find the id of a node at a point location
|
| GetTopologyID
(toponame)
Returns the id of a topology in the topology.topology table given the name of the topology.
|
| GetTopologySRID
(toponame)
Returns the SRID of a topology in the topology.topology table given the name of the topology.
|
| GetTopologyName
(topology_id)
Returns the name of a topology (schema) given the id of the topology.
|
| ST_GetFaceEdgesmm
(atopology, aface)
Returns a set of ordered edges that bound aface includes the sequence order.
|
| ST_GetFaceGeometrymm
(atopology, aface)
Returns the polygon in the given topology with the specified face id.
|
| GetRingEdges
(atopology, aring, max_edges=null)
Returns an ordered set of edges forming a ring with the given edge .
|
| GetNodeEdges
(atopology, anode)
Returns an ordered set of edges incident to the given node.
|
| Topology Processing |
|---|
| Polygonize
(toponame)
Find and register all faces defined by topology edges
|
| AddNode
(toponame, apoint, allowEdgeSplitting=false, computeContainingFace=false)
Adds a point node to the node table in the specified topology schema and returns the nodeid of new node. If point already exists as node, the existing nodeid is returned.
|
| AddEdge
(toponame, aline)
Adds a linestring edge to the edge table and associated start and end points to the point nodes table of the specified topology schema using the specified linestring geometry and returns the edgeid of the new (or existing) edge.
|
| AddFace
(toponame, apolygon, force_new=false)
Registers a face primitive to a topology and get it's identifier.
|
| TopoGeometry Constructors |
|---|
CreateTopoGeom
Creates a new topo geometry object from topo element array - tg_type: 1:[multi]point, 2:[multi]line, 3:[multi]poly, 4:collection- toponame, tg_type, layer_id, tg_objs
- toponame, tg_type, layer_id
|
toTopoGeom2
Converts a simple Geometry into a topo geometry
- geom, toponame, layer_id, tolerance
- geom, topogeom, tolerance
|
| TopoElementArray_Agg
(tefield)
Returns a topoelementarray for a set of element_id, type arrays (topoelements)
|
| TopoGeometry Outputs |
|---|
AsGML
Returns the GML representation of a topogeometry.- tg
- tg, nsprefix_in
- tg, visitedTable
- tg, visitedTable, nsprefix
- tg, nsprefix_in, precision, options
- tg, nsprefix_in, precision, options, visitedTable
- tg, nsprefix_in, precision, options, visitedTable, idprefix
- tg, nsprefix_in, precision, options, visitedTable, idprefix, gmlversion
|
.