[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    AW: [postgis-users] overall bbox from some polygons
From:       "Samson, Marko" <Marko.Samson () wald-und-holz ! nrw ! de>
Date:       2007-04-26 7:22:43
Message-ID: 48D45C62B4C8234795CB86F840F7DFCD5B0DCD () zeex01 ! forst ! local
[Download RAW message or body]

That's it! Thx!

> -----Ursprüngliche Nachricht-----
> Von: postgis-users-bounces@postgis.refractions.net 
> [mailto:postgis-users-bounces@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@postgis.refractions.net
> [mailto:postgis-users-bounces@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@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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]