This fresco decorates the (rather low) ceiling of the Casino, a summer house built for Cardinal Ludovico Ludovisi at the Monte Pincio in Rome.
