Check out flickrvision.com
Once you open the page it's hard to not get stuck watching what people are uploading...right now.
Want to see Wikimedia with Geotags? Go to www.wikimapia.org and zoom into the level of detail you're interested in. If there is no information then you have the ability to add your own entry.