Entity_Type:
Entity_Type_Label: Reformatted navigation in Excel spreadsheet and CSV format
Entity_Type_Definition:
The Excel spreadsheet has a header (in row 1) explaining the columns of information, row 2 has the header names, row 3 has header names that are appropriate for incorporation into a GIS (shorter names, no punctuation, and the header row of the CSV file), and the remaining rows contain the data in 11 columns. The labels below are the CSV row headers with the first part of the attribute definition the longer Excel header in row 2 of the Excel spreadsheet.
Entity_Type_Definition_Source: U.S. Geological Survey
Attribute:
Attribute_Label: VESSEL
Attribute_Definition:
Vessel name: The name of the ship that the field activity used for the cruise. The R/V Auk is the Stellwagen Bank National Marine Sanctuary research vessel - a 50-foot catamaran.
Attribute_Definition_Source: U.S. Geological Survey
Attribute_Domain_Values:
Unrepresentable_Domain: Text field.
Attribute:
Attribute_Label: CRUISE_ID
Attribute_Definition:
WHCMSC field activity number: The field activity number assigned to the cruise by the Woods Hole Coastal and Marine Science Center (WHCMSC). The number is in the format YYYY-XXX where YYYY is the year and XXX is the number activity in that year.
Attribute_Definition_Source: U.S. Geological Survey
Attribute_Domain_Values:
Unrepresentable_Domain: Text field.
Attribute:
Attribute_Label: UTC_DATE
Attribute_Definition:
Date, UTC: The date of data collection for the given row based on UTC (Coordinated Universal Time) time. In the Excel spreadsheet, the date has the format of D-M-YYYY where D is the numeric day of the month, M is the month abbreviation, and YYYY is the year.
Attribute_Definition_Source: U.S. Geological Survey
Attribute_Domain_Values:
Unrepresentable_Domain: Text field.
Attribute:
Attribute_Label: UTC_JD
Attribute_Definition:
Julian Day, UTC: Julian day of data collection based on UTC time. Julian day is the integer number representing the interval of time in days since January 1 of the year of collection.
Attribute_Definition_Source: U.S. Geological Survey
Attribute_Domain_Values:
Unrepresentable_Domain: Text field presented as a number.
Attribute:
Attribute_Label: TIMEZONE
Attribute_Definition:
Study area time zone: The time zone in which the study area is located. The time zone of the survey is dependent on the survey date.
Attribute_Definition_Source: U.S. Geological Survey
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: EDT
Enumerated_Domain_Value_Definition:
Eastern Daylight Time. To derive EDT, subtract 4 hours from the UTC time.
Enumerated_Domain_Value_Definition_Source: U.S. Geological Survey
Attribute:
Attribute_Label: UTC_TIME
Attribute_Definition:
Time, UTC, HHMMSS: The time of the navigation fix in the format HHMMSS where HH is hour, MM is minutes, and SS is seconds. The times are UTC (coordinated universal time).
Attribute_Definition_Source: U.S. Geological Survey
Attribute_Domain_Values:
Unrepresentable_Domain: Text field presented as a number.
Attribute:
Attribute_Label: DDMM_LAT
Attribute_Definition:
Lat N, DDMM.MMMM: The latitude coordinate in WGS 84 in the format DDMM.MMMM where DD is degrees and MM.MMMM is decimal minutes. The "N" refers to northern latitude.
Attribute_Definition_Source: U.S. Geological Survey
Attribute_Domain_Values:
Unrepresentable_Domain: Text field presented as a number.
Attribute:
Attribute_Label: DDMM_LON
Attribute_Definition:
Lon W, DDMM.MMMM: The longitude coordinate in WGS 84 in the format DDMM.MMMM where DD is degrees and MM.MMMM is decimal minutes. The "W" refers to western longitude and serves the place of having a negative value.
Attribute_Definition_Source: U.S. Geological Survey
Attribute_Domain_Values:
Unrepresentable_Domain: Text field presented as a number.
Attribute:
Attribute_Label: LATITUDE
Attribute_Definition:
Lat N, decimal degrees: The latitude coordinate in decimal degrees, WGS 84; positive values indicate northern hemisphere.
Attribute_Definition_Source: U.S. Geological Survey
Attribute_Domain_Values:
Range_Domain:
Range_Domain_Minimum: 42.09436
Range_Domain_Maximum: 42.44109
Attribute_Units_of_Measure: decimal degrees
Attribute:
Attribute_Label: LONGITUDE
Attribute_Definition:
Lon W, decimal degrees: The longitude coordinate in decimal degrees, WGS 84; negative values indicate western hemisphere.
Attribute_Definition_Source: U.S. Geological Survey
Attribute_Domain_Values:
Range_Domain:
Range_Domain_Minimum: -70.56294
Range_Domain_Maximum: -70.11564
Attribute_Units_of_Measure: decimal degrees
Attribute:
Attribute_Label: AREA
Attribute_Definition: Region: The area of the survey.
Attribute_Definition_Source: U.S. Geological Survey
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: SBNMS
Enumerated_Domain_Value_Definition: Region: Stellwagen Bank National Marine Sanctuary
Enumerated_Domain_Value_Definition_Source: U.S. Geological Survey
Entity_and_Attribute_Overview:
The attribute label is the abbreviated label in row 3 of the Excel file that is more compatible with importing the dataset into a GIS. The first part of the attribute definition is the longer label of the column that is in the second row of the Excel spreadsheet.
The Excel spreadsheets have the following information in the first row describing the spreadsheet:
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 Daylight Time subtract 4 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; EDT, Eastern Daylight Time; lat, latitude; lon, longitude; WHCMSC, USGS Woods Hole Coastal and Marine Science Center; SBNMS, Stellwagen Bank National Marine Sanctuary; UTC, Coordinated Universal Time (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 files with the same prefix name, but the CSV extension are exported from the Excel spreadsheet, minus the first two rows of information.
The *_raw.csv files are the original GGA 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 for field activities with the $GPGGA string is as follows:
$GPGGA, UTC time (HHMMSS), latitude (DDMM.MMMM), latitude hemisphere, longitude (DDMM.MMMM), longitude hemisphere.
Entity_and_Attribute_Detail_Citation: U.S. Geological Survey