[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