/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

-4 votes209 views1 answer
Kubernetes cluster unreachable: Get "https://192.168.56.10:6443/version?timeout=32s": net/http: TLS handshake timeout
Shell/Bash
23 votes187 views4 answers
Remove a non empty directory
Shell/Bash
1 vote249 views1 answer
How to add ca to linux
Shell/Bash
0 vote193 views1 answer
How to install intellij on manjaro
Shell/Bash
2 votes199 views1 answer
Ssh with private key terminal
Shell/Bash
0 vote217 views1 answer
Linux batch display number of lines
Shell/Bash
1 vote198 views1 answer
Install ext-dom linux
Shell/Bash
0 vote204 views2 answers
Remove pyqt5 with conda
Shell/Bash
47 votes187 views4 answers
Yarn download ubuntu
Shell/Bash
0 vote190 views1 answer
Install android sdk via terminal
Shell/Bash