Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

SQL Server 2008 queries return X and Y inverted (X is Lat, should be Lon, and Y is Lon, should be Lat)

Description

None

Environment

None

Attachments

2

Activity

Show:

Ricardo Stuven October 10, 2010 at 11:11 AM

There is no problem with Geometry because the inversion of coordinates only affects Geography.

See http://blogs.msdn.com/b/isaac/archive/2008/03/05/the-upcoming-geography-coordinate-order-swap-a-faq.aspx

David Pfeffer October 10, 2010 at 8:07 AM

This is only fixed for Geography – the problem persists for Geometry.

Ricardo Stuven October 6, 2010 at 10:01 AM

Fixed in revision 1350.

David Pfeffer September 2, 2010 at 4:48 PM

Whoops, I uploaded the wrong version of the patch.

David Pfeffer September 2, 2010 at 4:04 PM

This patch should resolve this issue.

Fixed

Details

Assignee

Reporter

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?

Created June 26, 2010 at 7:52 AM
Updated October 10, 2010 at 11:11 AM
Resolved October 6, 2010 at 10:01 AM
Who's Looking?