[postgis-users] box3d

[Jürgen Mischker]

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???




schabi at logix-tt.com wrote on 14.03.2006 18:15:41:
> Hi, Jürgen,
> 
> Jürgen Mischker wrote:
> 
>> BUT: 
>> ... 'BOX3D(90900 190900, 100100 200100)'::box3d...
>> doesn`t work:
>> ERROR: BOX3D parser - doesnt start with BOX3d(
> 
> Which PostGIS / PostgreSQL version are you using? I cannot reproduce it
> here:
> 
> navteq=# select 'BOX3D(90900 190900, 100100 200100)'::box3d;
>                  box3d
> ---------------------------------------
>  BOX3D(90900 190900 0,100100 200100 0)
> (1 row)
> 
> And grepping throug the current source, I cannot find the String "BOX3d"
> but I can see
> 
> ./lwgeom/lwgeom_box3d.c: elog(ERROR,"BOX3D parser - doesnt start with
> BOX3D(");
> 
> So I assume you've got a case sensitivity problem here.
> 
> 
> 
> Btw, why don't you use box2d:
> 
> navteq=# select 'BOX(90900 190900, 100100 200100)'::box2d;
>               box2d
> ---------------------------------
>  BOX(90900 190900,100100 200100)
> (1 row)
> 
> 
> 
> 
> HTH,
> Markus
> -- 
> Markus Schaber | Logical Tracking&Tracing International AG
> Dipl. Inf.     | Software Development GIS
> 
> Fight against software patents in EU! www.ffii.org 
> www.nosoftwarepatents.org 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net 
> http://postgis.refractions.net/mailman/listinfo/postgis-users