I need to select all points that is within 30 KM radius as a circle from a specific latitude/longitude using maria db.
For example:
latitude = 46.8167
longitude = 6.9333
Asked
Active
Viewed 602 times
2
Federico Alvarez
- 1,459
- 1
- 19
- 30
midhun k
- 1,032
- 1
- 15
- 41
-
1Possible duplicate of [Geo SQL to find points near location](http://stackoverflow.com/questions/29872384/geo-sql-to-find-points-near-location) – ivan_pozdeev Jun 13 '16 at 05:52
-
I am new to maria db . I found a lot of geometric relations like ST_DISTANCE,ST_WITHIN etc. Is it possible to do with this. – midhun k Jun 13 '16 at 05:59
-
1No. They use cartesian distance while you need distance on a sphere. – ivan_pozdeev Jun 13 '16 at 06:03
-
I need the distance in sphere. Sorry i didn't mention that in question. – midhun k Jun 13 '16 at 06:09