There are very few cameras with GPS inbuilt and that can tag the picture with data on where it was taken. There is an innovative solution that a few people are using to geotag their pictures. They carry a GPS tracker along with them when they take pictures.

The cheap GPS tracker (around $80) notes the current location every few seconds. The pictures are taken and later when they are downloaded back to the computer, software like Robogeo or WMMX is used to stamp the location data into pictures EXIF metadata by looking at the time the picture was taken and where the gps was at that time. Note that the GPS and the camera time must be in sync to the second. You can later visualize the photos in Picasa/Google earth or on Panoramia