Occasionally, there are cities that, no matter what happens, you CANNOT make it grow.
As stated, either make it build a barracks and spam units, or make it build wealth.
But... it does grab hold of some resources... it isn't a total waste, just one that could probably have waited a bit.
Oh, and finally, to prevent this happening again, this is what you should do.
Count the food output of each tile, minus two (so a grassland tile yields 0, a plains tile yeilds -1, and a floodplains yields 1). If you come across a resource, count the food output of that tile, with the appropiate improvement on it, and subtract two (so a corn tile, which yeilds 6 food on grassland, non-riverside, counts as 4).
The number you get means something IMPORTANT:
If the final number is NEGATIVE: Multiply by -1 (take away the minus sign) and that is how many farms / windmills you will need.
If the final number is ZERO: You don't need any farms / windmills.
If the final number is POSITIVE: This city is a prime candidate for a Great Person farm (A city that runs lots of specilists). If you already have one, and it yeilds a higher number, its probably best not to add any farms, but if you don't want to run a specilist economy, then you should add a number of workshops equal to the final number.
With that in mind, and once you think you have grasped it, use these tips:
After civil service, if you can make a farm-chain to any resource that is farms (eg. Rice / Corn etc.), then that tile will yeild one more food, meaning you don't have to build another farm. If the tile is already riverside, then increase the food output of that tile by 1.
Remember that some resources give extra food, something that I missed. Examples are: Spices (+1 with plantation), Wine (+1 with Winery), and Sugar (+1 with Plantation).
Coastal tiles count as 0 if the city is coastal, but -1 otherwise (Because, with a lighthouse, they yeild 2 food). Fresh water tiles (lakes) count as 1 if the tile is coastal,and 0 otherwise.
Don't count tundra tiles (unless they are forested, or riverside and you are going to COTTAGE them... farmed Tundra is pathetic), desert tiles, peaks, desert tiles with low outputs (eg. Stone on desert), snow, or ice in the final tally, as you won't be using them anyway. These tiles you will never work, count as 0.
Using that, the final value of the city you just built is something like -5 (meaning you will need to build 5 farms. But you cant, as everything is tundra, and isn't riverside!!)
Note: Deer gives +3 food or something. Build a camp on the deer.