Its called "Lick Observatory" on top of Mount Hamilton. You can see it from pretty much anywhere in the south San Francisco Bay. Many major discoveries in astronomy have been made there. They say on a clear day you can see famous "Half Dome" in Yosemite from there.
Here is a great video on it
http://www.openroad.tv/video.php?vid=84