Go back

RTree Spatial Indexes Extension

This extension adds a new capability for spatially indexing geometry columns. This extension uses the rtree implementation provided by the SQLite R*Tree Module extension.


Add a row to this table for each geometry type to be indexed.

Column Value
table_name table containing geometry to index
column_name column containing geometry to index
extension_name gpkg_rtree_index
scope write-only

Virtual Tables and Triggers

The spatial index is established by creating a virtual table and a set of triggers. These are detailed in Appendix F.3.