Geotagging is simply inserting geographic location data in a media file so that it can be placed on a map or otherwise related geographically with other images, services etc. It is the technology used by flickr maps, the Places categorization in iPhoto and many other services.
Aperture is Apples professional photo management tool