locked
Is it possible to convert between two different Srid RRS feed

  • Question

  • Hi,

    I frequently have the need to convert coordinates from one datum to another, say from NAD27 to NAD83 or vice versa. Is that possible to do with SQL 2008 Spatial?

    I have tried - but did not seem to find anyway to do it...

    /Hans Olav
    Monday, July 6, 2009 11:34 AM

Answers

  • No, you need an external tool to do this.

    Try Safe FME (http://www.safe.com, commercial), or FWTools (http://fwtools.maptools.org, free)
    Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290
    Monday, July 6, 2009 12:25 PM
    Answerer

All replies

  • No, you need an external tool to do this.

    Try Safe FME (http://www.safe.com, commercial), or FWTools (http://fwtools.maptools.org, free)
    Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290
    Monday, July 6, 2009 12:25 PM
    Answerer
  • OK, using FME already. Just would have been nice if you could do it without an external tool.

    /Hans Olav
    Monday, July 13, 2009 8:33 AM
  • totally agree with you there Hans!! I've had to make a winform prog that uses the free FWTools command line arg before i runs the shape2sql.exe command line arg. Importing all the USA TIGERS (and only one .shp file type .. not all the shape file data) took around a week. ... and that's just importing. I still need to find some time to convert the imported data into my own table / GEOG structure, including cleaning up the imported data (which i had my queries all done before they updated the codeplex project which more or less does this now) :P
    -Pure Krome-
    • Proposed as answer by Kalman Toth Wednesday, September 8, 2010 2:26 PM
    Tuesday, July 14, 2009 1:21 AM
  • Hi Pure Krome,

    You got the command line from shape2sql to work?
    Can u show me an example?

    Or do you see a mistake here?
    shape2sql.exe -sshp=\\Server\Shared Folder\Filename.shp -sconnstr=Persist Security Info=False;Data Source=MSSQLSERVER\Instance;Initial Catalog=DBNAME;User ID=user-id;Password=password -tablename=File_name -append=true

    Thx in advanced.
    Jessica

    Wednesday, September 8, 2010 10:58 AM