FishTable
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:27790 | Updated: August 9, 2022 | Published / External
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
|
|
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: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-05-04 |
| Owner Org: | AFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-05-04 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-05-04 |