Local foods are, as I understand it, supposed to be some combination of more eco-friendly and supporting local farmers.

Growing a potato in your kitchen cupboard using hydroponics and PV+LED is very local, but you'd have to grow a lot of them before you saved more on transport and processing emissions than created by the equipment; and you certainly aren't helping local farmers by doing it yourself.