Re: [postgis-users] query gist bbox
Till Kirchner wrote: 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 Hi Till, Take a look at the gevel module here: http://www.sai.msu.su/~megera/postgres/gist/. I did have a very basic prototype which I posted to the -users list a few years ago, but it needs some work as the visibility of the bounding boxes (i.e. whether they belong to geometry that has been deleted or not) is held in the heap and not the index. Unfortunately I don't have the URL to hand at the moment. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] query gist bbox
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 > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] query gist bbox
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 -- Johann Heinrich von Thünen-Institut Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei - Institut für Waldökologie und Waldinventuren Eberswalde - Alfred-Möller-Straße 1 16225 Eberswalde Deutschland Telefon/Mailbox: +49 (0)3334 65-331 E-Mail: till.kirch...@vti.bund.de http://www.vti.bund.de ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
