Tuesday, December 30, 2008

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 :

patient renter said...

Wow, very cool!

Max said...

Thanks! If anybody out there is good at video editing, please drop me a line. :)

Deflationary Jane said...

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 >; )

Max said...

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.

Anonymous said...

Awesome work.

-Replay

Luis said...

Davis needs more red.

Max said...

I've gotten an email saying the video isn't loading, but I can't replicate the problem. Is anybody else having trouble?

Anonymous said...

Not loading for me as well

Max said...

OK, I added a different version. If that works, let me know...

Jeff said...

It looks like Sacramento has cancer!

Max said...

It looks like Sacramento has cancer

Nah, it's just a rash.

stephen trentalange said...

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

patient renter said...

+1 to what Stephen had to say :)

Husmanen said...

As we ring in the New Year I just want to say...

THANKS FOR A GREAT SITE

... much appreciated

The best in 2009!

Anonymous said...

If your $330,000 dropped in value to $200,000 the color should be in red.

Suziclue said...

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.

Husmanen said...

Looks like you got linked on Patrick.net.

Congrats!

Max said...

+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? :)