Column Notes for UFA Sampling Data
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 11001
| Published / External
Created: 2011-04-29
|
Last Modified: 2025-02-13
Data Set (DS) | ID: 10841
ID: 11001
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Column Notes for UFA Sampling Data |
---|---|
Short Name | |
* Status | In Work |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Explanation of what each column could include in the UFA 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 | bottomfish |
None | fish auction |
None | Length |
None | species |
None | UFA |
None | Weight |
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | Big Island |
None | Kauai |
None | Maui |
None | Molokai |
None | NWHI |
None | Oahu |
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 |
IRC |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description |
UFA Sampling Data. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | 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 | Yes | No | VESSEL | VARCHAR2 | The name of the vessel that caught the fish. |
100 | No | No | 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 | Yes | No | DATE_MEASURED | DATE | Date that samplers measured the fish on location at the UFA Fish Auction. |
100 | Yes | No | SPECIES | VARCHAR2 | Species name of the fish sampled, scientific names are used. |
100 | Yes | No | 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 | No | No | 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 | Yes | No | TL_EFL_FL | CHAR | What type of length was recorded, total length (TL), fork length (FL), or eye to fork length (EFL) |
100 | No | No | NMFS_LENGTH_TAPE_CM | NUMBER | The length of the fish in centimeters rounded up to the nearest 0.5 cm. |
100 | No | No | 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 | No | No | 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 | Yes | No | NUM_OF_INDVL | NUMBER | Number of fish grouped into a lot. Could be 1 to 100+ |
100 | Yes | No | 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 | Yes | No | SEX | CHAR | Sex of the fish, male (M), female (F), unknown (U). |
100 | No | No | 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 | No | No | SPECIMEN_NOTES | VARCHAR2 | Any additional information associated with this fish. |
100 | Yes | No | 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 | Yes | No | 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 | No | No | 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 | No | No | USERNAME | VARCHAR2 | The name of the person operating the toughbook scanning system or person sampling on that specific date. |
Attribute Details
Attribute Name | UFA_MAIN_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 6 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
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. |
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 | VESSEL |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the vessel that caught the fish. |
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 | NWHI_OR_MHI |
---|---|
Seq. Order | 3 |
Data Storage Type | CHAR |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
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 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DATE_MEASURED |
---|---|
Seq. Order | 4 |
Data Storage Type | DATE |
Max Length | 6 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date that samplers measured the fish on location at the UFA Fish Auction. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NO |
Null Value Meaning |
There should always be a date recorded. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIES |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species name of the fish sampled, scientific names are used. |
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 | DRESSED_YN |
---|---|
Seq. Order | 6 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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. |
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 | NMFS_WT_KG |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
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. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TL_EFL_FL |
---|---|
Seq. Order | 8 |
Data Storage Type | CHAR |
Max Length | 3 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
What type of length was recorded, total length (TL), fork length (FL), or eye to fork length (EFL) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
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 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NMFS_LENGTH_TAPE_CM |
---|---|
Seq. Order | 9 |
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 rounded up to the nearest 0.5 cm. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | YES |
Null Value Meaning |
The length was not taken. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UFA_WT_LBS |
---|---|
Seq. Order | 10 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | YES |
Null Value Meaning |
The fish is grouped into a lot so the individual weight is unknown. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NMFS_LENGTH_BOARD_CM |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
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. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUM_OF_INDVL |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 3 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of fish grouped into a lot. Could be 1 to 100+ |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
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. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ALL_FISH_MSRD |
---|---|
Seq. Order | 13 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NO |
Null Value Meaning |
All fish in the lot either were or were not measured. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEX |
---|---|
Seq. Order | 14 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sex of the fish, male (M), female (F), unknown (U). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
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 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EYE_SIZE |
---|---|
Seq. Order | 15 |
Data Storage Type | CHAR |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | YES |
Null Value Meaning |
Will be blank for all species except Lampris spp. |
Allowed Values | BE, SE, U |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIMEN_NOTES |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 500 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any additional information associated with this fish. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | YES |
Null Value Meaning |
No additional information is available. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LESS_THAN_1_LB |
---|---|
Seq. Order | 17 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NO |
Null Value Meaning |
The fish either did or did not weigh less than one pound. |
Allowed Values | Y, N |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GONAD_YN |
---|---|
Seq. Order | 18 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NO |
Null Value Meaning |
Gonads either were or were not collected. |
Allowed Values | Y, N |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UFA_FISH_ID |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
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. |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | USERNAME |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the person operating the toughbook scanning system or person sampling on that specific date. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | YES |
Null Value Meaning |
The username was not recorded. |
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 |
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 | 2007-10-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 | 2007-10-01 |
End | |
Alternate Start As Of Info | |
Alternate End As Of Info | |
Description |
Access Information
* » Security Class | Restricted |
---|---|
* Security Classification System |
May contain confidential fisheries data. |
Security Handling Description | |
• Data Access Policy | |
» Data Access Procedure | |
• » Data Access Constraints |
Some information contained within may contain confidential information, contact for details. |
• 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 | 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 Workflow State | Published / External |
Metadata Last Review Date | |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date |
Tags |
---|