Picasa is an excellent image organizer in general, but its integration with Google Maps and Earth make it easy to add location information to the metadata of your photos. If you're not already using it, it's a free download as is Google Earth, which you'll need to install as well if you want to display photos on its satellite map.
In this example, I'm using some pictures taken of the Empire State Building. Find and select the photos being tagged and in the lower right corner of the interface, click the Places button. Places uses Google Maps to get the coordinates for your photos.
When you click the geotag button in Picasa (after you've selected the images you want to tag, of course), Google Earth will launch and ask you to navigate to the spot where you'd like to place your photos. You can do it manually using the crosshair (not shown)and directional controls in the upper right of the interface. Or, in the upper left, is a search bar.
After you've navigated to the correct location, you simply click Geotag and Earth will add the metadata and place the photos on the Google Earth globe.