[postgis-users] Selecting a Bounding Box for a whole table

Nicolas Ribot nicky666 at gmail.com
Thu Jul 7 07:35:12 PDT 2005

> Hi ,
> I was trying to select a bounding box for a whole theme, which then includes all features within a table. However I am not sure how to use the "SELECT (BOX(the_geom)) from myTheme; " - command for a whole table.
> Could somebody tell me a hint?!
> Thanks a lot!
> Tom

Hi Tom,
You can use the extent() table function for that:

select extent(the_geom) from myTheme;

It returns a box2d object: the spatial extension of the whole dataset
for your table.

More information about the postgis-users mailing list