My understanding, which is probably quite out of date, is that it's mostly harbor firefighting boats which had this ability.

A coworker of mine points out that many of the San Francisco manholes are actually covers for cisterns of water, which exist primarily for fighting fires after an earthquake possibly takes out the water mains and starts many fires. I should hope that San Francisco fire trucks can draft water to use these.