But this is fundamentally flaws analysis. Lack of economies of scale mean you have to analyze the production of food bottoms-up. What's the cost of getting the resources needed to each of these individual farms and to support the life of people there?

The thing people don't realize is that industrial farming is actually extremely carbon-emission efficient. Even your food coming from a container ship from halfway around the world, transported via freight, and driven last mile in a semi is less carbon intensive than getting a delivery from a local (XX miles away) farm.

This seems to be trivially true as well for an entire city of inefficient farms with any expectation of modern amenities.