ProaSailor
dreaming my life away...
I found a way to export hourly coordinates from the tracker in JSON format (currently 436 points in a 15K line text file), then wrote PHP code to:
So with only a few mouse clicks, I get the following: (in addition to the complete sorted list of hourly coordinates)
Again, I don't know what his route ahead will be - certainly longer than the great circle distance used - but this method will become increasingly accurate as he approaches Japan. And it's now very quick and easy to produce.
- sort the points by a sequence 'key'
- calculate the distances between all points to get the actual distance traveled
- derive average speed and GC distance remaining to Nishinomiya
- estimate days remaining, total days and percent completed
So with only a few mouse clicks, I get the following: (in addition to the complete sorted list of hourly coordinates)
- Days so far: 18.13
- Distance from San Francisco: 1981.6 NM
- Average speed: 4.56 knots
- GC distance to Nishinomiya: 3725.6 NM
- Days remaining (estimated): 34.08
- Total days (estimated): 52.2
- Percent completed (estimated): 34.7%
Again, I don't know what his route ahead will be - certainly longer than the great circle distance used - but this method will become increasingly accurate as he approaches Japan. And it's now very quick and easy to produce.
Last edited by a moderator: