Column Notes for Small-vessel Survey and Auction Sampling to Estimate Growth and Maturity of Eteline Snappers
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:23695 | Updated: August 26, 2023 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionSmall-vessel Survey and Auction Sampling to Estimate Growth and Maturity of Eteline Snappers.
Entity Information
Entity Type
Spreadsheet
Data Attribute / Type | Description |
---|---|
Species
VARCHAR2 |
The common name of the species purchased. |
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. |
Date Processed
DATE |
The date the fish was worked up/processed in the lab at the IRC NOAA Ford Island Facility. |
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). |
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. |
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. |
Island Caught
VARCHAR2 |
Island the fish was caught; all are from the Main Hawaiian Islands. |
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. |
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. |
Macro Sex
VARCHAR2 |
The sex of the fish determined macroscopically. |
Gonad Weight (g)
NUMBER |
The gonad weight of the fish in grams. |
Otoliths Extracted
NUMBER |
The number of sagittal otoliths extracted from the fish. |
Gonads Extracted
VARCHAR2 |
A yes (Y) or no (N) value of whether or not gonads were extracted and saved. |
Gonads Fixed
VARCHAR |
What chemical the gonads were fixed and preserved in; either Glyo-Fixx or Formalin. |
Other Tissues Hardparts Extracted
CHAR |
A yes (Y) or no (N) value on whether or not any additional specimens were saved from the fish. |
Body Weight lbs
NUMBER |
The weight of the fish in pounds. |
Price/lb
CURRENCY |
The price per pound the LHP paid for the fish. |
Dollar Value
CURRENCY |
The total cost of the fish; multiply fish body weight in pounds by price per pound. |
Notes
VARCHAR2 |
Any additional notes about the specimen/fish. |
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.). |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (PIFSC) for inquiries on this record.
Extents
2014-07-01 - Present
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 |
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. |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | age at maturity |
None | bottomfish |
None | eteline snappers |
None | length at maturity |
None | Life History |
None | maturity |
Spatial Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | MHI |
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?: | Yes |
Description: |
Small-vessel Survey and Auction Sampling to Estimate Growth and Maturity of Eteline Snappers. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
Species | VARCHAR2 | The common name of the species purchased. | |
100
|
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
|
Date Processed | DATE | The date the fish was worked up/processed in the lab at the IRC NOAA Ford Island Facility. | |
100
|
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
|
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
|
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
|
Island Caught | VARCHAR2 | Island the fish was caught; all are from the Main Hawaiian Islands. | |
100
|
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
|
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
|
Macro Sex | VARCHAR2 | The sex of the fish determined macroscopically. | |
100
|
Gonad Weight (g) | NUMBER | The gonad weight of the fish in grams. | |
100
|
Otoliths Extracted | NUMBER | The number of sagittal otoliths extracted from the fish. | |
100
|
Gonads Extracted | VARCHAR2 | A yes (Y) or no (N) value of whether or not gonads were extracted and saved. | |
100
|
Gonads Fixed | VARCHAR | What chemical the gonads were fixed and preserved in; either Glyo-Fixx or Formalin. | |
100
|
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
|
Body Weight lbs | NUMBER | The weight of the fish in pounds. | |
100
|
Price/lb | CURRENCY | The price per pound the LHP paid for the fish. | |
100
|
Dollar Value | CURRENCY | The total cost of the fish; multiply fish body weight in pounds by price per pound. | |
100
|
Notes | VARCHAR2 | Any additional notes about the specimen/fish. | |
100
|
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
Species
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The common name of the species purchased. |
Allowed Values: | Onaga, Ehu, Paka, Lehi, Uku, Gindai, Kale |
Date Purchased
Seq. Order: | 2 |
---|---|
Data Storage Type: | DATE |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
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. |
Null Value Meaning: |
The purchased or caught date is unknown. |
Date Processed
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Max Length: | 8 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The date the fish was worked up/processed in the lab at the IRC NOAA Ford Island Facility. |
Fish Data Num
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | Yes |
Primary Key: | Yes |
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). |
GVI Purchased Vessel
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
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. |
Null Value Meaning: |
The fish was not purchased by GVI or the auction tag was not included with the specimen. |
Area of Island Caught
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
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. |
Null Value Meaning: |
Information about the location of where the fish was caught is unknown. |
Island Caught
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Island the fish was caught; all are from the Main Hawaiian Islands. |
General Data Type: | Character |
Null Value Meaning: |
The island where the fish was caught is unknown; most often, the Island Caught is unknown for GVI purchased fish. |
Fork Length (cm)
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
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 |
Null Value Meaning: |
The fish length is unknown or was not recorded. |
Body Weight (kg)
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 8 |
Required: | Yes |
Primary Key: | No |
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. |
Null Value Meaning: |
The body weight was not recorded or is unknown. |
Macro Sex
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The sex of the fish determined macroscopically. |
Allowed Values: | M, F, U |
Gonad Weight (g)
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The gonad weight of the fish in grams. |
Null Value Meaning: |
The gonad was not extracted or available or the weight was not recorded or is unknown. |
Otoliths Extracted
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The number of sagittal otoliths extracted from the fish. |
Null Value Meaning: |
Otoliths weren't extracted or otoliths will be extracted at a later date. |
Gonads Extracted
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
A yes (Y) or no (N) value of whether or not gonads were extracted and saved. |
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 |
Gonads Fixed
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
What chemical the gonads were fixed and preserved in; either Glyo-Fixx or Formalin. |
Null Value Meaning: |
Gonads were not extracted or saved. |
Other Tissues Hardparts Extracted
Seq. Order: | 15 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
A yes (Y) or no (N) value on whether or not any additional specimens were saved from the fish. |
Body Weight lbs
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The weight of the fish in pounds. |
Price/lb
Seq. Order: | 17 |
---|---|
Data Storage Type: | CURRENCY |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The price per pound the LHP paid for the fish. |
Dollar Value
Seq. Order: | 18 |
---|---|
Data Storage Type: | CURRENCY |
Max Length: | 8 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The total cost of the fish; multiply fish body weight in pounds by price per pound. |
Notes
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Any additional notes about the specimen/fish. |
Data/Specimen Issues YN
Seq. Order: | 20 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
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.). |
Allowed Values: | Y, N |
Support Roles
Extents
Extent Group 1
Extent Group 1 / Time Frame 1
Time Frame Type: | Continuing |
---|---|
Start: | 2014-07-01 |
Access Information
Security Class: | Sensitive |
---|
Catalog Details
Catalog Item ID: | 23695 |
---|---|
GUID: | gov.noaa.nmfs.inport: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 Last Review Date: | 2019-07-23 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2020-07-23 |