The cold water cools down the air above it, and cool air can't hold as much moisture as warm air. The moisture condenses into fog. The water along the coast of California is cold for a couple of reasons.
