• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk MapGuide Enterprise

    Reply
    Contributor
    wilsonherrera
    Posts: 12
    Registered: ‎09-30-2010
    Accepted Solution

    SQL SERVER SPATIAL COORDINATES FLIP

    1372 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

    Please use plain text.
    Mentor
    Posts: 254
    Registered: ‎10-10-2003

    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
    Please use plain text.
    Contributor
    wilsonherrera
    Posts: 12
    Registered: ‎09-30-2010

    Re: SQL SERVER SPATIAL COORDINATES FLIP

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

    its a workaround but it works! thank you!

    Please use plain text.
    Mentor
    Posts: 254
    Registered: ‎10-10-2003

    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

     

    Please use plain text.