@john-nolton Adi17 is trying to convert a grid coordinate to lat/long. A grid coordinate that doesn??t look like any of the Australian projections published on the internet. The coordinates on the left side of his screenshot from Excel are the ones he is trying to convert. Without more information it is impossible to do.
Dave K.?ÿ Adi17 has some coord. that came from someplace which he did not understand (his very 1st post); The X value did not look good to me and I asked for more information.This Adi17 gave us. Now on page 2 (just above) he gives us 4 sets of coord. that he is trying to understand. His first is X: 145.09417 and Y: -37.90497 (This he calls Lat long in DD) (here I thing it should not be X and Y but label them as Lat. and Long). We can convert that set to deg. min. sec. as;
Lat -37.90497 D.D = -37d 54m 17.892 s?ÿ and Long. 145.09417 D.D = 145d 05m 39.012 s.?ÿ Now this is close to his value he gives on the next entry below of Lat Long in DMS he has?ÿLat: 37d 54m 17.91172s South and Lon: 145d 5m 38.95825s E.
Ok now I took his Lat/Long of his very 1st post of 37-54-17.91383 South and 145-05-38.94994 E and transformed them to Zone 55 south and got Easting of 332448.373 and a Northing of 5803015.645. I did this for 2 reasons; 1st to show that in his very 1st post he gave us some wrong coord. and 2nd to show Ari17 that if you convert (transform) from Lat/Long what the coord. will be. Which just happen to be close to his MGA zone 55 (GDA 1994) and his MGA zone 55 (GDA 2020). If you transform from Lat/Long to x/y coord. you sure can transform from from x & y to Lat/Long by using?ÿ ?ÿgeeoddmike 1st link. Since he is trying to learn I am leaving it up to Adi17 to do this and get back to us if he needs anymore help.
JOHN NOLTON
@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.
