Activity Feed › Discussion Forums › Ask A Surveyor › Failing to convert XYZ to DMS
-
@adi17 when you export data from an application you should have an opportunity to tell it what you want to export (Lat Long or some grid coordinate system). You are probably exporting to whatever the applicationƒ??s default map projection is which is why you are getting the weird XYZ coordinates.
Thats my best guess.
The application may be able to make a KML directly.
-
XYZ coordinates for NAD83 at this lat/lon should have a negative X and a positive Y. The NaN for Z sometimes results from using a non-numeric value as input to a calculation. The presence of a Tranverse Mercator projection is confusing. So let’s go back to the beginning.
1. Does the spreadsheet you’re using to build the XML file from consist of many rows of data with strange XYZ coordinates?
2. Were you given this spreadsheet or are you generating it? Where does its source data come from?
3. What data are you typing in and in what format?
4. Is your workflow this: Take given XYZ coordinates, convert them to lat/lon, build XML file?
5. Would you share the URL of the website you’re using for your conversion calculation?
Coordinate problems that involve 3 different systems (lat/lon, ECEF, and Transverse Mercator) can involve multiple missteps or may result from just one. If we can get to the source, we may be able to resolve it.
-
Outstanding MathTeacher : I was wondering when you would post. Hope all is well.
JOHN NOLTON
-
@dave-karoly Hi Dave, sorry for the late reply, it was a bit late at night in melbourne.
When I do CSV export, it just directly download the data for me, I think the weird XYZ is the default setting by the system.
I finally had a piece of luck ???? , as the CSV file was not helpful so I thought let’s explore the unknown territory and I click:-export the result in the shapefile. Then did a study on google what is shapefile and how to use and lucky me this file has a proper coordinates attribute column which I can use in the google earth Pro desktop version.
In google earth pro, I imported shapefile, did some small changes to make the data look good, then save it as a KML file. And finally, it works. I am so happy, took me almost 2 weeks to make it work but in the process, I learned a lot about the Globe and GPS systems.
Once again, I would like to pay my sincere thanks to the experts who help me by providing your guidance.
-
Decent, John, and thanks for asking. I hope you and yours are doing well.
Log in to reply.