I have database structure having values of longitude and latitude as shown in image.
Problem is, I want to Query for 'keys' that is in range of 5km. what I can do is read all the data and calculate the distance between these geopoints and mine geopoints, and select distance below 5km. But it will cost me lot of transactions and its not optimized way to do it.
I know geoquery is there, but I could not use Pagination there(not mentioned in docs). Anyone please help me out to find a way to query database or structure database, so could do locate key within 5 km.