Spatial: WKT vs Static Geography Function Parameter Positioning Is Reversed
Published Apr 25 2022 07:14 AM 1,369 Views
Microsoft

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.

Co-Authors
Version history
Last update:
‎Apr 25 2022 07:14 AM
Updated by: