locked
How to solve this geography's problem in sqlserver2008 (shape file--> sqlserver2008) RRS feed

  • Question

  • I export one ARCGIS's shape file(wgs84) to sqlserver2008's geography table sucessfully.

    Later I find both's lat/lon's value are different in shaper filIe and sqlserver2008's geography table

    The same point is below both
    shape file  110.68197631783 31.8551654808892 0 0
    geography   110.97685242292907 31.64306831125624 0

    1 I want to know the reason why both are different
    2 how to sovle this problem so that their difference are less

     

    Friday, November 15, 2013 2:15 PM

Answers

All replies

  • Hello,

    The differences are not less, they are huge.

    How have you imported the shape file?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Sofiya Li Monday, November 18, 2013 8:35 AM
    • Marked as answer by Sofiya Li Monday, November 25, 2013 3:37 AM
    Friday, November 15, 2013 2:27 PM
  • Yeah, that's definitely not the same point.... can you please describe the steps you took to perform the export? There's no reason why any translation should have taken place.
    • Proposed as answer by Sofiya Li Monday, November 18, 2013 8:35 AM
    Saturday, November 16, 2013 9:45 AM
  • This problem might be caused by Geo Referencing Coordinates System. As you mentioned that you are using WGS84,  the software that you have used to upload data may have used some other system reference. please make sure you are doing it correctly.

    This blog may be useful for you

    http://sqlserverrider.wordpress.com/2013/10/12/sql-server-definition-and-calculation-for-spatial-data/


    Thanks Ayyappan Thangaraj, http://SQLServerRider.wordpress.com


    • Edited by [Ayyappan] Monday, November 18, 2013 7:39 PM
    • Marked as answer by Sofiya Li Monday, November 25, 2013 3:37 AM
    Monday, November 18, 2013 7:38 PM