I worked for a GIS maker in the 90s whose biggest customer was a water utility. They knew where every pipe was and had (IIRC) a public health requirement to be

I worked for a GIS maker in the 90s whose biggest customer was a water utility. They knew where every pipe was and had (IIRC) a public health requirement to be able to trace cryptosporidium outbreaks (among other things) on a per-pipe basis. So the data ought to be out there