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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Stomach Contents of Juvenile Salmon Collected in Ocean Salmon Surveys.

Description

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

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 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