I have a polyline in Google Earth.
I am able to see the elevation profile in Google Earth when I move along the polyline but is there a way to extract the lat,long and elevation data out to Excel?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this communityI have a polyline in Google Earth.
I am able to see the elevation profile in Google Earth when I move along the polyline but is there a way to extract the lat,long and elevation data out to Excel?
The GEOCONTEXT-PROFILER will create an elevation profile just like Google Earth and you can import a KML and export a CSV. It should give you the same results as Google Earth.
This is the license restriction page that the tool links to.
The Google Elevation API can give you the elevation at any point on earth, so you can iterate across your polyline and get the elevation of each point:
{
"results" : [
{
"elevation" : 1608.637939453125,
"location" : {
"lat" : 39.7391536,
"lng" : -104.9847034
},
"resolution" : 4.771975994110107
},
{
"elevation" : -50.78903579711914,
"location" : {
"lat" : 36.455556,
"lng" : -116.866667
},
"resolution" : 19.08790397644043
}
],
"status" : "OK"
}
Up to 2,500 requests per day are available for free. Note that the terms of service require you to display any obtained results on a Google map, and calling the API from Excel or ArcGIS is likely to be a little complicated.