On Wed, Jun 04, 2008 at 06:18:22PM +0200, Christophe Leske scratched on the wall: > > > The "R" in "R-Tree" is for rectangle. The structure is designed to > > hold spaces, not points. You want to do something like: > > > > ... rtree(id, long-min, long-max, lat-min, lat-max) > > > > For cities where you only have point locations, enter each lat and > > long twice. > > Well, my database holds only cities for the time being! Does it make > sense to use rtree then?
Sure. Points should be no problem, you just need to express them as zero-width rectangles. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users