[postgis-users] box3d

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Jürgen Mischker
> Sent: 15 March 2006 07:31
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] box3d
> 
> Today I turned t back to my box3d problem: the odd thing is that I do not
> recive the error message again. (maybe I should check with my admin).
> Sorry keeping you busy...
> 
> The only strange thing is that I tried another query (workaround) , which
> should do the same thing, but with different results:
> 
> select count(*) from laserjosef
> WHERE the_geom && GeomFromText('POLYGON((-589213 -1149204, -589213 -
> 1149104, -589113 -1149104, -589113 -1149204, -589213 -1149204))',-1)
> AND distance(the_geom, GeomFromText('POINT(-589163 -1149154)',-1)) < 50;
> 
> Result: 18773 rows
> 
> select count(*) from laserjosef
> WHERE the_geom && 'BOX3D(-589213 -1149204, -589113 -1149104)'::box3d
> AND distance(the_geom, GeomFromText('POINT(-589163 -1149154)',-1)) < 50;
> 
> Result: 45157 rows
> 
> Did i missed something???


Hi Jürgen,

The result does seem unusual - can you confirm which version of
PostGIS/PostgreSQL you are using (SELECT version() and SELECT
postgis_full_version()) and also provide a reproducible test case as a .sql
file?


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk   
http://www.infomapper.com
http://www.swtc.co.uk  

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.