For the remaining rows, the format of the columns of information is as follows:
$GPGGA, UTC time (HHMMSS), latitude (DDMM.MMMM), latitude hemisphere, longitude (DDMM.MMMM), longitude hemisphere.
latitude: (4211.9672-4200)/60 + 42 to give 42.19945 decimal degrees
longitude: ((7043.2105-7000)/60 + 70) * -1 to give -70.72018 decimal degrees with negative for western hemisphere
Additional fields of information were added to the spreadsheet and are defined in the entity and attribute section, as well as within the header information in each spreadsheet. The first row is an explanation header, the second row contains descriptive column headers, and the third row contains brief column headers that are compatible with importing the data into a GIS.
GPS navigation log: Column A, vessel name, AUK, SBNMS research vessel; column B, field activity number; column C, date, UTC; column D, Julian Day, UTC; column E, study area time zone; column F, time, UTC (for Eastern Standard Time subtract 5 hours); column G, latitude north, degrees and decimal minutes; column H longitude west, degrees and decimal minutes; column I, latitude north, decimal degrees; column J, longitude west, decimal degrees; column K, geographic region [abbreviations: D, degrees; H, hour; M, minute; S, second; EST, Eastern Standard Time; lat, latitude; lon, longitude; WHCMSC, USGS Woods Hole Coastal and Marine Science Center; SBNMS, Stellwagen Bank National Marine Sanctuary; UTC, coordinated universal (Greenwich Mean Time, ZULU time); GPS, satellite-based Global Positioning System receiver]
The 11 columns of data are the same as those represented in the entity and attribute detailed description.
The file with the same prefix name, but the CSV extension was exported from the Excel spreadsheet, minus the first two rows of information.
The *_raw.csv file is the original $GPGGA strings off the ship. The first row in the *raw.csv file describes the file. For the remaining rows, the format of the columns of information is as follows:
$GPGGA, UTC time (HHMMSS), latitude (DDMM.MMMM), latitude hemisphere, longitude (DDMM.MMMM), longitude hemisphere.