This a fight going on in Idaho right now:
https://www.idahostatesman.com/news/local/community/boise/ar...
If you look at a google map of Ada County Idaho, the only viable agriculture land requires watering from the Snake and Boise Rivers.
What crop was so valuable that they would use precious water in a near desert? They were growing Kentucky bluegrass for lawn seed.
Yeah, stop subsidizing agriculture in arid lands.
So from this article:
https://www.8newsnow.com/investigators/farming-family-uses-m...
1 billion gallons is not unreasonable for a large scale farm. Unless you're doing rail, 8000 gallons is pretty standard for a tanker. So that's 125,000 trips over the course of a year and 500 trips a day maybe? Assuming you had a 1 billion gallon source 100 miles would be somewhere around US$28M burning gas (assuming a tanker marginal cost per mile is $2.27). But water sources might be much more than that from where your farm is in the desert. If it's 1000 miles, it's $280M.
At that rate it may be cheaper to use solar power to boil 10 billion gallons of ocean water into steam and let nature do the work to move the water to where you need it.