Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Extracting Z Values of imported Line Strings

Unanswered Extracting Z Values of imported Line Strings

  • Friday, December 16, 2011 9:40 PM
     
     
    Sign In to Vote
    0

    Hi,

    I impoted a line shapefile, using the 'Shape2SQL' tool. My shape contains besides lat/long coordinates also a Z value (altitude).

    When imported into the database, I tried to extract the Z values of the points, belonging to the line, but so without success...

    When I try to convert the binary data format into text (STAsText();AsTextZM()) there are only the x and y coordinates existing!?

    Any idea what´s wrong?

    Thanks for your help


    • Edited by Jodlmi Friday, December 16, 2011 11:10 PM
    •  
     

All Replies

  • Saturday, December 17, 2011 9:13 AM
    Answerer
     
     
    Sign In to Vote
    0
    I'm not sure Shape2SQL supports Z/M coordinate values - try importing using an alternative tool instead - Safe FME/OGR2OGR?
    twitter: @alastaira blog: http://alastaira.wordpress.com/
     
  • Monday, December 19, 2011 9:04 AM
     
     
    Sign In to Vote
    0

    Hi,

    I tried Safe FME now with the same result. In the manual they say that the FME writer doesn't support Z values.....

    What about ORG2ORG? It´s difficult to find any matching results on Google. Who has the right link?

    Any recommendations how to proceed?

    Thanx

    Jochen