32854 Data Set Published / External 74894 Survey Project In Work Description of the core columns that persist throughout OES bottomfish sampling datasets. While the data have not changed from previous InPort records (see Nodes 11630, 11652), this is part of an effort to standardize and streamline all life history program databases for past and future cruises. This data set includes separate catch logs from each LHP Bottomfishing cruise both within and outside of the Main Hawaiian Islands, as well as a master file with all records. 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 (such as bait and hook use or fishermen involved) 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 Bottomfish Theme FRMD Theme LHP Theme OES Theme Oscar Elton Sette Theme PIFSC Theme fishing Spatial American Samoa Spatial Big Island Spatial CNMI Spatial Johnston Atoll Spatial Kona Spatial MHI Spatial Penguin Banks Pacific Islands Fisheries Science Center Honolulu HI USA Original documents, copies and electronic files are stored at the IRC. Data Set Access Database, spreadsheets As Needed Table (digital) pencil and paper in a folder Bait and reel 32855 Published / External In Work Description of the columns of the OES Bottomfish Sampling Data dataset and specific information they contain. Data Table Catch Logs from LHP Cruises. 1 cruiseNum VARCHAR2 30 Yes No Active Abbreviated vessel name and the vessel trip number; used as the first component of the Fish Data Num. NO All cruises within this dataset were completed on the Oscar Elton Sette NOAA research vessel. 2 vessel VARCHAR2 4 Yes No Active The research vessel performing the operation, this could include the main ship (OES & SE) or the small boats deployed from the ship. NO Steel Toe, Oscar Elton Sette, SE-4, SE-6, etc. 3 location VARCHAR2 20 No No Active The general location (island, atoll, region) where the fish was caught. YES There should be something entered in this column, but it may be difficult to match up the fishing operations with the ship's logs. 4 startDate DATE 8 Yes No Active The date of the beginning of fishing operations or other event. NO There is always a start date. 8 driftNum NUM 3 No No Active The drift number which begins with 1 each day fishing operations occur aboard the small boats or the Oscar Elton Sette. YES There will not be a drift number if the gear used does not involve the bottomfish reels. 9 startDriftTime NUM 6 No No Active The time the drift started using the 24-hour clock. The time of the 1st drift for each day is the start fishing time used to calculate the total fishing time in minutes. YES The bottomfish reels were not used to catch fish or the time was not recorded. 10 startDepthFm NUM 3 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 startLatDeg NUM 3 No No Active The degrees latitude of the beginning of the drift. The time for the first drift is considered the start fishing time used to calculate total fishing time in minutes. These are recorded as written on the data sheets; a calculated field is used for visualization purposes in decimal degrees. YES The latitude of the beginning of the event is unknown or was not recorded. 12 startLatMin NUM 3 No No Active The latitude minutes of the beginning of the drift. YES The latitude of the beginning of the event is unknown or was not recorded. 13 startLatS NUM 4 No No Active The latitude seconds of the beginning of the drift. YES The latitude of the beginning of the event is unknown or was not recorded. 15 startLongDeg NUM 3 No No Active The degrees longitude of the beginning of the drift. YES The longitude of the beginning of the event is unknown or was not recorded. 16 startLongMin NUM 3 No No Active The longitude minutes of the beginning of the drift. YES The longitude of the beginning of the event is unknown or was not recorded. 17 startLongS NUM 4 No No Active The longitude seconds of the beginning of the drift. YES The longitude of the beginning of the event is unknown or was not recorded. 20 endDriftTime 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 endDepthFM 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 endLatDeg NUM 3 No No Active The degrees latitude of the end of the drift or event. YES The latitude of the end of the drift or event is unknown or was not recorded. 23 endLatMin NUM 3 No No Active The latitude minutes of the end of the drift or event. YES The latitude of the end of the drift or event is unknown or was not recorded. 24 endLatSec NUM 4 No No Active The latitude seconds of the end of the drift or event. YES The latitude of the end of the drift or event is unknown or was not recorded. 26 endLongDeg NUM 3 No No Active The degrees longitude of the end of the drift or event. YES The longitude of the end of the drift or event is unknown or was not recorded. 27 endLongMin NUM 3 No No Active The longitude minutes of the end of the drift or event. YES The longitude of the end of the drift or event is unknown or was not recorded. 28 endLongS NUM 4 No No Active The longitude seconds of the end of the drift or event. YES The longitude of the end of the drift or event is unknown or was not recorded. 30 species VARCHAR 30 No No Active The species caught, if any, during the drift, trap retrieval, or while using any other type of gear. This is ideally converted from latin/hawaiian into four-letter species codes. When unclear or unavailable, data entry personnel replicated what is written on the sheet. YES Nothing was caught. 31 ziptie VARCHAR2 15 No No Active The unique numerical identifier for the fish; if none was assigned, this value is "NO TAG" OR "RELEASED". This was not consistently created or recorded on all cruises. Occasionally, a 'boat tag number' or other unique identifier containing letters and numbers was used; thus the format for this field is somewhat variable. Users should NOT assume that each entry is unique. YES The bottomfish reels were not the specified event. 32 notes VARCHAR2 30 No No Active Notes written by the fisherman or data entry personnel. 35 startLat_DD NUM 10 No No Active A calculated field indicated the latitude of the drift's start in decimal degrees. YES Nothing was caught. Y, N 36 startLong_DD NUM 10 No No Active A calculated field indicated the longitude of the drift's start in decimal degrees. 40 endLat_DD NUM 10 No No Active A calculated field indicated the latitude of the drift's end in decimal degrees. YES Nothing was caught. Kept, Released 41 endLong_DD NUM 10 No No Active A calculated field indicated the longitude of the drift's end in decimal degrees. YES Nothing was caught. 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 2016-06-03 2018-09 Person Kapur, Maia maia.kapur@noaa.gov https://orcid.org/0000-0002-1781-169X 1845 Wasp Boulevard, Bldg 176 Honolulu HI 96818 USA Distributor 2016-06-03 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 2016-06-03 2018-09 Person Kapur, Maia maia.kapur@noaa.gov https://orcid.org/0000-0002-1781-169X 1845 Wasp Boulevard, Bldg 176 Honolulu HI 96818 USA 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 2016-06-03 2018-09 Person Kapur, Maia maia.kapur@noaa.gov https://orcid.org/0000-0002-1781-169X 1845 Wasp Boulevard, Bldg 176 Honolulu HI 96818 USA Central and south pacific north and south pacific ocean Continuing 2005-01-01 Unclassified Send written request to PIFSC and requires approval by data owner. none none 2016-06-02 InPort Node Created Kapur, Maia MK Has created this node and intends to alert Brent Miyamoto to nullify old bottomfish locations and catch log documentation nodes, namely parent items 10832 and 10833. SE-16-01 Samoa and Western Samoa Directory & R Project Consolidated by M Kapur 13 May 2016 maia.kapur@noaa.gov NOTICE: THE DATA FILES IN THE 'DATA' DIRECTORY ARE LINKED TO A RELATIONAL DATABASE IN MS ACCESS. MODIFICATIONS THEREOF WILL BE REFLECTED IN THE OVERALL DATABASE. This folder has raw and cleaned data recorded on SE-16-01 from Mar to Apr 2016. The 'code' folder is a growing compilation of scripts used to clean and visualize catch data from this cruise. SE-16-01 Samoa catchLog.xls: Each record (row) represents an single fishing outcome for a given drop. Drops with multiple fish caught result in duplicate records. Data were entered by Maia Kapur on 05 - 10 May 2016. GPS coordinates, as recorded by fishermen, were converted within excel to Decimal degrees with the following formula: (Hours + Minutes/60) * -1 ; ensuring that the "minutes" are comprised of a FLOAT value. The CSV version of this sheet is entitled "catch.csv". Notes: Certain crew did not record depth in fathoms for their trips. Wherever possible, species names have been substituted by four-letter codes. See "Spp Code" sheet in /Data for conversion key. Location was designated based on what was indicated for that date on the Bio Sampling data sheet, and is therefore approximate. SE-16-01 Samoa bioSampling.xls: Each row represents a single processed fish and its respective data number (beginning in SE-16-01) which will follow through histology and aging. The Zip Tie # connects it to the Catch dataset. The 'spurious' tab indicates records that are likely incorrect. The CSV version of this sheet is entitled "raw.csv". Notes: Some fish were saved for outreach or left unprocessed, and thus have no ZipTie number. Many such species did not undergo gonad extraction or other measurements. The affiliated R Projects detail the QA/QC procedures used to check data for typographical errors and possible outliers. Users are advised to use spatial visualization tools (eg GIS) to ensure that GPS coordinates are accurate within the catch log; and graphical tools in R to check for outlier points in life history parameters. Because SPP codes can only be verified by hand, we recommend checking ~20% of entries for accuracy. Yes Unknown No No No 2 years NCEI-MD 2 years PIFSC ITS performs scheduled backups. This data were entered by various personell, typically M Leuers/Sundberg or M Kapur following collection on LHP cruises beginning in 2008. This data was sourced from data sheets filled out by fishermen and scientists aboard the ship or small boats. In May of 2016 M Kapur took over as data steward and metadata specialist for this and all LHP program databases. 32855 Entity 32856 Data Set Part of a Seamless Database gov.noaa.nmfs.inport:32854 Maia Kapur 2016-06-03T14:34:45 SysAdmin InPortAdmin 2026-03-04T19:17:24 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