I have a made a query which as far as I can tell, returns the data that it should. The issue I have is that it is telling me an incorrect distance.
This is the join part of the query:
sqrt( ( latitude_miles - 54.6665 )^2
+ ( longitude_mpd * (longitude - 5.66341 ))^2
) as distance
ORDER BY distance;
I can't see anything wrong there so, maybe my statement which inserted the values for latitude_miles and longitude_mpd was wrong?
latitude_miles = 69.1 * latitude,
longitude_mpd = 69.1 * COS(latitude * 3.14159265 / 180)
any pointers are welcome.