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: PHOTO, DATE_, LATITUDE, LONGITUDE, JDTIME. The text editor VI v 7.3 was used to reformat the output so that DATE_ was in the format YYYYMMDD, the extension .jpg was added to the photo name, and the Julian Day was removed from JDTIME. 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 8.4.7.0) to write the information to the image headers of the full-resolution images. The headers of the medium resolution and thumbnails were not modified. 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
GSPDateStamp
JPEG tags: The tag is listed along with the information used to populate it - which is the same for every image.
Comment: Photo from down-looking camera on the USGS SEABOSS deployed from the R/V Rafael
during survey 2013-005-FA (<http://woodshole.er.usgs.gov/operations/ia/public_ds_info.php?fa=2005-004-FA>)
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 western Block Island Sound in New York waters from survey 2013-005-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: western Block Island Sound, New York, Connecticut, Rhode Island, 2013-005-FA, SEABOSS, sea floor, USGS
CopyrightNotice: Public Domain - please credit U.S. Geological Survey
Caption-Abstract: Photograph of the sea floor in western Block Island Sound in New York waters from survey 2013-005-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 western Block Island Sound in New York waters from survey 2013-005-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 -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.