Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FE (Fish Ecology) Division > Oceanographic Trawl Data - Juvenile Salmon & Oc... >

Ocean Trawl Catch Data

Entity (ENT)  |  Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:35563  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Junveile Salmon and Associated Nekton Captured in Ocean Salmon Surveys.

Description

Junveile Salmon and Associated Nekton Captured in Ocean Salmon Surveys.

Entity Information

Entity Type
Spreadsheet

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

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