GiST and SP-GiST operator classes are defined so the bounding-box operators of the previous section can be used with corresponding indexes.
GiST operator class for temporal H3 cells. Indexes an stbox spatiotemporal bounding box per row (the geodetic extent of the cell boundaries together with the time period).
CREATE INDEX ON trips USING gist(cells); -- uses th3_rtree_ops by default CREATE INDEX ON trips USING gist(cells th3_rtree_ops);
SP-GiST operator classes for temporal H3 cells, keyed on the stbox spatiotemporal bounding box. th3_quadtree_ops is the default (quadtree partitioning); th3_kdtree_ops uses k-d tree partitioning and must be named explicitly.
CREATE INDEX ON trips USING spgist(cells); -- uses th3_quadtree_ops by default CREATE INDEX ON trips USING spgist(cells th3_kdtree_ops);