67460 RP035AA1_V Entity Published / External 5887 Squid Morphometrics data collected by the Hokusei Maru during its 81-01 cruise in the main Hawaiian Islands Data Set Completed Squid morphometry collected in 1981 by the Hokusei Maru. Data Table Yes Squid morphometry collected in 1981 by the Hokusei Maru. 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 995 = HOKUSEI MARU 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 for the year, e.g., 8101. VARCHAR2 5 STATION_NUMBER VARCHAR2 3 No No Active Station number of the fishing operation. VARCHAR2 6 SPECIES_CODE VARCHAR2 5 No No Active Czm 5-digit species code. VARCHAR2 50302 = OMMASTREPHES BARTRAMI (LESUEUR); 50311 = SYMPLECTOTEUTHIS OUALANIENSIS (LESSON); 50701 = ONYCHOTEUTHIS BOREALIJAPONICUS (OKADA) 7 YEAR VARCHAR2 4 No No Active Year. VARCHAR2 8 MONTH VARCHAR2 2 No No Active Month. VARCHAR2 9 DAY VARCHAR2 2 No No Active Day. VARCHAR2 10 OCTANT VARCHAR2 1 No No Active Octant of the globe. OCTANT was 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 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 1 = NORTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 2 = NORTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 3 = NORTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE; 5 = SOUTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 6 = SOUTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 7 = SOUTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 8 = SOUTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE 11 LATITUDE_DEGREES VARCHAR2 2 No No Active Latitude degrees. Units for values are degrees. VARCHAR2 degrees 12 LATITUDE_MINUTES VARCHAR2 2 No No Active Latitude minutes. Units for values are minutes. VARCHAR2 minutes 13 LATITUDE_DIRECTION VARCHAR2 1 No No Active Latitude direction. OCTANT was used to determine latitude direction (N/S). VARCHAR2 N = NORTH; S = SOUTH 14 LATITUDE_DD NUMBER 41 No No 38 Active Computed latitude, in decimal degrees. 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 15 LONGITUDE_DEGREES VARCHAR2 3 No No Active Longitude degrees. During data entry the first digit (0 or 1) was omitted. OCTANT was used to determine the first digit (0 or 1) and inserted into the data. Units for values are degrees. VARCHAR2 degrees 16 LONGITUDE_MINUTES VARCHAR2 2 No No Active Longitude minutes. Units for values are minutes. VARCHAR2 minutes 17 LONGITUDE_DIRECTION VARCHAR2 1 No No Active Longitude direction. OCTANT was used to determine longitude direction (E/W). VARCHAR2 E = EAST; W = WEST 18 LONGITUDE_DD NUMBER 40 No No 36 Active Computed longitude, in decimal degrees. 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 19 MESH_SIZE VARCHAR2 3 No No Active Mesh size as "stretched" mesh measurement of the gillnet. VARCHAR2 20 AUTOMATIC_JIGGING_CODE VARCHAR2 1 No No Active Code if automatic jigging was used. VARCHAR2 1 = 0 ON COLLECTION FORM 21 HAND_JIGGING_CODE VARCHAR2 1 No No Active Code if hand jigging was used. VARCHAR2 1 = 0 ON COLLECTION FORM 22 LINE_NUMBER VARCHAR2 3 No No Active A consecutive number assigned to each data record on the collection form. VARCHAR2 23 MANTLE_LENGTH VARCHAR2 4 No No Active Mantle length, in millimeters. Units for values are millimeters. VARCHAR2 millimeters 24 BODY_WEIGHT VARCHAR2 4 No No Active Body weight, in grams. VARCHAR2 25 SEX_CODE VARCHAR2 1 No No Active Code for the sex of the squid. VARCHAR2 F = FEMALE; M = MALE 26 NIDAMENTAL_GLAND_LENGTH VARCHAR2 3 No No Active Nidamental gland length, in millimeters. Units for values are millimeters. VARCHAR2 millimeters 27 NIDAMENTAL_GLAND_WEIGHT VARCHAR2 5 No No 1 Active Nidamental gland weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 4. VARCHAR2 grams 28 VAN_DEFERENS_LENGTH VARCHAR2 3 No No Active Vas Deferens length, in millimeters. Units for values are millimeters. VARCHAR2 millimeters 29 NEEDHAMS_SAC_WEIGHT VARCHAR2 4 No No 1 Active Needham's Sac weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3. VARCHAR2 grams 30 OVIDUCT_WEIGHT VARCHAR2 4 No No 1 Active Oviduct weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3. VARCHAR2 grams 31 GONAD_WEIGHT_TESTIS VARCHAR2 4 No No 1 Active Testis weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3. VARCHAR2 grams 32 GONAD_WEIGHT_OVARY VARCHAR2 5 No No 1 Active Ovary weight, in tenths of a gram. Units for values are grams. Measures are reported with a precision of 4. VARCHAR2 grams 33 MATURITY_IMMATURE_CODE VARCHAR2 1 No No Active Code if the squid was immature. VARCHAR2 1 = 0 ON COLLECTION FORM 34 MATURITY_MATURE_CODE VARCHAR2 1 No No Active Code if the squid was mature. VARCHAR2 1 = 0 ON COLLECTION FORM 35 COITION_PRESENT_CODE VARCHAR2 1 No No Active Code for coition present. VARCHAR2 1 = 0 ON COLLECTION FORM 36 COITION_NONE_CODE VARCHAR2 1 No No Active Code for coition none. VARCHAR2 1 = 0 ON COLLECTION FORM 37 LIVER_WEIGHT VARCHAR2 3 No No Active Liver weight, in grams. Units for values are grams. VARCHAR2 grams 38 STOMACH_CONTENT_WEIGHT VARCHAR2 5 No No Active Stomach weight, units not provided. During data entry the decimal point was omitted; it has been inserted into the data. VARCHAR2 39 STOMACH_CONTENT_CODE VARCHAR2 2 No No Active Code for stomach contents. VARCHAR2 01 = CRUSTACEA; 02 = DISSOLVED MATERIAL; 03 = EMPTY; 04 = FISH; 05 = SQUID; 06 = SQUID FISH 40 BODY_WEIGHT_LESS_INTERNAL_ORGAN VARCHAR2 4 No No Active Body weight, except internal organs. Units not provided. VARCHAR2 41 GEAR_CODE VARCHAR2 1 No No Active Gear code for fishing. VARCHAR2 G = GILL NET; J = JIGGING 42 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 43 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE gov.noaa.nmfs.inport:67460 Brent Miyamoto 2022-06-23T00:21:21 SysAdmin InPortAdmin 2022-08-09T17:11:26 2022-06-24 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 2022-06-24 1 Year 2023-06-24