Greenhouses solve the problem of water while still using the sun. Peri-urban greenhouses also save on transportation costs while only being mildly more expensive in terms of land costs. As cities become more dense, former sprawl can be repurposed into local agricultural land.