[postgis-users] Calculate maximum bounding extent of selected features

[Jennifer Shanks]

Thanks Paul,

That was just what I was looking for.  My zoom to selection is now working.

I appreciate the help.

Regards,
Jennifer

At 12:42 PM 2/14/2006, you wrote:

>On 14-Feb-06, at 11:48 AM, Jennifer Shanks wrote:
>>
>>Does anyone know how I can get the bounding coordinates?  Would I
>>use an SQL statement?
>
>SELECT Extent(the_geom) FROM <yourtable> WHERE <your selection clause>;
>
>That will give you a polygon to parse.  Skip the parsing with:
>
>SELECT MinX(env), MinY(env), MaxX(env), MaxY(env)
>FROM
>(SELECT Extent(the_geom) AS env FROM <yourtable> WHERE <your
>selection clause>) AS sub;
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>

****************************
Jennifer Shanks
GreenInfo Network
116 New Montgomery, Suite 738
San Francisco, CA 94105
(415) 979-0343 x 306
(415) 979-0371 FAX
**GreenInfo has completely re-done our web site
Go to: www.greeninfo.org