[postgis-users] Problem with functions contains

Miguel de la Fuente mjdelafuente at gmail.com
Tue Oct 4 14:09:57 PDT 2005


strk: I' have the following problem, when I use the function contains it
returns true when the polygons is not totally contains.
I have applied snaptogrid in my geometry column.
I did the following :
update table1 set new_geom=snaptogrid(the_geom,1e-2)
update table2 set new_geom=snaptogrid(the_geom,1e-2))
When I use the function contains()
 select
b.*
from table2 b, table1 a
where contains (b.new_geom,a.new_geom)
it returns true,but I see visually that b not contains completely a.
 I don't understand why??
  I attach the data and a image showing the problem.
 Thanks.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20051004/0ef917d8/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tabla1.backup
Type: application/octet-stream
Size: 9256 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20051004/0ef917d8/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tabla2.backup
Type: application/octet-stream
Size: 42180 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20051004/0ef917d8/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: img.JPG
Type: image/jpeg
Size: 56402 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20051004/0ef917d8/attachment.jpe>


More information about the postgis-users mailing list