Here's a part of it showing the area around Fremont. We can't be expected to worry about every heavy line, can we? Thankfully, no; and not the colors and symbols either. That's geology stuff: bedrock and contacts between stratigraphic units. But the two heaviest lines are important. On the left is the Hayward Fault and on the right is the Calaveras fault, both capable of major shocks.

US Geological Survey image
Another USGS map called the Quaternary map focuses on just the active faults—well, the sort-of active ones that have moved during the Quaternary Period. You need to know only two things about the Quaternary: it's pronounced "qua-TERN-ary" and for our purposes it includes the last 1.8 million years of geologic time. Now a fault that hasn't moved in a million years, like a volcano that hasn't erupted in a million years, is not much of a threat. The color codes on the faults match the time of the latest fault movement, angry red being historic time (namely, 1868).
There are two good ways to visit our local faults. One is visiting them in parks (see the list below), and the other is the freelance approach of tracking them through the neighborhood. For that, the best tool is the State of California's Alquist-Priolo Earthquake Zone Maps, which have just been placed online by the California Geological Survey. Mandated by the Alquist-Priolo Act of 1972, these maps display the locations of faults that have ruptured during Holocene time, which is geologese for the last 11,000 years. Unlike Quaternary faults, activity on these Holocene faults is a pretty sure thing. And the maps display the detailed fault traces as mapped by geologists, superimposed on a high-quality topographic map.
With these, you can drive or stroll an area and assess the land for yourself. In places like downtown Hayward, the signs are plain and plentiful. In many others, you'll wonder what the heck those geologists were seeing. (The answer is that they were looking at historical aerial photos and data, finding subtle clues on the ground, and doing a lot of connecting dots.) You'll have a head-scratching good time, and you won't see your landscape the same way again.
Visit the San Andreas fault:
Fort Ross—Take Fort Ross Road east about 0.5 mile and spot the painted line across the road; an interpretive trail is nearby.
Olema—Take the Earthquake Trail near the Bear Valley Visitor Center in Point Reyes National Seashore.
Los Trancos Ridge—This ridgetop park above Palo Alto has an earthquake trail along the fault.
Sanborn County Park—South of Cupertino in the Santa Cruz Mountains is this park with the 2.5-mile San Andreas trail along the fault trace.
San Juan Bautista—The fault runs just yards east of the mission here.
Visit the Hayward fault:
Berkeley—Tour the fault in "Bear territory" including the infamous football stadium built across the fault in 1923.
Oakland—Lake Temescal park displays the fault in several places.
Hayward—The historic downtown and old City Hall straddle the fault, and signs of steady (aseismic) creep are abundant here.
37.5482697 -121.9885719