I live in lower haight.
go to:
sfstation.com
sfgate.com
haighteration.com and the linked neighborhood blogs.
There are a ton of concerts, and food tours, and touristy shit going on all the damn time. just use your intermanet.
Touristy shit would include: go to the upper haight(corner of haight and ashbury) to check out all the funky shops. go to the mission to eat at the rediculously awesome eateries. go to north beach and the marina to see the GG bridge, palace of the fine arts(really cool spot) and the general touristy shit there.
If you want bud, you can literally buy some off most of the bums in the upper haight- instead of begging for change they beg to sell you weed.
I hate to tell you this but its gonna be cold and gray everyday, so remember to dress warm.