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

List:       postgis-users
Subject:    Re: [postgis-users] table bbox
From:       Paul Ramsey <pramsey () refractions ! net>
Date:       2006-02-22 19:10:00
Message-ID: 2613B6BA-829B-45C7-952E-5CDA77C7FF17 () refractions ! net
[Download RAW message or body]

SELECT Extent(<geomcolumn>) FROM <tablename>;

Note that this involves a scan of every record in the table, so it  
will not necessarily be fast.

p

On 22-Feb-06, at 10:27 AM, Gilbert, Antoine wrote:

> How I can find the BBOX of an entire table (i.e. 1 BBOX for all  
> geometries) using SQL.
>
> http://postgis.refractions.net/mailman/listinfo/postgis-users


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