The CG Arena site published the making of this great futuristic city created in Photoshop, where the author explains the techniques of digital painting and composition (Matte Paint) to produce this type of image.

Here: http://www.cgarena.com/freestuff/tutorials/photoshop/futuristic-city/fcity.html