58307 RB005AA1_V Entity Published / External 5810 Juvenile Tuna Lengths collected during NOAA R/V Townsend Cromwell cruise in 1967 in Hawaiian waters Data Set Completed . Data Table Yes . 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 4 CRUISE_NUMBER VARCHAR2 4 No No Active Incremental number of the cruise for the vessel. VARCHAR2 5 STATION_NUMBER VARCHAR2 3 No No Active Station number of trawl operation. VARCHAR2 6 SAMPLE_NUMBER VARCHAR2 1 No No Active Sample number of the station. VARCHAR2 7 YEAR VARCHAR2 4 No No Active Imported from RB004AA1 - Year of trawl. VARCHAR2 8 MONTH VARCHAR2 2 No No Active Imported from RB004AA1 - Month of trawl. VARCHAR2 9 DAY VARCHAR2 2 No No Active Imported from RB004AA1 - Day of trawl. VARCHAR2 10 START_TIME VARCHAR2 4 No No Active Imported from RB004AA1 - Start time of trawl, in Hawaii Standard Time. VARCHAR2 11 END_TIME VARCHAR2 4 No No Active Imported from RB004AA1 - End time of trawl, in Hawaii Standard Time. VARCHAR2 12 OCTANT VARCHAR2 1 No No Active Imported from RB004AA1 - Octant of the globe. Used OCTANT to determine 1) Latitude Direction (N, S); 2) Longitude Direction (E, W); and 3) First digit of Longitude degrees (0, 1). VARCHAR2 1 = North Latitude; 90° West - 179° 59’ West Longitude 13 LATITUDE_DEGREES VARCHAR2 4 No No 1 Active Imported from RB004AA1 - Start latitude, in tenths of a degree. During data entry, the decimal point was omitted; it has been Iinserted into the data. Units for values are degrees. Measures are reported with a precision of 3. VARCHAR2 degrees 14 LATITUDE_DIRECTION VARCHAR2 1 No No Active Imported from RB004AA1 - Start latitude direction, determined using OCTANT. VARCHAR2 N = NORTH 15 LATITUDE_DD NUMBER 4 No No 1 Active Imported from RB004AA1 - Computed start latitude, in decimal degrees, of the trawl station. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 3. NUMBER degrees 16 LONGITUDE_DEGREES VARCHAR2 5 No No 1 Active Imported from RB004AA1 - Start longitude, in tenths of a degree. During data entry, the first digit (0 or 1) and the decimal point were omitted; both have been inserted into the data. Units for values are degrees. Measures are reported with a precision of 4. VARCHAR2 degrees 17 LONGITUDE_DIRECTION VARCHAR2 1 No No Active Imported from dataset RB004AA1 - Start longitude direction, determined using OCTANT. VARCHAR2 W = WEST 18 LONGITUDE_DD NUMBER 6 No No 1 Active Imported from dataset RB004AA1 - Computed start longitude, in decimal degrees, of the trawl station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 4. NUMBER degrees 19 SPECIES_CODE VARCHAR2 2 No No Active Two-digit species code. VARCHAR2 32 = KATSUWONUS PELAMIS - SKIPJACK TUNA 33 = EUTHYNNUS SPP. - LITTLE TUNNY 34 = THUNNUS OBESUS - BIGEYE TUNA 35 - THUNNUS ALBACARES - YELLOWFIN TUNA 36 - THUNNUS ALALUNGA - ALBACORE 41 - AUXIS SPP. - FRIGATE MACKEREL 44 - ACANTHOCYBIUM SOLANDRI - WAHOO. ONO 20 STANDARD_LENGTH VARCHAR2 5 No No 1 Active Standard length, in tenths of a millimeter. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 4. VARCHAR2 millimeters 21 FORK_LENGTH VARCHAR2 5 No No 1 Active Fork length, in tents of a millimeter. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 4. VARCHAR2 millimeters 22 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 23 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE gov.noaa.nmfs.inport:58307 Brent Miyamoto 2019-12-11T18:03:42 SysAdmin InPortAdmin 2022-08-09T17:11:04 2019-12-11 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 2019-12-11 1 Year 2020-12-11