Video Visualization: Submission from Daniel Sheehan
Watch on Youtube | Daniel's Website
How did you tackle the data? Using ArcGIS I cleaned up the database, created databases for each of the moves from 1990-2010 of the survey respondents responses, removed any of those records without proper US zip or a proper year (or I cleaned the year, ie 20005 to 2005) and then joined to ESRI US Census Zip point layers (exploded from multipoint feature class to point feature class). From this, using Hawth's tools (create line from X,Y table) and some more database table processing created From and To lines based on the unique ID and recent places 5->4, 4->3, 3->2, 2->1. Then using the Animation toolbar in ArcGIS created a video of the moves. Also, I assigned random months to the years of the moves b/c if everyone moved at the beginning of the year the animation would be boring.