Ok,
so i got the rtree extension to work. It does load and creates the
tables wanted.
Now I am studying the ReadMe
(http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/rtree/READMEv=1.4)
and there is this requirement:
All r-tree virtual tables have an odd number of columns between
3 and
On Wed, Jun 04, 2008 at 06:03:45PM +0200, Christophe Leske scratched on the
wall:
Ok,
so i got the rtree extension to work. It does load and creates the
tables wanted.
Now I am studying the ReadMe
(http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/rtree/READMEv=1.4)
and there is
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
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
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
