Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
Contributor
wilsonherrera
Posts: 12
Registered: ‎09-30-2010
Message 1 of 4 (1,890 Views)
Accepted Solution

SQL SERVER SPATIAL COORDINATES FLIP

1890 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

Valued Mentor
gluckett
Posts: 363
Registered: ‎10-10-2003
Message 2 of 4 (1,816 Views)

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
wilsonherrera
Posts: 12
Registered: ‎09-30-2010
Message 3 of 4 (1,721 Views)

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
gluckett
Posts: 363
Registered: ‎10-10-2003
Message 4 of 4 (1,309 Views)

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

 

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community