<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><div><span>If you are exporting from ArcMap (and have a copy of the software) then run the Repair Geometry tool before export. This seems to fix most issues with non closed rings that surface in PostGIS and other tools.</span></div><div><span><br></span></div><div><span>Phil</span></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><div style="font-size: 12pt; font-family: arial, helvetica, sans-serif; "><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "><font size="2" face="Arial"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Ben Madin <lists@remoteinformation.com.au><br><b><span style="font-weight: bold;">To:</span></b> PostGIS Users Discussion <postgis-users@postgis.refractions.net><br><b><span
style="font-weight: bold;">Sent:</span></b> Thursday, 18 August 2011, 17:34<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] ERROR: geometry contains non-closed rings<br></font><br>G'day Puneet,<br><br>Maybe you could start with :<br><br>SELECT gid, st_isvalidreason(the_geom), st_summary(the_geom) FROM data WHERE st_isclosed(the_geom) is FALSE;<br><br>cheers<br><br>Ben<br><br>On 19/08/2011, at 12:19 AM, Mr. Puneet Kishor wrote:<br><br>> <br>> I loaded a bunch of data (that came from ArcMap) into PostGIS (1.5.3) via shp2pgsql and am trying to draw it with MapServer 6.0.1. I get<br>> <br>>> msDrawMap(): Image handling error. Failed to draw layer named 'foo'. <br>>> msPostGISLayerWhichShapes(): Query error. Error (ERROR: geometry contains non-closed rings ) <br>> <br>> <br>> Many thanks in advance for your suggestions.<br>> <br>> --<br>> Puneet Kishor<br>> <br>>
_______________________________________________<br>> postgis-users mailing list<br>> <a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br><br></div></div></blockquote></div></div></body></html>