You can read a very good overview of R-Trees at Wikipedia. http://en.wikipedia.org/wiki/R-tree which includes some coordinate based examples.
On 6/4/08, Jay A. Kreibich <[EMAIL PROTECTED]> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
