/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 vote328 views2 answers
Ubuntu software doesn't work 20.04
Shell/Bash
15 votes336 views2 answers
Install discord
Shell/Bash
8 votes327 views1 answer
Wsl list distros
Shell/Bash
19 votes342 views6 answers
How to uninstall a software in ubuntu
Shell/Bash
1 vote332 views1 answer
Convert biom to tsv
Shell/Bash
7 votes344 views2 answers
Untar
Shell/Bash
0 vote360 views1 answer
Wsl2 icmp_seq=165 Destination Host Unreachable after installing docker
Shell/Bash
28 votes326 views2 answers
See password wifi windows 10
Shell/Bash
28 votes364 views5 answers
Create user linux
Shell/Bash
0 vote380 views2 answers
Ubuntu commands
Shell/Bash