[postgis-users] why is this poly invalid?

Rob Agar robagar at westnet.com.au
Sat Oct 20 02:20:43 PDT 2007


hi all

Several polygons in our DB are being flagged as invalid by ST_IsValid, 
but I don't really understand why.  Here's one of them as WKT:

"SRID=4326;POLYGON((144.196 -14.2479,144.196 -14.2607,143.736483333333 
-14.2991166666667,143.7384 -14.2987333333333,143.911533333333 
-14.4488166666667,144.037866666667 -14.4488166666667,144.037866666667 
-14.32515,144.119833333333 -14.3589833333333,144.196 -14.2479))"

The documentaion of ST_IsValid could be a little more helpful:

"ST_isvalid(geometry)

     returns true if this geometry is valid."

The poly is self intersecting, but ST_IsSimple returns true - that can't 
be right can it?


(btw in case anyones curious, this one's the boundary of the Princess 
Charlotte Bay coastal area Great Barrier Reef Habitat Protection Zone)

cheers
Rob