SQL Server Video
13 page views
1928 video views
2024, November 03, Sunday

#035 Calculate distance between two geographic points in SQL Server

how to use SQL Server geolocation technology to enter routes and calculate the distance between two geographic points

We will know the techniques:
How to capture the points of latitude and longitude using a free web tool (POLYLINE TOOL); Link: 🔹
https://www.keene.edu/campus/maps/tool
🔹Create table with column of the geographic data type (CREATE TABLE, GEOGRAPHY);
🔹Insert geographic line in the record (INSERT, STGeomFromText, LINESTRING);
🔹Calculate the distance in kilometers between two geographical points (STDistance);