Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Life History Program > Small-vessel Survey and Auction Sampling to Est... >

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

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

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

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.).

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

CC ID: 190229

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

CC ID: 190230

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

CC ID: 190231

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

CC ID: 190232

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

CC ID: 190233

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

CC ID: 190234

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

CC ID: 190235

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)

CC ID: 190236

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)

CC ID: 190237

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

CC ID: 190239

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)

CC ID: 190238

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

CC ID: 190240

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

CC ID: 190241

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

CC ID: 190242

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

CC ID: 190243

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

CC ID: 190244

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

CC ID: 190245

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

CC ID: 190248

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

CC ID: 190249

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

CC ID: 190250

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

This Catalog Item has no Support Roles that are currently in effect.

View Historical Support Roles

Extents

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 190247

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