Skydiving is in Byron - 1 hour east of the bay. Also in Lodi, 1.25 - 1.5 hours east.
Might be other places like Watsonville, Rio Vista. There is skydiving near (Woodville?), near Davis (near Sacramento).
SkyIMD - San Carlos. Does survey flying in 172's. Their idea is to be cheaper and more flexible than UAV/drones, by using a pilot. Interesting company.
Aperture Aviation - Reid Hillview (San Jose) Flies a whole bunch of 206's for aerial survey-photography. 1 week on 1 week off, they airline you to the planes. You will be all over the USA. Very well run company and well thought out operation. They say they want 500 hr mins, but who knows?
Traffic watch - forget the name, but its out of Livermore, in 172's. You may have to become familiar with the road structure of the bay area first, and the air structure, too.
Bay sightseeing tours - forget the company name, but it is out of San Carlos. Piper Archers, I believe.