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:
> >
> > >
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
> 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
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/README=1.4)
> and
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/README=1.4)
and there is this requirement:
All r-tree virtual tables have an odd number of columns between
3 and
5 matches
Mail list logo