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 the UTM coordinates, taking care that our system is configured to use the comma and the point as the decimal separator as a thousands separator. So a coordinate like 599.157,90 is not allowed it should be written as 599157.90
- In the next column we enter the zone. Just by placing it on the first line, the others will be changed. Although they can be changed manually in case the data were in the limit of two zones. Likewise the hemisphere; in this case I am using data from Bogotá, so I use Zone 18 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[advanced_iframe src=”https://script.google.com/macros/s/AKfycbxVLbJki_LyumjcW_IewXgNW4LZtvhQJn-ku2Y5ncCXLU_deWk/exec” width=”100%” height=”600″]
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 display of an image. It would still support things like links to routes on the Internet or the local disk of the computer, videos, or any rich content.
Step 3. Visualize 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, the points placed on the Google Street View can be viewed and navigated over it. By clicking on the icons you can see the details.
Step 4. Reproject the data. By default the data load is in WGS84, as used by Google. But this functionality allows you to change to another projected coordinate system and refresh the map. As an example, I am switching to Clarke 1866 and see that the vertices are re-projected on 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 download up to 400 times, with no limit to how many vertices there may be in each download using the gTools API. Just the map shows the coordinates from Gooogle Earth, with the three-dimensional model views activated.
Another option: Convert the coordinates to a kml file using an Excel macro
Once the tabular data has been filled in, the name of the kml file and the address where it will be stored appear on the right. 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: by touching a point you can display the description of the last Excel column.
- 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 the following. Look at the name of the layer, as we call it, and then there are the points with its description; touching them raises a display of detail. 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
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, you should put a path on disk D, which has fewer restrictions than 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. It always indicates the version of windows you are using.