Instructions for adding metadata to hurricane photos Download the EXIFtools (if you don't have them installed yet) from http://www.sno.phy.queensu.ca/~phil/exiftool/ (works on Macs or PC's). Bring up a command window and type exiftool to be sure that it is working. Create a working directory and place the PER script met_add.pl and the CSV file in this directory. Ensure there is a directory labeled "in" located in your working directory and place the photos that are to have metadata added into this directory. In the CSV file ensure that the latitude and longitude have the proper sign (i.e. longitudes from our part of the world are negative). Also ensure there are no commas used in any of the entries as this will break the decoding process. Located the working directory containing all of these files in the command window On the command line type: perl met_add.pl When prompted, type in the name the csv file is saved as. (this will create a new file called photos.sh) Once that has completed type (on a MAC): sh photos.sh (this could take awhile - you should see messages like 1 photo updated) When the process is complete the in directory will have the originals which have been relabeled to jpeg_original and the new photos with the metadata have the standard .jpg extension. On the command line type exiftool in/filename.jpg to verify the metadata is correct. Metadata Added: -Keywords = "oblique aerial photograph, [STORM from Excel], [PRE_post from Excel]-storm" -GPSLongitudeRef = "E or W" -GPSLatitudeRef = "N or S" -GPSLongitude = "[LONGITUDE from Excel]" -GPSLatitude = "[LATITUDE from Excel]" -DateTimeOriginal = "[YEAR_ from Excel]:[MONTH_ from Excel]:[DAY_ from Excel] [HR_MIN_SEC from Excel]" -Credit="U.S. Geological Survey" -Artist="Karen Morgan, Dennis Krohn" -Caption = "Photograph of the shoreline taken somewhere from [GEO_AREA from Excell] as part of the [PRE_post from Excel] [STORM from Excel] survey." -Copyright="none - please credit U.S. Geological Survey" -Contact="gs-sea-spcmsc.data.steward.photo@usgs.gov"