Monday, April 25, 2022

Spatial: WKT vs Static Geography Function Parameter Positioning Is Reversed

Be careful, this one caused me problems the other day. The WKT (Well-Known Text) format does not match with the geography static function parameter positioning.  Reference: Point (geography Data Type) - SQL Server | Microsoft Docs

 

select geography::Point(10 /*Lat*/, 91 /*Long*/, 4626).ToString()
POINT (91 10)

Note that the static function accepts Lat, Long and the WKT format is reversed, accepting Long, Lat.

Posted at https://sl.advdat.com/3vdfwhShttps://sl.advdat.com/3vdfwhS