64203 RI028AA1_V Entity Published / External 5845 Experimental Vertical Longline Report data collected during NOAA R/V Townsend Cromwell cruises in 1985 and 1987 at the Hancock Seamounts Data Set Completed Experimental veritical longline data collected on NOAA R/V Townsend Cromwell cruises. Data Table Yes Experimental veritical longline data collected on NOAA R/V Townsend Cromwell cruises. 1 DATASET_CODE VARCHAR2 5 No No Active Source ID Code assigned by the data entry staff. VARCHAR2 2 VERSION_CODE VARCHAR2 3 No No Active Code for the format version assigned by the data entry staff. VARCHAR2 3 VESSEL_CODE VARCHAR2 3 No No Active Code for the vessel. VARCHAR2 4 CRUISE_NUMBER VARCHAR2 4 No No Active Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year. VARCHAR2 5 STATION_NUMBER VARCHAR2 3 No No Active Station number of longline operation. VARCHAR2 6 BANK_CODE VARCHAR2 7 No No Active Seven-digit bank code. VARCHAR2 7 START_LATITUDE_DEGREES VARCHAR2 2 No No Active Start latitude degrees, in degrees. Units for values are degrees. VARCHAR2 degrees 8 START_LATITUDE_MINUTES VARCHAR2 4 No No 1 Active Start latitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. VARCHAR2 minutes 9 START_LATITUDE_DIRECTION VARCHAR2 1 No No Active Start latitude direction. VARCHAR2 10 START_LATITUDE_DD NUMBER 41 No No 38 Active Computed start latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. NUMBER degrees 11 START_LONGITUDE_DEGREES VARCHAR2 3 No No Active Start longitude degrees, in degrees. Units for values are degrees. VARCHAR2 degrees 12 START_LONGITUDE_MINUTES VARCHAR2 3 No No 1 Active Start longitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. VARCHAR2 minutes 13 START_LONGITUDE_DIRECTION VARCHAR2 1 No No Active Start longitude direction. VARCHAR2 14 START_LONGITUDE_DD NUMBER 40 No No 36 Active Computed start longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. NUMBER degrees 15 END_LATITUDE_DEGREES VARCHAR2 2 No No Active End latitude degrees, in degrees. Units for values are degrees. VARCHAR2 degrees 16 END_LATITUDE_MINUTES VARCHAR2 3 No No 1 Active End latitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. VARCHAR2 minutes 17 END_LATITUDE_DIRECTION VARCHAR2 1 No No Active End latitude direction. VARCHAR2 18 END_LATITUDE_DD NUMBER 41 No No 38 Active Computed end latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. NUMBER degrees 19 END_LONGITUDE_DEGREES VARCHAR2 3 No No Active End longitude degrees, in degrees. Units for values are degrees. VARCHAR2 degrees 20 END_LONGITUDE_MINUTES VARCHAR2 3 No No 1 Active End longitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. VARCHAR2 minutes 21 END_LONGITUDE_DIRECTION VARCHAR2 1 No No Active End longitude direction. VARCHAR2 22 END_LONGITUDE_DD NUMBER 40 No No 36 Active Computed end longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. NUMBER degrees 23 SET_YEAR VARCHAR2 4 No No Active Set gear year. VARCHAR2 24 SET_MONTH VARCHAR2 2 No No Active Set gear month. VARCHAR2 25 SET_DAY VARCHAR2 2 No No Active Set gear day. VARCHAR2 26 SET_TIME VARCHAR2 4 No No Active Set gear time. VARCHAR2 27 SET_START_DEPTH VARCHAR2 3 No No Active Set gear start depth, in fathom. Units for values are fathoms. VARCHAR2 fathoms 28 SET_END_DEPTH VARCHAR2 3 No No Active Set gear end depth, in fathoms. Units for values are fathoms. VARCHAR2 fathoms 29 HAUL_YEAR VARCHAR2 4 No No Active Haul gear year. VARCHAR2 30 HAUL_MONTH VARCHAR2 2 No No Active Haul gear month. VARCHAR2 31 HAUL_DAY VARCHAR2 2 No No Active Haul gear day. VARCHAR2 32 HAUL_TIME VARCHAR2 4 No No Active Haul gear time. VARCHAR2 33 HAUL_START_DEPTH VARCHAR2 3 No No Active Haul gear start depth, in fathoms. Units for values are fathoms. VARCHAR2 fathoms 34 HAUL_END_DEPTH VARCHAR2 3 No No Active Haul gear end depth, in fathoms. Units for values are fathoms. VARCHAR2 fathoms 35 NUMBER_DROPPERS VARCHAR2 3 No No Active Number of dropper lines on the longline gear. VARCHAR2 36 HOOKS_PER_DROPPER VARCHAR2 2 No No Active Number of hooks on a dropper line. VARCHAR2 37 DROPPER_SPACING VARCHAR2 3 No No Active Distance between droppers, in fathoms. Units for values are fathoms. VARCHAR2 fathoms 38 TOTAL_HOOKS VARCHAR2 3 No No Active Total number of hooks. VARCHAR2 39 HOOK_SIZE1 VARCHAR2 3 No No Active Size of hook on the dropper. VARCHAR2 40 HOOK_SIZE2 VARCHAR2 3 No No Active Size of hook, if a second hook type used. VARCHAR2 41 HOOK_SIZE3 VARCHAR2 3 No No Active Size of hook, if a third hook type used. VARCHAR2 42 HOOK_SIZE4 VARCHAR2 3 No No Active Size of hook, if a fourth hook type used. VARCHAR2 43 BAIT_CODE VARCHAR2 2 No No Active Code for the type of bait used. VARCHAR2 44 SURFACE_TEMPERATURE VARCHAR2 4 No No 1 Active Surface temperature, in tenths of a degree Celsius. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3. VARCHAR2 degrees Celsius 45 BOTTOM_TEMPERATURE VARCHAR2 4 No No 1 Active Bottom temperature, in tenths of a degree Celsius. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3. VARCHAR2 degrees Celsius 46 DROPPER_NUMBER VARCHAR2 3 No No Active Dropper number on the longline gear. VARCHAR2 47 HOOK_NUMBER VARCHAR2 2 No No Active Hook number on the dropper. VARCHAR2 48 HOOK_SIZE VARCHAR2 3 No No Active Hook size of the hook number. VARCHAR2 49 FISH_NUMBER VARCHAR2 3 No No Active Unique number assigned to each fish. VARCHAR2 50 SPECIES_CODE VARCHAR2 10 No No Active CZM 10-digit species code. VARCHAR2 51 FORK_LENGTH VARCHAR2 5 No No 1 Active Fork length, in tenths of a centimeter. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4. VARCHAR2 centimeters 52 WEIGHT VARCHAR2 6 No No 2 Active Weight, in hundredths of a kilogram. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 5. VARCHAR2 kilograms 53 SHARK_EATEN_CODE VARCHAR2 1 No No Active Code for species was shark eaten. VARCHAR2 54 HOOK_LOST_CODE VARCHAR2 1 No No Active Code if the hook was lost. VARCHAR2 55 BAIT_MISSING_CODE VARCHAR2 1 No No Active Code if the bait was missing. VARCHAR2 56 TANGLE_CODE VARCHAR2 1 No No Active Code if the line was tangled. VARCHAR2 57 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., D85227. VARCHAR2 58 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 59 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE gov.noaa.nmfs.inport:64203 Brent Miyamoto 2021-01-26T05:25:29 SysAdmin InPortAdmin 2022-08-09T17:11:59 2021-02-12 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 2021-02-12 1 Year 2022-02-12