Sacred Well in Oakland
If you're willing to get out of SF, the Sacred Well in Oakland on Grand Ave has a good selection of tarot decks and the best selection of crystals I've seen in the Bay Area. Also, it's right next to Oaktown Spice Shop, which has a good herb selection. It's mostly geared toward cooking but convenient if you pick up some tarot cards and you're out of sea salt. I haven't been to the Sacred Rose in SF, but the other shops mentioned seemed good to me. Sadly, SF is not the city it once was when it comes to counterculture of any kind. The Psychic Eye bookstore was the largest occult store I've ever seen in my life. I mean massive--like an occult emporium really--but it closed up shop many years ago. SF is mostly about $$$ these days and less about offbeat living and spiritual exploration IMHO.