Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FE (Fish Ecology) Division > Juvenile Salmonid Trophic Data - Juvenile Salmo... >

Ocean Juvenile Salmon Stomach Contents

Entity (ENT)  |  Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:35564  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: Ocean Juvenile Salmon Stomach Contents
Short Name: Ocean Juvenile Salmon Stomach Contents
Status: Planned
Abstract:

Stomach Contents of Juvenile Salmon Collected in Ocean Salmon Surveys.

Entity Information

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

Stomach Contents of Juvenile 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
 Salmon_Field_Length_millimeters NUMBER The length of the fish as measured in the field. Units for values are mm.
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
 Salmon_Lab_Length_millimeters NUMBER The Length of the fish as measured in the Laboratory. Units for values are mm.
100
 Salmon_Lab_Weight_grams NUMBER The weight of the fish as measured in the Laboratory. Units for values are g.
100
 Stomach_Condition_Description VARCHAR2 Descriptions of the condition of stomach contents.
100
 Prey_Item_Genus_species VARCHAR2 The latin classification assigned to stomach content.
100
 Prey_Item_Common_Name VARCHAR2 The common name assigned to stomach content.
100
 Prey_Item_Life_History_Stage VARCHAR2 The life history stage determined for stomach content.
100
 Prey_Item_Count NUMBER The count of each prey item in stomach content. Units for values are whole number.
100
 Prey_Item_Weight_grams NUMBER The weight of each prey item in stomach content. Units for values are grams.
100
 Prey_Item_Condition_Description VARCHAR2 Comments on prey item condition and description.

Attribute Details

Cruise_Number

CC ID: 733281
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: 733282
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: 733283
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: 733284
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: 733285
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: 733286
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: 733287
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: 733288
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: 733289
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: 733290
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: 733291
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: 733292
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: 733293
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: 733294
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: 733295
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: 733296
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: 733297
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

Salmon_Field_Length_millimeters

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

The length of the fish as measured in the field. Units for values are mm.
General Data Type: NUMBER
Unit of Measure: mm

Type_of_Length

CC ID: 733299
Seq. Order: 19
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: 733300
Seq. Order: 20
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

Salmon_Lab_Length_millimeters

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

The Length of the fish as measured in the Laboratory. Units for values are mm.
General Data Type: NUMBER
Unit of Measure: mm

Salmon_Lab_Weight_grams

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

The weight of the fish as measured in the Laboratory. Units for values are g.
General Data Type: NUMBER
Unit of Measure: g

Stomach_Condition_Description

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

Descriptions of the condition of stomach contents.
General Data Type: VARCHAR2

Prey_Item_Genus_species

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

The latin classification assigned to stomach content.
General Data Type: VARCHAR2

Prey_Item_Common_Name

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

The common name assigned to stomach content.
General Data Type: VARCHAR2

Prey_Item_Life_History_Stage

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

The life history stage determined for stomach content.
General Data Type: VARCHAR2

Prey_Item_Count

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

The count of each prey item in stomach content. Units for values are whole number.
General Data Type: NUMBER
Unit of Measure: whole number

Prey_Item_Weight_grams

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

The weight of each prey item in stomach content. Units for values are grams.
General Data Type: NUMBER
Unit of Measure: grams

Prey_Item_Condition_Description

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

Comments on prey item condition and description.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 35564
GUID: gov.noaa.nmfs.inport:35564
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