Hall of Famer moved to San Francisco in 1958 and he still has family, who happen to be Giants fans, in the Bay Area