The public trench across the Hayward fault
is open through the end of June! I'm a docent.
San Gregorio Beach, where the San
Gregorio fault goes out to sea.
Most of the geology sites I've described in the San Francisco Bay Area are on the San Andreas Fault page.
Until I write up some non-San Andreas related Bay Area trips, here are a few photos:
And here are some links to other sites with useful information:
The San Andreas Fault In The San Francisco Bay Area, California: A Geology Fieldtrip Guidebook To Selected Stops On Public Lands. An excellent collection of tour guides (PDF).
The California Geotour has an excellent collection of online field guides.
USGS On-line Digital Geologic Map Database
Guided Geologic Field Trip of the UCSC Campus
Geology and Natural History of the San Francisco Bay Area, a field trip guidebook (PDF) from the USGS.