/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

3 votes191 views1 answer
Bash only print duplicated lines
Shell/Bash
9 votes206 views1 answer
How to get hostname on linux
Shell/Bash
0 vote198 views1 answer
How to compare percentage value in shell script
Shell/Bash
66 votes141 views6 answers
Create user linux
Shell/Bash
1 vote186 views1 answer
Macbook pro mac address
Shell/Bash
20 votes193 views5 answers
How to remove software from ubuntu
Shell/Bash
0 vote220 views1 answer
Arch linux turn on wifi
Shell/Bash
15 votes209 views1 answer
Git add new files to existing repository
Shell/Bash
0 vote190 views2 answers
Dropbox windows powershell remove directory sync
Shell/Bash
6 votes220 views3 answers
How to install java 11 jdk on ubuntu 20.04
Shell/Bash