How can I make a geo location query in CBL?

[Mert_Celik]

I am using CBL for Android. I have the latitude and longitude values that the user saved earlier. And there are also values for the location the user has marked on the map.

I need to make a query on the database using the location information the user has selected on the map. So if the records in the database are located near the location the user chose, I want to show this.

How can I do that. I have no idea how to query this in CBL. I would be very glad if you could help. Thanks in advance.

[priya.rajagopal]

We do not support geo spatial queries out of the box but here is a post that may help you get going

Geospatial queries for Couchbase Lite? (Xamarin Forms .Net Standard App)

I agree, it seems like a natural feature for mobile apps… It’s possible to do bounding-box queries without specialized indexes; for example (pseudocode) loc.x BETWEEN $x0 AND $X1 AND loc.y BETWEEN $y0 AND $y1. With regular indexes on loc.x and loc.y (as opposed to R-trees) this isn’t very efficient, but it’s workable as long as your data set isn’t too large.