> 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? Sorry if i am abusing the help of this list - I like SQlite and have studied it for personal pleasure so far, but I am by all means no database expert. Greets, Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users