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. Table below lists possible errors and what the id1 and id2 mean in each case

Error	id1	id2
edge crosses node	node_id	edge_id # NOTE: should this be swapped?
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.

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