You can get horse compost up at Tilden Park - the stables by the trains. You go there and scoop up as much (or little) as you want. I'll try to find the directions. Sometimes there is a listing on craigslist.
For some general info go to: www.sfvictorygardens.org
The Berkeley Ecology Center also has a lot of info. They have a handout on planting times
Go to East Bay Nursery or Berkeley Horticulture (both in Berkeley) and ask any staff all your questions - they are all very helpful. Berkeley Hort also has lots of handouts buy the checkout.
A few other sites:http://loveapplefarm.typepad.com/growbetterveggies/instructions-on-how-to-gr.htmlhttp://inmykitchengarden.blogspot.com/
I'm in Oakland (Rockridge) and have lots of luck with beans, cucumbers, lettuce (romaine types are great), arugula, kale, beets, herbs of all types, basil, mint, lemon grass, potatoes, tomatoes, sweet and hot peppers, watermelon, canteloupe. I know 2 folks who had decent crops of corn. Bugs haven't be much of a problem using compost only for nutrients rather than chemical feritlizers. If I do get any aphids I use a dilute soap solution.
Oh and another resource- I'm getting a Wriggly Worm Wranch soon from here: http://stopwaste.org/home/index.asp