32856 Data Set Published / External 74894 Survey Project In Work This data set includes separate bioSampling logs from each LHP Bottomfishing cruise in the Hawaiian, Samoa, and Mariana Archipelagos as well as a master file with all records. While the data have not changed from previous InPort records (see Node 10806), this is part of an effort to standardize and streamline all life history program databases for past and future cruises. These data to NOT contain biosampling measurements for fish caught in non-cruise-related activities (e.g. fish acquired from auction). An Ecosystem Science and Management Planning Workshop was held in April 2005 that re-emphasized the need to update life history parameters from commercially important species in the Hawaiian Archipelago and assess spatial connectivity of local bottomfish populations in the region. It was further recognized that this work would require the collection of large numbers of geo-referenced samples to re-estimate life history parameters and assess connectivity between isolated populations. Collection of bottomfish specimens began to accomplish this goal. Interested parties should note that individual cruises may/may not have collected extraneous information on the data sheet that is NOT conserved in this streamlined edition. Please contact the data steward if there is a certain value (whether or not a fin clip was taken) that you are interested in that does not appear here. These are retained in the original datasets but removed from the consolidated version made available to the public. Theme FRMD Theme LHP Theme PIFSC Theme bottomfish Theme dorsal spines Theme lengths Theme otoliths Theme reef fish Theme weights Spatial Hawaiian Archipelago Spatial Mariana Archipelago Spatial Pacific Ocean Spatial Samoa Archipelago Pacific Islands Fisheries Science Center Honolulu HI USA The Honolulu IRC facility on Ford Island Data Set Database As Needed Table (digital) Additional information is available on paper such as fishing logs submitted by fishermen with location, species, and tag information, as well as information collected from individual fish such as length, gonad weight, sex, etc. This physical data is in the FRMD storage room. Excel spreadsheets exist containing all information recorded on paper and are located on Meagan Sundberg's hard drive and the G: and H: drive at IRC that is backed up regularly. Information has been put into an Oracle Developer Form then uploaded into an online Oracle integrated database via the PIFSC's intranet, but this database is no longer operational due to lack of personnel able to maintain and update an Oracle database. Bottomfish fishing gear Fishing vessels, either private or NOAA R/V Bottomfish fishing gear 32857 Published / External In Work Explanation of what each column could include in the bottomfish sampling data. Data Table Yes bfsamp.BFS_BFSAMP_MAIN_V Biosampling data from LHP cruises. Fisher_or_GVI_For RFPGrantOnly VARCHAR2 10 No No Active For ease of searching, I added this column to easily query fish purchased from individual fisherman (Fisher) or fish purchased from the wholesale buyer, Garden Valley Isle (GVI). These fish were purchased under the 2 year RFP starting July 2014-July 2016. YES This fish wasn't purchased under this RFP. Fisher, GVI GONAD_YN VARCHAR2 1 No No Active Was a gonad extracted from this fish and is the whole gonad still available for further processing (jar is stored in Wet Archival Storage)? Yes or No? Created for querying purposes. Yes whether or not there is still a whole gonad wasn't properly documented Y, N LEFT_Sagittae_Wt_G NUMBER 5 No No Active The weight of the left sagittae otolith in grams. NOTE: Oven dried weights were obtained 2007-2013, however, it was found the difference between oven and air-dried weights was insignificant. From 2014 on, otoliths were not oven-dried, but weighed after air drying in scintillation vials for three or more days. Oven dried values can be found in the Otolith_Wts_Msmts Spreadsheet. Otolith_Notes VARCHAR2 50 No No Active Any notes associated with both otoliths. YES NO NOTES PIFG_ID_Num VARCHAR2 10 No No Active In October, 2015, a stock assessment fishing project began and fishermen participating in that project provided fish to the LHP for age and growth research. The PIFG ID# is the number on the zip tie tag number attached to the fish when brought to the IRC. This number should be able to link each fish to additional information recoded on the SAP PIFG fishing forms with data collected in the field. Purchased_from_PIFG_YN VARCHAR2 1 No No Active For ease of searching, I added this column to easily query fish purchased from PIFG fishermen. They would bring in heads and gonads or juvenile bottomfish LHP asked them to arget at various times throughout the years. On occasion, PIFG asks for a summary of all fish brought in by PIFG. YES Wasn't properly documented whether or not fish was from PIFG. Y, N Right_Sagittae_Notes VARCHAR2 20 No No Active Any notes associated with the right sagittae, Possible values for this column are noted below. YES No notes associated with otolith AA Sectioned Allen Andrews already sectioned the otolith B-CI Otolith is broken but the core is intact B-CNI- Otolith is broken and the core is not intact C Small portion of otolith is chipped; chip is insignificant RB Rostrum broken, but the core intact RC Rostrum is chipped SH Otolith shattered in multiple pieces; core not intact 1 cruiseNum VARCHAR 30 Yes No Active The designator for the cruise, e.g. SE-16-01. NO 2 caughtDate DATE 8 No No Active The date that the fish was processed in the lab or at sea. Generally, this is done on the same day it was caught. YES The workup date was unkown or was not recorded. 3 location VARCHAR2 15 Yes No Active The island, region or location where the fish was caught. NO 4 species VARCHAR2 4 Yes No Active The 4-letter species code, common or latin name for the species. A separate entity in this same parent item can be used to cross reference species codes and their common or latin names. NO 5 fl_cm NUMBER 4 No No Active The length of the fish in centimeters. Fork length is measured from the tip of the snout to the fork of the tail. YES The length was not recorded. 6 wt_kg NUMBER 4 No No Active Body weight of the fish in kilograms before any extractions occurred (round weight). YES No weight was recorded. 7 macroSex CHAR 1 Yes No Active Sex of the fish, F for female, M for male, U for unknown. Gonads that are immature are difficult to determine sex using the naked eye, when the sex is not definite, a U is put into this column. NO If the sex is unknown or was not recorded, then a U should be put into the column. M, F, U 8 gonadWt_g NUMBER 6 No No Active Weight of the gonads in grams. YES Gonads were not extracted or gonads were not weighed; check notes. 9 numOtos VARCHAR2 2 No No Active Were there otoliths extracted and saved from this fish, Yes or No? Or, the # of otos extracted between 0 and 2. Some cruises only indicated Y/N values. YES Y,N 10 fishDatNum VARCHAR2 30 Yes Yes Active The unique fish data number assigned to each fish. This contains the abbreviated vessel name, vessel trip number, page number, line number, tag number, and species. After 2009, the page and line number were omitted from the fish data number. The composite cruise and fish id number. These are assigned in continuously increasing order as the cruise progresses, e.g. SE-16-01-101, SE-16-01-102 and should be unique. NO Every fish MUST have a fish data number to associate it with additional data collected from that fish. 10 ziptie VARCHAR2 4 Yes No Active The tag number assigned to each individual fish from each trip; used to correlate specimens with catch log. These should be unique, but shouldn't be assumed so (different cruises used varying methods; some didn't use the ziptie method at all). NO 12 notes VARCHAR 4000 No No Active Additional details about the fish and any of its collected parts. YES There was not additional information to report about the fish. 15 LAT_DEG NUMBER 2 No No Active The latitude degrees where the fish was caught. YES The latitude degrees is unknown or it was not recorded. 16 LAT_MIN NUMBER 6 No No Active The latitude minutes where the fish was caught. YES The latitude minutes is unknown or was not recorded. 17 LAT_DIR CHAR 1 Yes No Active The latitude direction. NO The latitude direction can be determined from other specimens provided by the same source. N, S N 18 LONG_DEG NUMBER 3 No No Active The longitude degrees of where the fish was caught. YES The longitude degrees is unknown or was not recorded. 19 LONG_MIN NUMBER 6 No No Active The longitude minutes of where the fish was caught. YES The longitude minutes is unknown or was not recorded. 30 L_SAG NUMBER 1 Yes No Active If the left sagitta was recovered successfully and was extracted intact, a 1 will be entered into this column. If the left sagitta was not extracted successfully, there will be a 0 in the row. NO There should always be a 1 or a 0 entered; the sagitta is either available or it isn't. 1, 0 34 DORSAL_FIN_YN CHAR 1 Yes No Active Was the dorsal fin collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to IRC, ALL these specimens were thrown away! NO There will always be a value; the dorsal spine either was or was not collected. Y, N Y 35 ANAL_FIN_YN CHAR 1 Yes No Active Was the anal fin collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to IRC, ALL these specimens were thrown away! NO Anal fin either was or was not collected however, anal fins are usually only collected from hapu'upu'puu. Y, N N 36 GENETICS_YN CHAR 1 Yes No Active Was tissue for genetics collected from this fish, yes(Y) or no (N)? Can most likely retain a sample for genetic analysis from other samples taken from the fish but if there is a yes in this column, a genetic sample was taken and put into DMSO or in a separate Ziploc for future analysis. NO Genetic tissue was or was not collected. If there is a "N" is this column, it is possible to collect genetic material from the dorsal spine or muscle tissue. Y, N Y 37 ISOTOPES_YN CHAR 1 Yes No Active Were isotopes collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to the IRC ALL these specimens were thrown away! NO Isotope tissue was or was not collected. Y, N 38 STOMACH VARCHAR2 30 Yes No Active Was the Stomach or its contents collected from this fish? (STOMACH/CONTENTS/SPEW) If nothing from the stomach was collected then there will be an N in this column. NO The stomach or its contents either were or were not collected. Stomach, Contents, Spew, N 39 EYEBALLS_YN CHAR 1 Yes No Active Were the eyeballs collected from this fish, yes(Y) or no (N)? When LHP moved from Aiea to IRC, ALL these specimens were thrown away! NO Y, N N 40 otoLoc CHAR 500 No No Active Once determined, the general physical location of any extracted otoliths. NO The opercles either were or were not collected. Y, N Data Steward 2019-04-01 2023-05 Person O'Malley, Joseph M joseph.omalley@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5741 Contact via email Data Steward 2015 2019-03-31 Person Miyamoto, Brent M brent.miyamoto@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5340 8:15 a.m. - 5:15 p.m. HST 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-01 2023-05 Person O'Malley, Joseph M joseph.omalley@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5741 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 Point of Contact 2023-08 Person Schemmel, Eva M eva.schemmel@noaa.gov Contact via email. Point of Contact 2019-04-01 2023-05 Person O'Malley, Joseph M joseph.omalley@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5741 Contact via email Point of Contact 2015 2017-01 Person Humphreys, Robert L robert.humphreys@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)983-5377 north and south pacific ocean Continuing 2005-10 Unclassified Send written request to PIFSC and requires approval by data owner. none none Oracle database QC review prior to data entry. Further QC after data entry. Yes Unknown No No 2 Year NCEI-MD 2 Year PIFSC ITS performs scheduled back-ups. Data was collected in the field by PIFSC staff, and entered in table format into electronic spreadsheets. 32857 Entity 32854 Data Set Part of a Seamless Database gov.noaa.nmfs.inport:32856 Maia Kapur 2016-06-03T15:08:00 SysAdmin InPortAdmin 2025-12-03T01:00:28 2025-02-13 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-23 1 Year 2020-07-23