6349 Data Set Published / External 29708 Hawaii Fish Dealer Project Completed Between 1984 January - 2002 June, personnel from NMFS/PIFSC/FRMD/FMB/FMAP and Hawaii Department of Aquatic Resources (DAR) conducted port sampling at the United Fishing Agency (UFA) Fish Auction. They recorded the total landing at the UFA Fish Auction, with a frequency of six times a week during the earlier years to twice a week during the later years. In 2000 January, DAR implemented a Dealer Data collection procedure that receives reports from the fish dealers that are more complete and covers more than just the auction. This Dealer Data takes the place of the UFA Sampling Data, and after a 2.5 year overlap, the collection of the UFA Sampling Data was discontinued in 2002 June. The DAR Dealer Data is archived and documented separately. The data collected at the auction was not intended to be an accounting of the complete landings of any kind. It was an attempt to record the total landings on any given sampling day, which ranged from two to six times a week. This sampling contains information on the price per pound and quantity sold, and could be used to provide a size structure (weight frequency) by species. ORADATA.FE022AA1 contains PIFSC Historical Data for years 1984 to 1990. ( Record count: 749,894 UFA.UFA created by Frank Cabacungan should be used as the source of the data. It contains data for years 1981 to 2001 in the UFA schema. Record count: 1,923,132 SOURCE ID: FE022 Theme $/lb Theme FMB Theme FRMD Theme IFP Theme PIFSC Theme auction Theme bottomfish Theme commercial Theme crustaceans Theme fish dealers Theme imports Theme invertebrates Theme longline Theme mollusks Theme price Theme reef fish Theme sales Theme sampling Theme trolling Theme weight Spatial Main Hawaiian Islands (MHI) Spatial Northwestern Hawaiian Islands (NWHI) Spatial Pacific Ocean Pacific Islands Fisheries Science Center Honolulu HI USA Data Set Oracle Database None Planned Table (digital) Frank Cabacungan developed the UFA schema tables NA NA NA 11044 UFA Published / External In Work Data Table Yes UFA UFA UFA Auction Sampling Data. 1 YEAR VARCHAR2 4 No No Active Year of sample 2 MONTH VARCHAR2 2 No No Active Month of sample; left justified, one-digit months may or may not be padded with leading zero 3 DAY VARCHAR2 2 No No Active Day of sample; left justified, one-digit days may or may not be padded with leading zero 4 BOAT VARCHAR2 6 No No Active Code for boat or fisher; left justified, one-digit code may or may not be padded with leading zero 5 AREA VARCHAR2 3 No No Active Code for area fished; left justified, one-digit code may or may not be padded with leading zero 6 SPECIES VARCHAR2 5 No No Active Code for species; left justified, one-digit code may or may not be padded with leading zero 7 NUM NUMERIC 4 No No Active Number of pieces 8 POUNDS NUMERIC 7 No No 2 Active Adjusted whole weight of fish 9 PRICE NUMERIC 6 No No 2 Active Price per (sold) pounds 10 BUYER VARCHAR2 6 No No Active Code for buyer; code is padded with leading zeros or left justified 11 CONDITION VARCHAR2 2 No No Active Code for condition or state of fish; code is padded with leading zero or left justified 12 TRIPTYPE VARCHAR2 2 No No Active Code for trip type; code is padded with leading zero or left justified 13 TRIPNUM VARCHAR2 5 No No Active For longline trips, this field is comprised of the trip_type_code and trip_number from the longline logbook data 14 CONV NUMERIC 4 No No 2 Active Conversion factor to convert auction weight to whole weight of fish 15 FROM_FILE VARCHAR2 12 No No Active Source file of the data 16 POSTED DATE 21 No No Active Date the data was loaded or updated, or date of the source file. 11067 Published / External In Work Reference code table Data Table Yes UFA UFA_FSHR. 1 CODE VARCHAR2 5 No No Active Code for the fishing vessel, fisher, import company or neighbor island dealer sending fish to the auction; left justified 2 NAME VARCHAR2 46 No No Active Name of the fishing vessel, fisher, import company or neighbor island dealer sending fish to the auction 3 ABBREV VARCHAR2 15 No No Active Abbreviation for the fishing vessel, fisher, import company or neighbor island dealer sending fish to the auction, or notes on the name 4 TYPE VARCHAR2 1 No No Active Code for the type of entry 5 AREA VARCHAR2 3 No No Active Area code for the area fished or imported from; left justified 6 POSTED DATE 21 No No Active Date the data was posted or updated, or date of the source file. Default date format is DD-MON-YY. 11068 Published / External In Work Reference code table Data Table Yes UFA UFA_AREA. 1 CODE VARCHAR2 3 No No Active Code for the area fished or imported from; left justified 2 NAME VARCHAR2 21 No No Active Name of the area fished or imported from 3 POSTED VARCHAR2 21 No No Active Date the data was posted or updated, or date of the source file. Default date format is DD-MON-YY. 11069 Published / External In Work Reference code table Data Table UFA UFA_SPEC. 1 CODE VARCHAR2 3 No No Active Code for the species; left justified 2 NAME VARCHAR2 21 No No Active Species name 3 UFA_NAME VARCHAR2 35 No No Active Species name used by UFA 4 RNP LOGICAL 1 No No Active (R)equired (N)ame (P)ieces - field used by the error checking program 5 MAJOR VARCHAR2 2 No No Active Major grouping; field used for processing 6 MINOR VARCHAR2 2 No No Active Minor grouping; field used for processing 7 SEQ VARCHAR2 3 No No Active Sequence in major / minor grouping; field used for processing 8 POSTED DATE 21 No No Active Date the data was posted or updated, or date of the source file. Default date format is DD-MON-YY 11070 Published / External In Work Reference code table Data Table UFA UFA_BUYR. 1 CODE VARCHAR2 3 No No Active Code for the buyer; left justified 2 NAME VARCHAR2 30 No No Active Name of the buyer 3 ABBREV VARCHAR2 30 No No Active Abbreviation for the buyer 4 POSTED DATE 21 No No Active Date the data was posted or updated, or date of the source file. Default date format is DD-MON-YY. 11071 Published / External In Work Reference code table Data Table UFA UFA_COND. 1 CODE VARCHAR2 2 No No Active Code for the condition or state of fish 2 SPECIES VARCHAR2 3 No No Active Species 3 CONV_FACTOR NUMERIC 4 No No 2 Active Conversion factor 4 REMARK VARCHAR2 80 No No Active Remarks 5 POSTED DATE 21 No No Active Date the data was posted or updated, or date of the source file. Default date format is DD-MON-YY. Data Steward 2019-04-04 Person Bigelow, Keith A keith.bigelow@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5388 Contact via email Data Steward 2006-08-31 2017-12-31 Person Kawamoto, Kurt E kurt.kawamoto@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5326 (808)725-5475 Distributor 2015 Organization Pacific Islands Fisheries Science Center PIFSC pifsc.info@noaa.gov https://ror.org/02apffz65 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5360 https://www.pifsc.noaa.gov Pacific Island Fisheries Science Center homepage Online Resource 8:00 a.m. - 4:30 p.m. Metadata Contact 2019-04-04 Person Tomita, Ashley S ashley.tomita@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5693 Contact via email Metadata Contact 2015 2018-12-31 Person Tagami, Darryl T darryl.tagami@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5745 8:00 AM - 4:30 PM email Originator 2006-08-31 Organization Pacific Islands Fisheries Science Center PIFSC pifsc.info@noaa.gov https://ror.org/02apffz65 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5360 https://www.pifsc.noaa.gov Pacific Island Fisheries Science Center homepage Online Resource 8:00 a.m. - 4:30 p.m. Point of Contact 2019-04-04 Person Tomita, Ashley S ashley.tomita@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5693 Contact via email Point of Contact 2017-10-30 2019-04-04 Person Bigelow, Keith A keith.bigelow@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5388 Point of Contact 2008-04-08 2017-10-30 Person Lowe, Kimberly kimberly.lowe@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5660 9:00 a.m. - 5:30 p.m. HST M-F Ground Condition 170 -120 50 -20 Latitude and longitude data are not collected, but most of the fish are caught in Hawaiian waters; bounding coordinates are from the Hawaii Longline Fishery Data, per David Hamm. Range 1984-01-01 2001-12-31 The total landing at the UFA Fish Auction was collected with a frequency of six times a week during the earlier years to twice a week during the later years. Data collected through 01-JUN-2006, but data only through 2001 entered. Sensitive Send written request to PIFSC and requires approval by the PIFSC data owner. Requires signing a PIFSC non-disclosure statement for fisheries confidential data. QC review prior to data entry. Further QC after data entry. Yes Unknown No Yes 1 year To Be Determined Unknown PIFSC ITS performs scheduled back-ups. Data was collected in the field by PIFSC staff and data entry was conducted at PIFSC to create ASCII fixed record length flat files. Flat files were loaded into an ORACLE database. 11044 Entity 11068 Entity 11070 Entity 11071 Entity 11067 Entity 11069 Entity 2721 Data Set Cross Reference gov.noaa.nmfs.inport:6349 Brent Miyamoto 2007-11-07T14:24:37 SysAdmin InPortAdmin 2025-12-03T01:00:28 2025-02-20 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No No 2019-07-25 1 Year 2020-07-25