[postgis-users] st_within maddness

Kevin Galligan kg at kagii.com
Fri Jul 24 07:50:02 PDT 2009


Flip the order of arguments to contains, as in the bbox comes after?
I tried that.  No results.

On Fri, Jul 24, 2009 at 10:48 AM, Paul Ramsey<pramsey at cleverelephant.ca> wrote:
> If you flip the order of arguments and use st_contains() instead, does
> that work? I vaguely remember a bug in the bounds-check short-circuit
> of within that was fixed a while ago...
>
> P.
>
> On Fri, Jul 24, 2009 at 7:46 AM, Kevin Galligan<kg at kagii.com> wrote:
>> Might I ask where you get the definition of srid '900913'?  I know I
>> had to insert that myself from something I found on the web.  I'm
>> shooting in the dark here, but that's another possible variable in the
>> mix.
>>
>> On Fri, Jul 24, 2009 at 10:18 AM, Maxime van Noppen<maxime at altribe.org> wrote:
>>> On 07/24/09 15:49, Kevin Galligan wrote:
>>>> I'm sure there's something simple I'm missing here, but we've hit the
>>>> "pull hair out" stage, so I'm hoping there's a kind soul out there
>>>> that can clear things up.
>>>
>>> I've ran the example you give that you give as example and get results :
>>>
>>>> # select asewkt(bbox) from testwithin where st_within(bbox, ST_Buffer(ST_SetSRID(ST_MakePoint(-8232000, 4980000),900913), 500));
>>>>                                                    asewkt
>>>> -------------------------------------------------------------------------------------------------------------
>>>>  SRID=900913;POLYGON((-8232000 4980000,-8232000 4980100,-8231900 4980100,-8231900 4980000,-8232000 4980000))
>>>
>>> No idea what the problem can be though :-/
>>>
>>> --
>>> yabo
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>>
>>
>> --
>> --------------------
>> Kevin Galligan
>> www.kagii.com
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
--------------------
Kevin Galligan
www.kagii.com



More information about the postgis-users mailing list