Also, people especially farmers have been complaining about San Diego’s pricing to pay for their plant. Still, like you I don’t see any other long term solution since CA provides 1/3 of the US food supply. Maybe stop exporting live stock feed grown from the desert (ie water) to Asia?
We could do this with desalination, green energy projects, and other public infrastructure. I'd even love to see us subsidize fiber to homes and businesses en masse and allow ISPs to share the resulting infrastructure like they do in Europe
I also imagine with continued investment and research the tech could get better at scale too. It may be hard today but perhaps there's headroom for innovation with more funding while tackling migrating cities to using desalination
What’s affordable for a town is several orders of magnitude different than what’s viable for that farmer.