Distance Between Lat-Long Points
SQL code to find the distance between two lat-long points on a globe.
Additional information can be found here:
Calculating Distance Between Data Centers on a Globe
Calculating Distance Between Data Centers on a Globe
2 * 3960 * asin(sqrt((sin(radians(([latitude_2] - [latitude_1]) / 2)))
^ 2 + cos(radians([latitude_1])) * cos(radians([latitude_2]))
* (sin(radians(([longitude_2] - [longitude_1]) / 2)))^ 2))For area, see our blog post:
Geographic Analysis in SQL: Measuring Polygon Area from Latitude and Longitude
Geographic Analysis in SQL: Measuring Polygon Area from Latitude and Longitude
Updated 03-02-2023
