Android Question GoogleMapsExtras Circle radius find all location in there from SqlLite

[yfleury]

Hi all
It's easy to make a circle (radius of 25 km) on google map.
But I need to find how all location inside this circle from database (over 10000 rows)

 

[BillMeyer]

Geofence - Monitoring a region in the background

Geofencing is an Android feature that allows your app to be notified when the user enters or exits a monitored region. The nice thing about this feature is that your app doesn't need to run for monitoring to work. It will be started automatically when needed. The GeofenceService uses...

www.b4x.com

This might help.

 

[janderkan]

I read your question like you want to get the locations from your DB that is within a circle defined on a map.
This makes it a SQL question and my first search gave me this answer.
https://stackoverflow.com/questions/2234204/find-nearest-latitude-longitude-with-an-sql-query

 

[yfleury]

Geofence - Monitoring a region in the background

Geofencing is an Android feature that allows your app to be notified when the user enters or exits a monitored region. The nice thing about this feature is that your app doesn't need to run for monitoring to work. It will be started automatically when needed. The GeofenceService uses...

www.b4x.com

This might help.

For a location, I need to find in DB all rows in radius of 25km from location. (background is useless)

I read your question like you want to get the locations from your DB that is within a circle defined on a map.
This makes it a SQL question and my first search gave me this answer.
https://stackoverflow.com/questions/2234204/find-nearest-latitude-longitude-with-an-sql-query

Sqlite don't have SQRT function. Nor Acos

 

[klaus]

You may have a look at this GPS - get nearest coordinates from SQLite database.