Panoramio has built a very clever website which is kind of like Flickr meets Google Maps. In fact Panoramio does use the Google Maps API, and allows users to post pictures and link them to a geographic location.
It’s pretty cool, and just shows what you can do with a bit of imagination. I would like to see a ratings system and someway to filter the results. Otherwise popular cities are going to end up with 1000’s of pictures which will be make it difficult to find what you want.