In my region, the street trees are usually getting sewer water. Residential service in older houses are usually clay pipes with lead solder that the tree infiltrates. It’s not a problem until the clay pops and roots clog it.
It varies a lot by region and jurisdiction. One of the cities near me made the mistake of using riveted pipe from rolled steel to save money 75 years ago, and regularly has catastrophic main breaks as the rivets aren’t as robust as a regular pipe.