I really hope that never happens
I think the OP is sadly mistaken if he thinks that in 100 years cities will "take over"... Remember we are humans and we have to do a little thing called EAT every once in a while! Where does that food come from? The grocery store? Oh yeah!
I'd say Calgary is great, closest mountain is 1:00 hour away, season is from Nov to May, and it's a big city with big city amenities. But I don't want somebody living here who doesn't like the outdoors and farm land.