/Shell/Bash/How to calculate nearest location using longitude and latitude

How to calculate nearest location using longitude and latitude

SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance < 25 ORDER BY distance LIMIT 0 , 20;

Source: stackoverflow.com

Similar codes

1 vote128 views1 answer
Run conda commands on linux
Shell/Bash
3 votes119 views3 answers
How to compress pdf in linux
Shell/Bash
1 vote140 views1 answer
Install rancher
Shell/Bash
1 vote126 views1 answer
Unable to start ssh-agent service, error :1058
Shell/Bash
0 vote113 views1 answer
Get my most used command from history
Shell/Bash
28 votes125 views3 answers
Install package on specific version of python
Shell/Bash
1 vote123 views2 answers
Copy first 100 lines from a file linux
Shell/Bash
0 vote137 views1 answer
Android logs for app on terminal
Shell/Bash
8 votes108 views2 answers
How to install pod
Shell/Bash
1 vote73 views2 answers
How to copy directory to a ssh server
Shell/Bash