[postgis-users] Mapserver extent question
David Niergarth
dn at hddesign.com
Tue Sep 20 13:17:44 PDT 2005
Hello,
I have an extent from mapserver (e.g., "-121.682485 38.408966
-121.231440 38.763359") that I want to feed back into a PostGIS query.
How do I express this extent in my query?
I want to write a query something like
select recid from tbl_points
where the_geom && <what goes here?> ;
A related question... What's a BOX (see following query):
select extent(the_geom) from tbl_points ;
extent
----------------------------------------------------------------------------
BOX(-124.278755187988 32.5427703857422,-73.5306396484375 46.1519355773926)
(1 row)
It doesn't appear to be a WKT format. Is there a way to use BOX like you
would with other WKT formats?
Thanks for any suggestions.
--David
More information about the postgis-users
mailing list