On Mon, Mar 05, 2012 at 12:29:08PM +0100, Alessandro Candini wrote:
> Hi list.
>
> I have a db with 50000 geometries inside.
>
> I would like to search if some features are present ONLY inside a
> given bounding box.
>
> How can I achieve this?
SELECT * FROM yourdbtable
WHERE ST_Contains(
ST_MakeEnvelope(...),
geom
);
--strk;
,------o-.
| __/ | Delivering high quality PostGIS 2.0 !
| / 2.0 | http://strk.keybit.net - http://vizzuality.com
`-o------'
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
