[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    RE: [postgis-users] Help: Ring not closed error when loading data
From:       "Ethan Alpert" <ealpert () digitalglobe ! com>
Date:       2004-08-24 13:31:54
Message-ID: 1FB6937A87F9074C9A2B8F9D9137EB16147A52 () COMAIL01 ! digitalglobe ! com
[Download RAW message or body]


I have written a perl script that uses Geo::Shapelib that adds the duplicate point I \
can send you. You'll need to install Geo::Shapelib from cpan.org. If the shapefile \
doesn't have many features then it's probably easier to do it by hand.  
-e

________________________________

From: postgis-users-bounces@postgis.refractions.net on behalf of Wood Brent
Sent: Mon 8/23/2004 11:30 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Help: Ring not closed error when loading data viashp2pgsql





I have a shapefile to load into PostGIS.

When I run the SQL created with shp2pgsql, I get the following message,
psql:ross020107.sql:7: ERROR:  polygon has ring where first point != last point
followed by errors until the failed commit statement.

The polygons contain several rings & several thousand vertices, and I have
potentially a few hundred shapefiles to load.

Is there any way to give a more verbose error message to help identify the
erroneous Ring so I can edit in the closing coordinate pair.

Could the "7" help find the polygon? What does it refer to?

Any suggestions as to how I can get closer to identifying the offending
polygon/ring appreciated.



Thanks,

   Brent Wood
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


["winmail.dat" (application/ms-tnef)]

[prev in list] [next in list] [prev in thread] [next in thread]