Column Notes for Small-vessel Survey and Auction Sampling to Estimate Growth and Maturity of Eteline Snappers
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 23695
| Published / External
Created: 2015-03-10
|
Last Modified: 2023-08-26
Data Set (DS) | ID: 23694
ID: 23695
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Column Notes for Small-vessel Survey and Auction Sampling to Estimate Growth and Maturity of Eteline Snappers |
---|---|
Short Name | Column Notes for RFP Biosampling Project |
* Status | In Work |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Entity describes what types of information can be found in the data set for Small-vessel Survey and Auction Sampling to Estimate Growth and Maturity of Eteline Snappers and Improve Data-Limited Stock Assessments data. RFP Biosampling Project. |
* Purpose |
To explain the column notes of the Small-vessel Survey and Auction Sampling to Estimate Growth and Maturity of Eteline Snappers and Improve Data-Limited Stock Assessments data set. |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
None | age at maturity |
None | bottomfish |
None | eteline snappers |
None | length at maturity |
None | Life History |
None | maturity |
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | MHI |
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 |
Physical specimens (otoliths and gonads) are stored in the fish necropsy lab or IRC wet archival storage; gonads are fixed and preserved with either 10% Formalin or Glyo-Fixx. Physical data and spreadsheets are in the possession of the POC. |
Entity Information
Entity Type | Spreadsheet |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» Description |
Small-vessel Survey and Auction Sampling to Estimate Growth and Maturity of Eteline Snappers. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | Species | VARCHAR2 | The common name of the species purchased. |
100 | No | No | Date Purchased | DATE | The date the fish was purchased by the LHP or the date the fish was purchased by GVI, the wholesale buyer purchased specific fish for the LHP from the UFA fish auction. |
100 | Yes | No | Date Processed | DATE | The date the fish was worked up/processed in the lab at the IRC NOAA Ford Island Facility. |
100 | Yes | Yes | Fish Data Num | VARCHAR2 | The fish data number which consists of the trip number, the sequential tag number for that trip, and the species name (Hawaiian common name). |
100 | No | No | GVI Purchased Vessel | VARCHAR2 | For fish purchased by GVI. GVI is a wholesale buyer that purchases fish from the UFA fish auction for the LHP. A tag containing the weight, species, date, and vessel that caught the fish is attached to each auction fish. The name of the fishing vessel is obtained from this tag. |
100 | No | No | Area of Island Caught | VARCHAR2 | The area of the island the fish was caught. Sometimes, fishermen share more specific location information with the LHP but, exact locations (lat & long) are rarely available. For fish purchased by GVI, it is difficult to determine which island or island area the fish was caught. |
100 | No | No | Island Caught | VARCHAR2 | Island the fish was caught; all are from the Main Hawaiian Islands. |
100 | No | No | Fork Length (cm) | NUMBER | The fork length of the fish in centimeters. For GVI purchased fish, the fork length is obtained by GVI staff; all other fish are measured by LHP staff. |
100 | Yes | No | Body Weight (kg) | NUMBER | The body weight of the fish in kilograms. This is a calculated value for GVI-purchased fish, fish weight is given in pounds by GVI. |
100 | Yes | No | Macro Sex | VARCHAR2 | The sex of the fish determined macroscopically. |
100 | No | No | Gonad Weight (g) | NUMBER | The gonad weight of the fish in grams. |
100 | No | No | Otoliths Extracted | NUMBER | The number of sagittal otoliths extracted from the fish. |
100 | Yes | No | Gonads Extracted | VARCHAR2 | A yes (Y) or no (N) value of whether or not gonads were extracted and saved. |
100 | No | No | Gonads Fixed | VARCHAR | What chemical the gonads were fixed and preserved in; either Glyo-Fixx or Formalin. |
100 | Yes | No | Other Tissues Hardparts Extracted | CHAR | A yes (Y) or no (N) value on whether or not any additional specimens were saved from the fish. |
100 | No | No | Body Weight lbs | NUMBER | The weight of the fish in pounds. |
100 | No | No | Price/lb | CURRENCY | The price per pound the LHP paid for the fish. |
100 | Yes | No | Dollar Value | CURRENCY | The total cost of the fish; multiply fish body weight in pounds by price per pound. |
100 | No | No | Notes | VARCHAR2 | Any additional notes about the specimen/fish. |
100 | Yes | No | Data/Specimen Issues YN | CHAR | A yes (Y) or no (N) value identifying whether or not any data was missing for the fish/specimen (no gonads, no fork length, no date etc.). |
Attribute Details
Attribute Name | Species |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The common name of the species purchased. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Onaga, Ehu, Paka, Lehi, Uku, Gindai, Kale |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Date Purchased |
---|---|
Seq. Order | 2 |
Data Storage Type | DATE |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date the fish was purchased by the LHP or the date the fish was purchased by GVI, the wholesale buyer purchased specific fish for the LHP from the UFA fish auction. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
The purchased or caught date is unknown. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Date Processed |
---|---|
Seq. Order | 3 |
Data Storage Type | DATE |
Max Length | 8 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date the fish was worked up/processed in the lab at the IRC NOAA Ford Island Facility. |
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 | Fish Data Num |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
The fish data number which consists of the trip number, the sequential tag number for that trip, and the species name (Hawaiian common name). |
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 | GVI Purchased Vessel |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
For fish purchased by GVI. GVI is a wholesale buyer that purchases fish from the UFA fish auction for the LHP. A tag containing the weight, species, date, and vessel that caught the fish is attached to each auction fish. The name of the fishing vessel is obtained from this tag. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
The fish was not purchased by GVI or the auction tag was not included with the specimen. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Area of Island Caught |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The area of the island the fish was caught. Sometimes, fishermen share more specific location information with the LHP but, exact locations (lat & long) are rarely available. For fish purchased by GVI, it is difficult to determine which island or island area the fish was caught. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
Information about the location of where the fish was caught is unknown. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Island Caught |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Island the fish was caught; all are from the Main Hawaiian Islands. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
The island where the fish was caught is unknown; most often, the Island Caught is unknown for GVI purchased fish. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Fork Length (cm) |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The fork length of the fish in centimeters. For GVI purchased fish, the fork length is obtained by GVI staff; all other fish are measured by LHP staff. |
General Data Type | Integer |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
The fish length is unknown or was not recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Body Weight (kg) |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 8 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The body weight of the fish in kilograms. This is a calculated value for GVI-purchased fish, fish weight is given in pounds by GVI. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
The body weight was not recorded or is unknown. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Macro Sex |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The sex of the fish determined macroscopically. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | M, F, U |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Gonad Weight (g) |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The gonad weight of the fish in grams. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
The gonad was not extracted or available or the weight was not recorded or is unknown. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Otoliths Extracted |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of sagittal otoliths extracted from the fish. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
Otoliths weren't extracted or otoliths will be extracted at a later date. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Gonads Extracted |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A yes (Y) or no (N) value of whether or not gonads were extracted and saved. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
N value: Gonads were not included in the bag provided by GVI, gonads were too deteriorated to be saved. |
Allowed Values | Y, N |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Gonads Fixed |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
What chemical the gonads were fixed and preserved in; either Glyo-Fixx or Formalin. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning |
Gonads were not extracted or saved. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Other Tissues Hardparts Extracted |
---|---|
Seq. Order | 15 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A yes (Y) or no (N) value on whether or not any additional specimens were saved from the fish. |
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 | Body Weight lbs |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The weight of the fish in pounds. |
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 | Price/lb |
---|---|
Seq. Order | 17 |
Data Storage Type | CURRENCY |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The price per pound the LHP paid for the fish. |
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 | Dollar Value |
---|---|
Seq. Order | 18 |
Data Storage Type | CURRENCY |
Max Length | 8 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total cost of the fish; multiply fish body weight in pounds by price per pound. |
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 | Notes |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 500 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any additional notes about the specimen/fish. |
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 | Data/Specimen Issues YN |
---|---|
Seq. Order | 20 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A yes (Y) or no (N) value identifying whether or not any data was missing for the fish/specimen (no gonads, no fork length, no date etc.). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Y, N |
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 | Data Steward |
---|---|
* » Date Effective From | 2014-07-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 | Metadata Contact |
---|---|
* » Date Effective From | 2014 |
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 |
* » Support Role | Originator |
---|---|
* » Date Effective From | 2014 |
Date Effective To | 2017-01 |
Person | Humphreys, Robert L |
Address |
1845 Wasp Blvd. Honolulu, HI 96818 USA |
Email Address | robert.humphreys@noaa.gov |
Phone | (808)983-5377 |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » Support Role | Point of Contact |
---|---|
* » Date Effective From | 2014-07-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 |
* » 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 | 2014-07-01 |
End | |
Alternate Start As Of Info | |
Alternate End As Of Info | |
Description |
Access Information
* » Security Class | Sensitive |
---|---|
* 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 | 23695 |
---|---|
Metadata Record Created By | Meagan A Sundberg |
Metadata Record Created | 2015-03-10 19:33+0000 |
Metadata Record Last Modified By | Brent M Miyamoto |
» Metadata Record Last Modified | 2023-08-26 01:42+0000 |
Metadata Record Published | 2019-07-23 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2019-07-23 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2020-07-23 |
Tags |
---|