CSV file of names, times, and locations of images collected by an unmanned aerial system (UAS) flying over Black Beach, Falmouth, Massachusetts on 18 March 2016

A DJI Phantom 3 Professional quadcopter with onboard camera, which uses a Sony EXMOR 1/2.3" sensor, was operated through a tablet computer for flight programming and control. The flight was conducted by Simon Miner of Woods Hole Analytics using Maps Made Easy (MME; https://www.mapsmadeeasy.com; Automotive Data Research) for route design and automated flight programming, including camera shutter control and vehicle return for battery replacement. Photographs were collected in JPEG format by the built-in camera on the DJI and capture information was stored in the accompanying Exchangeable Image File (EXIF). The approximate camera position at the time of each photograph was measured by a GPS receiver onboard the UAS and recorded in the image EXIF data. All activities were conducted according to Federal Aviation Administration regulations. Images were collected between approximately 1101 EDT at the most southwestern point and 1129 EDT at the most northeastern point. The survey was timed to correspond to the time of local low tide. Weather conditions included sunny skies, with winds of about 10.3 m/s. The DJI captured an image approximately every 20 meters in 15 east-west transects spaced 30 m apart at an altitude of 35 m (115 feet). This design ensured an image resolution of 2.5 cm and an overlap of 80 percent between photos. The images were downloaded from the camera on the day of flight.

A Python version 2.7 script was run to extract GPS data from the image headers and format the output CSV table. The script used ExifTool (version 10.43) with the following command was used to create the CSV: exiftool -csv -filename -DateTimeOriginal -GPSLongitude -GPSLatitude -GPSAltitude -n imagedirectory > bb20160318_UAS_imagelocations.csv The path to the image directory was substituted for 'imagedirectory' in the command. 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 DateTimeOriginal tag was used because the GPS time was not recorded in the EXIF data by the UAS.
The table output by ExifTool was reformatted and the fields Easting and Northing were added. This involved converting the datetime from Eastern Daylight time to UTC (added 4 hours) and then splitting the values into dates and times. Then, fields SourceFile and DateTimeOriginal were removed. Fields GPSLongitude, GPSLatitude, and GPSAltitude were stripped of the 'GPS' prefix and ‘_ft’ was added to the Altitude column label. The longitude and latitude coordinate pairs referenced to WGS84 were converted to easting and northing in UTM Zone 19 North with a datum transformation to NAD83 using the function 'transform' in the Python module 'pyproj' and the values were stored in new columns 'Easting' and 'Northing'. The transformation was performed in Python with the following call, in which lon and lat stand in for the value of longitude and latitude in one row and east and north are the resulting easting and northing in NAD83 UTM Zone 19N:
import pyproj east, north = pyproj.transform(p1=pyproj.Proj(init='epsg:4326'), p2=pyproj.Proj(init='epsg:26919'), x=lon, y=lat)

Added keywords section with USGS persistent identifier as theme keyword.