Extracting Z Values of imported Line Strings


  • 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
    Friday, December 16, 2011 9:40 PM

All replies

  • I'm not sure Shape2SQL supports Z/M coordinate values - try importing using an alternative tool instead - Safe FME/OGR2OGR?
    twitter: @alastaira blog:
    Saturday, December 17, 2011 9:13 AM
  • 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?



    Monday, December 19, 2011 9:04 AM