You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@couchdb.apache.org by "Duane Almond Sto. Tomas" <du...@gmail.com> on 2010/01/02 14:41:49 UTC
problem with two key ranges in couchdb
I'm having problem getting the right results in my coordinate system.
To explain my system, I have this simple database that have x_axis, y_axis
and name columns. I don't need to get all the data, I just need to display
some part of it.
For example, I have a coordinate system that have 10:10(meaning from x_axis
-10 to 10 and from y_axis -10 to 10) and I want to display only 49
coordinates. In sql query I can do it something like this:
"select * from coordinate where x_axis >= -3 and x_axis <= 3 and y_axis >=
-3 y_axis <= 3"
I tried this function but no success:
"by_range": {
"map": "function(doc) { emit([doc.x_axis, doc.y_axis], doc) }"
}
by_range?startkey=[-3,-3]&endkey=[3,3]
I got a wrong results of:
-3x-3
-3x-2
-3x-1
-3x0
-3x1
-3x2
-3x3
<-- should not display this part -->
-3x4
-3x5
-3x6
-3x7
-3x8
-3x9
-3x10
<-- end of should not display this part -->
..... up to 3x3
to give you a better understanding of my project here is the screenshot of
that I want to be made:
http://img96.imageshack.us/img96/5382/coordinates.jpg
--
I wanted a perfect ending.
Now I've learned, the hard way, that some poems don't rhyme, and some
stories don't have a clear beginning, middle, and end.
Life is about not knowing, having to change, taking the moment and making
the best of it, without knowing what's going to happen next......Farewell
Team !
Duane Almond C. Sto. Tomas
09062772487
OOiP Manila
personal websites:
http://duasto.freehostia.com/
http://duanealmond.com/
Re: problem with two key ranges in couchdb
Posted by Jan Lehnardt <ja...@apache.org>.
On 3 Jan 2010, at 14:57, Duane Almond Sto. Tomas wrote:
> Is there other way? because geocouch does not support PHP language and PHP
> will be the language of my project.
GeoCouch lives behind CouchDB. You can access it using PHP through CouchDB just fine.
Cheers
Jan
--
>
> On Sat, Jan 2, 2010 at 10:22 AM, Chris Anderson <jc...@apache.org> wrote:
>
>> On Sat, Jan 2, 2010 at 5:41 AM, Duane Almond Sto. Tomas
>> <du...@gmail.com> wrote:
>>> I'm having problem getting the right results in my coordinate system.
>>> To explain my system, I have this simple database that have x_axis,
>> y_axis
>>> and name columns. I don't need to get all the data, I just need to
>> display
>>> some part of it.
>>>
>>
>> The fundamental problem is that CouchDB indexes are 1-dimensional.
>> Essentially a sorted list. You can pull out every point between 2
>> lines of longitude. You can pull out every point between 2 lines of
>> latitude.
>>
>> But when you need points within a bounding box, you have to pull out
>> all of the above, and intersect them in your application. (There are
>> some optimizations you do, but fundamentally, this is the issue.)
>>
>> This general problem is addressed with geo indexers. You might want to
>> take a look at this one for Couch:
>>
>>
>> http://vmx.cx/cgi-bin/blog/index.cgi/geocouch-new-release-0.10.0:2009-09-19:en,CouchDB,Python,geo
>>
>> Chris
>>
>>
>>> For example, I have a coordinate system that have 10:10(meaning from
>> x_axis
>>> -10 to 10 and from y_axis -10 to 10) and I want to display only 49
>>> coordinates. In sql query I can do it something like this:
>>> "select * from coordinate where x_axis >= -3 and x_axis <= 3 and y_axis
>>> =
>>> -3 y_axis <= 3"
>>>
>>> I tried this function but no success:
>>>
>>> "by_range": {
>>> "map": "function(doc) { emit([doc.x_axis, doc.y_axis], doc) }"
>>> }
>>>
>>> by_range?startkey=[-3,-3]&endkey=[3,3]
>>>
>>> I got a wrong results of:
>>>
>>> -3x-3
>>> -3x-2
>>> -3x-1
>>> -3x0
>>> -3x1
>>> -3x2
>>> -3x3
>>> <-- should not display this part -->
>>> -3x4
>>> -3x5
>>> -3x6
>>> -3x7
>>> -3x8
>>> -3x9
>>> -3x10
>>> <-- end of should not display this part -->
>>> ..... up to 3x3
>>>
>>> to give you a better understanding of my project here is the screenshot
>> of
>>> that I want to be made:
>>> http://img96.imageshack.us/img96/5382/coordinates.jpg
>>>
>>> --
>>> I wanted a perfect ending.
>>> Now I've learned, the hard way, that some poems don't rhyme, and some
>>> stories don't have a clear beginning, middle, and end.
>>> Life is about not knowing, having to change, taking the moment and making
>>> the best of it, without knowing what's going to happen next......Farewell
>>> Team !
>>>
>>> Duane Almond C. Sto. Tomas
>>> 09062772487
>>> OOiP Manila
>>> personal websites:
>>> http://duasto.freehostia.com/
>>> http://duanealmond.com/
>>>
>>
>>
>>
>> --
>> Chris Anderson
>> http://jchrisa.net
>> http://couch.io
>>
>
>
>
> --
> I wanted a perfect ending.
> Now I've learned, the hard way, that some poems don't rhyme, and some
> stories don't have a clear beginning, middle, and end.
> Life is about not knowing, having to change, taking the moment and making
> the best of it, without knowing what's going to happen next......Farewell
> Team !
>
> Duane Almond C. Sto. Tomas
> 09062772487
> OOiP Manila
> personal websites:
> http://duasto.freehostia.com/
> http://duanealmond.com/
Re: problem with two key ranges in couchdb
Posted by till <kl...@gmail.com>.
Hey Duane,
On Sun, Jan 3, 2010 at 2:57 PM, Duane Almond Sto. Tomas
<du...@gmail.com> wrote:
> Is there other way? because geocouch does not support PHP language and PHP
> will be the language of my project.
There's a view server written in PHP, it's part of the Sopha (a
CouchDB access wrapper):
http://github.com/shevron/sopha
I haven't tried it yet, but it might give you something to play with/extend.
Till
>
> On Sat, Jan 2, 2010 at 10:22 AM, Chris Anderson <jc...@apache.org> wrote:
>
>> On Sat, Jan 2, 2010 at 5:41 AM, Duane Almond Sto. Tomas
>> <du...@gmail.com> wrote:
>> > I'm having problem getting the right results in my coordinate system.
>> > To explain my system, I have this simple database that have x_axis,
>> y_axis
>> > and name columns. I don't need to get all the data, I just need to
>> display
>> > some part of it.
>> >
>>
>> The fundamental problem is that CouchDB indexes are 1-dimensional.
>> Essentially a sorted list. You can pull out every point between 2
>> lines of longitude. You can pull out every point between 2 lines of
>> latitude.
>>
>> But when you need points within a bounding box, you have to pull out
>> all of the above, and intersect them in your application. (There are
>> some optimizations you do, but fundamentally, this is the issue.)
>>
>> This general problem is addressed with geo indexers. You might want to
>> take a look at this one for Couch:
>>
>>
>> http://vmx.cx/cgi-bin/blog/index.cgi/geocouch-new-release-0.10.0:2009-09-19:en,CouchDB,Python,geo
>>
>> Chris
>>
>>
>> > For example, I have a coordinate system that have 10:10(meaning from
>> x_axis
>> > -10 to 10 and from y_axis -10 to 10) and I want to display only 49
>> > coordinates. In sql query I can do it something like this:
>> > "select * from coordinate where x_axis >= -3 and x_axis <= 3 and y_axis
>> >=
>> > -3 y_axis <= 3"
>> >
>> > I tried this function but no success:
>> >
>> > "by_range": {
>> > "map": "function(doc) { emit([doc.x_axis, doc.y_axis], doc) }"
>> > }
>> >
>> > by_range?startkey=[-3,-3]&endkey=[3,3]
>> >
>> > I got a wrong results of:
>> >
>> > -3x-3
>> > -3x-2
>> > -3x-1
>> > -3x0
>> > -3x1
>> > -3x2
>> > -3x3
>> > <-- should not display this part -->
>> > -3x4
>> > -3x5
>> > -3x6
>> > -3x7
>> > -3x8
>> > -3x9
>> > -3x10
>> > <-- end of should not display this part -->
>> > ..... up to 3x3
>> >
>> > to give you a better understanding of my project here is the screenshot
>> of
>> > that I want to be made:
>> > http://img96.imageshack.us/img96/5382/coordinates.jpg
>> >
>> > --
>> > I wanted a perfect ending.
>> > Now I've learned, the hard way, that some poems don't rhyme, and some
>> > stories don't have a clear beginning, middle, and end.
>> > Life is about not knowing, having to change, taking the moment and making
>> > the best of it, without knowing what's going to happen next......Farewell
>> > Team !
>> >
>> > Duane Almond C. Sto. Tomas
>> > 09062772487
>> > OOiP Manila
>> > personal websites:
>> > http://duasto.freehostia.com/
>> > http://duanealmond.com/
>> >
>>
>>
>>
>> --
>> Chris Anderson
>> http://jchrisa.net
>> http://couch.io
>>
>
>
>
> --
> I wanted a perfect ending.
> Now I've learned, the hard way, that some poems don't rhyme, and some
> stories don't have a clear beginning, middle, and end.
> Life is about not knowing, having to change, taking the moment and making
> the best of it, without knowing what's going to happen next......Farewell
> Team !
>
> Duane Almond C. Sto. Tomas
> 09062772487
> OOiP Manila
> personal websites:
> http://duasto.freehostia.com/
> http://duanealmond.com/
>
Re: problem with two key ranges in couchdb
Posted by "Duane Almond Sto. Tomas" <du...@gmail.com>.
Is there other way? because geocouch does not support PHP language and PHP
will be the language of my project.
On Sat, Jan 2, 2010 at 10:22 AM, Chris Anderson <jc...@apache.org> wrote:
> On Sat, Jan 2, 2010 at 5:41 AM, Duane Almond Sto. Tomas
> <du...@gmail.com> wrote:
> > I'm having problem getting the right results in my coordinate system.
> > To explain my system, I have this simple database that have x_axis,
> y_axis
> > and name columns. I don't need to get all the data, I just need to
> display
> > some part of it.
> >
>
> The fundamental problem is that CouchDB indexes are 1-dimensional.
> Essentially a sorted list. You can pull out every point between 2
> lines of longitude. You can pull out every point between 2 lines of
> latitude.
>
> But when you need points within a bounding box, you have to pull out
> all of the above, and intersect them in your application. (There are
> some optimizations you do, but fundamentally, this is the issue.)
>
> This general problem is addressed with geo indexers. You might want to
> take a look at this one for Couch:
>
>
> http://vmx.cx/cgi-bin/blog/index.cgi/geocouch-new-release-0.10.0:2009-09-19:en,CouchDB,Python,geo
>
> Chris
>
>
> > For example, I have a coordinate system that have 10:10(meaning from
> x_axis
> > -10 to 10 and from y_axis -10 to 10) and I want to display only 49
> > coordinates. In sql query I can do it something like this:
> > "select * from coordinate where x_axis >= -3 and x_axis <= 3 and y_axis
> >=
> > -3 y_axis <= 3"
> >
> > I tried this function but no success:
> >
> > "by_range": {
> > "map": "function(doc) { emit([doc.x_axis, doc.y_axis], doc) }"
> > }
> >
> > by_range?startkey=[-3,-3]&endkey=[3,3]
> >
> > I got a wrong results of:
> >
> > -3x-3
> > -3x-2
> > -3x-1
> > -3x0
> > -3x1
> > -3x2
> > -3x3
> > <-- should not display this part -->
> > -3x4
> > -3x5
> > -3x6
> > -3x7
> > -3x8
> > -3x9
> > -3x10
> > <-- end of should not display this part -->
> > ..... up to 3x3
> >
> > to give you a better understanding of my project here is the screenshot
> of
> > that I want to be made:
> > http://img96.imageshack.us/img96/5382/coordinates.jpg
> >
> > --
> > I wanted a perfect ending.
> > Now I've learned, the hard way, that some poems don't rhyme, and some
> > stories don't have a clear beginning, middle, and end.
> > Life is about not knowing, having to change, taking the moment and making
> > the best of it, without knowing what's going to happen next......Farewell
> > Team !
> >
> > Duane Almond C. Sto. Tomas
> > 09062772487
> > OOiP Manila
> > personal websites:
> > http://duasto.freehostia.com/
> > http://duanealmond.com/
> >
>
>
>
> --
> Chris Anderson
> http://jchrisa.net
> http://couch.io
>
--
I wanted a perfect ending.
Now I've learned, the hard way, that some poems don't rhyme, and some
stories don't have a clear beginning, middle, and end.
Life is about not knowing, having to change, taking the moment and making
the best of it, without knowing what's going to happen next......Farewell
Team !
Duane Almond C. Sto. Tomas
09062772487
OOiP Manila
personal websites:
http://duasto.freehostia.com/
http://duanealmond.com/
Re: problem with two key ranges in couchdb
Posted by Chris Anderson <jc...@apache.org>.
On Sat, Jan 2, 2010 at 5:41 AM, Duane Almond Sto. Tomas
<du...@gmail.com> wrote:
> I'm having problem getting the right results in my coordinate system.
> To explain my system, I have this simple database that have x_axis, y_axis
> and name columns. I don't need to get all the data, I just need to display
> some part of it.
>
The fundamental problem is that CouchDB indexes are 1-dimensional.
Essentially a sorted list. You can pull out every point between 2
lines of longitude. You can pull out every point between 2 lines of
latitude.
But when you need points within a bounding box, you have to pull out
all of the above, and intersect them in your application. (There are
some optimizations you do, but fundamentally, this is the issue.)
This general problem is addressed with geo indexers. You might want to
take a look at this one for Couch:
http://vmx.cx/cgi-bin/blog/index.cgi/geocouch-new-release-0.10.0:2009-09-19:en,CouchDB,Python,geo
Chris
> For example, I have a coordinate system that have 10:10(meaning from x_axis
> -10 to 10 and from y_axis -10 to 10) and I want to display only 49
> coordinates. In sql query I can do it something like this:
> "select * from coordinate where x_axis >= -3 and x_axis <= 3 and y_axis >=
> -3 y_axis <= 3"
>
> I tried this function but no success:
>
> "by_range": {
> "map": "function(doc) { emit([doc.x_axis, doc.y_axis], doc) }"
> }
>
> by_range?startkey=[-3,-3]&endkey=[3,3]
>
> I got a wrong results of:
>
> -3x-3
> -3x-2
> -3x-1
> -3x0
> -3x1
> -3x2
> -3x3
> <-- should not display this part -->
> -3x4
> -3x5
> -3x6
> -3x7
> -3x8
> -3x9
> -3x10
> <-- end of should not display this part -->
> ..... up to 3x3
>
> to give you a better understanding of my project here is the screenshot of
> that I want to be made:
> http://img96.imageshack.us/img96/5382/coordinates.jpg
>
> --
> I wanted a perfect ending.
> Now I've learned, the hard way, that some poems don't rhyme, and some
> stories don't have a clear beginning, middle, and end.
> Life is about not knowing, having to change, taking the moment and making
> the best of it, without knowing what's going to happen next......Farewell
> Team !
>
> Duane Almond C. Sto. Tomas
> 09062772487
> OOiP Manila
> personal websites:
> http://duasto.freehostia.com/
> http://duanealmond.com/
>
--
Chris Anderson
http://jchrisa.net
http://couch.io