We came from out of town to see NYC and Kiki's was the closest to where we were staying so we put our dog in daycare while we wandered the city. When we picked our dog up she was in a cage, not in the general dog population, when she got out of the cage she drank an entire bowl of water while we paid and when we got her back to our van she drank another liter of water. I'm not sure we wouldn't have been better to leave her in our van for the day, at least she would have had more room than the cage she was in and she would have had water available.
If you have no other options Kiki's is probably better than leaving your dog in a hot car all day, but only marginally.
more