[OSGeo-Discuss] Geometry check QGIS vs PostGIS

[Massimiliano Cannata]

Hi there,
I have a question on how to reproduce the QGIS "check Geometries" within
PostGIS.
I'm working with multipolygons layers...

So far i got features with issues using for geometry validity check:
 - WHERE NOT ST_IsValid(geom)
and duplicated nodes with:
- WHERE NOT ST_Equals(ST_RemoveRepeatedPoints(geom), geom)

In QGIS there's the possibility to set a tolerance value that I have to
respect in my check and is set to 1E-3.

How can I apply this tolerance level in PostGIS?
I looked at ST_QuantizeCoordinates() but it doesn't seems to me doing the
right job...

Any hints or help is well appreciated...

Best,
Maxi

-- 
*Massimiliano Cannata*

Professore SUPSI in ingegneria Geomatica

Responsabile settore Geomatica


*Istituto scienze della Terra*

Dipartimento ambiente costruzione e design

Scuola universitaria professionale della Svizzera italiana

Campus Mendrisio, Via Francesco Catenazzi 23

CH – 6850 Mendrisio

Tel. +41 (0)58 666 62 14

Fax +41 (0)58 666 62 09

massimiliano.cannata at supsi.ch

*www.supsi.ch/ist <http://www.supsi.ch/ist>*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/discuss/attachments/20210213/f26b66ef/attachment.html>