[postgis] Query a zone

[Jose Moran]

Eugenio:
Si buscas recuperar una zona encerrada por una "caja" puedes tratar con:
select * from my_table where my_geo_field && 'BOX3D(x y,x+Dx y+Dy)'::box3d

example:
select * from streets where geo_street && 'BOX3D(275800 8668900,275900
8669000)'::box3d

Saludos
Jose

----- Original Message -----
From: "waldonion" <waldonion at yahoo.com>
To: <postgis at yahoogroups.com>
Sent: Tuesday, January 29, 2002 1:12 PM
Subject: [postgis] Query a zone


> Hie..
> I have to query a zone insert a box like
> ((x,y),(x+10,y), etc.. etc...))
>
> But I read a lot but I cant saw a sentence like
>
> Select the_geom from xxx
>
> where the_geom Intersects (polygon((x,y),(x+10,y)....etc)
>
>
> how can I do that?
>
> Thanks a lot
>
> Pd: Sorry for my english
>
>
> Ahora en castellano
> Hola:
> La verdad es que quiero consultar a este gran grupo, como puedo hacer
> para recuperar una zona determinada de una tabla espacial...
> P.E: Quiero recuperar una "caja" o box de una base de datos espacial
>
> Revise que en Oracle ocupan una sentencia llamada window o algo
>
> ¿Como se puede hacer esto??
> Select the_geom from xxx
>
> where the_geom Intersects (polygon((x,y),(x+10,y)....etc)
>
> Gracias de antemano
> Eugenio
>
>
>
> To unsubscribe from this group, send an email to:
> postgis-unsubscribe at yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Sponsored by VeriSign - The Value of Trust
Pinpoint the right security solution for your company - FREE
Guide from industry leader VeriSign gives you all the facts.
http://us.click.yahoo.com/pCuuSA/WdiDAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/