Fish
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:27939 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Fish |
|---|---|
| Short Name: | Fish |
| Status: | In Work |
| Abstract: |
This table contains the bioenergetic data for all fish anylized. |
| Notes: |
Loaded by FGDC Metadata Uploader, batch 7301, 10-13-2015 19:37 |
Entity Information
| Description: |
This table contains the bioenergetic data for all fish anylized. |
|---|
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
Unique_ID | Unknown | Used to link Fish table to ADFG-GOA table | |
|
100
|
UI_SECM_HAUL | Unknown | Unique id for SECM samples to link to SECM database Haul table | |
|
100
|
UI_GOA_STATIONNAME | Unknown | Unique id for GOAIERP & GOA samples to link to GOA database Station table | |
|
100
|
UI_YUKON_SAMPLEID | Unknown | Unique id for Yukon samples to link to Yukon database Samples table | |
|
100
|
UI_EMA_ALTSTATIONNAME | Unknown | Unique id for EMA samples to link to EMA database CATCH table | |
|
100
|
Year | Unknown | year sample was collected | |
|
100
|
Project | VARCHAR2 | name of project collecting samples, see project table | |
|
100
|
Species | VARCHAR2 | species of fish | |
|
100
|
TSN_species | Unknown | unique identifier for species code - see Species_TSN_lookup table | |
|
100
|
Station#/Haul# | Unknown | Station where fish was captured | |
|
100
|
FIN | Unknown | Fish Identification Number = YYYYPPFFFF: Y is year, P is project (see project table), F is four digit fish # | |
|
100
|
FEDZ_Fish# | Unknown | Unique number assigned to each fish, not unique between species - Used prior to 2014 sampling. | |
|
100
|
Field_Fish# | Unknown | number assigned to the fish in the field, must be linked to station and species to be unique - Used prior to 2014 sampling | |
|
100
|
SIN | Unknown | Sample Identification Number, unique identifier to the NUT lab projects | |
|
100
|
Length | Unknown | frozen fork length (mm) of fish | |
|
100
|
Weight | Unknown | frozen weight (g) of fish | |
|
100
|
StomachFull | Unknown | weight (g) of stomach with contents | |
|
100
|
StomachEmpty | Unknown | weight (g) of stomach without contents | |
|
100
|
Content_wt_method | Unknown | 1 = subtraction, 2 = prey weight (empty weight will be 0) | |
|
100
|
Full | Unknown | stomach fullness (percent) | |
|
100
|
TrayWt | Unknown | weight of tray | |
|
100
|
DryWtWithTray | Unknown | weight of dried fish & tray | |
|
100
|
%DW | Unknown | percent dry weight of energy fish | |
|
100
|
cal/gDW | Unknown | calories per gram dry weight of energy fish (this is the data output from the calorimeter) | |
|
100
|
cal/gWW | Unknown | calories per gram wet weight of energy fish | |
|
100
|
ProcDate | Unknown | date stomach was processed | |
|
100
|
Processor | Unknown | name of processor | |
|
100
|
Length/weight | VARCHAR2 | Yes if length and/or weight was taken on fish | |
|
100
|
Otoltih | VARCHAR2 | Yes if otolith was removed | |
|
100
|
Genetics | VARCHAR2 | Yes if genetic clip was taken | |
|
100
|
DietFish | VARCHAR2 | If fish was processed for diet | |
|
100
|
EnergyFish | VARCHAR2 | If fish was processed for energy | |
|
100
|
CWT | VARCHAR2 | If fish had a cwt or was missing it's adipose fin, cwt information is in the cwt table | |
|
100
|
Comments | Unknown | comments about fish or processing |
Attribute Details
Unique_ID
CC ID: 232288
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Used to link Fish table to ADFG-GOA table |
| Allowed Values: | No domain defined. |
UI_SECM_HAUL
CC ID: 232289
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique id for SECM samples to link to SECM database Haul table |
| Allowed Values: | No domain defined. |
UI_GOA_STATIONNAME
CC ID: 232290
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique id for GOAIERP & GOA samples to link to GOA database Station table |
| Allowed Values: | No domain defined. |
UI_YUKON_SAMPLEID
CC ID: 232291
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique id for Yukon samples to link to Yukon database Samples table |
| Allowed Values: | No domain defined. |
UI_EMA_ALTSTATIONNAME
CC ID: 232292
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique id for EMA samples to link to EMA database CATCH table |
| Allowed Values: | No domain defined. |
Year
CC ID: 232293
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
year sample was collected |
| Allowed Values: | No domain defined. |
Project
CC ID: 232294
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of project collecting samples, see project table |
| Allowed Values: | ACES, ArcticEIS, BSIERP-BASIS12, EMA, EVOS-HCM, Freezer longevity, GOA, GOA/ADFG, GOAIERP, NBS, SEBS, SECM, Yukon-LPW, Yukon-Offshore, Yukon-River |
Species
CC ID: 232295
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
species of fish |
| Allowed Values: | ATF, Chinook salmon, Chum salmon, Coho salmon, Pacific cod, Pink salmon, Pollock, Rockfish, Sockeye salmon |
TSN_species
CC ID: 232296
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
unique identifier for species code - see Species_TSN_lookup table |
| Allowed Values: | No domain defined. |
Station#/Haul#
CC ID: 232297
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Station where fish was captured |
| Allowed Values: | No domain defined. |
FIN
CC ID: 232298
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Fish Identification Number = YYYYPPFFFF: Y is year, P is project (see project table), F is four digit fish # |
| Allowed Values: | No domain defined. |
FEDZ_Fish#
CC ID: 232299
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique number assigned to each fish, not unique between species - Used prior to 2014 sampling. |
| Allowed Values: | No domain defined. |
Field_Fish#
CC ID: 232300
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
number assigned to the fish in the field, must be linked to station and species to be unique - Used prior to 2014 sampling |
| Allowed Values: | No domain defined. |
SIN
CC ID: 232301
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sample Identification Number, unique identifier to the NUT lab projects |
| Allowed Values: | No domain defined. |
Length
CC ID: 232302
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
frozen fork length (mm) of fish |
| Allowed Values: | No domain defined. |
Weight
CC ID: 232303
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
frozen weight (g) of fish |
| Allowed Values: | No domain defined. |
StomachFull
CC ID: 232304
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
weight (g) of stomach with contents |
| Allowed Values: | No domain defined. |
StomachEmpty
CC ID: 232305
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
weight (g) of stomach without contents |
| Allowed Values: | No domain defined. |
Content_wt_method
CC ID: 232306
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
1 = subtraction, 2 = prey weight (empty weight will be 0) |
| Allowed Values: | No domain defined. |
Full
CC ID: 232307
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
stomach fullness (percent) |
| Allowed Values: | No domain defined. |
TrayWt
CC ID: 232308
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
weight of tray |
| Allowed Values: | No domain defined. |
DryWtWithTray
CC ID: 232309
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
weight of dried fish & tray |
| Allowed Values: | No domain defined. |
%DW
CC ID: 232310
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
percent dry weight of energy fish |
| Allowed Values: | No domain defined. |
cal/gDW
CC ID: 232311
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
calories per gram dry weight of energy fish (this is the data output from the calorimeter) |
| Allowed Values: | No domain defined. |
cal/gWW
CC ID: 232312
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
calories per gram wet weight of energy fish |
| Allowed Values: | No domain defined. |
ProcDate
CC ID: 232313
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date stomach was processed |
| Allowed Values: | No domain defined. |
Processor
CC ID: 232314
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of processor |
| Allowed Values: | No domain defined. |
Length/weight
CC ID: 232315
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Yes if length and/or weight was taken on fish |
| Allowed Values: | False, True |
Otoltih
CC ID: 232316
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Yes if otolith was removed |
| Allowed Values: | False, True |
Genetics
CC ID: 232317
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Yes if genetic clip was taken |
| Allowed Values: | False, True |
DietFish
CC ID: 232318
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
If fish was processed for diet |
| Allowed Values: | False, True |
EnergyFish
CC ID: 232319
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
If fish was processed for energy |
| Allowed Values: | False, True |
CWT
CC ID: 232320
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
If fish had a cwt or was missing it's adipose fin, cwt information is in the cwt table |
| Allowed Values: | False, True |
Comments
CC ID: 232321
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
comments about fish or processing |
| Allowed Values: | No domain defined. |
Catalog Details
| Catalog Item ID: | 27939 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:27939 |
| Metadata Record Created By: | Emily A Fergusson |
| Metadata Record Created: | 2015-10-13 19:37+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2019-05-24 |
| Owner Org: | AFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2019-05-24 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2020-05-24 |