Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Ocean Trawl Catch Data
Short Name: Ocean Trawl Catch Data
Status: Planned
Abstract:

Junveile Salmon and Associated Nekton Captured in Ocean Salmon Surveys.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Schema Name: PARR
Description:

Junveile Salmon and Associated Nekton Captured in Ocean Salmon Surveys.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Cruise_Number NUMBER The numerical designation of the cruise in sequence of research performed.
100
Sample_Date_Local DATE The local time data were collected. Units for values are Month/Day/Year.
100
Year_ NUMBER The year the data were collected. Units for values are Year.
100
Vessel_Name VARCHAR2 The name of the vessel used to collect the data.
100
Transect_Name VARCHAR2 The name of the location where the data were collected.
100
Distance_Offshore_Nautical_Miles NUMBER The distance offshore the data were collected. Units for values are nautical miles.
100
Station_Depth_Meters NUMBER The bottom depth of the station where the data were collected. Units for values are Meters.
100
Station_Code VARCHAR2 The code created to name the date and location when and where the data were collected.
100
Start_Time_Local DATE The local time trawl started collecting data. Units for values are hh:mm (24 hour).
100
End_Time_Local DATE The local time trawl ended collecting data. Units for values are hh:mm (24 hour).
100
Start_Latitude_Decimal_Degrees_North NUMBER The latitude recorded at start of trawl sampling. Units for values are decimal degrees North.
100
Start_Longitude_Decimal_Degrees_West NUMBER The longitude recorded at start of trawl sampling. Units for values are decimal degrees West.
100
End_Latitude_Decimal_Degrees_North NUMBER The latitude recorded at end of trawl sampling. Units for values are decimal degrees North.
100
End_Longitude_Decimal_Degrees_West NUMBER The longitude recorded at end of trawl sampling. Units for values are decimal degrees West.
100
Trawling_Distance_Km NUMBER The distance the trawl sampled. Units for values are kilometers.
100
Salmon_ID_Number VARCHAR2 The unique identifier of the salmon in sequence of research performed.
100
Common_Name VARCHAR2 The common name of fishes and invertebrates captured in the trawl.
100
Genus_Species VARCHAR2 The Latin name of fishes and invertebrates captured in the trawl.
100
Age_ClassByLength VARCHAR2 The age class of salmon based on their length, which may not be their actual age, but is our best estimate from length.
100
Tagged_Code VARCHAR2 The list of codes assigned to salmon as identifying marks such as coded wire tags.
100
Tagged_Description VARCHAR2 The descriptions of codes assigned to salmon as identifying marks such as coded wire tags.
100
Count_ NUMBER The count of each fish or invertebrate. Units for values are whole number.
100
Field_Length_millimeters NUMBER The field length recorded. Units for values are milimeters.
100
Type_of_Length VARCHAR2 The type of the length measurement recorded.
100
Length_Description VARCHAR2 The description of the type of the length measurement.
100
Method_Saved VARCHAR2 The description of how fishes and invertebrates were retained.
100
Sorting_ID NUMBER The numerical designation of the data point in sequence of data entry - primary key. Units for values are whole number.

Attribute Details

Cruise_Number

CC ID: 733254
Seq. Order: 1
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The numerical designation of the cruise in sequence of research performed.

General Data Type: NUMBER

Sample_Date_Local

CC ID: 733255
Seq. Order: 2
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

The local time data were collected. Units for values are Month/Day/Year.

General Data Type: DATE
Unit of Measure: Month/Day/Year
Format Mask: MM/DD/YYYY

Year_

CC ID: 733256
Seq. Order: 3
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The year the data were collected. Units for values are Year.

General Data Type: NUMBER
Unit of Measure: Year

Vessel_Name

CC ID: 733257
Seq. Order: 4
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The name of the vessel used to collect the data.

General Data Type: VARCHAR2

Transect_Name

CC ID: 733258
Seq. Order: 5
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The name of the location where the data were collected.

General Data Type: VARCHAR2

Distance_Offshore_Nautical_Miles

CC ID: 733259
Seq. Order: 6
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The distance offshore the data were collected. Units for values are nautical miles.

General Data Type: NUMBER
Unit of Measure: nautical miles

Station_Depth_Meters

CC ID: 733260
Seq. Order: 7
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The bottom depth of the station where the data were collected. Units for values are Meters.

General Data Type: NUMBER
Unit of Measure: Meters

Station_Code

CC ID: 733261
Seq. Order: 8
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The code created to name the date and location when and where the data were collected.

General Data Type: VARCHAR2

Start_Time_Local

CC ID: 733262
Seq. Order: 9
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

The local time trawl started collecting data. Units for values are hh:mm (24 hour).

General Data Type: DATE
Unit of Measure: hh:mm (24 hour)
Format Mask: HH24:MI

End_Time_Local

CC ID: 733263
Seq. Order: 10
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

The local time trawl ended collecting data. Units for values are hh:mm (24 hour).

General Data Type: DATE
Unit of Measure: hh:mm (24 hour)
Format Mask: HH24:MI

Start_Latitude_Decimal_Degrees_North

CC ID: 733264
Seq. Order: 11
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The latitude recorded at start of trawl sampling. Units for values are decimal degrees North.

General Data Type: NUMBER
Unit of Measure: decimal degrees North

Start_Longitude_Decimal_Degrees_West

CC ID: 733265
Seq. Order: 12
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The longitude recorded at start of trawl sampling. Units for values are decimal degrees West.

General Data Type: NUMBER
Unit of Measure: decimal degrees West

End_Latitude_Decimal_Degrees_North

CC ID: 733266
Seq. Order: 13
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The latitude recorded at end of trawl sampling. Units for values are decimal degrees North.

General Data Type: NUMBER
Unit of Measure: decimal degrees North

End_Longitude_Decimal_Degrees_West

CC ID: 733267
Seq. Order: 14
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The longitude recorded at end of trawl sampling. Units for values are decimal degrees West.

General Data Type: NUMBER
Unit of Measure: decimal degrees West

Trawling_Distance_Km

CC ID: 733268
Seq. Order: 15
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The distance the trawl sampled. Units for values are kilometers.

General Data Type: NUMBER
Unit of Measure: kilometers

Salmon_ID_Number

CC ID: 733269
Seq. Order: 16
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The unique identifier of the salmon in sequence of research performed.

General Data Type: VARCHAR2

Common_Name

CC ID: 733270
Seq. Order: 17
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The common name of fishes and invertebrates captured in the trawl.

General Data Type: VARCHAR2

Genus_Species

CC ID: 733271
Seq. Order: 18
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The Latin name of fishes and invertebrates captured in the trawl.

General Data Type: VARCHAR2

Age_ClassByLength

CC ID: 733272
Seq. Order: 19
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The age class of salmon based on their length, which may not be their actual age, but is our best estimate from length.

General Data Type: VARCHAR2

Tagged_Code

CC ID: 733273
Seq. Order: 20
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The list of codes assigned to salmon as identifying marks such as coded wire tags.

General Data Type: VARCHAR2

Tagged_Description

CC ID: 733274
Seq. Order: 21
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The descriptions of codes assigned to salmon as identifying marks such as coded wire tags.

General Data Type: VARCHAR2

Count_

CC ID: 733275
Seq. Order: 22
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The count of each fish or invertebrate. Units for values are whole number.

General Data Type: NUMBER
Unit of Measure: whole number

Field_Length_millimeters

CC ID: 733276
Seq. Order: 23
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The field length recorded. Units for values are milimeters.

General Data Type: NUMBER
Unit of Measure: milimeters

Type_of_Length

CC ID: 733277
Seq. Order: 24
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The type of the length measurement recorded.

General Data Type: VARCHAR2

Length_Description

CC ID: 733278
Seq. Order: 25
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The description of the type of the length measurement.

General Data Type: VARCHAR2

Method_Saved

CC ID: 733279
Seq. Order: 26
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The description of how fishes and invertebrates were retained.

General Data Type: VARCHAR2

Sorting_ID

CC ID: 733280
Seq. Order: 27
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The numerical designation of the data point in sequence of data entry - primary key. Units for values are whole number.

General Data Type: NUMBER
Unit of Measure: whole number

Catalog Details

Catalog Item ID: 35563
GUID: gov.noaa.nmfs.inport:35563
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2016-11-04 19:22+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-02-27
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-02-27