coordinates – IT Nursery

Find nearest latitude/longitude with an SQL query

May 31, 2022 by IT Nursery

I have latitude and longitude and I want to pull the record from the database, which has nearest latitude and longitude by the distance, if that distance gets longer than specified one, then don’t retrieve it. Table structure: id latitude longitude place name city country state zip sealevel 18 Answers 18

Function to calculate distance between two coordinates

May 25, 2022 by IT Nursery

I’m currently using the function below and it doesn’t work properly. According to Google Maps, the distance between these coordinates (from 59.3293371,13.4877472 to 59.3225525,13.4619422) are 2.2 kilometres while the function returns 1.6 kilometres. How can I make this function return the correct distance? function getDistanceFromLatLonInKm(lat1, lon1, lat2, lon2) { var R = 6371; // Radius … Read more