Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
Contributor
12 Posts
0 Kudos
Registered: ‎09-30-2010
Post 1 of 4
Accepted Solution

SQL SERVER SPATIAL COORDINATES FLIP

1944 Views, 3 Replies
08-13-2012 09:56 AM

currentlky i have several layers stored in MS SQL server 2008 if i query them inside sql server management studio, the layers appear normal, but one i try to load them into mapguide, the x and y values swap, creating a 90° map.

 

this would be a nice feature if you could enable with a click, but this is a bug, and a big one to start, this mean that i can´t really load data from a MS SQL Spatial.

 

is there a way to fix this? this also happens in map 3D.

 

this is the layer in MS SQL SERVER

 

error1.JPG

 

this is mapguide

 

error2.JPG

workaround: store ll coordinates in geography rather than geometry
Valued Mentor
434 Posts
74 Kudos
Registered: ‎10-10-2003
Post 2 of 4

Re: SQL SERVER SPATIAL COORDINATES FLIP

09-12-2012 07:20 AM in reply to: wilsonherrera
workaround: store ll coordinates in geography rather than geometry
Contributor
12 Posts
0 Kudos
Registered: ‎09-30-2010
Post 3 of 4

Re: SQL SERVER SPATIAL COORDINATES FLIP

10-09-2012 01:04 PM in reply to: gluckett

its a workaround but it works! thank you!

Valued Mentor
434 Posts
74 Kudos
Registered: ‎10-10-2003
Post 4 of 4

Re: SQL SERVER SPATIAL COORDINATES FLIP

12-05-2012 10:01 AM in reply to: wilsonherrera

This BUG has no HOTFIX and is STILL Broken with the FDO 3.7 for the following products:

 

  • MapGuide Open Source 2.4
  • Autodesk IMS 2013
  • AutoCAD Map 3D 2013
  • Autodesk Infrastructure Modeler 2013

 

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post