[postgis-users] ERROR: geometry contains non-closed rings

[Ben Madin]

G'day Puneet,

Maybe you could start with :

SELECT gid, st_isvalidreason(the_geom), st_summary(the_geom) FROM data WHERE st_isclosed(the_geom) is FALSE;

cheers

Ben

On 19/08/2011, at 12:19 AM, Mr. Puneet Kishor wrote:

> 
> 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
> 
>> msDrawMap(): Image handling error. Failed to draw layer named 'foo'. 
>> msPostGISLayerWhichShapes(): Query error. Error (ERROR: geometry contains non-closed rings ) 
> 
> 
> Many thanks in advance for your suggestions.
> 
> --
> Puneet Kishor
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users