[postgis-users] newbie question about non closed rings

[Ivan Mincik]

On Wednesday 15 April 2009, G. van Es wrote:
> 
> Hi All,
> 
> I am a bit new to this so excuse me if this is a foolish question.
> 
> Can anyone tell me what is wrong with the following geometry?
> 
> '0106000000010000000103000000010000000700000024213D12AA7BFD40945FF42576511941676A32F9017BFD40B1D67BEA7E511941C3E3C640DB7DFD4026CE38F4EE531941C91289C5AA7EFD40017B8518E3531941646F1599AB7DFD409627F1F0AE521941355EBA49547CFD407B14AEC74652194123213D12AA7BFD40945FF42576511941'
Hi, You need to use ST_AsText(the_geom) function to display geometry in human readable form.

> 
> I have a shapefile converted with shp2pgsql. Some records will not insert due to the ERROR: geometry contains non-closed rings. The shapefile itself is viewable without problems.
Shapefiles can contain invalid geometries and they can be displayed by many applications without any problems. I guess, in Your case, You have some polygons which does not finish in exactly same point, they started. - They are not closed.

What kind of software are You using _

Ivan 
> 
> Thanks,
> Ge
> 
> 
> 
>       
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>