SQLite Forum

Visualizing r-tree structure
Login
Hi,
I'd like to visualize the structure of an R-TREE index, in terms of index nodes and their bounding box, from the root and down the leaves.

The structure of the database seems to be relatively straightforward, but wanted 
to confirm before delving into it:

* The `<rtree>_node` contains the node ids
* The `<rtree>_parent` contains the node parent/child relationships
* The `<rtree>_rowid` associates each indexed row id to a node

I'm guessing the `data` column in the `<rtree>_node` table contains, among other things, the bbox of the node itself. Any suggestion on how to read it?

Or, if there is there a better way to dump the tree structure, I'm all ears.


By the way, thanks for the previous answers on the topic, have been pretty useful!


Best regards
Andrea