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
The basic issue is farmers can only make money with practically free water they get from natural sources. Anything that raise the average price per gallon is useless to them and they own most water rights. The long term solution is to reduce the amount of farming via eminent domain and rejecting all new farming operations.
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.