We have already seen some striking pictures of cities at Night seen from Space. Here is the explanation on how Nasa can make these beautiful images despite of orbital motion.
By the way, they now have a databse of over 4,000 images of cities at night (via The Regional Studies Blog).