The shapefile containing the photo locations was exported to a comma-delimited text file based on each individual cruise. This was done in ArcMap 9.3.1 using XTools Pro 7.1. First the photos for a particular survey were selected, then XTools was used to export the following attributes: Latitude, Longitude, PhotoName, Time, Date_. The text editor VI v 7.3 was used to reformat the output so that DATE_ was in the format YYYYMMDD and the header line was removed. A Python version 2.7.3 script (andrews_write_exif.py) was then run that incorporated the information in the export text file, along with additional information supplied in a GUI of the script, into the appropriate locations in the EXIF header of each full-resolution JPEG image. The PYTHON script uses ExifTool (version 9.4.6.0) to write the information to the image headers. The full-resolution images will eventually be incorporated into the WHCMSC photo database and the EXIF header information is a requirement for the database.
The following tags were populated in the JPEG image headers. Information is duplicated in some tags. This was done because different software packages access different tags. The example below has the information for field activity 2012-003-FA. For the other two field activities, the appropriate field activity number was substituted.
GPS tags: The values populated are unique for each image and based on the information exported from the photo locations shapefile.
GPSLatitudeRef
GPSLatitude
GPSLongitudeRef
GPSLongitude
GPSTimeStamp
GSPDateStamp
JPEG tags: The tag is listed along with the information used to populate it - which is the same for every image of a given field activity.
Comment: Photo from down-looking camera on the USGS SEABOSS deployed from the R/V Rafael
during survey 2012-003-FA (http://woodshole.er.usgs.gov/operations/ia/public_ds_info.php?fa=2012-003-FA)
Released as part of publication DOI:10.3133/ds937
EXIF tags: The tag is listed along with the information used to populate it - which is the same for every image.
ImageDescription: Photograph of the sea floor in Barnegat Bay, New Jersey from survey 2012-003-FA.
released as part of publication DOI:10.3133/ds937
Artist: Brian Andrews
Copyright: Public Domain - please credit U.S. Geological Survey
IPTC tags: The tag is listed along with the information used to populate it - which is the same for every image.
Credit: U.S. Geological Survey
Contact: WHSC_data_contact@usgs.gov >Keywords: Barnegat Bay, New Jersey, 2012-003-FA, SEABOSS, sea floor, USGS
CopyrightNotice: Public Domain - please credit U.S. Geological Survey
Caption-Abstract: Photograph of the sea floor in Barnegat Bay, New Jersey from survey 2012-003-FA.
released as part of publication DOI:10.3133/ds937
XMP tags: The tag is listed along with the information used to populate it - which is the same for every image.
Caption: Photograph of the sea floor in Barnegat Bay, New Jersey from survey 2012-003-FA.
released as part of publication DOI:10.3133/ds937
To extract the information from the image headers using ExifTool, the following command can be used (tested with ExifTool version 9.4.6.0): exiftool.exe -csv -f -filename -GPSTimeStamp -GPSDateStamp -GPSLongitude -GPSLatitude -n -Artist -Credit -comment -keywords -Caption -Copyright -CopyrightNotice -Caption-Abstract -ImageDescription imgtest/*.jpg > out.csv > The -csv flag writes the information out in a comma-delimited format. The -n option formats the latitude and longitude as signed decimal degrees. The folder "imgtest" would be replaced with the folder name containing the images.