in reply to Re^2: Calculate aircraft headings from GPS data for google kml display
in thread Calculate aircraft headings from GPS data for google kml display

Can you prove a small sample of the dataset that illustrates the structure?

DOH!

You must always remember that the primary goal is to drain the swamp even when you are hip-deep in alligators.
  • Comment on Re^3: Calculate aircraft headings from GPS data for google kml display

Replies are listed 'Best First'.
Re^4: Calculate aircraft headings from GPS data for google kml display
by hujunsimon (Sexton) on Jun 09, 2014 at 23:28 UTC

    Hi boftx, the data sample is in my original post, let me knwo if it's not clear enough !

      Without looking at the calcs in detail, I would say that you should convert the data (if size is not prohibitive) to a hash where each key is the aircraft ID and the value is an array hashes containing the other data points from each row with that aircraft ID.

      You can then easily loop over the aircraft IDs. Assuming the data rows are already sorted by time it should be a relatively simple matter to step through the array items at that point calculating the deltas.

      You must always remember that the primary goal is to drain the swamp even when you are hip-deep in alligators.

        Yes, that sounds right. definitely need to use the hash keys to step through all these items. Any chance you have an example to point me to, that would greatly appreciated !

        thank you !

        Si