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.
How to upload these coordinates to Google Maps and then download them to Google Earth
Step 1. Download the data feed template. To use the example we have shown in the images you can download this template.
Step 2. Upload the template By selecting the template with the data, the system will alert if there was data that could not be validated; Among these validations includes:
- If the coordinate columns are empty
- If the coordinates have non-numeric fields
- If the zones are not between the 1 and the 60
- If the hemisphere field there is something different than North or South.
The description data supports html content, like the one shown in the example that includes the deployment of an image. The same would support things like links to routes on the Internet or the local disk of the computer, videos, or any rich content.
Step 3. Display the data in the table and on the map.
Immediately the data is uploaded, the table will show the alphanumeric data and the map the geographical locations; As you can see, the upload process includes the transformation of these coordinates into geographic format as required by Google Maps.
Once the icon is released you can have the visualization of the points placed on the Google Street View and navigate on it. By clicking on the icons you can see the detail.
Step 4. Reproject data. By default, data loading is in WGS84, as used by Google. But this functionality allows you to change to another system of projected coordinates and refresh the map. As an example, I'm switching to Clarke 1866 and see that the vertices are re-projected onto the map.
Here you can see the template working in video.
Step 5. Download the Kml map using the gTools service.
You enter a download code and then you have the file that you can view in Google Earth; the application shows where to obtain a download code with which you can make downloads up to 400 times, with no limit on how many vertices there may be in each download using the gTools API. Just the map shows the coordinates from Gooogle Earth, with the views of three-dimensional models are activated.
Another option: Convert the coordinates to a kml file using an Excel macro
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, Cadastre Level Bank <img src = »http://geofumadas.com/wp-content/uploads/2012/02/Clavo_alcoi.jpg» width = »250 ″ height =» 233 ″ />
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.
In case what you have is Geographic coordinates of type Latitude, Longitude, and you want to send to Google Earth, the template is this.
Learn how to make this and other templates in the Excel-CAD-GIS cheat course.
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.