Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Spreadsheet: Benthic Habitat Database, Worksheet: ShelfLatTransTrawls
Short Name: Shelf Latitudinal Trawls 2008 - 2011
Status: Completed
Abstract:

Trawl physical data (date-time, positions, depths, lengths of trawls) from each trawl in a set of Shelf Latitude Transects in the mid-Altantic region for the Shelf Latitudinal Transect Program 2008-2011

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Trawl physical data (date-time, positions, depths, lengths of trawls) from each trawl in a set of Shelf Latitude Transects in the mid-Altantic region for the Shelf Latitudinal Transect Program 2008-2011

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key cruise CHARACTER NEFSC cruise code
100
Primary Key station CHARACTER station alphanumeric names
100
UTC date DATE date of trawl in Universal Time Code
100
Begin UTC NUMBER trawl begin time (trawl wires at full scope) in Universal Time Code
100
End UTC NUMBER trawl end time (haul back begun) in Universal Time Code
100
event duration NUMBER duration of trawl between begin and end times
100
start lat NUMBER N Latitude at trawl begin time in ddmm.mmm format
100
start lon NUMBER W Longitude at trawl begin time in ddmm.mmm format
100
end lat NUMBER N Latitude at trawl end time in ddmm.mmm format
100
end lon NUMBER W Longitude at trawl end time in ddmm.mmm format
100
beg depth NUMBER depth of bottom in meters at begin trawl time
100
end depth NUMBER depth of bottom in meters at end trawl time
100
nominal trawl dist. NUMBER nominal distance between trawl begin and trawl end positions in nautical miles
100
trawl distance NUMBER nominal distance between trawl begin and trawl end positions in meters
100
Geog. Loc. CHARACTER description of geographic location of trawl
100
surface T NUMBER sea surface temperature in degrees C
100
bottom T NUMBER sea bottom temperature in degrees C
100
Data Collected & Comments CHARACTER comments regarding trawl operation and catch

Attribute Details

cruise

CC ID: 355651
Seq. Order: 1
Data Storage Type: CHARACTER
Max Length: 7
Required: Yes
Primary Key: Yes
Status: Active
Description:

NEFSC cruise code

General Data Type: CHARACTER

station

CC ID: 355652
Seq. Order: 2
Data Storage Type: CHARACTER
Max Length: 5
Required: Yes
Primary Key: Yes
Status: Active
Description:

station alphanumeric names

General Data Type: CHARACTER

UTC date

CC ID: 355653
Seq. Order: 3
Data Storage Type: DATE
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

date of trawl in Universal Time Code

General Data Type: DATE

Begin UTC

CC ID: 355654
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

trawl begin time (trawl wires at full scope) in Universal Time Code

General Data Type: NUMBER

End UTC

CC ID: 355655
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

trawl end time (haul back begun) in Universal Time Code

General Data Type: NUMBER

event duration

CC ID: 355656
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

duration of trawl between begin and end times

General Data Type: NUMBER

start lat

CC ID: 355657
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

N Latitude at trawl begin time in ddmm.mmm format

General Data Type: NUMBER

start lon

CC ID: 355658
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

W Longitude at trawl begin time in ddmm.mmm format

General Data Type: NUMBER

end lat

CC ID: 355659
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

N Latitude at trawl end time in ddmm.mmm format

General Data Type: NUMBER

end lon

CC ID: 355660
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

W Longitude at trawl end time in ddmm.mmm format

General Data Type: NUMBER

beg depth

CC ID: 355661
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 5
Required: Yes
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

depth of bottom in meters at begin trawl time

General Data Type: NUMBER

end depth

CC ID: 355662
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 5
Required: Yes
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

depth of bottom in meters at end trawl time

General Data Type: NUMBER

nominal trawl dist.

CC ID: 355663
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 5
Required: Yes
Primary Key: No
Precision: 4
Scale: 3
Status: Active
Description:

nominal distance between trawl begin and trawl end positions in nautical miles

General Data Type: NUMBER

trawl distance

CC ID: 355664
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 4
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

nominal distance between trawl begin and trawl end positions in meters

General Data Type: NUMBER

Geog. Loc.

CC ID: 355665
Seq. Order: 15
Data Storage Type: CHARACTER
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

description of geographic location of trawl

General Data Type: CHARACTER

surface T

CC ID: 355666
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 4
Required: Yes
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

sea surface temperature in degrees C

General Data Type: NUMBER

bottom T

CC ID: 355667
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 4
Required: Yes
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

sea bottom temperature in degrees C

General Data Type: NUMBER

Data Collected & Comments

CC ID: 355668
Seq. Order: 18
Data Storage Type: CHARACTER
Max Length: 120
Required: No
Primary Key: No
Status: Active
Description:

comments regarding trawl operation and catch

General Data Type: CHARACTER

Catalog Details

Catalog Item ID: 35464
GUID: gov.noaa.nmfs.inport:35464
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-11-01 16:51+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-11-02
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-11-02
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-11-02