GiST indexes

Ganos supports native 2D Generalized Search Tree (GiST) spatial indexes for GeomGrid and H3Grid geographic grid objects.

-- Create a table with a GeomGrid column.
CREATE TABLE geomgrid_gist_test (
    id serial,
    code geomgrid
);

-- Insert sample records.
INSERT INTO geomgrid_gist_test(code) VALUES('0102000F58182C0E'::GeomGrid);
INSERT INTO geomgrid_gist_test(code) VALUES('0102000F58182C0D'::GeomGrid);
INSERT INTO geomgrid_gist_test(code) VALUES('0102000F59163522'::GeomGrid);
INSERT INTO geomgrid_gist_test(code) VALUES('0102000F59163622'::GeomGrid);
INSERT INTO geomgrid_gist_test(code) VALUES('0102000F59163B22'::GeomGrid);

-- Create a GiST 2D spatial index on the code column.
CREATE INDEX geomgrid_gist_test_idx on geomgrid_gist_test using gist (code);

-- Create a table with an H3Grid column.
CREATE TABLE h3grid_gist_test (
    id serial,
    code h3grid
);

-- Insert sample records.
INSERT INTO h3grid_gist_test(code) VALUES('010100FFFF846CD932AB08'::H3Grid);
INSERT INTO h3grid_gist_test(code) VALUES('010100FF7F366127CEA308'::H3Grid);
INSERT INTO h3grid_gist_test(code) VALUES('010100FF7F466C3B8EAA08'::H3Grid);
INSERT INTO h3grid_gist_test(code) VALUES('010100FFFF0C134D87A308'::H3Grid);
INSERT INTO h3grid_gist_test(code) VALUES('010100FF7FD95460EFA108'::H3Grid);

-- Create a GiST 2D spatial index on the code column.
CREATE INDEX h3grid_gist_test_idx on h3grid_gist_test using gist (code);