Flickr has added a pretty cool feature to their site: geotags let you can point out on a map exactly where you took a photo. (FlickrBlog has all the details.)
For example, take my photo of the Zakim Bridge: Under “Additional Information” in the right part of the page it says “Taken in East Cambridge, Massachusetts” and clicking the “map” link shows you where I shot it (from the Museum of Science). You can also explore photos other people have taken near that photo to see what other people shot.
This might get kind of messy (and possibly unusable) for very popular sites — especially touristy destinations — but might be fun for less popular locations and/or your hometown.