Column Notes for BioSampling Data from LHP Cruises

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 32857 | Published / External
Created: 2016-06-03   |   Last Modified: 2023-08-26

Parent: BioSampling Data from LHP Cruises
Data Set (DS) | ID: 32856

ID: 32857
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Column Notes for BioSampling Data from LHP Cruises
Short Name  
* Status In Work
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

Explanation of what each column could include in the bottomfish sampling data.
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
None Hawaiian
None Length
None species
None weight
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
None CNMI
None Guam
None Johnston
None Kona
None MHI
None NWHI
None Oahu
None Samoa
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization Pacific Islands Fisheries Science Center
• » City Honolulu
• » State/Province HI
• Country USA
• » Location Description

NOAA IRC Ford Island Facility

Entity Information

Entity Type Data Table
Active Version? Y
Alias  
Schema Name bfsamp.BFS_BFSAMP_MAIN_V
» Description

Biosampling data from LHP cruises.
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 Yes No cruiseNum VARCHAR The designator for the cruise, e.g. SE-16-01.
100 No No caughtDate DATE The date that the fish was processed in the lab or at sea. Generally, this is done on the same day it was caught.
100 Yes No location VARCHAR2 The island, region or location where the fish was caught.
100 Yes No species VARCHAR2 The 4-letter species code, common or latin name for the species. A separate entity in this same parent item can be used to cross reference species codes and their common or latin names.
100 No No fl_cm NUMBER The length of the fish in centimeters. Fork length is measured from the tip of the snout to the fork of the tail.
100 No No wt_kg NUMBER Body weight of the fish in kilograms before any extractions occurred (round weight).
100 Yes No macroSex CHAR Sex of the fish, F for female, M for male, U for unknown. Gonads that are immature are difficult to determine sex using the naked eye, when the sex is not definite, a U is put into this column.
100 No No gonadWt_g NUMBER Weight of the gonads in grams.
100 No No numOtos VARCHAR2 Were there otoliths extracted and saved from this fish, Yes or No? Or, the # of otos extracted between 0 and 2. Some cruises only indicated Y/N values.
100 Yes Yes fishDatNum VARCHAR2 The unique fish data number assigned to each fish. This contains the abbreviated vessel name, vessel trip number, page number, line number, tag number, and species. After 2009, the page and line number were omitted from the fish data number. The composite cruise and fish id number. These are assigned in continuously increasing order as the cruise progresses, e.g. SE-16-01-101, SE-16-01-102 and should be unique.
100 Yes No ziptie VARCHAR2 The tag number assigned to each individual fish from each trip; used to correlate specimens with catch log. These should be unique, but shouldn't be assumed so (different cruises used varying methods; some didn't use the ziptie method at all).
100 No No notes VARCHAR Additional details about the fish and any of its collected parts.
100 No No LAT_DEG NUMBER The latitude degrees where the fish was caught.
100 No No LAT_MIN NUMBER The latitude minutes where the fish was caught.
100 Yes No LAT_DIR CHAR The latitude direction.
100 No No LONG_DEG NUMBER The longitude degrees of where the fish was caught.
100 No No LONG_MIN NUMBER The longitude minutes of where the fish was caught.
100 Yes No L_SAG NUMBER If the left sagitta was recovered successfully and was extracted intact, a 1 will be entered into this column. If the left sagitta was not extracted successfully, there will be a 0 in the row.
100 Yes No DORSAL_FIN_YN CHAR Was the dorsal fin collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to IRC, ALL these specimens were thrown away!
100 Yes No ANAL_FIN_YN CHAR Was the anal fin collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to IRC, ALL these specimens were thrown away!
100 Yes No GENETICS_YN CHAR Was tissue for genetics collected from this fish, yes(Y) or no (N)? Can most likely retain a sample for genetic analysis from other samples taken from the fish but if there is a yes in this column, a genetic sample was taken and put into DMSO or in a separate Ziploc for future analysis.
100 Yes No ISOTOPES_YN CHAR Were isotopes collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to the IRC ALL these specimens were thrown away!
100 Yes No STOMACH VARCHAR2 Was the Stomach or its contents collected from this fish? (STOMACH/CONTENTS/SPEW) If nothing from the stomach was collected then there will be an N in this column.
100 Yes No EYEBALLS_YN CHAR Were the eyeballs collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to IRC, ALL these specimens were thrown away!
100 No No otoLoc CHAR Once determined, the general physical location of any extracted otoliths.
100 No No Fisher_or_GVI_For RFPGrantOnly VARCHAR2 For ease of searching, I added this column to easily query fish purchased from individual fisherman (Fisher) or fish purchased from the wholesale buyer, Garden Valley Isle (GVI). These fish were purchased under the 2 year RFP starting July 2014-July 2016.
100 No No GONAD_YN VARCHAR2 Was a gonad extracted from this fish and is the whole gonad still available for further processing (jar is stored in Wet Archival Storage)? Yes or No? Created for querying purposes.
100 No No LEFT_Sagittae_Wt_G NUMBER The weight of the left sagittae otolith in grams. NOTE: Oven dried weights were obtained 2007-2013, however, it was found the difference between oven and air-dried weights was insignificant. From 2014 on, otoliths were not oven-dried, but weighed after air drying in scintillation vials for three or more days. Oven dried values can be found in the Otolith_Wts_Msmts Spreadsheet.
100 No No Otolith_Notes VARCHAR2 Any notes associated with both otoliths.
100 No No PIFG_ID_Num VARCHAR2 In October, 2015, a stock assessment fishing project began and fishermen participating in that project provided fish to the LHP for age and growth research. The PIFG ID# is the number on the zip tie tag number attached to the fish when brought to the IRC. This number should be able to link each fish to additional information recoded on the SAP PIFG fishing forms with data collected in the field.
100 No No Purchased_from_PIFG_YN VARCHAR2 For ease of searching, I added this column to easily query fish purchased from PIFG fishermen. They would bring in heads and gonads or juvenile bottomfish LHP asked them to arget at various times throughout the years. On occasion, PIFG asks for a summary of all fish brought in by PIFG.
100 No No Right_Sagittae_Notes VARCHAR2 Any notes associated with the right sagittae, Possible values for this column are noted below.

Attribute Details

Attribute Name cruiseNum
Seq. Order 1
Data Storage Type VARCHAR
Max Length 30
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The designator for the cruise, e.g. SE-16-01.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name caughtDate
Seq. Order 2
Data Storage Type DATE
Max Length 8
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The date that the fish was processed in the lab or at sea. Generally, this is done on the same day it was caught.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The workup date was unkown or was not recorded.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name location
Seq. Order 3
Data Storage Type VARCHAR2
Max Length 15
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The island, region or location where the fish was caught.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name species
Seq. Order 4
Data Storage Type VARCHAR2
Max Length 4
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The 4-letter species code, common or latin name for the species. A separate entity in this same parent item can be used to cross reference species codes and their common or latin names.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name fl_cm
Seq. Order 5
Data Storage Type NUMBER
Max Length 4
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The length of the fish in centimeters. Fork length is measured from the tip of the snout to the fork of the tail.

General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The length was not recorded.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name wt_kg
Seq. Order 6
Data Storage Type NUMBER
Max Length 4
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Body weight of the fish in kilograms before any extractions occurred (round weight).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

No weight was recorded.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name macroSex
Seq. Order 7
Data Storage Type CHAR
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Sex of the fish, F for female, M for male, U for unknown. Gonads that are immature are difficult to determine sex using the naked eye, when the sex is not definite, a U is put into this column.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

If the sex is unknown or was not recorded, then a U should be put into the column.
Allowed Values M, F, U
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name gonadWt_g
Seq. Order 8
Data Storage Type NUMBER
Max Length 6
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Weight of the gonads in grams.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

Gonads were not extracted or gonads were not weighed; check notes.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name numOtos
Seq. Order 9
Data Storage Type VARCHAR2
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Were there otoliths extracted and saved from this fish, Yes or No? Or, the # of otos extracted between 0 and 2. Some cruises only indicated Y/N values.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning
Allowed Values Y,N
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name fishDatNum
Seq. Order 10
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required Yes
Primary Key Yes
Precision  
Scale  
Status Active
Description

The unique fish data number assigned to each fish. This contains the abbreviated vessel name, vessel trip number, page number, line number, tag number, and species. After 2009, the page and line number were omitted from the fish data number. The composite cruise and fish id number. These are assigned in continuously increasing order as the cruise progresses, e.g. SE-16-01-101, SE-16-01-102 and should be unique.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

Every fish MUST have a fish data number to associate it with additional data collected from that fish.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ziptie
Seq. Order 10
Data Storage Type VARCHAR2
Max Length 4
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The tag number assigned to each individual fish from each trip; used to correlate specimens with catch log. These should be unique, but shouldn't be assumed so (different cruises used varying methods; some didn't use the ziptie method at all).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name notes
Seq. Order 12
Data Storage Type VARCHAR
Max Length 4000
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Additional details about the fish and any of its collected parts.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

There was not additional information to report about the fish.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LAT_DEG
Seq. Order 15
Data Storage Type NUMBER
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The latitude degrees where the fish was caught.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The latitude degrees is unknown or it was not recorded.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LAT_MIN
Seq. Order 16
Data Storage Type NUMBER
Max Length 6
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The latitude minutes where the fish was caught.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The latitude minutes is unknown or was not recorded.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LAT_DIR
Seq. Order 17
Data Storage Type CHAR
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The latitude direction.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

The latitude direction can be determined from other specimens provided by the same source.
Allowed Values N, S
Default Value N
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LONG_DEG
Seq. Order 18
Data Storage Type NUMBER
Max Length 3
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The longitude degrees of where the fish was caught.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The longitude degrees is unknown or was not recorded.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LONG_MIN
Seq. Order 19
Data Storage Type NUMBER
Max Length 6
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The longitude minutes of where the fish was caught.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

The longitude minutes is unknown or was not recorded.
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name L_SAG
Seq. Order 30
Data Storage Type NUMBER
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

If the left sagitta was recovered successfully and was extracted intact, a 1 will be entered into this column. If the left sagitta was not extracted successfully, there will be a 0 in the row.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

There should always be a 1 or a 0 entered; the sagitta is either available or it isn't.
Allowed Values 1, 0
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DORSAL_FIN_YN
Seq. Order 34
Data Storage Type CHAR
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Was the dorsal fin collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to IRC, ALL these specimens were thrown away!
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

There will always be a value; the dorsal spine either was or was not collected.
Allowed Values Y, N
Default Value Y
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ANAL_FIN_YN
Seq. Order 35
Data Storage Type CHAR
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Was the anal fin collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to IRC, ALL these specimens were thrown away!
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

Anal fin either was or was not collected however, anal fins are usually only collected from hapu'upu'puu.
Allowed Values Y, N
Default Value N
Foreign Key Relations
Derivation
Validation Rules
Attribute Name GENETICS_YN
Seq. Order 36
Data Storage Type CHAR
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Was tissue for genetics collected from this fish, yes(Y) or no (N)? Can most likely retain a sample for genetic analysis from other samples taken from the fish but if there is a yes in this column, a genetic sample was taken and put into DMSO or in a separate Ziploc for future analysis.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

Genetic tissue was or was not collected. If there is a "N" is this column, it is possible to collect genetic material from the dorsal spine or muscle tissue.
Allowed Values Y, N
Default Value Y
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ISOTOPES_YN
Seq. Order 37
Data Storage Type CHAR
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Were isotopes collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to the IRC ALL these specimens were thrown away!
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

Isotope tissue was or was not collected.
Allowed Values Y, N
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name STOMACH
Seq. Order 38
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Was the Stomach or its contents collected from this fish? (STOMACH/CONTENTS/SPEW) If nothing from the stomach was collected then there will be an N in this column.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

The stomach or its contents either were or were not collected.
Allowed Values Stomach, Contents, Spew, N
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name EYEBALLS_YN
Seq. Order 39
Data Storage Type CHAR
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Were the eyeballs collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to IRC, ALL these specimens were thrown away!
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning
Allowed Values Y, N
Default Value N
Foreign Key Relations
Derivation
Validation Rules
Attribute Name otoLoc
Seq. Order 40
Data Storage Type CHAR
Max Length 500
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Once determined, the general physical location of any extracted otoliths.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NO
Null Value Meaning

The opercles either were or were not collected.
Allowed Values Y, N
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name Fisher_or_GVI_For RFPGrantOnly
Seq. Order  
Data Storage Type VARCHAR2
Max Length 10
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

For ease of searching, I added this column to easily query fish purchased from individual fisherman (Fisher) or fish purchased from the wholesale buyer, Garden Valley Isle (GVI). These fish were purchased under the 2 year RFP starting July 2014-July 2016.

General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

This fish wasn't purchased under this RFP.
Allowed Values Fisher, GVI
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name GONAD_YN
Seq. Order  
Data Storage Type VARCHAR2
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Was a gonad extracted from this fish and is the whole gonad still available for further processing (jar is stored in Wet Archival Storage)? Yes or No? Created for querying purposes.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value Yes
Null Value Meaning

whether or not there is still a whole gonad wasn't properly documented
Allowed Values Y, N
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LEFT_Sagittae_Wt_G
Seq. Order  
Data Storage Type NUMBER
Max Length 5
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The weight of the left sagittae otolith in grams. NOTE: Oven dried weights were obtained 2007-2013, however, it was found the difference between oven and air-dried weights was insignificant. From 2014 on, otoliths were not oven-dried, but weighed after air drying in scintillation vials for three or more days. Oven dried values can be found in the Otolith_Wts_Msmts Spreadsheet.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name Otolith_Notes
Seq. Order  
Data Storage Type VARCHAR2
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Any notes associated with both otoliths.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

NO NOTES
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PIFG_ID_Num
Seq. Order  
Data Storage Type VARCHAR2
Max Length 10
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

In October, 2015, a stock assessment fishing project began and fishermen participating in that project provided fish to the LHP for age and growth research. The PIFG ID# is the number on the zip tie tag number attached to the fish when brought to the IRC. This number should be able to link each fish to additional information recoded on the SAP PIFG fishing forms with data collected in the field.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name Purchased_from_PIFG_YN
Seq. Order  
Data Storage Type VARCHAR2
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

For ease of searching, I added this column to easily query fish purchased from PIFG fishermen. They would bring in heads and gonads or juvenile bottomfish LHP asked them to arget at various times throughout the years. On occasion, PIFG asks for a summary of all fish brought in by PIFG.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

Wasn't properly documented whether or not fish was from PIFG.
Allowed Values Y, N
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name Right_Sagittae_Notes
Seq. Order  
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Any notes associated with the right sagittae, Possible values for this column are noted below.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value YES
Null Value Meaning

No notes associated with otolith
Allowed Values AA Sectioned Allen Andrews already sectioned the otolith B-CI Otolith is broken but the core is intact B-CNI- Otolith is broken and the core is not intact C Small portion of otolith is chipped; chip is insignificant RB Rostrum broken, but the core intact RC Rostrum is chipped SH Otolith shattered in multiple pieces; core not intact
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

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role Data Steward
* » Date Effective From 2008-01-01
Date Effective To 2015-12
Person Sundberg, Meagan A
Address 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address meagan.sundberg@noaa.gov
Phone (808)725-5379
Fax  
Mobile  
URL  
Business Hours 7:30 a.m. - 4:00 p.m. M-F
Contact Instructions

Email with questions.
* » 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 1

* » Time Frame Type Continuing
* » Start 2005-01-01
End  
Alternate Start As Of Info  
Alternate End As Of Info  
Description

Access Information

* » Security Class Confidential
* Security Classification System

After permission is granted to view the dataset, a read-only view will be provided.
Security Handling Description
• Data Access Policy

Need to obtain clearance before this data is available for view.
» 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 32857
Metadata Record Created By Maia Kapur
Metadata Record Created 2016-06-03 15:12+0000
Metadata Record Last Modified By Brent M Miyamoto
» Metadata Record Last Modified 2023-08-26 02:53+0000
Metadata Record Published 2020-03-06
Owner Org PIFSC
Metadata Publication Status Published Externally
Do Not Publish? N
Metadata Workflow State Published / External
Metadata Last Review Date 2020-03-06
Metadata Review Frequency 1 Year
Metadata Next Review Date 2021-03-06
Tags