AW: [postgis-users] overall bbox from some polygons

[Samson, Marko]

That's it! Thx!

> -----Ursprüngliche Nachricht-----
> Von: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] Im 
> Auftrag von Obe, Regina
> Gesendet: Mittwoch, 25. April 2007 16:55
> An: PostGIS Users Discussion
> Betreff: RE: [postgis-users] overall bbox from some polygons
> 
> Select extent(the_geom) from polygontable where oid in(....)
> 
> If your geometry is 3 dimensional, I think you need to use extent3d.
> 
> Depending on how you are using this - to convert to a polygon 
> with an SRID, you may need to do
> 
> SELECT setsrid(extent(the_geom), <srid of your table goes 
> here>) from polygontable where oid in(....)
> 
>  
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Samson, Marko
> Sent: Wednesday, April 25, 2007 10:34 AM
> To: PostGIS Users Discussion
> Subject: [postgis-users] overall bbox from some polygons
> 
> Hi,
> 
> I want to get an overall-bbox of some polygons with a select 
> statement.
> With "select envelope(the_geom)from polygontable where oid in 
> (.....)" I just get the separate geoms of every single 
> polygon. Now I'm looking for a solution to get the bbox of 
> all these polygons.
> Is there a function or other elegant way to get the 'overall envelope'
> of some polygons, or do I have to create a little sorting 
> function into my phpscript
> 
> Bye,
> Marko
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> -----------------------------------------
> The substance of this message, including any attachments, may 
> be confidential, legally privileged and/or exempt from 
> disclosure pursuant to Massachusetts law. It is intended 
> solely for the addressee. If you received this in error, 
> please contact the sender and delete the material from any computer.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>