The photo locations were exported from ArcMap 9.3.1 using XTools Pro 7.1 as a comma-delimited text file. The attributes chosen for export were: LATITUDE, LONGITUDE, photo_name, date_exif, time_exif. A Python version 2.7.3 script (kate_write_exif.py) was then run that incorporated this information, along with additional information, 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 of the full-resolution images. 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.
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
GPSDateStamp
JPEG tags: The tag is listed along with the information used to populate it - which is the same for every image.
Comment: Photograph of the sea floor in southern Narragansett Bay, Rhode Island from down-looking camera on the USGS SEABOSS deployed from the R/V Rafael during survey 2014-046-FA (<http://cmgds.marine.usgs.gov/fan_info.php?fan=2014-046-FA>). Released as part of publication DOI:10.3133/ofr20151149.
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 southern Narragansett Bay, Rhode Island from survey 2014-046-FA.
Artist: Katherine McMullen
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: Narragansett Bay, Rhode Island, 2014-046-FA, SEABOSS, sea floor, USGS
CopyrightNotice: Public Domain - please credit U.S. Geological Survey
Caption-Abstract: Photograph of the sea floor in southern Narragansett Bay, Rhode Island from survey 2014-046-FA.
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 southern Narragansett Bay, Rhode Island from survey 2014-046-FA.
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 full-res/*.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.