Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FE (Fish Ecology) Division > Juvenile Salmonid Metrics - Juvenile Salmon & O... >

Ocean Juvenile Salmon Metrics

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

Summary

Abstract

Metrics for Salmon Collected in Ocean Salmon Surveys.

Description

Metrics for Salmon Collected 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).
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.
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.
Lab_Fork_Length_millimeters
NUMBER 		The fork length recorded in the lab. Units for values are millimeters.
Lab_Weight_grams
NUMBER 		The salmon weight recorded in the lab. Units for values are grams.
PIT_Code
VARCHAR2 		PIT Tag for individual fish.
Coded_Wire_Tag_Number
VARCHAR2 		The number assigned to a coded wire tag.
Genetic_Stock_Best_Estimate
VARCHAR2 		The best estimate at genetic stock.
Genetic_Stock_Best_Estimate_Probability
NUMBER 		The probability of correct assignment of genetic stock. Units for values are Probability.
Genetic_Stock_Second_Best_Estimate
VARCHAR2 		The second best estimate at genetic stock.
Genetic_Stock_Second_Best_Estimate_Probability
NUMBER 		The probability of correct assignment with second best estimate of genetic stock. Units for values are Probability.
Insulin_Like_Growth_Factor_One_nanograms_per_milliliter
NUMBER 		The measurement of hormone level in salmon from laboratory analysis. Units for values are nanograms per milliliter.
Parentage_Based_Tag_Hatchery_Assignment
VARCHAR2 		The genetically assigned hatchery using parentage based tags.
Parentage_Based_Tag_Probability
NUMBER 		The probability of correct assignment of hatchery using parentage based tags. Units for values are Probability.
Fork_Length_millimeter_Freshwater_Emmigration_Otolith
NUMBER 		The fork length at freshwater emmigration, estimated using otoliths. Units for values are millimeters.

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 Juvenile Salmon Metrics
Short Name: Ocean Juvenile Salmon Metrics
Status: Planned
Abstract:

Metrics for Salmon Collected in Ocean Salmon Surveys.

Entity Information

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

Metrics for Salmon Collected 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
 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
 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
 Lab_Fork_Length_millimeters NUMBER The fork length recorded in the lab. Units for values are millimeters.
100
 Lab_Weight_grams NUMBER The salmon weight recorded in the lab. Units for values are grams.
100
 PIT_Code VARCHAR2 PIT Tag for individual fish.
100
 Coded_Wire_Tag_Number VARCHAR2 The number assigned to a coded wire tag.
100
 Genetic_Stock_Best_Estimate VARCHAR2 The best estimate at genetic stock.
100
 Genetic_Stock_Best_Estimate_Probability NUMBER The probability of correct assignment of genetic stock. Units for values are Probability.
100
 Genetic_Stock_Second_Best_Estimate VARCHAR2 The second best estimate at genetic stock.
100
 Genetic_Stock_Second_Best_Estimate_Probability NUMBER The probability of correct assignment with second best estimate of genetic stock. Units for values are Probability.
100
 Insulin_Like_Growth_Factor_One_nanograms_per_milliliter NUMBER The measurement of hormone level in salmon from laboratory analysis. Units for values are nanograms per milliliter.
100
 Parentage_Based_Tag_Hatchery_Assignment VARCHAR2 The genetically assigned hatchery using parentage based tags.
100
 Parentage_Based_Tag_Probability NUMBER The probability of correct assignment of hatchery using parentage based tags. Units for values are Probability.
100
 Fork_Length_millimeter_Freshwater_Emmigration_Otolith NUMBER The fork length at freshwater emmigration, estimated using otoliths. Units for values are millimeters.

Attribute Details

Cruise_Number

CC ID: 733310
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: 733311
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: 733312
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: 733313
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: 733314
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: 733315
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: 733316
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: 733317
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: 733318
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

Start_Latitude_Decimal_Degrees_North

CC ID: 733319
Seq. Order: 10
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: 733320
Seq. Order: 11
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

Salmon_ID_Number

CC ID: 733321
Seq. Order: 12
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: 733322
Seq. Order: 13
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: 733323
Seq. Order: 14
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: 733324
Seq. Order: 15
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: 733325
Seq. Order: 16
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: 733326
Seq. Order: 17
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: 733327
Seq. Order: 18
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: 733328
Seq. Order: 19
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: 733329
Seq. Order: 20
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: 733330
Seq. Order: 21
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: 733331
Seq. Order: 22
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

Lab_Fork_Length_millimeters

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

The fork length recorded in the lab. Units for values are millimeters.
General Data Type: NUMBER
Unit of Measure: millimeters

Lab_Weight_grams

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

The salmon weight recorded in the lab. Units for values are grams.
General Data Type: NUMBER
Unit of Measure: grams

PIT_Code

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

PIT Tag for individual fish.
General Data Type: VARCHAR2

Coded_Wire_Tag_Number

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

The number assigned to a coded wire tag.
General Data Type: VARCHAR2

Genetic_Stock_Best_Estimate

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

The best estimate at genetic stock.
General Data Type: VARCHAR2

Genetic_Stock_Best_Estimate_Probability

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

The probability of correct assignment of genetic stock. Units for values are Probability.
General Data Type: NUMBER
Unit of Measure: Probability

Genetic_Stock_Second_Best_Estimate

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

The second best estimate at genetic stock.
General Data Type: VARCHAR2

Genetic_Stock_Second_Best_Estimate_Probability

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

The probability of correct assignment with second best estimate of genetic stock. Units for values are Probability.
General Data Type: NUMBER
Unit of Measure: Probability

Insulin_Like_Growth_Factor_One_nanograms_per_milliliter

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

The measurement of hormone level in salmon from laboratory analysis. Units for values are nanograms per milliliter.
General Data Type: NUMBER
Unit of Measure: nanograms per milliliter

Parentage_Based_Tag_Hatchery_Assignment

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

The genetically assigned hatchery using parentage based tags.
General Data Type: VARCHAR2

Parentage_Based_Tag_Probability

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

The probability of correct assignment of hatchery using parentage based tags. Units for values are Probability.
General Data Type: NUMBER
Unit of Measure: Probability

Fork_Length_millimeter_Freshwater_Emmigration_Otolith

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

The fork length at freshwater emmigration, estimated using otoliths. Units for values are millimeters.
General Data Type: NUMBER
Unit of Measure: millimeters

Catalog Details

Catalog Item ID: 37571
GUID: gov.noaa.nmfs.inport:37571
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-04-03 14:18+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