[postgis-users] query gist bbox

Ralf Suhr Ralf.Suhr at itc-halle.de
Fri Sep 24 01:35:38 PDT 2010


Hi Till,

you can use casting to get the bbox.

geom_column::box2d::geometry

Gr
Ralf

Am Freitag 24 September 2010 10:02:43 schrieb Till Kirchner:
>   Hello together,
> 
> I would like to visualize and query the bboxes used by a gist (rtree)
>  index.
> 
> I thought there should be an easy and fast way to get the maximum extend
> of geometries stored in a column by simply
> querying the corners of the bbox which covers all data used by the index.
> 
> Is there a function which allows to get information about bboxes used by
> a gist index?
> 
> Thanks in advance
> 
> Till
> 



More information about the postgis-users mailing list