ValidateTopologyPrecision — Returns non-precise vertices in the topology.
geometry ValidateTopologyPrecision(name toponame, geometry bbox, float8 gridSize);
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.
Disponibilité : 3.6.0
SELECT ST_AsEWKT(g)
FROM topology.ValidateTopologyPrecision(
'city_data',
gridSize =
> 2,
bbox =
> ST_MakeEnvelope(0, 0, 20, 20)
) g;
MULTIPOINT(9 6,9 14)