Steeev at Excellatronic Communications figures out a way to automate adding geotags to Flickr photos, using Greasemonkey and Google Earth. I haven’t had a chance to try it yet, but it looks funky.