[postgis-users] St_within problem
Bob Pawley
rjpawley at shaw.ca
Mon Oct 19 09:41:08 PDT 2009
Funny this does work when I include st_box2d as in -
st_within( graphics.point_grid.the_geom,
st_box2d(library.dgm_process.the_geom))
However, this will include points within the box yet outside of the actual
geometry.
Bob
----- Original Message -----
From: "Maxime van Noppen" <maxime at altribe.org>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Monday, October 19, 2009 9:16 AM
Subject: Re: [postgis-users] St_within problem
> Bob Pawley wrote:
>> I have tried it with the point and geometry reversed with the same
>> result.
>>
>> Perhaps, I am not looking at this the right way.
>>
>> According to the manual
>>
>> st_within Returns TRUE if geometry A (points) is completely inside
>> geometry B ( geometry).
>>
>> If it scans the list of 858 points some of those points are within the
>> geometry - unless Postgis is looking at the 858 points as one entity.
>
> Ooops, sorry, indeed you were right and used the function the right way.
> :)
>
> Could you provide an example of a geometry & some points you're using ?
>
> You might also try ST_Intersects or ST_Covers.
>
> --
> Maxime
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list