Measurement Forum Archive

Read-only historical archive of measure.infopop.cc

What is the best way to use waypoint data?

#1 • 11/7/13 @ 8:09 PM
I was encouraged by one race organizer to supply waypoint information about the timing points, and so I have done that for some courses-- marking points using a gps device and then creating a .kmz file that shows up in Google Earth, and also constructing a chart showing latitude and longitude for each point.

Apparently it was a big help for the folks who put the mile signs out at the Marine Corps Marathon, and for others who have gone to look for the points. But I need a little instruction on how best to (1) construct the chart, and (2) advise someone how to use it.

Specifically, is there a way to get around reading and typing all of the numbers to create the lat-long chart, and on the other end is there a way around typing in all those numbers in order to find the spots?
#2 • 11/8/13 @ 6:02 AM
Bob, There are several methods to extract the GPS coordinates from a Google Earth file. If there are a just a few points, save as a KML file, instead of the compressed KMZ file. The KML file can be easily opened in a text editor. You'll recognize your data points within the tagged file.

If you have lots of points, save the KML file and go to GPS Visualizer.

http://www.gpsvisualizer.com/convert_input

Select the Output as plain text and Upload your KML file. The output text will contain the coordinates.

Hope this helps. -- Justin
#3 • 12/3/13 @ 3:40 AM
Similar to Justin's suggestion...but using Excel...
Lat-Long data from Google Earth
#4 • 12/3/13 @ 7:41 PM
Ken,
That link didn't work for me, can you give it in another form? Appreciate all the help.
#5 • 12/4/13 @ 2:24 AM
Hi Bob,
Here is the full link...
Google Earth to Excel

If that doesn't work...go to...
http://www.landviser.net/
and do a search for :
Extracting Geographical Lat-Long data from Google Earth KML / KMZ files to Excel