I live in San Francisco. Just a word of warning..the subways to Walnut Creek (BART) stops running shortly past midnight so if you're heading into the city for a night of clubbing, act like Cinderella and get to the station by midnight or it will be an expensive cab ride back.
Paul