Good stuff Marty. Water and food are in need of much more enginuity.
I’ve been looking in to expanding the OpenAg food computer idea that I first saw on a TEDtalk by Caleb Harper, to incorporate an aeroculture system for growing fruit, herbs and vegetables, with additional sections for insects, fungi, seaweed and fish production in a total unit size of a room in a house.

It is even feasible to automate the entire process, from seeding to harvesting, from storage to cooking and even cleaning. On the next evolution there could even be a cell wall, where the occupants of the house store their health information and culture samples of their cells for testing, personalized medicine and even usings seaweed extract to generate bioscaffold for 3D printing replacement body parts and organs.

It’s one of the first spin-off areas I’m looking into after finally finishing my AuraOZ general intelligence because I want to live for 1000’s of years at a bare minimum. All a bit futuristic at the moment but very possible to manufacture and scale if a few focused people got engineering.