GeoNames Forum

First i want to say a BIG Thank you for your work. It's fantastic and I realize that what you provide was build in many many hours of hard work.

I have one question related to reverse geocoding - near by place.
I intend to use your data (downloaded into mysql) against some GPS records to display a polyline with a route.
I'm interested in how do you manage to get nearest location to some lat/long data. Ofcourse if you can tell.
My main programing language is PHP.
I readed in another post that you compare lat and long with country borders but in the downloaded file for my country i see nothing like this.

Hope this helps you

Code:

 SELECT *, 
 	truncate((degrees(acos(sin(radians(latitude)) * sin( radians(" . $locale['latitude'] . ")) 
 	+ cos(radians(latitude)) * cos( radians(" . $locale['latitude'] . ")) 
 	* cos( radians(longitude - " . $locale['longitude'] . ") ) ) ) 
 	* 69.09),1) as distance_miles,
 
 	DEGREES(
 	     ACOS(
       		(
 	       	SIN(RADIANS(" . $locale['latitude'] . "))
        		*
        		SIN(RADIANS(latitude))
       		)
      		+
       		(
        		COS(RADIANS(" . $locale['latitude'] . "))
        		*
        		COS(RADIANS(latitude))
        		*
        		COS(RADIANS(" . $locale['longitude'] . " - longitude))
       		)
      		)
      		*
      		60	 * 1.1515 * 1.61
 	) AS distance_km 
 	
 	FROM locations 
 	ORDER BY `distance` ASC LIMIT 10

Yes, your code really helps me. Thank you. A lot