[postgis-users] Help: Ring not closed error when loading data via shp2pgsql

[Stephen Frost]

* Wood Brent (pcreso at pcreso.com) wrote:
> 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.
[...]
> Could the "7" help find the polygon? What does it refer to?

I *think* it might be the line number. :)  Certainly, that's probably
the first thing I'd check.

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

Well, binary search is one approach to take.  Only load half the file,
see if you get a problem or not, then load half the problem file, etc.

	Stephen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20040824/1929d986/attachment.pgp>