<div dir="ltr"><div class="gmail_default" style="font-family:arial,sans-serif">Hi there,</div><div class="gmail_default" style="font-family:arial,sans-serif">I have a question on how to reproduce the QGIS "check Geometries" within PostGIS.</div><div class="gmail_default" style="font-family:arial,sans-serif">I'm working with multipolygons layers...</div><div class="gmail_default" style="font-family:arial,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,sans-serif">So far i got features with issues using for geometry validity check:</div><div class="gmail_default" style="font-family:arial,sans-serif"> - WHERE NOT ST_IsValid(geom)<br></div><div class="gmail_default" style="font-family:arial,sans-serif">and duplicated nodes with:</div><div class="gmail_default" style="font-family:arial,sans-serif">- WHERE NOT ST_Equals(ST_RemoveRepeatedPoints(geom), geom)</div><div class="gmail_default" style="font-family:arial,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,sans-serif">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.</div><div class="gmail_default" style="font-family:arial,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,sans-serif">How can I apply this tolerance level in PostGIS?</div><div class="gmail_default" style="font-family:arial,sans-serif">I looked at ST_QuantizeCoordinates() but it doesn't seems to me doing the right job...</div><div class="gmail_default" style="font-family:arial,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,sans-serif">Any hints or help is well appreciated...</div><div class="gmail_default" style="font-family:arial,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,sans-serif">Best,</div><div class="gmail_default" style="font-family:arial,sans-serif">Maxi</div><div><br></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><b style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12px">Massimiliano Cannata</b><br><p style="margin:0px;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span style="color:gray;font-size:9pt">Professore SUPSI in ingegneria Geomatica</span></p><p style="margin:0px;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span style="color:gray;font-size:9pt">Responsabile settore Geomatica</span></p><p style="margin:0px;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span style="color:gray;font-size:9pt"><br></span></p><p style="margin:0px;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span style="color:gray;font-size:9pt"><b>Istituto scienze della Terra</b></span></p><p style="margin:0px;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"></p><p style="margin:0px"><span lang="IT" style="font-size:9pt;color:gray">Dipartimento ambiente costruzione e design</span></p><p style="color:rgb(0,0,0);font-family:arial;font-size:small;margin:0px"><span lang="IT" style="font-size:12px"><font color="#808080" face="arial, sans-serif">Scuola universitaria professionale della Svizzera italiana</font></span></p><p style="margin:0px"><font color="#808080" face="arial, sans-serif"><span style="font-size:12px">Campus Mendrisio, </span></font><span style="color:rgb(128,128,128);font-family:arial,sans-serif;font-size:12px">Via Francesco Catenazzi 23</span></p><p style="margin:0px"><font color="#808080" face="arial, sans-serif"><span style="font-size:12px">CH – 6850 Mendrisio</span></font><br></p><p></p><p style="margin:0px;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span lang="IT" style="font-size:9pt;color:gray">Tel. +41 (0)58 666 62 14<u></u><u></u></span></p><p style="margin:0px;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span lang="EN-US" style="font-size:9pt;color:gray">Fax +41 (0)58 666 62 09<u></u><u></u></span></p><p style="margin:0px;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span lang="EN-US" style="font-size:9pt"><a href="mailto:massimiliano.cannata@supsi.ch" target="_blank">massimiliano.cannata@supsi.ch</a></span></p><p style="margin:0px;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><u><span lang="EN-US" style="font-size:9pt;color:blue"><span style="color:blue"><a href="http://www.supsi.ch/ist" target="_blank">www.supsi.ch/ist</a></span></span></u></p></div></div></div>