70447 RP004AA2_V Entity Published / External 5852 Squid Jig Fishing Log data collected during research cruises between 1981 and 1983 in the North Pacific Data Set Completed Data for jig fishing for squid collected between 1981 and 1983 during Townsend Cromwell and Hokusei Maru cruises. Data Table Yes Data for jig fishing for squid collected between 1981 and 1983 during Townsend Cromwell and Hokusei Maru 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 001 = NOAA R/V TOWNSEND CROMWELL; 995 = HOKUSEI MARU, A JAPANESE RESEARCH AND TRAINING VESSEL 4 CRUISE_NUMBER VARCHAR2 4 No No Active Last two digits of the year of the cruise and two digits incremental number of the cruise, e.g., 8205. VARCHAR2 5 STATION_NUMBER VARCHAR2 3 No No Active Station number of jig fishing for squid. VARCHAR2 6 YEAR VARCHAR2 4 No No Active Year of jig fishing for squid. VARCHAR2 7 MONTH VARCHAR2 2 No No Active Month of jig fishing for squid. VARCHAR2 8 DAY VARCHAR2 2 No No Active Day of jig fishing for squid. VARCHAR2 9 START_LATITUDE_DEGREES VARCHAR2 2 No No Active Begin latitude degrees of jig fishing for squid. Units for values are degrees. VARCHAR2 degrees 10 START_LATITUDE_MINUTES VARCHAR2 2 No No Active Begin latitude minutes of jig fishing for squid. Units for values are minutes. VARCHAR2 minutes 11 START_LATITUDE_DIRECTION VARCHAR2 1 No No Active Begin latitude direction of jig fishing for squid. VARCHAR2 N = NORTH 12 START_LATITUDE_DD NUMBER 41 No No 38 Active Computed begin latitude, in decimal degrees, of jig fishing for squid. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. NUMBER degrees 13 START_LONGITUDE_DEGREES VARCHAR2 3 No No Active Begin longitude degrees of jig fishing for squid. Units for values are degrees. VARCHAR2 degrees 14 START_LONGITUDE_MINUTES VARCHAR2 2 No No Active Begin longitude minutes of jig fishing for squid. Units for values are minutes. VARCHAR2 minutes 15 START_LONGITUDE_DIRECTION VARCHAR2 1 No No Active Begin longitude direction of jig fishing for squid. VARCHAR2 E = EAST; W = WEST 16 START_LONGITUDE_DD NUMBER 41 No No 36 Active Computed begin longitude, in decimal degrees, of jig fishing for squid. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. NUMBER degrees 17 END_LATITUDE_DEGREES VARCHAR2 2 No No Active End latitude degrees of jig fishing for squid. Units for values are degrees. VARCHAR2 degrees 18 END_LATITUDE_MINUTES VARCHAR2 2 No No Active End latitude minutes of jig fishing for squid. Units for values are minutes. VARCHAR2 minutes 19 END_LATITUDE_DIRECTION VARCHAR2 1 No No Active End latitude direction of jig fishing for squid. VARCHAR2 N = NORTH 20 END_LATITUDE_DD NUMBER 41 No No 38 Active Computed end latitude, in decimal degrees, of jig fishing for squid. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. NUMBER degrees 21 END_LONGITUDE_DEGREES VARCHAR2 3 No No Active End longitude degrees of jig fishing for squid. Units for values are degrees. VARCHAR2 degrees 22 END_LONGITUDE_MINUTES VARCHAR2 2 No No Active End longitude minutes of jig fishing for squid. Units for values are minutes. VARCHAR2 minutes 23 END_LONGITUDE_DIRECTION VARCHAR2 1 No No Active End longitude direction of jig fishing for squid. VARCHAR2 E = EAST; W = WEST 24 END_LONGITUDE_DD NUMBER 41 No No 36 Active Computed end longitude, in decimal degrees, of jig fishing for squid. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. NUMBER degrees 25 SEA_SURFACE_TEMPERATURE VARCHAR2 4 No No 1 Active Sea 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 26 TIME_STARTED VARCHAR2 4 No No Active Begin time of jig fishing for squid. VARCHAR2 27 TIME_ENDED VARCHAR2 4 No No Active End time of jig fishing for squid. VARCHAR2 28 BREAK_TIME VARCHAR2 3 No No Active Break time, in minutes. Units for values are minutes. VARCHAR2 minutes 29 CLOUD_COVER_CODE VARCHAR2 2 No No Active Cloud cover code. VARCHAR2 00 = 00/10; 01 = 01/10; 02 = 02/10; 03 = 03/10; 04 = 04/10; 05 = 05/10; 06 = 06/10; 07 = 07/10; 08 = 08/10; 09 = 09/10; 10 = 10/10 30 WIND_DIRECTION VARCHAR2 3 No No Active Direction, in degrees, from which the surface wind is blowing. Units for values are degrees. VARCHAR2 degrees 31 MINIMUM_WIND_SPEED VARCHAR2 4 No No 1 Active Minimum wind speed, in tenths of meters/second. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are meters/second. Measures are reported with a precision of 3. VARCHAR2 meters/second 32 MAXIMUM_WIND_SPEED VARCHAR2 4 No No 1 Active Maximum wind speed, in tenths of meters/second. During data entry the decimal point was omitted; it has been inserted into the data. If only one value was recorded, it was entered in the minimum and maximum data fields. Units for values are meters/second. Measures are reported with a precision of 3. VARCHAR2 meters/second 33 SEA_CONDITION_CODE VARCHAR2 2 No No Active Code for sea condition. VARCHAR2 00 = CALM; 01 = SLIGHT; 02 = MODERATE; 03 = ROUGH (RP004AA1); 03 = CHOPPY (RP004AA2); 04 = NOT DEFINED (RP004AA1); 04 = 12-15 FT SWELLS (RP004AA2) 34 NUMBER_MACHINES VARCHAR2 2 No No Active Number of jigging machines. VARCHAR2 35 NUMBER_JIGS VARCHAR2 3 No No Active Number of jigs. VARCHAR2 36 NUMBER_LINES VARCHAR2 1 No No Active Number of lines on the machine. VARCHAR2 37 NUMBER_JIGS_PER_LINE VARCHAR2 3 No No Active Number of jigs per line. VARCHAR2 38 NUMBER_JIGS_PER_MACHINE VARCHAR2 3 No No Active Number of jigs per machine. VARCHAR2 39 BOTTOM_DEPTH VARCHAR2 5 No No Active Bottom depth, in meters. VARCHAR2 40 FISHING_DEPTH VARCHAR2 3 No No Active Fishing depth, in meters. VARCHAR2 41 MINIMUM_FISHING_DEPTH VARCHAR2 3 No No 1 Active Minimum fishing depth, in tenths of a meter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are meters. Measures are reported with a precision of 3. VARCHAR2 meters 42 MAXIMUM_FISHING_DEPTH VARCHAR2 3 No No 1 Active Maximum fishing depth, in tenths of a meter. During data entry the decimal point was omitted; it has been inserted into the data. If only one value was recorded, it was entered in the minimum and maximum data fields. Units for values are meters. Measures are reported with a precision of 3. VARCHAR2 meters 43 SPECIES_CODE VARCHAR2 10 No No Active Ten-digit CZM species code. VARCHAR2 0000000000 = NO CATCH; 7073090101 = ONYCHOTEUTHIS COMPACTA; 7073090103 = ONYCHOTEUTHIS BANKSII; 7073300501 = NOTOTODARUS HAWAIIENSIS; 7073300701 = OMMASTREPHES BARTRAMI; 7073301001 = SYMPLECTOTEUTHIS OUALANIENSIS; 7073301002 = SYMPLECTOTEUTHIS LUMINOSA; 8516120506 = CARCHARHINUS LONGIMANUS 44 NUMBER_CAUGHT VARCHAR2 3 No No Active Number caught of the species. VARCHAR2 45 WEIGHT VARCHAR2 6 No No Active Weight, in grams. Units for values are grams. VARCHAR2 grams 46 GEAR_CODE VARCHAR2 2 No No Active Code for other gear used to catch the species. VARCHAR2 01 = POLE AND LINE; 04 = HANDLINE; 08 = ROD AND REEL; 92 = SQUID JIGGING MACHINE (AUTOMATIC) 47 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., D83200. VARCHAR2 48 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 49 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE gov.noaa.nmfs.inport:70447 Brent Miyamoto 2023-08-12T03:33:30 Brent Miyamoto 2023-08-21T20:45:36 2023-08-21 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 2023-08-21 1 Year 2024-08-21