Re: WGS84 Data & distance queries

[sud pan]

I am using this query to calculate nearest street from a given lat/long (-37.8954, 145.0616). I have lat/ lon of streets stored in colunm lat and lon. The distance is resulted in Kilometer. I have more that 330,000 records in table and the performace is quite good,less than a second.

SELECT street, (acos(sin(radians(-37.8954)) * sin(radians(Lat))
+ cos(radians(-37.8954)) * cos(radians(Lat)) * cos(radians(145.0616 -
Lon))
))*6371 as dist FROM roads order by dist asc limit 5