You've always wanted to see the world. Panoramio lets you see photos from all around the world on a map. You just have to select a location (like your favorite holiday destination) and you'll see pictures from there located on the map.
Panoramio lets you upload up to 2 Gb of photos in their original size and quality and label them with the place they were taken and some tags. This way, you can upload pictures from your trips and see other people's perspectives on the same places.
Panoramio photos can be viewed in Google Earth too if you download a KML file.
Also see:
Picasa Web Albums (Picasa also has geotagging)
Change the world with Google Earth 4
Google Earth reveals Iran's nuclear sites