Column Notes for UFA Sampling Data
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:11001 | Updated: February 13, 2025 | Published / External
Item Identification
Title: | Column Notes for UFA Sampling Data |
---|---|
Status: | In Work |
Abstract: |
Explanation of what each column could include in the UFA Sampling Data. |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | bottomfish |
None | fish auction |
None | Length |
None | species |
None | UFA |
None | Weight |
Spatial Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | Big Island |
None | Kauai |
None | Maui |
None | Molokai |
None | NWHI |
None | Oahu |
Physical Location
Organization: | Pacific Islands Fisheries Science Center |
---|---|
City: | Honolulu |
State/Province: | HI |
Country: | USA |
Location Description: |
IRC |
Entity Information
Entity Type: | Data Table |
---|---|
Description: |
UFA Sampling Data. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
UFA_MAIN_ID | NUMBER | The unique sequential number recorded within the database (this number has no significance outside of the database) starting with 1 to uniquely identify each record. |
100
|
VESSEL | VARCHAR2 | The name of the vessel that caught the fish. | |
100
|
NWHI_OR_MHI | CHAR | The region where the bottomfish or pelagic species of fish originated from. This can be determined by the vessel name if its general fishing grounds are known. All bottomfish entries after January 2010 originated from the MHI; the NWHI was closed for bottomfishing. | |
100
|
DATE_MEASURED | DATE | Date that samplers measured the fish on location at the UFA Fish Auction. | |
100
|
SPECIES | VARCHAR2 | Species name of the fish sampled, scientific names are used. | |
100
|
DRESSED_YN | CHAR | Whether or not the fish was eviscerated at sea. Most fish sampled are intact except for dolphinfish, wahoo, Smith's Escolar, and Oilfish; but they too are sometimes sold without being gutted. Bottomfish are never eviscerated at sea. | |
100
|
NMFS_WT_KG | NUMBER | Weight taken by NMFS staff using a bench scale. This measurement was no longer taken after June 2009. Weight measurements collected independently of the UFA were time consuming and got in the way of normal auction operations. From June 2010 and on, the UFA weight in pounds was collected. | |
100
|
TL_EFL_FL | CHAR | What type of length was recorded, total length (TL), fork length (FL), or eye to fork length (EFL) | |
100
|
NMFS_LENGTH_TAPE_CM | NUMBER | The length of the fish in centimeters rounded up to the nearest 0.5 cm. | |
100
|
UFA_WT_LBS | NUMBER | The weight given by the UFA and put onto the fish's identifying barcode tag. Weight is measured in pounds to the 0.5 lb. | |
100
|
NMFS_LENGTH_BOARD_CM | NUMBER | The length of the fish obtained using a fish board. Comparison of measuremnts obtained using a fish board versus a fabric measuring tape began in January 2012. | |
100
|
NUM_OF_INDVL | NUMBER | Number of fish grouped into a lot. Could be 1 to 100+ | |
100
|
ALL_FISH_MSRD | CHAR | Were all the fish in the lot measured, yes (Y), no (N)? If there was only one fish in the lot and it was measured or both fish in a lot of 2 were measured, the answer would be Y. If 4 out of 6 fish in the lot were measured, the answer would be N. | |
100
|
SEX | CHAR | Sex of the fish, male (M), female (F), unknown (U). | |
100
|
EYE_SIZE | CHAR | This column pertains only to Lampris species, if it is a smalleye opah, SE will be recorded, bigeye-BE, and if it is unknown what species it is, then U. | |
100
|
SPECIMEN_NOTES | VARCHAR2 | Any additional information associated with this fish. | |
100
|
LESS_THAN_1_LB | CHAR | Did the fish measured weigh less than 1 pound, yes (Y) or no (N)? UFA staff record a less than sign on the barcode tag of fish weighing less than one pound. | |
100
|
GONAD_YN | CHAR | Were the gonads from this fish extracted, yes (Y) or no (N)? Collection of gonads from the UFA fish auction specimens began in the summer of 2012; all entries prior to May 2012 will have an N in this row. | |
100
|
UFA_FISH_ID | NUMBER | The number assigned to each fish by the UFA. There will be a value here if the toughbook scanning system was used for data collection. | |
100
|
USERNAME | VARCHAR2 | The name of the person operating the toughbook scanning system or person sampling on that specific date. |
Attribute Details
UFA_MAIN_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 6 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
The unique sequential number recorded within the database (this number has no significance outside of the database) starting with 1 to uniquely identify each record. |
Null Value: | NO |
VESSEL
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The name of the vessel that caught the fish. |
Null Value: | NO |
NWHI_OR_MHI
Seq. Order: | 3 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The region where the bottomfish or pelagic species of fish originated from. This can be determined by the vessel name if its general fishing grounds are known. All bottomfish entries after January 2010 originated from the MHI; the NWHI was closed for bottomfishing. |
Null Value: | YES |
Null Value Meaning: |
The fish was caught on a pelagic fishing vessel and the location of capture was not known. |
Allowed Values: | NWHI, MHI |
Default Value: | MHI |
DATE_MEASURED
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 6 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date that samplers measured the fish on location at the UFA Fish Auction. |
Null Value: | NO |
Null Value Meaning: |
There should always be a date recorded. |
SPECIES
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Species name of the fish sampled, scientific names are used. |
Null Value: | NO |
DRESSED_YN
Seq. Order: | 6 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Whether or not the fish was eviscerated at sea. Most fish sampled are intact except for dolphinfish, wahoo, Smith's Escolar, and Oilfish; but they too are sometimes sold without being gutted. Bottomfish are never eviscerated at sea. |
Null Value: | NO |
Allowed Values: | Y, N |
Default Value: | N |
NMFS_WT_KG
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight taken by NMFS staff using a bench scale. This measurement was no longer taken after June 2009. Weight measurements collected independently of the UFA were time consuming and got in the way of normal auction operations. From June 2010 and on, the UFA weight in pounds was collected. |
Null Value: | YES |
Null Value Meaning: |
The weight was not taken by NMFS staff. After June 2009, all rows in this field will be null. |
TL_EFL_FL
Seq. Order: | 8 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
What type of length was recorded, total length (TL), fork length (FL), or eye to fork length (EFL) |
Null Value: | NO |
Null Value Meaning: |
It can always be determined what type of length was/would have been recorded based on the species. |
Allowed Values: | TL, EFL, FL |
Default Value: | FL |
NMFS_LENGTH_TAPE_CM
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The length of the fish in centimeters rounded up to the nearest 0.5 cm. |
Null Value: | YES |
Null Value Meaning: |
The length was not taken. |
UFA_WT_LBS
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The weight given by the UFA and put onto the fish's identifying barcode tag. Weight is measured in pounds to the 0.5 lb. |
Null Value: | YES |
Null Value Meaning: |
The fish is grouped into a lot so the individual weight is unknown. |
NMFS_LENGTH_BOARD_CM
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The length of the fish obtained using a fish board. Comparison of measuremnts obtained using a fish board versus a fabric measuring tape began in January 2012. |
Null Value: | YES |
Null Value Meaning: |
Information was collected prior to 2012 when the fish board was not in use or fish board was too small to capture measurement of large-sized bottomfish specimens. |
NUM_OF_INDVL
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Number of fish grouped into a lot. Could be 1 to 100+ |
Null Value: | NO |
Null Value Meaning: |
Each fish is part of a lot. If more than one fish is in a lot, the total number of fish in that lot will be indicated here. All fish in the lot are not always measured. |
ALL_FISH_MSRD
Seq. Order: | 13 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Were all the fish in the lot measured, yes (Y), no (N)? If there was only one fish in the lot and it was measured or both fish in a lot of 2 were measured, the answer would be Y. If 4 out of 6 fish in the lot were measured, the answer would be N. |
Null Value: | NO |
Null Value Meaning: |
All fish in the lot either were or were not measured. |
SEX
Seq. Order: | 14 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Sex of the fish, male (M), female (F), unknown (U). |
Null Value: | NO |
Null Value Meaning: |
If the sex is unknown, which will be the case for most species, a U should be entered into the cell. |
Allowed Values: | M, F, U |
Default Value: | U |
EYE_SIZE
Seq. Order: | 15 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
This column pertains only to Lampris species, if it is a smalleye opah, SE will be recorded, bigeye-BE, and if it is unknown what species it is, then U. |
Null Value: | YES |
Null Value Meaning: |
Will be blank for all species except Lampris spp. |
Allowed Values: | BE, SE, U |
SPECIMEN_NOTES
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Any additional information associated with this fish. |
Null Value: | YES |
Null Value Meaning: |
No additional information is available. |
LESS_THAN_1_LB
Seq. Order: | 17 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Did the fish measured weigh less than 1 pound, yes (Y) or no (N)? UFA staff record a less than sign on the barcode tag of fish weighing less than one pound. |
Null Value: | NO |
Null Value Meaning: |
The fish either did or did not weigh less than one pound. |
Allowed Values: | Y, N |
GONAD_YN
Seq. Order: | 18 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Were the gonads from this fish extracted, yes (Y) or no (N)? Collection of gonads from the UFA fish auction specimens began in the summer of 2012; all entries prior to May 2012 will have an N in this row. |
Null Value: | NO |
Null Value Meaning: |
Gonads either were or were not collected. |
Allowed Values: | Y, N |
UFA_FISH_ID
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The number assigned to each fish by the UFA. There will be a value here if the toughbook scanning system was used for data collection. |
Null Value: | YES |
Null Value Meaning: |
The toughbook was not in operation until November 2010, any entry prior will not have a value for this column. This column will be blank whenever the scanning system was not used. |
USERNAME
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the person operating the toughbook scanning system or person sampling on that specific date. |
Null Value: | YES |
Null Value Meaning: |
The username was not recorded. |
Support Roles
Extents
Extent Group 1
Extent Group 1 / Time Frame 1
Time Frame Type: | Continuing |
---|---|
Start: | 2007-10-01 |
Access Information
Security Class: | Restricted |
---|---|
Security Classification System: |
May contain confidential fisheries data. |
Data Access Constraints: |
Some information contained within may contain confidential information, contact for details. |
Catalog Details
Catalog Item ID: | 11001 |
---|---|
GUID: | gov.noaa.nmfs.inport:11001 |
Metadata Record Created By: | Meagan A Sundberg |
Metadata Record Created: | 2011-04-29 16:21+0000 |
Metadata Record Last Modified By: | Michael Chang |
Metadata Record Last Modified: | 2025-02-13 22:57+0000 |
Metadata Record Published: | 2025-02-13 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Review Frequency: | 1 Year |