 During the swimming pool scene (when Andrew cannot swim) the fog was  not there for effect. The site was originally chosen because the  Manhattan Skyline was clearly visible but it just happened to be  incredibly foggy on the day of filming.