Farms around freshwater

[ray111]

Anyone knows how to make a mod to enable building farms around a freshwater source in desert? There's generally some oases or lakes in there, even if there's no river in sight..

Relying on Petra is quite stupid, especially since anyone can beat you to building it, not to mention it only works for 1 city - in a map I'm playing now, I have 4 cities on my continent, of which 4/5 are desert, with only occasional patches of plains or grassland.

Well.... I suppose I could make Petra a non-unique building (and cheaper) instead of a world wonder, or make it civ-wide, but that's kinda clunky ... (and I'm not entirely sure it would work just by eliminating a 'city has petra' condition from those bonuses in xml..)

 

[Infixo]

Rather not possible with existing farms. Improvements have valid features and terrains assigned to them, if you allow desert that will be all desert tiles.
I would create a new improvement type, let's say DesertFarm. This could be built only on desert tiles and yield nothing. Then a modifier for oasis and lake adjacency to increase yield. This farm could utilize normal farm 3D model.

Edit. Another idea. Allow for farms to be built on desert (all tiles) but attach a negative modifier that would nullify their yields. Unless there's oasis or lake nearby - same as above. Probably little easier than previous idea.

 

[ray111]

well, for now, I just modified Quo's sql that assigns yields next to oasis to boost food yield from 1 to 3. At least I don't have to waste worker charges.. but it's kinda cheating...

Btw the Petra solution didn't work for me. Or rather, it didn't work when changing xml AFTER building it. I'll see if it modifies yields in all existing cities upon completion. I have a feeling that thing only activates upon completion... (now, if only the stupid map generator could grant me some equally good map with deserts.. I swear, I'll screenshot the game creation screen from now on and never use random AIs again. No way to get the same place again even using the seed from the save)