This week I have been busy trying to visualize the race data available from the Danish scout adventure race "Alligatorløbet" 2013. This year they made the race tracking data available online as an Excel file with check-in and check-out times for each team on each checkpoint. What I have done is to animate that information as a little interactive movie that displays team-at-checkpoint intensity as heat maps on Google map.
It is rather neat, if you ask me, but check it out yourself: http://www.elfisk.dk/allitrack/CheckpointAnimation.html.
It is implemented like this:
- All data is normalized to CSV files with one record for each team/checkpoint/arrival-time/departure-time registration.
- The HTML page loads Google maps and overlays it with a KML file that shows the checkpoints. This KML file was created in Google Earth.
- Add to this some event handlers for interacting with the buttons and you are done :-)