[Fdo-trac] [fdo-trac] #844: SQL Server provider flipping X/Y coordinates for points (SRID = 4326)
FDO
trac_fdo at osgeo.org
Thu Aug 9 20:04:32 PDT 2012
#844: SQL Server provider flipping X/Y coordinates for points (SRID = 4326)
---------------------------------+------------------------------------------
Reporter: jng | Owner: danstoica
Type: defect | Status: new
Priority: blocker | Milestone: 3.7.0
Component: SQLServer Spatial | Version: 3.7.0
Severity: 1 | Keywords:
External_id: |
---------------------------------+------------------------------------------
Create a new SQL Server database with the following table
{{{
CREATE TABLE [dbo].[COUNTRY](
[ID] [int] IDENTITY(1,1) NOT NULL,
[COUNTRY] [varchar](50) NULL,
[GEOM] [geometry] NULL,
CONSTRAINT [PK_COUNTRY] PRIMARY KEY CLUSTERED
(
[ID] ASC
)
) ON [PRIMARY]
}}}
Then execute the attached SQL script
The layer when seen from MapGuide OS 2.4/AIMS 2013/AutoCAD Map 2013 shows
the points as lat/lon instead of lon/lat (see attached screenshots from
SQL Server mgmt studio and MapGuide viewer)
--
Ticket URL: <http://trac.osgeo.org/fdo/ticket/844>
FDO <http://fdo.osgeo.org/>
Feature Data Objects
More information about the fdo-trac
mailing list