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.min...@gmail.com> wrote: > From: Ivan Mincik <ivan.min...@gmail.com> > Subject: Re: [postgis-users] newbie question about non closed rings > To: "PostGIS Users Discussion" <postgis-users@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@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
