dimanche 24 avril 2016

SQLite: find all R*Tree entries that overlap with a circle with radius

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