[postgis-users] ST_Contains(a.coordinates::::geometry, b.coordinates::::geometry)

[Sandro Santilli]

On Fri, Aug 12, 2011 at 03:27:30PM +0400, Antonio Rodriges wrote:
> Sandro,
> 
> when I use ST_MakePolygon
> I get error
> ERROR: lwpoly_from_lwlines: shell must be closed
> Does this mean that my polygons are not closed?

Your _lines_ are not closed, looks like.

> I am sure I have closed polygons: the start point is equal to end point
> 
> I verified my assumption with
> select a.id, ST_AsText(a.coordinates)
> from contours a
> where a.time = '2002-12-31 16:00:00'

Which means you verified with your eyes ?
Try ST_IsClosed().

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html