Basejumper.com - archive

The Hangout

Shortcut
Flysight raw data, Google Fusion tables
Has anyone successfully geotagged the CSV data from a flysight file, into a Google Fusion Table, and then got it to plot correctly on google maps? I try the "two column" location option for "lat" and "lon" and it looks like it is trying to geoconvert it, but it ends up in the middle of the pacific ocean without any pin dropped on the map...

Thanks in advance!
Smile

(Yes I know paralog & flysightviewer exist, and I don't care about them right now)
Shortcut
Re: [Colm] Flysight raw data, Google Fusion tables
Add a column to the raw file file with the Lat & ", " & Lon. You'll automatically get a map view based on that column.

I think getting Fusion to Geocode is only necessary when you are supplying something other than Lat & Lon e.g. postcode or address. It's also quite slow - 10 rows per second.
Shortcut
Re: [LukeH] Flysight raw data, Google Fusion tables
Hey, that worked great, thanks.

I'm downloading google earth right now, I bet there must be a way to plot 3-d points in that, too. Will report if I figure anything out.
Shortcut
Re: [LukeH] Flysight raw data, Google Fusion tables
Hah, LukeH it looks like you actually wrote the style file for the gpsbabel CLI conversion :)

i used the graphical frontend, and gpsbabel converted the CSV to KML. at least, the lat/longs appear to have converted.

i am futzing with google earth now to see if i can see the altitude elevations plotted in a profile view. google earth is a bit smarter than me, so this is somewhat of a struggle.
Shortcut
Re: [Colm] Flysight raw data, Google Fusion tables
I did. :)

In Google earth right click on the track and go to Properties > Altitude. Change it to "Absolute".
Shortcut
Re: [LukeH] Flysight raw data, Google Fusion tables
Thanks! Your style file with the command line options made for a much better depiction of the track, than the basic GUI gpsbabel conversion. I really appreciate that you put that out there.

do I need to modify the style file if i switch over to the linux version of gpsbabel?

If readers are wondering wtf we are talking about, you can see these things at http://flysight.ca/...hp?title=File_format
Shortcut
Re: [Colm] Flysight raw data, Google Fusion tables
Colm wrote:
do I need to modify the style file if i switch over to the linux version of gpsbabel?

I wouldn't think so, but I've never tested it.
If there is a need for a change it would probably be just changing carriage return / line feed characters.

The batch file would obviously need to be rewritten for Linux.
Shortcut
Re: [LukeH] Flysight raw data, Google Fusion tables
LukeH wrote:
The batch file would obviously need to be rewritten for Linux.

piece of cake
Shortcut
Re: [Colm] Flysight raw data, Google Fusion tables
There is a free online viewer on Paralog's website http://www.paralog.net/...html#Free_GPS_Viewer that will allow you to visualize the track too.

Paralog Desktop supports far more customizable templates than GPS Babel for exporting to whatever file format you define. It has the benefits of being able to export multiple files at once if required and take advantage of the automatic jump trimming and free-fall detection.

I have a a couple of KML export templates for Paralog somewhere, if you decide to try it let me know and I'll dig them out.