<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=487064818-05102005>From
my testing in JUMP & JTS, it is the case that the table2 geometry (b) is
completely contained in the table1 geometry (a). I can see the same
thing as shown in the image, but that's correct - b is the blue geometry, and it
contains the red geometry (a).</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=487064818-05102005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=487064818-05102005>To me
it looks like PostGIS, JUMP and JTS are all saying the same thing, and it
matches the geometric situation.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=487064818-05102005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV> </DIV>
<DIV align=center><FONT face=Arial size=2><STRONG>Martin Davis, Senior Technical
Architect</STRONG><BR><STRONG><FONT color=#0000ff>Vivid Solutions
Inc.
<I>www.vividsolutions.com</I></FONT></STRONG><BR></FONT><EM><FONT face=Arial
size=2>Suite #1A-2328 Government Street Victoria, B.C. V8T 5G5<BR>Phone: (250)
385 6040 - Local 308 Fax: (250) 385 6046</FONT></EM></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Miguel de la Fuente<BR><B>Sent:</B> October 4, 2005 2:10 PM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
Problem with functions contains<BR><BR></FONT></DIV>
<DIV>strk: I' have the following problem, when I use the function
contains it returns true when the polygons is not totally contains.</DIV>
<DIV>I have applied snaptogrid in my geometry column.</DIV>
<DIV>I did the following :</DIV>
<DIV>update table1 set new_geom=snaptogrid(the_geom,1e-2)</DIV>
<DIV>update table2 set new_geom=snaptogrid(the_geom,1e-2))</DIV>
<DIV>When I use the function contains()</DIV>
<DIV> </DIV>
<DIV>select<BR>b.*<BR>from table2 b, table1
a<BR>where contains (b.new_geom,a.new_geom) </DIV>
<DIV>it returns true,but I see visually that b not contains completely
a.</DIV>
<DIV> </DIV>
<DIV>I don't understand why??</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>I attach the data and a image showing the problem.</DIV>
<DIV> </DIV>
<DIV>Thanks.</DIV></BLOCKQUOTE></BODY></HTML>