Friday, December 16, 2011 9:40 PM
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
Saturday, December 17, 2011 9:13 AMAnswererI'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
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?