Really appreciate the thorough deep dive! In your research, did you find any populous corner of California, the American SW, or the U.S. in general that has a good story to address problems like these?

Out east, it seems like upstate NY has a decent shot at long-term water security, depending on how thirsty NYC becomes and how influential that thirst is in the scheme of NY state politics.