Simon Christen has put together one of the best timelapse videos of San Francisco and the Bay Area that I've seen yet.  It's posted on his profile on exposureroom.com and the video isn't embeddable as far as I can tell, so follow the link and check it out:

http://exposureroom.com/members/seemoo/8d13ea8361dc41c3a5dd629de3e9624e/