Hi I have an interesting task I want to achieve. I currently manage a website that acts as a tracking system for a popular piece of flight simulation software. Currently we take a dump of the lat/lon and other data of everybody flying every 5 minutes. This has been done constantly for the past two years. There is close to a million records now in the database.
What I would really like to produce is a video of the world showing these lines being drawn in a sped-up fashion however this isn't really my area and I can't think of the best way I could go about this in such a programatic fashion. I've seen similar types of videos done before but has anyone got any ideas of what routes I could go down to make this visualisation?