Starting the year 2012, taking advantage of these boring hotel nights, I have recycled this template made with Excel to generate a kml file that can be opened in Google Earth, generated from UTM coordinates.
Let's see the case:
I have gone to the field to build a property, as shown in the following table and I want to visualize it in Google Earth, including a couple of photos that I have taken
The genius of the template is that of only one:
- Converts the UTM coordinatesTo Geographic in decimal format, as it is what Google requires
- Allows you to set the name of the destination file
- Lets name the layer of kml
- Rewrite existing file, even if it is already generated
- It allows to use html tags in the description, such as images, hyperlinks, etc.
The template is ready for the spheroid to be selected, we know that for Google Earth we must choose WGS84.
- In the first column we enter the data that Google will show as Label.
- In the next two UTM coordinates, taking care that our system is configured to use the thousands separator comma and the point as a decimal point separator. So a coordinate such as 599.157,90 should not be written as 599157.90
- In the next column we enter the zone. With only placing it on the first line, the others will be changed. Although they can be changed manually if the data were in the limit of two zones. In the same way the hemisphere; in this case I am using data from Bogotá, that is why I use the 18 Zone and the Northern Hemisphere.
- And finally the description, which is what we would see when we click on the point in Google Earth.
Once the tabular data has been filled in, on the right appears the name of the kml file and the address where it will be stored. in this case it appears as C: \ Race 25 X.kml
- In the lower row we write the name that the layer will have in the kml file, in this case: 25 X Race Survey
- The result is this: when you touch a point you can see the description of the last column of Excel.
- Finally, once we are ready we press the green button, and the file should have been generated.
The result, when opening it in Google Earth is as follows. See the name of the layer, as we call it, and then there are the points with its description; when touched, a display of detail is raised. If the objects or labels They are very large, they can be customized in Google Earth by right clicking on the layer and choosing properties.
How to add the photo to kml
This is simple, suppose that in the detail of the level bank I want to put the image of the cadastre plate, then in the cell corresponding to the description I write:
Property limit, Bank of level Cadastre <img src = »http://geofumadas.com/wp-content/uploads/2012/02/Clavo_alcoi.jpg» width = »250" height = »233" />
Of course, the photo must be stored somewhere and we must know the address; It could even be in the machine locally. The file could also be View in Google Maps, Following the procedure I mentioned above.
Similarly, if at the point I have called Photo, I want to place a photo of the facade of the house, the procedure is similar.
- If you need to insert more rows, make copies of the existing ones so that they go with formula.
- You do not have to add columns, if you do it can stop working.
- Requires that you accept the execution of macros when opening the Excel file
- If it sends you an error message, it could be that the C: directory does not have write permission, you can try another folder like C: \ users \ downloads \ as long as the folder exists.
From here they can download The kml file As it should be.
Downloading the template in Excel requires a symbolic contribution, 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.
In case what you have is Geographic coordinates of type Latitude, Longitude, and you want to send to Google Earth, the template is this.
It may happen that, when using the application, one of the following incidents may appear:
This happens because the path that has been defined where the kml file is to be saved is not accessible or there are no permissions for this action.
Ideally, it is to place a route on disk D, which has fewer restrictions than what disk C. usually has. Example:
The points are coming out at the North Pole.
This usually happens, because in our windows, as indicated in the instruction for the template to work, the regional configuration must be established in the regional panel:
- -Point, for decimals separator
- -Coma, for thousands separator
- -Coma, for listings separator
So, a data such as: One thousand seven hundred and eighty meters with twelve centimeters should be seen as 1,780.12
The image shows how this configuration is done.
This is another image that shows the configuration in the control panel.
Once the change is made, the file is generated again and then, the points will appear where it corresponds in Google Earth.
If you have a question, write to the support email firstname.lastname@example.org. Always indicate the version of windows you are using.