Navigation :

ValidateTopology

ValidateTopology
Prev   11.3. Topology and TopoGeometry Management   Next

Name

ValidateTopology — Returns a set of validatetopology_returntype objects detailing issues with topology

Synopsis

setof validatetopology_returntype ValidateTopology ( varchar topology_schema_name ) ;

Description

Returns a set of validatetopology_returntype objects detailing issues with topology. List of possible errors and what the returned ids represent are displayed below:

Error id1 id2
edge crosses node edge_id node_id
invalid edge edge_id null
edge not simple edge_id null
edge crosses edge edge_id edge_id
edge start node geometry mis-match edge_id node_id
edge end node geometry mis-match edge_id node_id
face without edges face_id null
face has no rings face_id null
face overlaps face face_id face_id
face within face inner face_id outer face_id

Availability: 1.0.0

Enhanced: 2.0.0 more efficient edge crossing detection and fixes for false positives that were existent in prior versions.

Changed: 2.2.0 values for id1 and id2 were swapped for 'edge crosses node' to be consistent with error description.

Examples 

SELECT * FROM  topology.ValidateTopology('ma_topo');
      error        | id1 | id2
-------------------+-----+-----
face without edges |   0 |

See Also

validatetopology_returntype , Topology_Load_Tiger

Prev   Up   Next
TopologySummary  Home  CreateTopology