Housing Market Meltdown Google Earth Video: 2006-2008
The following is a video I put together showing the Sacramento market meltdown. Each frame is a week of data, and the video covers about 28 months from April 2006 until December 2008. Each color represents a listing price range (see the legend), and each dot is one MLS listing.
The meltdown really started picking up steam by the middle of 2007, as evidenced by the spread of the red dots. Notice also the resiliency of the "good areas" along the river and through parts of downtown, although it looks like price declines are beginning to encroach. 2009 should be interesting, that's for sure.
**Update: Here are the first and last frames in high quality:
April 15, 2006
December 27, 2008
**Update2: It looks like some people are having trouble loading the video, so here's a lower-quality version that should load for everyone:
18 comments :
Wow, very cool!
Thanks! If anybody out there is good at video editing, please drop me a line. :)
I may be able to hook you up with a pro but it won't be until after the first. We have tickets for the Weir/Lesh shows for the next two nights >; )
I may be able to hook you up with a pro but it won't be until after the first. We have tickets for the Weir/Lesh shows for the next two nights >; )
Thanks, DJ. I'd be forever "grateful." :) Seriously, I have a talent pool I can tap, but they're busy with jobs that actually pay in money.
Awesome work.
-Replay
Davis needs more red.
I've gotten an email saying the video isn't loading, but I can't replicate the problem. Is anybody else having trouble?
Not loading for me as well
OK, I added a different version. If that works, let me know...
It looks like Sacramento has cancer!
It looks like Sacramento has cancer
Nah, it's just a rash.
Very nice work!
I am not a professional, but may I suggest you change your color
scheme. The lowest prices should be the 'coolest' colors (dark blue)
and the highest prices should be the 'warmest' colors (red). A simple example is given in
http://www.physics.ucla.edu/~trent/hshowershape.png
+1 to what Stephen had to say :)
As we ring in the New Year I just want to say...
THANKS FOR A GREAT SITE
... much appreciated
The best in 2009!
If your $330,000 dropped in value to $200,000 the color should be in red.
Great visuals. Another visual can be seen at the site:
http://www.homepricetrend.com
You may begin to cry when you relize how much your home is worth now.
Looks like you got linked on Patrick.net.
Congrats!
+1 to what Stephen had to say :)
maybe for the next vid. This one took several hours to build; I had to load each weeks dump into GE and save the image. 178 in all. I'm thinking of doing a price differential vid next... what's the proper color-coding in physics for positive/negative differentials? :)
Post a Comment