/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 vote171 views1 answer
Get current user debian
Shell/Bash
8 votes172 views1 answer
Docker remove all dead containers
Shell/Bash
0 vote182 views1 answer
How to check reportlab version
Shell/Bash
1 vote160 views1 answer
Ubuntu iptables open ssh output port
Shell/Bash
0 vote152 views1 answer
Usar comandos de linux en mi cmmd
Shell/Bash
1 vote164 views1 answer
Tsc: command not found on arch
Shell/Bash
0 vote124 views1 answer
Install snap on debian
Shell/Bash
65 votes155 views6 answers
React router
Shell/Bash
11 votes195 views3 answers
Macos install yarn
Shell/Bash
2 votes210 views1 answer
How to install npx
Shell/Bash