Above is a photo I took just after midnight of fireworks exploding above San Francisco on January 1st.
I know that I like to "preview" a city before I travel to it and thought it might be helpful to feature photo sites that feature some "only in San Francisco" shots on Blog Appetit Does San Francisco.
Here's a few I found that I thought were worthwhile. I'll add to this list as I come across more.
If you know of a site with great Bay area photos, please leave a comment below to share it.
Flicker -- SF group
A different photo for every day
SF Axis has lots of photos as well as a lot of other information for tourists and locals. (See my post on SF web basics for more info.)
SF Photorama has wonderful photos. It sometimes takes a bit to load (at least on my computer with my dsl) but is well worth the wait. (Be sure to scroll down, the pix tend to be toward the bottom of the page.)