I’m almost positive this snippet is returning the distance in meters, but I wanted to confirm.
DECLARE @StationCoords_Lon DECIMAL(12, 9) = -80.230679;
DECLARE @StationCoords_Lat DECIMAL(12, 9) = 25.789954;
DECLARE @MyCoords_Lon DECIMAL(12, 9) = -80.230600;
DECLARE @MyCoords_Lat DECIMAL(12, 9) =25.789951;
DECLARE @orig geography = geography::Point(@StationCoords_Lat, @StationCoords_Lon, 4326);
SELECT
@orig.STDistance(geography::Point(@MyCoords_Lat, @MyCoords_Lon, 4326))
AS distance
Are there approximately 7.93 meters between these two points?