On 6/3/08, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > On Jun 3, 2008, at 10:27 AM, Christophe Leske wrote: > > > > We have a city database that is being queried regurlarly depending on > > the lat/long position of the viewport in order to show city names and > > labels. > > > > SQLite has an optional R-Tree engine. The R-Tree is a new addition > and has not appeared in any release of SQLite, but it is available via > CVS. There is little documentation other than a README file in the > source directory. Nevertheless, an R-Tree is specifically designed to > solve the kind of query you describe above. If you are willing to > work on the bleeding edge, you might want to investigate SQLite's R- > Tree capabilities.
Richard, I am very interested in this. A few of us GIS-types have been tinkering with this (http://sqlitegis.org), but working off what you have been doing would likely be a lot better. > > > > D. Richard Hipp > [EMAIL PROTECTED] > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users