Wasn't it Antioch that had a Skydiving center ? The bigger one is at Yolo County Airport near Davis. Also Cloverdale a little further north.
It's been awhile ( like 18 years ) but I flew some traffic watch in the Bay Area when I was going to SJSU. My company, Performance Aircraft of Hayward, would provide the pilots for Lin Durling and KGO radio when Lin went on vacation. I did that for a few times over a two year period and then Lin had a mid-air over Palo Alto with a C-152. It bent the vertical stabilizer of his Mooney 201 in half and knocked off most of the rudder. He managed to land it safely. The C-152, with a student and CFI, lost their nosewheel but also managed to land safely at Palo Alto. Kind of miraculous that nobody crashed and a great testament to the ruggedness of the Mooney. Anyway, after that Lin was really nervous and we ended up taking over the flying full time in a Piper Warrior. Not sure who does it now, but as previously suggested ask around and it shouldn't be too difficult to find out.
I really liked the traffic watch flying. I would do one flight from 0600 to 0830 and then another from 1600 to 1800. An easy 4.5 hours of flying for the day and I could attend class or teach students the rest of the time. It was a radio work out going up the west side of the Bay talking to SJC, Moffet, Palo Alto, San Carlos, and then SFO tower in quick succesion. We would get the helicopter routing over the top of SFO and then either fly over the Golden Gate or the Bay Bridge.
When the fog was in it could get a bit tricky. Sometimes we would just stay on top the whole time. The reporter would get the reports from the station and relay them from the air. That way the driving public still heard the background noise of the airplane. There was a little bit of pressure to get a look when you could. I would fly approaches into SJC or OAK to give the reporter a glimpse of the freeway before we went missed. Flying up the bay from the south the fog base would get lower, pushing us lower and lower. Ask me if I've been over the top of downtown San Francisco at less than 1000 feet

.... Of course the answer is, no

.
If you can get a job doing that it is a great way to build time. Just be careful and don't ever hesitate to contact Bay approach and ask for a climb.
Typhoonpilot