FishTable
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 27790
| Published / External
Created: 2015-10-07
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 27787
ID: 27790
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | FishTable |
---|---|
Short Name | FishTable |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
-no description- |
* Purpose | |
Notes |
Loaded by FGDC Metadata Uploader, batch 7221, 10-07-2015 19:12 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description |
-no description- |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | Year | Unknown | Year of sampling |
100 | No | No | Month | Unknown | Month that fish were collected |
100 | No | No | Date | Unknown | Date the fish were captured |
100 | No | No | LocationName | VARCHAR2 | Location where fish were caught. Restricted to accepted list. |
100 | No | No | Stomach# | Unknown | Unique number assigned to each fish. THIS IS THE PRIMARY KEY. |
100 | No | No | OtoSheet# | Unknown | Sheet the otolith is on. |
100 | No | No | OtoSample# | Unknown | Alpha-numeric location on otolith sheet that contains otolith |
100 | No | No | OtolithMarked? | Unknown | Was the otolith marked? Yes, No, NA (not able to read) |
100 | No | No | MarkID | Unknown | Thermal mark ID |
100 | No | No | Set# | Unknown | Alpha-numeric identifier for the individual fishing events |
100 | No | No | Species | Unknown | Specie of fish collected and assigned a stomach number (Restricted to Chum or Pink) |
100 | No | No | Sex | Unknown | Sex of the fish collected. M = male; F = female |
100 | No | No | ForkLength | Unknown | Length of fish as: mid-eye to fork (fork length). Measured in mm. No weights taken in field |
100 | No | No | StdLength | Unknown | Length of fish as: snout to hypural (standard length). Measured in mm. |
100 | No | No | GonadMass | Unknown | Weight of gonads, measured in grams (g) |
100 | No | No | Notes | Unknown | Comments about fish or collection. |
100 | No | No | StomachFullWt | Unknown | Weight of stomach with content (g) |
100 | No | No | StomachEmptyWt | Unknown | Weight of stomach without content (g) |
100 | No | No | DigestionCode | VARCHAR2 | State of digestion of contents. 0 = Fresh; 1 = Some digested; 2 = Mostly digested; 3 = empty stomach |
100 | No | No | 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 | No | No | ProcessingDate | Unknown | Date the stomach contents were examined |
100 | No | No | Processor | VARCHAR2 | Last name of processor. Fergusson = Emily Fergusson; Sturdevant = Molly Sturdevant |
100 | No | No | ProcessingComments | Unknown | Comments about processing |
100 | No | No | PrimaryKey | Unknown | Primary Key |
100 | No | No | gear | Unknown | anchovy seine (AS) or adult purse seine (PS) or Nordic trawl (NT) |
Attribute Details
Attribute Name | Year |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Year of sampling |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Month |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Month that fish were collected |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Date |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date the fish were captured |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LocationName |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Location where fish were caught. Restricted to accepted list. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Stomach# |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique number assigned to each fish. THIS IS THE PRIMARY KEY. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OtoSheet# |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sheet the otolith is on. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OtoSample# |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Alpha-numeric location on otolith sheet that contains otolith |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OtolithMarked? |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was the otolith marked? Yes, No, NA (not able to read) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MarkID |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Thermal mark ID |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Set# |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Alpha-numeric identifier for the individual fishing events |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Species |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Specie of fish collected and assigned a stomach number (Restricted to Chum or Pink) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Sex |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sex of the fish collected. M = male; F = female |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ForkLength |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Length of fish as: mid-eye to fork (fork length). Measured in mm. No weights taken in field |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | StdLength |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Length of fish as: snout to hypural (standard length). Measured in mm. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GonadMass |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight of gonads, measured in grams (g) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Notes |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments about fish or collection. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | StomachFullWt |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight of stomach with content (g) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | StomachEmptyWt |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight of stomach without content (g) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DigestionCode |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State of digestion of contents. 0 = Fresh; 1 = Some digested; 2 = Mostly digested; 3 = empty stomach |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0, 1, 2, 3 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | StomachFullness |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0, 1, 10, 100, 110, 25, 50, 75 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ProcessingDate |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date the stomach contents were examined |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Processor |
---|---|
Seq. Order | |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Last name of processor. Fergusson = Emily Fergusson; Sturdevant = Molly Sturdevant |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | "Fergusson", "Sturdevant" |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ProcessingComments |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments about processing |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PrimaryKey |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Primary Key |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
anchovy seine (AS) or adult purse seine (PS) or Nordic trawl (NT) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2016-05-04 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-05-04 |
Tags |
---|