<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7651.59">
<TITLE>[postgis-users] find single bbox of multiple objects</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText63042 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>What about
extent</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>SELECT extent(the_geom) from yourtable
where id IN(1,2,3)</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net on behalf of Richard
Greenwood<BR><B>Sent:</B> Sat 3/31/2007 2:05 PM<BR><B>To:</B> PostGIS Users
Discussion<BR><B>Subject:</B> [postgis-users] find single bbox of multiple
objects<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>I need to find the bounding box (minimum bounding rectangle) of
a<BR>group of objects. I am trying things like:<BR> select
box(the_geom) where id in (1, 2, 3);<BR>Which gives me 3 boxes. But I want a
single box representing the<BR>bounds of all three
objects.<BR><BR>Thanks,<BR>Rich<BR><BR>--<BR>Richard
Greenwood<BR>richard.greenwood@gmail.com<BR>www.greenwoodmap.com<BR>_______________________________________________<BR>postgis-users
mailing list<BR>postgis-users@postgis.refractions.net<BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></FONT></P></DIV>
</BODY>
</HTML>
<HTML><BODY><P><hr size=1></P><br>
<P><STRONG><br>
The substance of this message, including any attachments, may be<br>
confidential, legally privileged and/or exempt from disclosure<br>
pursuant to Massachusetts law. It is intended solely for the<br>
addressee. If you received this in error, please contact the sender<br>
and delete the material from any computer.<br>
</STRONG></P></BODY></HTML>