58731 PIFG_TAGGING Entity Published / External 58729 Bottomfish tagging data Data Set Completed Data for cooperative research tagging studies in MHI and Guam. Data Table Yes Data for cooperative research tagging studies in MHI and Guam. 1 DATASET_CODE VARCHAR2 5 No No Active Source ID Code assigned by the data entry staff (FC076). VARCHAR2 2 VERSION_CODE VARCHAR2 3 No No Active Code for the format version assigned by the data entry staff. VARCHAR2 3 ISLAND VARCHAR2 10 No No Active Island where fishing took place. VARCHAR2 4 VESSEL_NAME VARCHAR2 25 No No Active Vessel name. VARCHAR2 5 CAPTAIN_FIRST_NAME VARCHAR2 25 No No Active First name of captain. VARCHAR2 6 CAPTAIN_LAST_NAME VARCHAR2 25 No No Active Last name of captain. VARCHAR2 7 TRIP_START_MONTH VARCHAR2 2 No No Active The month the trip started in. VARCHAR2 8 TRIP_START_DAY VARCHAR2 2 No No Active The day the trip started on. VARCHAR2 9 TRIP_START_YEAR VARCHAR2 4 No No Active The year the trip started in. VARCHAR2 10 TRIP_END_MONTH VARCHAR2 2 No No Active The month the trip ended in. VARCHAR2 11 TRIP_END_DAY VARCHAR2 2 No No Active The day the trip ended on. VARCHAR2 12 TRIP_END_YEAR VARCHAR2 4 No No Active The year the trip ended in. VARCHAR2 13 FISHING_LOCATION VARCHAR2 60 No No Active Location where fishing occurred, if written in. VARCHAR2 14 TAG_NUMBER_1 VARCHAR2 7 No No Active Tag number. VARCHAR2 15 FORK_LENGTH_INCHES VARCHAR2 6 No No Active Fork length in inches. Units for values are inches. VARCHAR2 inches 16 FORK_LENGTH_CENTIMETERS VARCHAR2 6 No No Active Fork length in centimeters. Units for values are centimeters. VARCHAR2 centimeters 17 PURGE VARCHAR2 1 No No Active Was a tool used to treat barotrauma (Y=yes, Blank=no). VARCHAR2 18 DROP_SHOT VARCHAR2 1 No No Active Was a weighted recompression device used to treat baratrauma (Y=yes, Blank=no). VARCHAR2 19 RECAPTURED VARCHAR2 1 No No Active Was the fish a recapture (Y=yes, Blank=no). VARCHAR2 20 RECAPTURED_AND_RELEASED VARCHAR2 1 No No Active If the fish was a recapture, was it released (Y=yes, Blank=no). VARCHAR2 21 TAG_NUMBER_2 VARCHAR2 7 No No Active Additional tag number. VARCHAR2 22 SPECIES VARCHAR2 15 No No Active Species of fish caught. VARCHAR2 23 DATE_CAPTURED_MONTH VARCHAR2 2 No No Active Month fish was caught. VARCHAR2 24 DATE_CAPTURED_DAY VARCHAR2 2 No No Active Day fish was caught. VARCHAR2 25 DATE_CAPTURED_YEAR VARCHAR2 4 No No Active Year fish was caught. VARCHAR2 26 LATITUDE_DEGREES VARCHAR2 2 No No Active Degrees latitutde where fish was caught. Units for values are degrees. VARCHAR2 degrees 27 LATITUDE_MINUTES VARCHAR2 6 No No Active Minutes latitutde where fish was caught. Units for values are minutes. VARCHAR2 minutes 28 LATITUDE_DIRECTION VARCHAR2 1 No No Active Latitude direction (N/S) where fish was caught. VARCHAR2 29 LONGITUDE_DEGREES VARCHAR2 3 No No Active Degrees longitude where fish was caught. Units for values are degrees. VARCHAR2 degrees 30 LONGITUDE_MINUTES VARCHAR2 6 No No Active Minutes longitude where fish was caught. Units for values are minutes. VARCHAR2 minutes 31 LONGITUDE_DIRECTION VARCHAR2 1 No No Active Longitude direction (E/W) where fish was caught. VARCHAR2 32 STATE_CHART_AREA_CODE VARCHAR2 3 No No Active State of Hawaii area code, if in Hawaii. VARCHAR2 33 DEPTH_FATHOMS VARCHAR2 5 No No Active Depth in fathoms where fish was caught. Units for values are fathoms. VARCHAR2 fathoms 34 DEPTH_METERS VARCHAR2 5 No No Active Depth in meters where fish was caught. Units for values are meters. VARCHAR2 meters 35 NOTES_LINE_1 VARCHAR2 80 No No Active First line of comments from fisher. VARCHAR2 36 NOTES_LINE_2 VARCHAR2 80 No No Active Second line of comments from fisher. VARCHAR2 37 NOTES_LINE_3 VARCHAR2 80 No No Active Third line of comments from fisher. VARCHAR2 38 JOB_NUMBER VARCHAR2 6 No No Active A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D12045. VARCHAR2 39 FROM_FILE VARCHAR2 20 No No Active Name of the flat ASCII file that was the source of the data. VARCHAR2 40 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE 41 TAGGER VARCHAR2 22 No No Active Name of individual tagging the fish. VARCHAR2 gov.noaa.nmfs.inport:58731 Brian Langseth 2020-01-30T16:35:51 SysAdmin InPortAdmin 2022-08-09T17:11:45 2020-01-30 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 2020-01-30 1 Year 2021-01-30