Movies set in San Francisco

I've long thought that San Francisco was strangely under-rated as a site of great movies, but having taken a closer look I'm no longer so sure about that. These lists are based on various lists found on the internet and a thorough investigation of IMDb, which lets you browse by location. I have a nagging feeling I've still missed some important ones. Is it really possible that none of the classic musicals were set in San Francisco? Anyway, I'm not coming up with anything earthshaking here.

( Lists beneath the bay ... )