Hey Duane, On Sun, Jan 3, 2010 at 2:57 PM, Duane Almond Sto. Tomas <[email protected]> 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 <[email protected]> wrote: > >> On Sat, Jan 2, 2010 at 5:41 AM, Duane Almond Sto. Tomas >> <[email protected]> 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/ >
