[postgis-users] ERROR: pt_in_ring_2d

[Christo Du Preez]

Hi All,

I'm receiving the following error. Can someone please advise me on this.

ERROR:  pt_in_ring_2d: V[n] != V[0] (18.7 -33.4651 != 18.7 -33.4651)

the_geom is a MULTIPOLYGON

SELECT simplify(intersection(the_geom, geomfromtext('POLYGON((17.989674 
-34.214581, 17.989674 -33.214581, 18.989674 -33.214581, 18.989674 
-34.214581, 17.989674 -34.214581))', -1)), 
getmapstersimplification('cdsminlandwater'::text,'all'::text,4::int4))
FROM cdsminlandwater
WHERE the_geom && geomfromtext('POLYGON((17.989674 -34.214581, 17.989674 
-33.214581, 18.989674 -33.214581, 18.989674 -34.214581, 17.989674 
-34.214581))',-1)
AND distance(geomfromtext('POINT(18.489674 -33.714581)',-1),the_geom) < 
0.7071067811865476