Check out this video of Todmorden's urban food production in the UK.
For anyone interested in urban renewal through community gardens, this is a prime example. Unfortunately there's not too many details on how the gardens get watered and how particular city ordinances were addressed or overcome (although the topic is broached).
Look for fascinating use of a cemetary, purple cauliflower, and squashes that looked way better than mine.