The Microsoft Excel spreadsheet has a header in row 1 explaining the columns of information, header names in row 2, and header names that are appropriate for incorporation into a GIS (shorter names, no punctuation) in row 3. The spreadsheet gives basic station information (location, cruise, occupation date and time), as well as additional information indicating what data were collected at each location. The labels below are the shapefile and CSV row headers with the first part of the attribute definition representing the longer Excel header on row 2 of the Excel spreadsheet. The shapefile has these attributes and the software-generated FID and shape attributes which are absent from the Excel spreadsheet and CSV file.
(Source: U.S. Geological Survey)
- FID
- Internal feature number.
(Source: Esri)
Sequential unique whole numbers that are automatically generated.
- Shape
- Feature geometry
(Source: Esri)
Coordinates defining the features.
- FIELD_NO
- USGS station: Sample name or number as assigned in the field by the Chief Scientist.
(Source: U.S. Geological Survey)
Character set. Although numeric, stations could have a decimal number indicating a reoccupation of a station.
- DEPTH_M
- Water depth, m: Depth in meters of the station based on the ship echo sounder. Recorded in the log book at the time of deployment of the SEABOSS. The values were rounded to the nearest meter to account for ship motion.
(Source: U.S. Geological Survey)
Range of values |
Minimum: | 23 |
Maximum: | 27 |
Units: | meters |
- VESSEL
- Vessel name: The name of the ship that the field activity used for the cruise.
(Source: U.S. Geological Survey)
Character string.
- CRUISE_ID
- WHCMSC field activity number: Name or number of cruise on which the sample was collected. The cruise identifier is in the format YYYY-XXX where YYYY is the survey year, and XXX is the survey number of that year.
(Source: U.S. Geological Survey)
Character string.
- UTC_DATE
- Date, UTC: The date of data collection based on UTC (Coordinated Universal Time) time. In the Excel spreadsheet, the date has the format of D-M-YYYY where DD is the numeric day, M is the month abbreviation, and YYYY is the year. The date is based on the deployment of the SEABOSS.
(Source: U.S. Geological Survey)
Character string.
- UTC_JD
- Julian Day, UTC: Julian day of data collection based on the deployment of the SEABOSS in UTC time. Julian day is the integer number representing the interval of time in days since January 1 of the year of collection.
(Source: U.S. Geological Survey)
Text field presented as a number.
- UTC_JDTIME
- Station occupation date and time, DDD:HH:MM:SS, UTC: Station occupation date and time with Julian day and time in UTC. The format is DDD:HH:MM:SS where DDD is the Julian day, HH is hour, MM is minutes, and SS is seconds. Julian day is the integer number representing the interval of time in days since January 1 of the year of collection. This time corresponds to when the sediment sample was collected (if one was collected). If a sediment sample was not collected, this time represents the end of the video drift.
(Source: U.S. Geological Survey)
Text field presented as a number.
- TIMEZONE
- Study area time zone: The time zone in which the study area is located.
(Source: U.S. Geological Survey)
Value | Definition |
EST | Eastern Standard Time. To derive EST, subtract 5 hours from the UTC time.
|
- STA_LAT
- Station location, Lat N, decimal degrees: Latitude coordinate in decimal degrees WGS84, of station location. The position represents the location of the sediment sample (if collected). If a sediment sample was not collected, the position represents the end of the video drift.
(Source: U.S. Geological Survey)
Range of values |
Minimum: | 42.17590 |
Maximum: | 42.19667 |
Units: | decimal degrees |
- STA_LON
- Station location, Lon W, decimal degrees: Longitude coordinate in decimal degrees WGS84, of station location. West longitudes are recorded as negative values. The position represents the location of the sediment sample (if collected). If a sediment sample was not collected, the position represents the end of the video drift.
(Source: U.S. Geological Survey)
Range of values |
Minimum: | -70.27916 |
Maximum: | -70.23925 |
Units: | decimal degrees |
- STIME_VID
- Video drift start time, UTC, HHMMSS: Start time of the video drift when the SEABOSS reached the seabed in UTC time in the format HHMMSS.
(Source: U.S. Geological Survey)
Text field presented as a number.
- ETIME_VID
- Video drift end time, UTC, HHMMSS: End time of the video drift when the SEABOSS left the seabed in UTC time in the format HHMMSS.
(Source: U.S. Geological Survey)
Text field presented as a number.
- SLAT_VID
- Video drift start Lat N, decimal degrees: Latitude coordinate in decimal degrees WGS84, at the start of the station video drift.
(Source: U.S. Geological Survey)
Range of values |
Minimum: | 42.17586 |
Maximum: | 42.19666 |
Units: | decimal degrees |
- SLON_VID
- Video drift start Lon W, decimal degrees: Longitude coordinate in decimal degrees WGS84, at the start of the station video drift. West longitude is recorded as negative values.
(Source: U.S. Geological Survey)
Range of values |
Minimum: | -70.27873 |
Maximum: | -70.23898 |
Units: | decimal degrees |
- ELAT_VID
- Video drift end Lat N, decimal degrees: Latitude coordinate in decimal degrees WGS84, at the end of the station video drift.
(Source: U.S. Geological Survey)
Range of values |
Minimum: | 42.17590 |
Maximum: | 42.19667 |
Units: | decimal degrees |
- ELON_VID
- Video drift end Lon W, decimal degrees: Longitude coordinate in decimal degrees WGS84, at the end of the station video drift. West longitude is recorded as negative values.
(Source: U.S. Geological Survey)
Range of values |
Minimum: | -70.27916 |
Maximum: | -70.23925 |
Units: | decimal degrees |
- SAMP_LAT
- Sediment sample location, Lat N, decimal degrees: Latitude coordinate in decimal degrees WGS84, of the sediment sample location. A value of 9999 indicates no sample location because no sample was collected.
(Source: U.S. Geological Survey)
Range of values |
Minimum: | 42.1759 |
Maximum: | 42.19667 |
Units: | decimal degrees |
- SAMP_LON
- Sediment sample location, Lon W, decimal degrees: Longitude coordinate in decimal degrees WGS84, of the sediment sample location. West longitude is recorded as negative values. A value of 9999 indicates no sample location because no sample was collected.
(Source: U.S. Geological Survey)
Range of values |
Minimum: | -70.27916 |
Maximum: | -70.23925 |
Units: | decimal degrees |
- VIDEO
- Video imagery collected: The value of this attribute indicates if seabed video was recorded at the station. The value "y" indicates that video was recorded, "n" indicates no video was recorded.
(Source: U.S. Geological Survey)
Boolean character set.
- VIDEOFG
- Video frame grabs: The value of this attribute indicates if a video frame grab was acquired at the station. The value "y" indicates that a frame was captured, "n" indicates no frame was acquired.
(Source: U.S. Geological Survey)
Boolean character set.
- CTD_PR
- CTD profile data collected: The value of this attribute indicates if a CTD cast was taken and data collected. The value "du" indicates that CTD downcast and upcast data were collected, "n" indicates no CTD cast was taken.
(Source: U.S. Geological Survey)
Boolean character set.
- SEDSAMP
- Sediment sample collected: The value of this attribute indicates if a seabed sample was successfully collected at the station. The value "y" indicates that a sample was collected, "n" indicates no sample was collected.
(Source: U.S. Geological Survey)
Boolean character set.
- SEDSAMPPH
- Sediment sample photo collected: The value of this attribute indicates if a photo of the sediment sample surface in the SEABOSS grab sampler was taken at the station. The value "y" indicates that a photo was taken, "n" indicates no photo was taken.
(Source: U.S. Geological Survey)
Boolean character set.
- AREA
- Region: General geographic area of data collection. This can be an abbreviation, such as SBNMS for Stellwagen Bank National Marine Sanctuary.
(Source: U.S. Geological Survey)
Character string.
Entity_and_Attribute_Overview:
The attribute label is the abbreviated label in the third row 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.
Additionally, the Excel spreadsheet has the following information in the first row describing the spreadsheet:
[Cruise station and data summary: column A, USGS station number; column B, water depth, meters; column C, vessel name; column D, WHSC field activity number; column E, date, UTC; column F, Julian Day, UTC; column G, station occupation date and time, UTC (for Eastern Daylight Time subtract 4 hours; for Eastern Standard Time, subtract 5 hours); column H, study area time zone; column I, station location, latitude north, decimal degrees; column J, station location, longitude west, decimal degrees (station location is the sample location, if collected; otherwise it is the video drift end location); column K, video drift start time, UTC; column L, video drift end time, UTC; column M, start of video drift, latitude north, decimal degrees; column N, start of video drift, longitude west, decimal degrees; column O, end of video drift, latitude north, decimal degrees; column P, end of video drift, longitude west, decimal degrees; column Q, sediment sample location, latitude north, decimal degrees; column R, sediment sample location, longitude west, decimal degrees; column S, video imagery collected; column T, video frame grabs collected; column U, CTD profile collected; column V, sediment sample collected; column W, sediment sample photo collected; column X, geographic region [abbreviations: DDD, Julian Day; EDT, Eastern Daylight Time; EST, Eastern Standard Time; H, hour; M, minute; S, second; 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); y, yes; n, no; du, downcast and upcast data; 9999, no sample location because no sample collected]
The CSV file has the same information and the same column definitions except the first two rows included in the XLSX file are omitted (information describing the spreadsheet and longer column labels).
Entity_and_Attribute_Detail_Citation: U.S. Geological Survey