"Shanghaiing Days," by Richard Dillon, is another good one about San Francisco, and predates Pickelhaupt. They compliment each other nicely. The cigar store Indian story has also been told about San Francisco.