[postgis-users] newbie question about non closed rings

[G. van Es]

The shapefile is created with software from Bentley.
PostgreSQL is version 8.3.4 on Ubuntu
PostGis is version 1.3

I also see a difference between conversion as WKB and WKT (-w option). If I use shp2pgsql with the -w option there are far less records that fail.

So can this be an issue with rounding up numbers? In WKT I see a tiny difference between some start and end points on failing records.

And if so, is there a possibility to ignore those tiny differences?

Thanks again,
Ge



--- On Wed, 4/15/09, Ivan Mincik <ivan.mincik at gmail.com> wrote:

> From: Ivan Mincik <ivan.mincik at gmail.com>
> Subject: Re: [postgis-users] newbie question about non closed rings
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Date: Wednesday, April 15, 2009, 12:40 AM
>  
> 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
> > 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>