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: FishTable
Short Name: FishTable
Status: Completed
Abstract:

-no description-

Notes:

Loaded by FGDC Metadata Uploader, batch 7221, 10-07-2015 19:12

Entity Information

Description:

-no description-

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Year Unknown Year of sampling
100
Month Unknown Month that fish were collected
100
Date Unknown Date the fish were captured
100
LocationName VARCHAR2 Location where fish were caught. Restricted to accepted list.
100
Stomach# Unknown Unique number assigned to each fish. THIS IS THE PRIMARY KEY.
100
OtoSheet# Unknown Sheet the otolith is on.
100
OtoSample# Unknown Alpha-numeric location on otolith sheet that contains otolith
100
OtolithMarked? Unknown Was the otolith marked? Yes, No, NA (not able to read)
100
MarkID Unknown Thermal mark ID
100
Set# Unknown Alpha-numeric identifier for the individual fishing events
100
Species Unknown Specie of fish collected and assigned a stomach number (Restricted to Chum or Pink)
100
Sex Unknown Sex of the fish collected. M = male; F = female
100
ForkLength Unknown Length of fish as: mid-eye to fork (fork length). Measured in mm. No weights taken in field
100
StdLength Unknown Length of fish as: snout to hypural (standard length). Measured in mm.
100
GonadMass Unknown Weight of gonads, measured in grams (g)
100
Notes Unknown Comments about fish or collection.
100
StomachFullWt Unknown Weight of stomach with content (g)
100
StomachEmptyWt Unknown Weight of stomach without content (g)
100
DigestionCode VARCHAR2 State of digestion of contents. 0 = Fresh; 1 = Some digested; 2 = Mostly digested; 3 = empty stomach
100
StomachFullness VARCHAR2 Fullness of stomach. 0, 1 (trace), 10, 25, 50, 75, 100, or 110% full; can't calculate %BW because no fish body weight
100
ProcessingDate Unknown Date the stomach contents were examined
100
Processor VARCHAR2 Last name of processor. Fergusson = Emily Fergusson; Sturdevant = Molly Sturdevant
100
ProcessingComments Unknown Comments about processing
100
PrimaryKey Unknown Primary Key
100
gear Unknown anchovy seine (AS) or adult purse seine (PS) or Nordic trawl (NT)

Attribute Details

Year

CC ID: 230412
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Year of sampling

Allowed Values: No domain defined.

Month

CC ID: 230413
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Month that fish were collected

Allowed Values: No domain defined.

Date

CC ID: 230414
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Date the fish were captured

Allowed Values: No domain defined.

LocationName

CC ID: 230415
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Location where fish were caught. Restricted to accepted list.

Allowed Values: Bainbridge Point, Bishop Rock, Chenega Point, Fox Farm, Hawk Inlet, Hawk Inlet2, Hawk Inlet3, Hawk Inlet4, Herring Bay, ISA, ISB, ISC, ISD, Kingsmill, Main Bay, Middle Cape, Mummy Bay, North Chenega, Point Gardner, Point Nowell, Shelter Bay, Snug Harbor, Squire Island, Squirrel Bay, UCA, UCB, UCC, UCD

Stomach#

CC ID: 230416
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Unique number assigned to each fish. THIS IS THE PRIMARY KEY.

Allowed Values: No domain defined.

OtoSheet#

CC ID: 230417
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Sheet the otolith is on.

Allowed Values: No domain defined.

OtoSample#

CC ID: 230418
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Alpha-numeric location on otolith sheet that contains otolith

Allowed Values: No domain defined.

OtolithMarked?

CC ID: 230419
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Was the otolith marked? Yes, No, NA (not able to read)

Allowed Values: No domain defined.

MarkID

CC ID: 230420
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Thermal mark ID

Allowed Values: No domain defined.

Set#

CC ID: 230421
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Alpha-numeric identifier for the individual fishing events

Allowed Values: No domain defined.

Species

CC ID: 230422
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Specie of fish collected and assigned a stomach number (Restricted to Chum or Pink)

Allowed Values: No domain defined.

Sex

CC ID: 230423
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Sex of the fish collected. M = male; F = female

Allowed Values: No domain defined.

ForkLength

CC ID: 230424
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Length of fish as: mid-eye to fork (fork length). Measured in mm. No weights taken in field

Allowed Values: No domain defined.

StdLength

CC ID: 230425
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Length of fish as: snout to hypural (standard length). Measured in mm.

Allowed Values: No domain defined.

GonadMass

CC ID: 230426
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Weight of gonads, measured in grams (g)

Allowed Values: No domain defined.

Notes

CC ID: 230427
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Comments about fish or collection.

Allowed Values: No domain defined.

StomachFullWt

CC ID: 230428
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Weight of stomach with content (g)

Allowed Values: No domain defined.

StomachEmptyWt

CC ID: 230429
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Weight of stomach without content (g)

Allowed Values: No domain defined.

DigestionCode

CC ID: 230430
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

State of digestion of contents. 0 = Fresh; 1 = Some digested; 2 = Mostly digested; 3 = empty stomach

Allowed Values: 0, 1, 2, 3

StomachFullness

CC ID: 230431
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Fullness of stomach. 0, 1 (trace), 10, 25, 50, 75, 100, or 110% full; can't calculate %BW because no fish body weight

Allowed Values: 0, 1, 10, 100, 110, 25, 50, 75

ProcessingDate

CC ID: 230432
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Date the stomach contents were examined

Allowed Values: No domain defined.

Processor

CC ID: 230433
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Last name of processor. Fergusson = Emily Fergusson; Sturdevant = Molly Sturdevant

Allowed Values: "Fergusson", "Sturdevant"

ProcessingComments

CC ID: 230434
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Comments about processing

Allowed Values: No domain defined.

PrimaryKey

CC ID: 230435
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Primary Key

Allowed Values: No domain defined.

gear

CC ID: 230436
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

anchovy seine (AS) or adult purse seine (PS) or Nordic trawl (NT)

Allowed Values: No domain defined.

Catalog Details

Catalog Item ID: 27790
GUID: gov.noaa.nmfs.inport:27790
Metadata Record Created By: Emily A Fergusson
Metadata Record Created: 2015-10-07 19:12+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2016-05-04
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2017-05-05