Navigation :

ValidateTopologyPrecision

ValidateTopologyPrecision
Prev   9.3. Topology and TopoGeometry Management   Next

Name

ValidateTopologyPrecision — Returns non-precise vertices in the topology.

Synopsis

geometry ValidateTopologyPrecision ( name toponame , geometry bbox , float8 gridSize ) ;

Description

Returns all vertices that are not rounded to the topology or given gridSize as a puntal geometry, optionally limiting the check to the area specified by the bbox parameter.

Availability: 3.6.0

Examples 

SELECT ST_AsEWKT(g) FROM
 topology.ValidateTopologyPrecision(
    'city_data',
    gridSize => 2,
    bbox => ST_MakeEnvelope(0,0,20,20)
) g;
      st_asewkt
----------------------
 MULTIPOINT(9 6,9 14)
(1 row)