Item Identification

Title: Ocean Juvenile Salmon Trophic Parasite Data
Short Name: Ocean Juvenile Salmon Trophic Parasite Data
Status: Planned
Abstract:

Trophically Transmitted Parasite Data for Juvenile Salmon collected in Ocean Salmon Surveys.

Entity Information

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

Trophically Transmitted Parasite Data for 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
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
Lab_Weight_grams NUMBER The salmon weight recorded in the lab. Units for values are grams.
100
Parasite_Species_Genus_species VARCHAR2 The Latin name of parasites encountered in the salmon.
100
Parasite_Species_Location VARCHAR2 The description of where in the salmon the parasites were discovered.
100
Parsite_Species_Count NUMBER The number of each parasite species. Units for values are whole number.

Attribute Details

Cruise_Number

CC ID: 733344
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: 733345
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: 733346
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: 733347
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: 733348
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: 733349
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: 733350
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: 733351
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: 733352
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: 733353
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: 733354
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: 733355
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: 733356
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: 733357
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: 733358
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: 733359
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: 733360
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: 733361
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: 733362
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: 733363
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: 733364
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

Lab_Weight_grams

CC ID: 733365
Seq. Order: 22
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

Parasite_Species_Genus_species

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

The Latin name of parasites encountered in the salmon.

General Data Type: VARCHAR2

Parasite_Species_Location

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

The description of where in the salmon the parasites were discovered.

General Data Type: VARCHAR2

Parsite_Species_Count

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

The number of each parasite species. Units for values are whole number.

General Data Type: NUMBER
Unit of Measure: whole number

Catalog Details

Catalog Item ID: 37572
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