I am developing an android application, and in my database of dadaos are registered specific points using geo location, as the scope of the application is global, in some time it will become unviable to load so much information of the cell phone, I would only load the geolocation interval, For example, just load the range of the city where the user is, how could this be done? I thought about doing a WHERE with the location range, but I do not think that's possible.
Has anyone ever had a similar situation that could share the solution?