Spatial: WKT vs Static Geography Function Parameter Positioning Is Reversed

Published Apr 25 2022 07:14 AM 948 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:
We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE