GPS radius calculation

Question

I have these coordinates:

lat: 45.815005 lon: 15.978501

and I have a mysql table with lat and lon coordinates stored as float

What do I need to get the entire coordinate 500 meters around me?

So the main problem is to add X-meters to the coordinate location

Also: how can I separate the coordinate 45.815005 (45 | 81 | 50 | 05 ???), so I can store them in mysql using indexes for faster searches?

+3

mgalesic Mar 22 '11 at 11:31

1 answer

Pascal MARTIN · Answer 1 · 2011-03-22T11:34:41+0000

MySQL supports spatial extension (citation):

MySQL supports spatial extensions to enable the generation, storage, and analysis of geographic features.

- , .