[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