This is one belongs under the "That's-No-Moon-That's-A-Space-Station" folder. As everyone knows, I like Star Wars quite a bit. But even I was a little bug-eyed to see these fan-made clips.
In case you can't tell, these are most likely your standard shots collected from home movies around San Francisco. But the effects have been seamlessly and pretty flawlessly added in. Check out the full video of the Death Star over San Francisco on Current.