This looks like the mouth of an old train or maybe cable car tunnel from Aquatic Park to Fort Mason. Old: check. Cool: check.