/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

10 votes218 views2 answers
Angular cli interface generate
Shell/Bash
0 vote189 views1 answer
Get serial number for server using powreshell
Shell/Bash
16 votes207 views2 answers
Nvm install lts
Shell/Bash
7 votes193 views2 answers
Get directory of a file linux
Shell/Bash
14 votes247 views5 answers
Git revert merge commit
Shell/Bash
13 votes198 views2 answers
Amend commit change description
Shell/Bash
6 votes208 views2 answers
Adb for ubuntu
Shell/Bash
2 votes246 views1 answer
Search by commit message
Shell/Bash
0 vote263 views1 answer
Ubuntu permission all file in folder
Shell/Bash
0 vote224 views1 answer
Pup command example
Shell/Bash