BornDownUnder
Warlord
Every x4 game is about strategy and management, not just get as much as you can...I would like to know how I could do better?
I have a number of forge enhanced mines, with a few fresh water wheat tiles. That's about as high yield as you can get at this point in the game. I have a citadel for a bit of science, I even have a holy site for extra culture. I have every science building you can get at this point in the game. As to working specialists, as I already mentioned, I tried shifting something to specialists to see if that would help my unhappiness, it did not.
Now considering the growth penalties for unhappiness, you might be right that shifting some food tiles to specialist is probably more efficient (as my food is severally dropped due to unhappiness). but in terms of addressing my unhappiness, no the specialist switch does not help and actually greatly lowers my overall yields for the purpose of happiness.
Also this scenario could be achieved with the previous VP versions, just at a higher population.
The bulk of your unhappiness for that city in particular is from you not managing growth effectively. That is not to say that you should have locked growth.
It seems to me you let the city population continue to grow rapidly as you were focusing on the food and production requirements to mitigate that particular unhappiness quotient. You would have fared much better instead by slowing growth around 8 population and assigning specialists to address the deficits for lower yields of science and poverty as per the requirements of the city.
If you continue to let your city grow unabated, you will have created the need to do repeated Public Works just to mitigate the exceeded unhappiness threshold in the future (Probably around 20+ population) where you could have been happily investing in infrustucture/unit production to fund your war efforts. If you don't stagnate/severely restrict growth soon you will have serious issues with being able to use that city for production of units in sustained war efforts in late game, as well as continued empire unhappiness contribution.
You could alleviate it by reassigning a couple of the wheat and the farm plus oasis tiles to the lake tile to gain some faith, with a few specialists for the science and increased poverty requirements, along with an engineer specialist for production. This will in the short term slow your population growth and alleviate some of the needs of the city. It won't aid in happiness, for that you need infrustructure investment and that will take time.
You don't have to lock growth, just slow it right down.