I would like to store an r-tree or quadtree index in a sqlite database using python.
Does anyone know if there is any code to do this?
A bit of background:
- The dataset cannot be moved to another format.
- the dataset in question is a shapefile
- Though there is spatial indexing for shapefiles, it's not meeting the needs
- I want to avoid using spatialite extension (it's messy to install on windows)
I can create a quadtree/rtree in-memory, but since the dataset is very large, the index takes a longtime to build. In addition, it consumes a large about of memory and effects other analysis down stream. If I could store the index in sqlite it would help get past that issue I think.