Calculating gps coordinate radius

Question

I have this coordinates:

lat: 45.815005 lon: 15.978501

and i have mysql table with lat and lon coordinates stored as float

what i need is to get all coordinate in 500 meters around me?

so basicly my problem is to add X meters to my coordinate location

Also: how can i separate coordinate 45.815005 (45 | 81 | 50 | 05 ???) so i can store them in mysql using indexes for quicker search?

Please see this question and answers: [Queries to find places within a given lat/lng](http://stackoverflow.com/questions/5135488/queries-to-find-places-within-a-given-lat-lng) — Czechnology, Mar 22 '11 at 11:33

score 0 · Answer 1 · answered Mar 22 '11 at 11:34

0

MySQL supports a spatial extension (quoting) :

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

Using those, instead of storing coordinates your own way, might help, when it comes to geographical manipulations.

answered Mar 22 '11 at 11:34

Pascal MARTIN

i have try spatial extension but is really slow with large amount od data. I would like to use indexed separated coordinates. – Gale Mar 22 '11 at 11:42

1 Answers1