Slide Menu
System Maintenance Notice, Sunday, January 23, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

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: 2019-06-04 13:14+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-02-28