[postgis-users] ERROR: pt_in_ring_2d: V[n] != V[0]

Stephen Woodbridge woodbri at swoodbridge.com
Thu Dec 8 08:42:35 PST 2011


Hi all,

I'm getting this error:

select gid from parcels where not isvalid(the_geom);
ERROR:  pt_in_ring_2d: V[n] != V[0] (-83.5001 38.244 != -83.5001 38.244)

********** Error **********

ERROR: pt_in_ring_2d: V[n] != V[0] (-83.5001 38.244 != -83.5001 38.244)
SQL state: XX000

select gid, st_isvalidreason(the_geom) from parcels where not 
isvalid(the_geom);
NOTICE:  IllegalArgumentException: Invalid number of points in 
LinearRing found 3 - must be 0 or >= 4
NOTICE:  IllegalArgumentException: Invalid number of points in 
LinearRing found 3 - must be 0 or >= 4
ERROR:  POSTGIS2GEOS conversion failed

********** Error **********

ERROR: POSTGIS2GEOS conversion failed
SQL state: XX000

"POSTGIS="1.5.1" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August 
2008" LIBXML="2.6.32" USE_STATS"

This just seems very bad in that isvalid() and st_isvalidreason() should 
never fail, IMO.

-Steve



More information about the postgis-users mailing list