Aberdeen: A city in transition