Distance and bearings between GPS coordinates in SQL
Another post from my sql abominations series. I’m running this on MySQL 5 particularly. Assume you have a table of locations with Latitude and Longitude for each one. In my case the table is “station”, primary key being “LocID”. With help from this article, first we create a view to get 3D coordinates (6378 =
[...read the post]
mrclay.
rg
song for a future generation
