[postgis-users] Selecting a Bounding Box for a whole table
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!
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