CouchDB query multiple keys startkey endkey

Question

Hey Guys i'm trying to get a Point within a specific location from my CouchDB Database. I have absolutely no Idea how to build the query and the view.

In my Document, there is a value latitude and a value longitude.

I am building a quadratic bound latMin, longMin, latMax, longMax. The view should return all documents where:

latitude is between latMin and latMax

and

longitude is between longMin and longMax

Thank you in advance

Edit: For this Project i am forced to use IrisCouch where i'm not able to install an extension. I have to solve it with key, startkey and endkey.

Daniel Pinzon · Accepted Answer · 2015-07-17 01:00:57Z

2

You may use the extension "geocouch" which is specialized to do spatial queries.

answered Jul 17, 2015 at 1:00

Daniel Pinzon

363 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

FFirmenich Over a year ago

Thank you for this Answer. The Problem is: For this Project i am forced to use IrisCouch where i'm not able to install an extension.

Ingo Radatz Over a year ago

The extension geocouch is installed in iriscouch by default. The reason why it exists is - you can't design a couchdb index which lets you perform boundary requests as you want.

FFirmenich Over a year ago

Thank you guys. Didn't know that it is already included. This helped me out!

Collectives™ on Stack Overflow

CouchDB query multiple keys startkey endkey

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related