<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">G'day all,<div><br></div><div>I have some bad geometries (Self-intersections) that I need to fix:</div><div><br></div><div>when I run :</div><div><br></div><div><div><font class="Apple-style-span" face="'Courier New'">australia=# select gid, tailtag, area_name, st_astext(st_centroid(the_geom)) as centroid from tailtagarea where st_isValid(the_geom) is false order by st_centroid(the_geom);;</font></div><div><br></div><div> to make myself a nice list to work with I get :</div><div><br></div><div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 146.646 -41.1121</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 147.787 -42.288</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 115.999 -32.7807</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 136.002 -33.3412</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 151.385 -27.7379</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 142.163 -26.2079</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 151.385 -27.7379</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 142.163 -26.2079</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 115.999 -32.7807</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 130.528 -12.7086</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 115.556 -21.4113</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 113.653 -24.8917</font></div><div><font class="Apple-style-span" face="'Courier New'">NOTICE: Self-intersection at or near point 115.142 -30.6844</font></div><div><br></div><div><div>then :</div><br></div><div><br></div><div><br></div><div><font class="Apple-style-span" face="'Courier New'"> gid | tailtag | area_name | centroid </font></div><div><font class="Apple-style-span" face="'Courier New'">-----+---------+-----------------+-------------------------------------------</font></div><div><font class="Apple-style-span" face="'Courier New'"> 276 | WCN | Carnarvon | POINT(114.382000002796 -24.3219058101861)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 291 | WDN | Dandaragan | POINT(115.504407697781 -30.5410130360183)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 380 | WWA | Waroona | POINT(115.91620760142 -32.8588263644047)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 343 | WMY | Murray | POINT(115.966965752586 -32.6237045619179)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 362 | WRO | Roebourne | POINT(117.03170469097 -21.0526004441269)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 60 | TDG | Darwin And Gulf | POINT(133.897365573887 -14.2140172548334)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 247 | S71 | S71 | POINT(136.913166015303 -32.9332738397356)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 70 | QBC | Barcoo | POINT(142.269579925576 -25.1377197205728)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 170 | QQP | Quilpie | POINT(143.889867295296 -26.354593975264)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 498 | MLA | Latrobe | POINT(146.544098538635 -41.2417387155427)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 510 | MRS | Ross | POINT(147.556140609695 -42.1118612308958)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 147 | QMM | Millmerran | POINT(151.11832129932 -27.8551116855016)</font></div><div><font class="Apple-style-span" face="'Courier New'"> 169 | QPW | Pittsworth | POINT(151.538916320118 -27.7014266930915)</font></div><div><font class="Apple-style-span" face="'Courier New'">(13 rows)</font></div><br></div><div><br></div><div><br></div><div>It would be excellent if I could get the Notice to display in the query results, so I could print it out and work with it to quickly locate the problems (in QGIS)</div><div><br></div><div>... so can I do that? or am I best to just copy and paste the notices</div><div><br></div><div>Unfortunately as I write this "Safari could not open the page “<a href="http://postgis.refractions.net/documentation/">http://postgis.refractions.net/documentation/</a>” because the server is not responding."</div><div><br></div><div>cheers</div><div><br></div><div>Ben</div><div><br></div><div><br></div><br><div apple-content-edited="true"> <div><div>-- </div><div><br></div><div>Ben Madin</div><div>REMOTE INFORMATION</div><div><br></div><div>t : +61 8 9192 5455</div><div>f : +61 8 9192 5535</div><div>m : 0448 887 220</div><div>Broome WA 6725</div><div><br></div><div><a href="mailto:ben@remoteinformation.com.au">ben@remoteinformation.com.au</a></div><div><br></div><div><br></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Out here, it pays to know...</div></div><br> </div><br></div></body></html>