63444 RI021AA1_V Entity Published / External 6371 Crustacean Tagging and Morphometric Form data collected on NOAA R/V Townsend Cromwell cruise between 1984 and 1986 and in 1989 in the Hawaiian Archipelago Data Set Completed Crustacean Tagging and Morphometry data collected on NOAA R/V Townsend Cromwell cruises. Data Table Yes Crustacean Tagging and Morphometry 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 001 = NOAA R/V TOWNSEND CROMWELL 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 YEAR VARCHAR2 4 No No Active Year of capture. VARCHAR2 6 MONTH VARCHAR2 2 No No Active Month of capture. VARCHAR2 7 DAY VARCHAR2 2 No No Active Day of capture. VARCHAR2 8 CAPTURE_STATION_NUMBER VARCHAR2 3 No No Active Capture station number. VARCHAR2 9 CAPTURE_LATITUDE_DEGREES VARCHAR2 2 No No Active Capture latitude degrees. Units for values are degrees. VARCHAR2 degrees 10 CAPTURE_LATITUDE_MINUTES VARCHAR2 4 No No 1 Active Capture 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 11 CAPTURE_LATITUDE_DIRECTION VARCHAR2 1 No No Active Capture latitude direction. VARCHAR2 N = NORTH 12 CAPTURE_LATITUDE_DD NUMERIC 41 No No 38 Active Computed capture 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. NUMERIC degrees 13 CAPTURE_LONGITUDE_DEGREES VARCHAR2 3 No No Active Capture longitude degrees. Units for values are degrees. VARCHAR2 degrees 14 CAPTURE_LONGITUDE_MINUTES VARCHAR2 4 No No 1 Active Capture 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 15 CAPTURE_LONGITUDE_DIRECTION VARCHAR2 1 No No Active Capture longitude direction. VARCHAR2 E = EAST; W = WEST 16 CAPTURE_LONGITUDE_DD NUMERIC 41 No No 36 Active Computed capture 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. NUMERIC degrees 17 RELEASE_STATION_NUMBER VARCHAR2 3 No No Active Release station number. VARCHAR2 18 RELEASE_LATITUDE_DEGREES VARCHAR2 2 No No Active Release latitude degrees. Units for values are degrees. VARCHAR2 degrees 19 RELEASE_LATITUDE_MINUTES VARCHAR2 4 No No 1 Active Release 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 20 RELEASE_LATITUDE_DIRECTION VARCHAR2 1 No No Active Release latitude direction. VARCHAR2 N = NORTH 21 RELEASE_LATITUDE_DD VARCHAR2 41 No No 38 Active Computed release 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. VARCHAR2 degrees 22 RELEASE_LONGITUDE_DEGREES VARCHAR2 3 No No Active Release longitude degrees. Units for values are degrees. VARCHAR2 degrees 23 RELEASE_LONGITUDE_MINUTES VARCHAR2 4 No No 1 Active Release 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 24 RELEASE_LONGITUDE_DIRECTION VARCHAR2 1 No No Active Release longitude direction. VARCHAR2 E = EAST; W = WEST 25 RELEASE_LONGITUDE_DD VARCHAR2 41 No No 36 Active Computed release 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. VARCHAR2 degrees 26 STRING_NUMBER VARCHAR2 2 No No Active The consecutive number of the string of traps. A string is an assembly of traps or pots attached to a mainline. If there is more than one string per station, each string should be numbered consecutively as they are retrieved. VARCHAR2 27 TRAP_NUMBER VARCHAR2 2 No No Active The consecutive number assigned to gear (trap or pot) attached to a string. VARCHAR2 28 GEAR_CODE VARCHAR2 2 No No Active Code for the type of gear used. VARCHAR2 43 = "OCTOPUS POT - PLASTIC (PVC PIPE) TYPE, 5 IN DIAMETER PIPE, 3 IN MOUTH IN DIAMETER"; 45 = "PLASTIC LOBSTER POT, WITH 2 IN X 2 IN MESH (CONTROL)"; 46 = "PLASTIC LOBSTER POT (54 MM ESCAPE VENT) (BLACK)"; 47 = "PLASTIC LOBSTER POT (55 MM ESCAPE VENT) (RED)"; 48 = "PLASTIC LOBSTER POT (56 MM ESCAPE VENT) (BLUE)"; 61 = "VARIOUS CALIFORNIA LOBSTER POTS (GENERALLY 2 IN X 4 IN MESH) (FIRST USED ON TC 85-04, ALSO USED ON TC 86-05, PURCHASED FROM SPI)"; 64 = "2 CHAMBERED, 3 FUNNEL ENTRANCE WITH 4TH ENTRANCE TO INNER CHAMBER; 74 CM X 73 CM X 32 CM" 29 LINE_NUMBER VARCHAR2 4 No No Active A consecutive number for each entry on the collection form. VARCHAR2 30 SPECIES_CODE VARCHAR2 10 No No Active Czm 10-digit species code. VARCHAR2 6483460302 = HETEROCARPUS LAEVIGATUS; 6486060101 = PANULIRUS JAPONICUS; 6486060101 = PANULIRUS MARGINATUS; 6486060102 = PANULIRUS PENICILLATUS; 6486070201 = SCYLLARIDES SQUAMMOSUS; 6486070202 = SCYLLARIDES HAANII; 6486070301 = PARRIBACUS ANTARCTICUS; 6487110401 = LITHODES NINTOKUAE; 6487110503 = PARALOMIS PACIFICA; 6488340301 = PROGERYON QUINOTAE; 6488340401 = NEOPILUMNOPLAX MAJOR 31 TAG_NUMBER VARCHAR2 6 No No Active Tag number attached to the animal before release. VARCHAR2 32 CARAPACE_LENGTH VARCHAR2 6 No No 2 Active Carapace length, in hundredths 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 5. VARCHAR2 millimeters 33 CARAPACE_WIDTH VARCHAR2 6 No No 2 Active Carapace width, in hundredths 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 5. VARCHAR2 millimeters 34 TAIL_LENGTH VARCHAR2 6 No No 2 Active Tail length, in hundredths 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 5. VARCHAR2 millimeters 35 TAIL_WIDTH VARCHAR2 6 No No 2 Active Tail width, in hundredths of a millimeter. During data entry the decimal point was omitted (00000 = 000.00). Units for values are millimeters. Measures are reported with a precision of 5. VARCHAR2 millimeters 36 TOTAL_LENGTH VARCHAR2 6 No No 2 Active Total length, in hundredths 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 5. VARCHAR2 millimeters 37 WEIGHT VARCHAR2 7 No No 4 Active Weight, in ten thousandths 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 6. VARCHAR2 kilograms 38 SEX_CODE VARCHAR2 1 No No Active Code for the sex of the species. VARCHAR2 F = FEMALE; M = MALE 39 BERRIED_OVA_COLOR_CODE VARCHAR2 1 No No Active Code for the color of the berried ova. VARCHAR2 1 = ORANGE; 2 = BROWN; 3 = WHITE; 4 = BLUE (SHRIMP ONLY); 5 = BERRIED (COLOR NOT RECORDED) 40 SPERM_PLATE_CODE VARCHAR2 1 No No Active Code for the condition of the sperm plate. VARCHAR2 1 = WHITISH BROWN (GRAY); 2 = BROWN SMOOTH; 3 = BROWN ROUGH; 4 = BLACK; 5 = SPERM PLATE PRESENT (CHECK, YES) 41 MISSING_LEFT_ANTENNA_CODE VARCHAR2 1 No No Active Code for missing appendage left antenna. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 42 MISSING_LEFT_ANTENNULE_CODE VARCHAR2 1 No No Active Code for missing appendage left antennule. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 43 MISSING_LEFT_LEG1_CODE VARCHAR2 1 No No Active Code for missing appendage left leg 1. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 44 MISSING_LEFT_LEG2_CODE VARCHAR2 1 No No Active Code for missing appendage left leg 2. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 45 MISSING_LEFT_LEG3_CODE VARCHAR2 1 No No Active Code for missing appendage left leg 3. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 46 MISSING_LEFT_LEG4_CODE VARCHAR2 1 No No Active Code for missing appendage left leg 4. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 47 MISSING_LEFT_LEG5_CODE VARCHAR2 1 No No Active Code for missing appendage left leg 5. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 48 MISSING_RIGHT_ANTENNA_CODE VARCHAR2 1 No No Active Code for missing appendage right antenna. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 49 MISSING_RIGHT_ANTENNULE_CODE VARCHAR2 1 No No Active Code for missing appendage right antennule. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 50 MISSING_RIGHT_LEG1_CODE VARCHAR2 1 No No Active Code for missing appendage right leg 1. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 51 MISSING_RIGHT_LEG2_CODE VARCHAR2 1 No No Active Code for missing appendage right leg 2. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 52 MISSING_RIGHT_LEG3_CODE VARCHAR2 1 No No Active Code for missing appendage right leg 3. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 53 MISSING_RIGHT_LEG4_CODE VARCHAR2 1 No No Active Code for missing appendage right leg 4. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 54 MISSING_RIGHT_LEG5_CODE VARCHAR2 1 No No Active Code for missing appendage right leg 5. VARCHAR2 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE 55 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., D85013. VARCHAR2 56 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 57 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE gov.noaa.nmfs.inport:63444 Brent Miyamoto 2021-01-15T23:58:37 SysAdmin InPortAdmin 2022-08-09T17:11:55 2021-01-22 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-01-22 1 Year 2022-01-22