Some time ago I have been asking for this, and since the friend looks like a Little hurried And today is a day to celebrate many things, here I leave a tool that allows you to convert geographic coordinates, degrees to decimals.
Why the conversion table
It is common to find coordinates that are in degrees, minutes, seconds, for example:
75 ° 25 '23.72 »N 45 ° 59' 12» W
The N means that it is a latitude 75 degrees above the equator, if it had an S it would mean that it is in the southern hemisphere. In the case of lengths, they will have E or W, depending on whether they are east or west of the Greenwich meridian
Programs such as Google Earth and ArcGIS require that they go in decimal format, such as:
The latitude, if it were below the equator would be negative, and the same will happen with the longitudes, which would be negative for the western hemisphere. I recommend to understand it, play a bit with Google Earth, changing the UTM display options, geographical, with and without decimals.
How the table works to convert geographic coordinates, degrees to decimals
Always using the Gabriel Ortiz table, which had been arranged for the conversion of geographic coordinates to UTM, displaying a column where they are seen in decimal format.
- You can choose the spheroid, in the upper flange.
- The columns in yellow, are to enter the data, in the first column accepts a point identifier number.
- To the right of each one is the latitude and longitude in decimal form, without rounding, with its respective negative symbol when it corresponds.
- The orange column contains the concatenated data, with the point number, latitude and longitude.
- In the header of this column, you can enter the number of decimals that we hope will round the concatenation. With care, that rounding off decimals of geographic coordinates can lead to large errors.
Send the coordinates to txt
To send them to a txt file, just open a new file, copy the data from the orange column and paste it there.
Then this file can be loaded from Google Earth, indicating the order, such as I explained it in that post.
Of course, the Datum must be in WGS84 so they do not fall elsewhere. The columns have always been left to convert to UTM and concatenate for AutoCAD, as it was The original version Of this table.
Downloading it requires a symbolic contribution for the download, which you can do with Paypal or credit card.
It is symbolic if one considers the utility it provides and the ease with which it can be acquired.
Learn how to make this and other templates in the Excel-CAD-GIS cheat course.