Visualising geo data on a map 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?

Thanks,
Rory
I think this is probably less of a question for video production people as much as it is for Geographic Information Systems (GIS) people.

GIS Forum on Stack Exchange

While you might be able to find an After Effects (AE) wizard who knows some scripting tricks to make this happen, my guess is more folks over in a GIS forum know how to do this in something like ArcGIS.

Additionally, laying out a million records is going to be an awful lot to ask of a program like AE or Motion, while that amount of detail is pretty much what ArcGIS exists to deal with.

My guess is if this is a one-shot project, you could probably hire some college student to turn it around for you.  If it's going to be something on-going and constantly updated for your web site with a million plus data points, that might be also do-able, but a much bigger programming issue.