Find Nearest Place By Using My SQL Record Of LATITUDE And LONGITUDE

Question

I have a mySql table named tbl_places This contains fields Place_id, PlaceName, Place_LATITUDE, place_LONGITUDE.

I want to use it in the place detail page now If the current place_id of the open page is 4 then I want a maximum 6 records nearest to that place.

Suppose the current place is:

 place_id = 4
 place_name = Lal Killa
 place_LATITUDE = 77.2413969039917
 place_LONGITUDE = 28.653838307772872

I can't understand how to find nearest place to the current place??

Does this answer your question? [Find nearest latitude/longitude with an SQL query](https://stackoverflow.com/questions/2234204/find-nearest-latitude-longitude-with-an-sql-query) — Vega, Jan 06 '23 at 23:58

score 1 · Accepted Answer · edited Nov 22 '19 at 15:04

1

Use below query:

SELECT
    Place_id,
    PlaceName,
    (
        3959 
        * acos(
            cos( radians(37) ) 
            * cos( radians( Place_LATITUDE ) ) 
            * cos( radians( Place_LONGITUDE ) - radians(-122) ) 
            + sin( radians(37) ) 
            * sin( radians( Place_LATITUDE ) ) 
        ) 
    ) AS distance 
FROM tbl_places 
HAVING distance < 25 
ORDER BY distance 
LIMIT 0 , 20;

NOTE - Here latitude = 37 & longitude = -122

Also, check here for more reference.

edited Nov 22 '19 at 15:04

AymDev

6,626
4
29
52

answered Apr 12 '16 at 14:07

Jainil

1,488
1
21
26

What is the Meaning of "distance < 25" – Amranur Rahman Jan 04 '19 at 10:37
25 is the distance in miles. This will find the closest 20 locations that are within a radius of 25 miles to the 37, -122 coordinate. – Jainil Jan 05 '19 at 10:11
To search by kilometers instead of miles, replace 3959 with 6371. 25 will be in kilometer then – Faizan Anwer Ali Rupani Dec 18 '19 at 16:59

score 0 · Answer 2 · answered Apr 12 '16 at 14:11

You can use a Cohen–Sutherland (point clipping) algorithm to know the people near by, if you want to minimize the result,set it as a incremental order from 0 to YOUR_LIMIT.

it is better than a formula that convert a polar co-ordinates[(ie)lat and long] to XY

Find Nearest Place By Using My SQL Record Of LATITUDE And LONGITUDE

2 Answers2