[postgis-users] Problem with functions contains
Miguel de la Fuente
mjdelafuente at gmail.com
Thu Oct 6 10:58:17 PDT 2005
Martin: Thank you for your help, sorry I'm feeling a fool.You're right. The
geometry b is completely contained in geometry a, but it no touch the border
line of the geometry b in somewhere.
I did a difference and saw the problem.
Str, thank you too.
On 10/5/05, Martin Davis <mbdavis at vividsolutions.com> wrote:
> 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).
> To me it looks like PostGIS, JUMP and JTS are all saying the same thing,
> and it matches the geometric situation.
> *Martin Davis, Senior Technical Architect*
> *Vivid Solutions Inc. www.vividsolutions.com<http://www.vividsolutions.com/>
> *Suite #1A-2328 Government Street Victoria, B.C. V8T 5G5
> Phone: (250) 385 6040 - Local 308 Fax: (250) 385 6046*
> -----Original Message-----
> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *Miguel de la
> *Sent:* October 4, 2005 2:10 PM
> *To:* postgis-users at postgis.refractions.net
> *Subject:* [postgis-users] Problem with functions contains
> 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()
> 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.
> postgis-users mailing list
> postgis-users at postgis.refractions.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users