11652 Entity Published / External 10833 Small Boat Bottomfish Sampling Data Data Set In Work Description of the columns created for the Small Boat Bottomfish Sampling Data dataset and what information each column contains. Theme bottomfish Theme sampling Spatial main hawaiian islands Spatial oahu Pacific Islands Fisheries Science Center Honolulu HI USA The Life History Program has relocated to the Honolulu IRC facility on Ford Island hence; most data sets are stored there. Data Table Small Boat Bottomfish Sampling Data. 1 SMALL_BOAT_CRUISE_NUM VARCHAR2 30 Yes No Active The cruise identification number that always begins with SB (small boat) followed by the sequential trip number. NO 2 VESSEL VARCHAR2 30 Yes No Active The research vessel (name of small boat) performing the operation. NO 3 BAIT VARCHAR2 30 Yes No Active The type of bait used during fishing operations, this will most likely be squid when fishing for bottomfish. NO Bait is always used. Squid 4 GEAR VARCHAR2 30 Yes No Active The type of gear used during fishing operations. NO Some type of gear will always be used. Bottomfish Reel 5 HOOK NUM 2 No No Active The size of the hook used for fishing operations. YES A hook may have not been used if the method of fishing does not involve the bottomfish reels. 6 START_FISHING_TIME NUM 4 No No Active The time fishing operations began each day. YES There should always be a time specified for the beginning of fishing operations when possible. 7 START_DATE DATE 8 Yes No Active The date that fishing operations begin. NO 8 DRIFT_NUM NUM 2 No No Active The drift number which begins with 1 each day fishing operations occur aboard the small boats. YES There will not be a drift number if the gear used does not involve the bottomfish reels; this will be highly unlikely though during small boat operations. 9 START_DRIFT_TIME NUM 4 No No Active The time that the drift started using the 24-hour clock. YES The bottomfish reels were not used to catch fish or the time was not recorded. 10 START_DEPTH_FM NUM 4 No No Active The depth when the drift started recorded in fathoms. YES The bottomfish reels were not used to catch fish or the depth was unknown or not recorded. 11 START_LAT_DEG NUM 3 No No Active The degrees latitude of the beginning of the drift. YES The latitude of the beginning of the drift is unknown or was not recorded. 12 START_LAT_MIN_SEC NUM 6 No No Active The latitude minutes and seconds of the beginning of the drift. YES The latitude of the beginning of the drift is unknown or was not recorded. 13 START_LAT_DIR CHAR 1 Yes No Active The latitude direction of the beginning of the drift. NO The latitude direction should be the same as other entries on a given day. N, S 14 START_LAT_DEC_DEG NUM 8 No No Active The decimal degrees of latitude of the start of the drift. YES The latitude of the beginning of the drift is unknown or was not recorded. 15 START_LONG_DEG NUM 3 No No Active The degrees longitude of the beginning of the drift. YES The longitude of the beginning of the drift is unknown or was not recorded. 16 START_LONG_MIN_SEC NUM 6 No No Active The longitude minutes and seconds of the beginning of the drift. YES The longitude of the beginning of the drift is unknown or was not recorded. 17 START_LONG_DIR CHAR 1 Yes No Active The longitude direction of the beginning of the drift. NO The longitude direction should be the same as other entries on a given day. W, E 18 START_LONG_DEC_DEG NUM 8 No No Active The decimal degrees of longitude of the beginning of the drift. YES The longitude of the beginning of the drift is unknown or was not recorded. 19 END_DATE DATE 8 Yes No Active The end date of the specific drift fishing operations occurred. NO This will most likely be the same date as the START_DATE during small boat operations. 20 END_DRIFT_TIME NUM 4 No No Active The time the drift ended using the 24-hour clock. YES The bottomfish reels were not used to catch fish or the time was not recorded. 21 END_DEPTH_FM NUM 4 No No Active The depth when the drift ended recorded in fathoms. YES The bottomfish reels were not used to catch fish or the depth was unknown or not recorded. 22 END_LAT_DEG NUM 3 No No Active The degrees latitude of the end of the drift. YES The latitude of the end of the drift is unknown or was not recorded. 23 END_LAT_MIN_SEC NUM 6 No No Active The latitude minutes and seconds of the end of the drift. YES The latitude minutes of the end of the drift is unknown or was not recorded. 24 END_LAT_DIR CHAR 1 Yes No Active The latitude direction of the end of the drift. NO The latitude direction should be the same as other entries on a given day. N, S N 25 END_LAT_DEC_DEG NUM 8 No No Active The decimal degrees of latitude of the end of the drift. YES The lat of the end of the drift is unknown or was not recorded. 26 END_LONG_DEG NUM 3 No No Active The degrees longitude of the end of the drift. YES The longitude of the end of the drift is unknown or was not recorded. 27 END_LONG_MIN_SEC NUM 8 No No Active The longitude minutes and seconds of the end of the drift. YES The longitude of the end of the drift is unknown or was not recorded. 28 END_LONG_DIR CHAR 1 Yes No Active The longitude direction of the end of the drift. NO The longitude direction should be the same as other entries on a given day. W, E W 29 END_LONG_DEC_DEG NUM 8 No No Active The decimal degrees of longitude of the end of the drift. YES The longitude of the end of the drift is unknown or was not recorded. 30 END_FISHING_TIME NUM 4 No No Active The end of the fishing day; the time the last fishing line is on deck. YES The end fishing time was unknown or was not recorded. 31 SPECIES_CAPTURED VARCHAR2 40 No No Active The species caught, if any, during the drift, trap retrieval, or while using any other type of gear. YES Nothing was caught. 32 COMMON_NAME VARCHAR2 40 No No Active The common name of the species caught using any means of fishing. YES Nothing was caught or there is not a common name specified for the species. 33 HAWAIIAN_NAME VARCHAR2 40 No No Active The Hawaiian name of the species caught using any means of fishing. YES Nothing was caught or there is not a Hawaiian name specified for the species. 34 TARGET_YN CHAR 1 No No Active Was the species caught considered a target species, yes (Y) or no (N)? YES Nothing was caught. Y, N 35 LENGTH_FL_TL_EFL CHAR 3 No No Active The type of measurement taken from the specimen. YES Nothing was caught to measure. FL, TL, EFL FL 36 LENGTH_CM_TAKEN_ON_BOAT NUM 3 No No Active The length of the specimen obtained on the boat or while out in the field in centimeters. YES Nothing was caught to measure. 37 LENGTH_CM_AT_LAB NUM 3 No No Active The length of the specimen obtained at the lab. YES Nothing was caught to measure. 38 WT_KG NUM 3 No No Active The weight of the specimen taken at the lab in kilograms. YES Nothing was caught to weigh. 39 SEX CHAR 1 No No Active The sex of the specimen caught. YES Nothing was caught or the specimen was not processed. M, F, U 40 DISPOSITION VARCHAR2 10 No No Active The disposition of the specimen caught, was it tagged, kept, and/or released. YES Nothing was caught. Tagged, Kept, Released 41 TAG_NUM_GIVEN_ON_BOAT NUM 5 No No Active If it is a target species, a pre-numbered zip-tie tag is fastened in its mouth through the gills for future identification; the number on that tag is recorded here. YES Nothing was caught or the species retained was not a target species and not assigned a tag number. 42 FISH_DATA_NUM VARCHAR2 20 No No Active The number assigned at the lab consisting of the trip number, the consecutive tag number assigned at the lab, and the abbreviated species name. YES There was nothing caught or the species retained was not a target species. 43 TTL_FISHING_TIME_MIN NUM 5 No No Active The total fishing time; subtract the END_FISHING_TIME from the START_FISHING_TIME calculated in minutes. YES The fishing gear used was not bottomfish reels. 44 TTL_DRIFT_TIME_MIN NUM 5 No No Active The time of each individual drift; subtract the END_DRIFT_TIME from the START_DRIFT_TIME calculated in minutes. YES The method of fishing did not involve bottomfish reels. 45 COMMENTS VARCHAR2 500 No No Active Any additional information about the drift, species caught, depth, etc. YES No additional information was needed or recorded. Data Steward 2009-01-01 Person Sundberg, Meagan A meagan.sundberg@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5379 7:30 a.m. - 4:00 p.m. M-F Email with questions. Continuing 2009-01-01 Restricted Contact for information. Data set may contain confidential fishing locations. 11629 Entity Cross Reference The species list in the bottomfish sampling data set is the same one utilized for small boat bottomfish sampling data. gov.noaa.nmfs.inport:11652 Meagan Sundberg 2012-01-10T17:25:26 Michael Chang 2025-02-13T22:57:27 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 1 Year