Google is perhaps a tool with which we live almost weekly, for not thinking that every day. Although the application is widely used to navigate and move through directions, it is not so easy to visualize coordinates of a specific point, nor in geographic format, much less coordinates UTM in google maps
This article, apart from showing you how to visualize the coordinates in Google Maps, will teach you to become an expert in visualizing those coordinates in Excel, convert them to UTM and even draw them in AutoCAD.
Utm coordinates on google maps
In the previous display, a Google Maps view appears, with the necessary options to locate a position. You can enter at the top a specific address, or the name of a city, or by looking for the list that is in the top right display.
Once selected, the map is located at the selected address.
We can click anywhere on the map, and we display an indicator of the coordinate in decimal format and also sexagesimal (degrees, minutes and seconds).
As you can see, the decimal coordinate 19.4326077, -99.133208. It means 19 degrees over the equator and 99 degrees from the meridian Greenwich, towards the west, that's why it is in negative. In the same way, this geographical coordinate is equivalent to the latitude 19º 25 '57.39 "N, length 99º 7' 59.55" W. The upper part shows the UTM coordinate X = 486,016.49 Y = 2,148,701.07 which corresponds to the 14 zone in the northern hemisphere.
Ready. With this you have learned to locate a point in Google Maps and know its UTM coordinate.
How to save several coordinates of Google Maps.
Previously, it has been explained how to visualize individual points, both its geographical coordinate and its coordinate in Universal Traverso de Mercator (UTM).
If we want to save several points on Google Maps and visualize them in an Excel file, then we must follow this procedure.
- We entered Google Maps, with our Gmail account.
- In the left menu we select the option "Your places". Here we will see the points that we have labeled, routes or maps that we have saved.
- In this section we choose the option "Maps" and create a new map.
As you can see, here are several features to create layers. In this case, I created the 6 points of the vertices and also the polygon. Although the functionality is simple, it allows to change color, style of the point, description of the object and even add an image to each vertex.
So you move to the area of your interest and draw the layers you think are necessary. It can be a layer for the vertices, another layer for the polygons of the terrains and another layer for the buildings, if you are going to draw them.
Once finished, to download it, select the three vertical dots and save it as a kml / kmz file, as shown in the following image.
The kml and kmz files are the formats of Google Maps and Google Earth in which the coordinates, routes and polygons are stored.
Ready. You have learned how to save different points in Google Maps and download them as a kmz file. Here's how to view these coordinates in Excel.
How to see Google Maps coordinates in Excel
A kmz is a set of compressed kml files. So, the easiest way to unzip it is as we would do with a .zip / .rar file.
As shown in the following graphic, it might be that we do not see the file extension. For this, we must do the following actions:
- The option to see the extension of the files is activated, from the "View" tab of the file browser.
- The extension from .kmz to .zip is changed. To do this, a soft click is made on the file, and the data that is after the point is modified. We accept the message that will appear, indicating that we are changing the file extension and that it could become unusable.
- The file is decompressed. Right mouse button, and "Extract in ..." is selected. In our case, the file is called «Geofumadas Classroom Ground».
As we can see, a folder was created, and right inside you can see the kml file called "doc.kml" and a folder called "files" that contains the associated data, in general images.
Open KML from Excel
Kml is a format popularized by Google Earth / Maps, which was before the Keyhole company, hence the name (Keyhole Markup Language), therefore, it is a file in XML structure (eXtensible Markup Language). So, being an XML file must be able to be viewed from Excel:
1 We changed its extension from .kml to .xml.
2 We open the file from Excel. In my case, I'm using Excel 2015, I get a message if I want to see it as an XML table, as a read-only book or if I want to use the XML source panel. I select the first option.
3 We search the list of geographic coordinates.
4 We copy them to a new file.
And voila, now we have the file of the coordinates of Google Maps, in an Excel table. In this case, starting from row 12, in column U the names of the vertices appear, in column V the descriptions and the latitude / longitude coordinates in column X.
So, with copying the X columns and the AH column, you have the objects and coordinates of your Google Maps points.
Interested in something else?
Convert coordinates from Google Maps to UTM.
Now, if you want to convert those geographic coordinates that you have in the form of decimal degrees of latitude and longitude to a format of projected UTM coordinates, then you can use the template that exists for that.
What are UTM coordinates?
UTM (Universal Traverso Mercator) is a system that divides the globe in 60 zones of 6 degrees each, transformed in a mathematical way to resemble a grid projected on an ellipsoid; such as is explained in this article and in this video.
As you can see, there copies the coordinates shown above. As a result, you will have the X, Y coordinates and also the UTM Zone marked in the green column, which in that example appears in the 16 Zone.
Send the coordinates of Google Maps to AutoCAD.
To be able to send the data to AutoCAD, you only have to activate the command of multiple points. This is on the "Draw" tab, as shown in the drawing on the right.
Once you have activated the Multiple Points command, copy and paste the data from the Excel template, from the last column, to the AutoCAD command line.
With this, your coordinates have been drawn. To visualize them, Zoom / All can be done.
You can buy the template with Paypal or credit card. Acquiring the template gives you the right to support by email, in case you have a problem with the template.