I need to find all R*Tree entries that overlap with a circle. I searched a lot but didn't find implementation especially on SQLite. I have already created table
CREATE VIRTUAL TABLE demo_index USING rtree(
id, -- Integer primary key
minX, maxX, -- Minimum and maximum X coordinate
minY, maxY -- Minimum and maximum Y coordinate
);
and inserted values in it. It should be called as
SELECT id FROM demo_index WHERE id MATCH circle(45.3, 22.9, 5.0)
Aucun commentaire:
Enregistrer un commentaire