Fixed the problem in a round about way. Purchased a Rain Soft whole home water conditioner for the house (not a water softener as most think). Water had 11 grains of hardness and a lot of sediment. Test after install showed Zero with sediment removed. Had an independent water test done and it is actually 2 grains (still really really good) with no sediment.
Bottom line...soap works really well and foams up ten times better. Car rinses clean with zero spots...in direct sun light.
...and no I didn't spend the money just to wash cars, I have family members with some skin issues and this helped clear it up.