There are not a lot of good route areas close to san francisco...probably your best bet is the gym. There are a few less than desirable areas to rope up at within an hour or two like Mt. Diablo. Your best bet is to drive to Yosemite, about 4 hours away...
Information about climbing in San Francisco