65738 RP022AA1_RSCH_V Entity Published / External 5870 Longline effort data collected during research cruises in 1950-1960, 1962-1964, 1966-1970, 1973, 1981 and 1992 in the Pacific Ocean Data Set Completed Longline effort data collected during research cruises between 1950 and 1992 in the Pacific Ocean. Data Table Yes Longline effort data collected during research cruises between 1950 and 1992 in the Pacific Ocean. 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 001 = NOAA R/V TOWNSEND CROMWELL; 004 = NOAA R/V HUGH M SMITH; 005 = NOAA R/V JOHN R MANNING; 007 = NOAA R/V CHARLES H GILBERT; 995 = HOKUSEI MARU 4 CRUISE_NUMBER VARCHAR2 4 No No Active Four digit incremental cruise number of the vessel, e.g., 0001, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101. VARCHAR2 5 YEAR VARCHAR2 4 No No Active Year of set. VARCHAR2 6 MONTH VARCHAR2 2 No No Active Month of set. VARCHAR2 7 DAY VARCHAR2 2 No No Active Day of set. VARCHAR2 8 SET_TIME_FIRST VARCHAR2 4 No No Active Set time of the first basket. VARCHAR2 9 SET_OCTANT VARCHAR2 1 No No Active Set octant for the first basket. SET_OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). VARCHAR2 0 = NORTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 1 = NORTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 2 = NORTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 3 = NORTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE; 5 = SOUTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 6 = SOUTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 7 = SOUTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 8 = SOUTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE 10 SET_LATITUDE_DEGREES_FIRST VARCHAR2 2 No No Active Set latitude degrees of the first basket. Units for values are degrees. VARCHAR2 degrees 11 SET_LATITUDE_MINUTES_FIRST VARCHAR2 2 No No Active Set latitude minutes of the first basket. Units for values are minutes. VARCHAR2 minutes 12 SET_LATITUDE_DIRECTION_FIRST VARCHAR2 1 No No Active Set latitude direction of the first basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_FIRST (N/S). VARCHAR2 N = NORTH; S = SOUTH 13 SET_LATITUDE_DD_FIRST NUMBER 42 No No 38 Active Set latitude, in decimal degrees, of the first basket. 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 14 SET_LONGITUDE_DEGREES_FIRST VARCHAR2 3 No No Active Set longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. VARCHAR2 degrees 15 SET_LONGITUDE_MINUTES_FIRST VARCHAR2 2 No No Active Set longitude minutes of the first basket. Units for values are minutes. VARCHAR2 minutes 16 SET_LONGITUDE_DIRECTION_FIRST VARCHAR2 1 No No Active Set longitude direction of the first basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_FIRST (E/W). VARCHAR2 E = EAST; W = WEST 17 SET_LONGITUDE_DD_FIRST NUMBER 41 No No 36 Active Set longitude, in decimal degrees, of the first basket. 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 18 STATION_NUMBER VARCHAR2 3 No No Active Station number of the longline operation. VARCHAR2 19 SET_LATITUDE_DEGREES_LAST VARCHAR2 2 No No Active Set latitude degrees of the last basket. Units for values are degrees. VARCHAR2 degrees 20 SET_LATITUDE_MINUTES_LAST VARCHAR2 2 No No Active Set latitude minutes of the last basket. Units for values are minutes. VARCHAR2 minutes 21 SET_LATITUDE_DIRECTION_LAST VARCHAR2 1 No No 38 Active Set latitude direction of the last basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_LAST (N/S). Measures are reported with a precision of 40. VARCHAR2 N = NORTH; S = SOUTH 22 SET_LATITUDE_DD_LAST NUMBER 42 No No Active Set latitude, in decimal degrees, of the last basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. NUMBER degrees 23 SET_LONGITUDE_DEGREES_LAST VARCHAR2 3 No No Active Set longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. VARCHAR2 degrees 24 SET_LONGITUDE_MINUTES_LAST VARCHAR2 2 No No Active Set longitude minutes of the last basket. Units for values are minutes. VARCHAR2 minutes 25 SET_LONGITUDE_DIRECTION_LAST VARCHAR2 1 No No Active Set longitude direction of the last basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_LAST (E/W). VARCHAR2 E = EAST; W = WEST 26 SET_LONGITUDE_DD_LAST NUMBER 41 No No 36 Active Set longitude, in decimal degrees, of the last basket. 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 27 TOTAL_SETTING_TIME VARCHAR2 3 No No Active Total time, in minutes, of setting operation. Units for values are minutes. VARCHAR2 minutes 28 HAUL_TIME_FIRST VARCHAR2 4 No No Active Haul time of the first basket. VARCHAR2 29 HAUL_LATITUDE_DEGREES_FIRST VARCHAR2 2 No No Active Haul latitude degrees of the first basket. Units for values are degrees. VARCHAR2 degrees 30 HAUL_LATITUDE_MINUTES_FIRST VARCHAR2 2 No No Active Haul latitude minutes of the first basket. Units for values are minutes. VARCHAR2 minutes 31 HAUL_LATITUDE_DIRECTION_FIRST VARCHAR2 1 No No Active Haul latitude direction of the first basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_FIRST (N/S). VARCHAR2 N = NORTH; S= SOUTH 32 HAUL_LATITUDE_DD_FIRST NUMBER 42 No No 38 Active Haul latitude, in decimal degrees, of the first basket. 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 33 HAUL_LONGITUDE_DEGREES_FIRST VARCHAR2 3 No No Active Haul longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. VARCHAR2 degrees 34 HAUL_LONGITUDE_MINUTES_FIRST VARCHAR2 2 No No Active Haul longitude minutes of the first basket. Units for values are minutes. VARCHAR2 minutes 35 HAUL_LONGITUDE_DIRECTION_FIRST VARCHAR2 1 No No Active Haul longitude direction of the first basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_FIRST (E/W). VARCHAR2 E = EAST; W = WEST 36 HAUL_LONGITUDE_DD_FIRST NUMBER 41 No No 36 Active Haul longitude, in decimal degrees, of the first basket. 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 37 HAUL_LATITUDE_DEGREES_LAST VARCHAR2 2 No No Active Haul latitude degrees of the last basket. Units for values are degrees. VARCHAR2 degrees 38 HAUL_LATITUDE_MINUTES_LAST VARCHAR2 2 No No Active Haul latitude minutes of the last basket. Units for values are minutes. VARCHAR2 minutes 39 HAUL_LATITUDE_DIRECTION_LAST VARCHAR2 1 No No Active Haul latitude direction of the last basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_LAST (N/S). VARCHAR2 N = NORTH; S = SOUTH 40 HAUL_LATITUDE_DD_LAST NUMBER 42 No No 38 Active Haul latitude, in decimal degrees, of the last basket. 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 41 HAUL_LONGITUDE_DEGREES_LAST VARCHAR2 3 No No Active Haul longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. VARCHAR2 degrees 42 HAUL_LONGITUDE_MINUTES_LAST VARCHAR2 2 No No Active Haul longitude minutes of the last basket. Units for values are minutes. VARCHAR2 minutes 43 HAUL_LONGITUDE_DIRECTION_LAST VARCHAR2 1 No No Active Haul longitude direction of the last basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_LAST (E/W). VARCHAR2 E = EAST; W = WEST 44 HAUL_LONGITUDE_DD_LAST NUMBER 41 No No 36 Active Haul longitude, in decimal degrees, of the last basket. 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 45 ACTUAL_HAULING_TIME VARCHAR2 3 No No Active Actual time, in minutes of the hauling operation. Units for values are minutes. VARCHAR2 minutes 46 DIRECTION_SET VARCHAR2 2 No No Active Direction of set, in 10s of degrees, e.g., 272 = 27. Units for values are degrees. VARCHAR2 degrees 47 TOTAL_NUMBER_BASKETS_SET VARCHAR2 3 No No Active Total number of baskets set. VARCHAR2 48 NUMBER_HOOKS_PER_BASKET VARCHAR2 2 No No Active Number of hooks per basket. VARCHAR2 49 NUMBER_HOOKS_RETRIEVED VARCHAR2 4 No No Active Number of hooks retrieved. VARCHAR2 50 DISTANCE_FROM_LAND VARCHAR2 3 No No Active For stations within 200 miles of land, the distance from land, in miles, of the first postion. Units for values are miles. VARCHAR2 miles 51 TIME_ZONE_CODE VARCHAR2 1 No No Active Code for the time zone. VARCHAR2 L = MINUS 11; M = MINUS 12; T = PLUS 7; U = PLUS 8; V = PLUS 9; W = PLUS 10; X = PLUS 11 52 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., D94471. VARCHAR2 53 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 54 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE gov.noaa.nmfs.inport:65738 Brent Miyamoto 2021-10-28T01:51:54 SysAdmin InPortAdmin 2022-08-09T17:11:31 2021-10-29 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-10-29 1 Year 2022-10-29