[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Operator precision
From:       Paul Ramsey <pramsey () opengeo ! org>
Date:       2009-02-25 15:04:22
Message-ID: 30fe546d0902250704g2f9162b1l17928338d00816fe () mail ! gmail ! com
[Download RAW message or body]

No, very large numbers do get indexed, they just don't get indexed
quite so precisely.

P.

On Wed, Feb 25, 2009 at 2:43 AM, Kemal Bayram <kemal@cins.co.uk> wrote:
> Thanks, that solved the problem but I'm guessing that very large numbers do
> not get indexed properly but then again if we're working with long/latitute
> ranges normally I guess it's not really a concern.
>
>> Add an "AND" clause that tests containment of the point
>> against a rectangular polygon. Or that does explict
>> ST_X(point) ST_Y(point) against your box. There's no way to
>> change the box2d behavior, and it's a feature, not a bug
>> (small boxes work better for large data sets, and spatial
>> index results are expected to be over-determined).
>>
>> P.
>>
>> On Mon, Feb 23, 2009 at 3:58 PM, Kemal Bayram
>> <kemal@cins.co.uk> wrote:
>> > Hello all,
>> >
>> > I'm a using PostGIS working with mainly points testing against 2d
>> > bounded boxes, I recently came across a problem that is
>> driving me nuts whereby:
>> >
>> > select makebox2d(makepoint(32.25, 34.9375),
>> makepoint(32.31249, 35))
>> > && makepoint(32.3125, 34.996448);
>> >
>> > returns false (as expected), where as:
>> >
>> >
>> > select makebox2d(makepoint(32.25, 34.9375),
>> makepoint(32.312499, 35))
>> > && makepoint(32.3125, 34.996448);
>> >
>> > returns true.
>> >
>> > 32.312499 cast as float4 is 32.3125, so I'm assuming that
>> internally
>> > single precision is being used. Is there any way change
>> this behaviour?
>> >
>> > Regards
>> > Kemal
>> > _______________________________________________
>> > postgis-users mailing list
>> > postgis-users@postgis.refractions.net
>> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >
>> >
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users@postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]