5843 RI020 Shrimp Morphometric Log (RSCH) Data Set Published / External 5822 Historical Research Insular Metadata Portfolio Project Completed 1998-11 Shrimp morphometry data was collected on NOAA R/V Townsend Cromwell cruise in 1980, 1982 - 1989 and 1992 in the Main Hawaiian Islands, Northwestern Hawaiian Islands, Guam, Commonwealth of the Northern Mariana Islands, Niue and American Samoa. Data inclues capture date, location, depth, carapace length, carapace width, total length, weight, sex and fecundity data. Resource survey and assessment. Record count: 77, 467 SOURCE ID: RI020 Theme PIFSC Theme PIFSC Historical Theme RI Theme SIS Theme shrimp fecundity Theme shrimp morphometry Spatial American Samoa Spatial Commonwealth of the Northern Mariana Islands Spatial Guam Spatial Main Hawaiian Islands Spatial Niue Spatial Northwestern Hawaiian Islands Pacific Islands Fisheries Science Center Honolulu HI USA Data Set Oracle Database As Needed Table (digital) While every effort has been made to ensure that these data are accurate and reliable within the limits of the current state of the art, NOAA cannot assume liability for any damages caused by errors or omissions in the data, nor as a result of the failure of the data to function on a particular system. NOAA makes no warranty, expressed or implied, nor does the fact of distribution constitute such a warranty. 53175 RI020AA2_RSCH_V Published / External Completed Shrimp Morphometric Log data collected on NOAA R/V Townsend Cromwell cruises. Data Table Yes Shrimp Morphometric Log 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 STATION_NUMBER_FIRST VARCHAR2 3 No No Active First station number. For AA1 format, there was only one capture station number collected. For AA2 format, if only one station number was collected, the same number was entered into STATION_NUMBER_FIRST and STATION_NUMBER_LAST. VARCHAR2 9 STATION_NUMBER_LAST VARCHAR2 3 No No Active Last station number. VARCHAR2 10 LATITUDE_DEGREES VARCHAR2 2 No No Active Latitude degrees. Units for values are degrees. VARCHAR2 degrees 11 LATITUDE_MINUTES VARCHAR2 4 No No 1 Active 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 12 LATITUDE_DIRECTION VARCHAR2 1 No No Active Latitude direction. VARCHAR2 N = NORTH; S= SOUTH 13 LATITUDE_DD NUMERIC 41 No No 38 Active Computed 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 14 LONGITUDE_DEGREES VARCHAR2 3 No No Active Longitude degrees. Units for values are degrees. VARCHAR2 degrees 15 LONGITUDE_MINUTES VARCHAR2 4 No No 1 Active 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 16 LONGITUDE_DIRECTION VARCHAR2 1 No No Active Longitude direction. VARCHAR2 E = EAST; W = WEST 17 LONGITUDE_DD NUMERIC 41 No No 36 Active Computed 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 18 BANK_CODE VARCHAR2 7 No No Active Seven digit bank code. VARCHAR2 19 DEPTH_SET VARCHAR2 4 No No Active Set depth, in fathoms. Units for values are fathoms. VARCHAR2 fathoms 20 DEPTH_HAUL VARCHAR2 4 No No Active Haul depth in fathoms. Units for values are fathoms. VARCHAR2 fathoms 21 DEPTH_MINIMUM VARCHAR2 3 No No Active Minimum depth, in fathoms. For AA1 format, if only one depth, the same number was entered into DEPTH_MINIMUM and DEPTH_MAXIMUM. Units for values are fathoms. VARCHAR2 fathoms 22 DEPTH_MAXIMUM VARCHAR2 3 No No Active Maximum depth, in fathoms. Units for values are fathoms. VARCHAR2 fathoms 23 LINE_NUMBER NUMERIC 4 No No Active A consecutive number for each entry on the collection form. NUMERIC 24 SPECIES_CODE VARCHAR2 10 No No Active Czm 10-digit species code. VARCHAR2 25 STRING_NUMBER VARCHAR2 2 No No Active The consecutive number of the string of traps. VARCHAR2 26 GEAR_CODE VARCHAR2 2 No No Active Code for the type of gear used. VARCHAR2 27 TRAP_NUMBER_FIRST VARCHAR2 2 No No Active First trap number. For AA2 format if only one trap number, the same number was entered into TRAP_NUMBER_FIRST AND TRAP_NUMBER_LAST. VARCHAR2 28 TRAP_NUMBER_LAST VARCHAR2 2 No No Active Last trap number. VARCHAR2 29 CARAPACE_LENGTH VARCHAR2 6 No No 2 Active Carapace length, in hundredths of a millimeter. For AA1 format, data was collected in tens of millimeter and reformated to hundreds of millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. VARCHAR2 millimeters 30 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 have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. VARCHAR2 millimeters 31 TOTAL_LENGTH NUMERIC 6 No No 2 Active Total length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. NUMERIC millimeters 32 WEIGHT VARCHAR2 4 No No 1 Active 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 33 SEX_CODE VARCHAR2 1 No No Active Code for the sex of the species. VARCHAR2 F = FEMALE; I = IMMATURE; M = MALE; U = UNKNOWN, UNDETERMINED 34 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; 5 = BERRIED (COLOR NOT RECORDED); } = UNKNOWN CODE 35 MALE_MATURITY_CODE VARCHAR2 1 No No Active Code for the maturity of the male. VARCHAR2 0 = BLANK OR -; 3 = I, IMMATURE; 5 = IU, BETWEEN IMMATURE/UNDERDEVELOPED; 7 = U, UNDEVELOPED 9 = CU, COMPLETELY UNDEVELOPED; } = UNKNOWN CODE 36 GILL_PARASITE_CODE VARCHAR2 1 No No Active Code for the presence of gill parasites. VARCHAR2 1 = GILL PARASITE PRESENT 37 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., D84233. VARCHAR2 38 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 39 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE 63423 Published / External Spreadsheet Yes This spreadsheet provides the name of the SPECIES_CODE in the data. 1 SPECIES_CODE VARCHAR2 10 No No Active Ten-digit CZM species code for the species caught 2 SPECIES_NAME VARCHAR2 50 No No Active Name of the species caught 63424 Published / External Spreadsheet Yes This spreadsheet provides the name of each BANK_CODE in the data. 1 BANK_CODE VARCHAR2 7 No No Active Seven-digit bank code. 2 BANK_NAME VARCHAR2 75 No No Active Name of the bank. Data Steward 2018 Person Miyamoto, Brent M brent.miyamoto@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5340 8:15 a.m. - 5:15 p.m. HST Distributor 2018 Organization Pacific Islands Fisheries Science Center PIFSC pifsc.info@noaa.gov https://ror.org/02apffz65 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5360 https://www.pifsc.noaa.gov Pacific Island Fisheries Science Center homepage Online Resource 8:00 a.m. - 4:30 p.m. Metadata Contact 2018 Person Miyamoto, Brent M brent.miyamoto@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5340 8:15 a.m. - 5:15 p.m. HST Point of Contact 2018 Person Tokita, Christopher Y christopher.tokita@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5342 8:00 a.m. - 4:30 p.m. HST M-F Ground Condition Main Hawaiian Islands, Northwestern Hawaiian Islands, Guam, Commonwealth of the Northern Mariana Islands, Niue, American Samoa Discrete 1980 Range 1982 1989 Discrete 1992 Unclassified Send written request to PIFSC. None None None https://oceanwatch.pifsc.noaa.gov/xfer/PIFSC_PIRO_bulk_data_download_InPort_5843.tgz 2018 Organization Pacific Islands Fisheries Science Center https://ror.org/02apffz65 2021-01-05 Miyamoto, Brent M UNRESOLVED ISSUES: 1) SEX_CODE = 'I' (IMMATURE) NOT ENTERED; SEX_CODE IS NULL VESSEL_CODE = 001, CRUISE_NUMBER = 8404, STATION_NUMBER_FIRST = 106 -LINE_NUMBER = 0012, 0023, 0031, 0059, 0062, 0066 2) BERRIED_OVA_COLOR_CODE = '}' VESSEL_CODE = 001, CRUISE_NUMBER = 8305 - STATION_NUMBER_FIRST = 023, LINE_NUMBER = 0008 - STATION_NUMBER_FIRST = 131, LINE_NUMBER = 0021 - STATION_NUMBER_FIRST = 133, LINE_NUMBER = 0115 3) BERRIED_OVA_COLOR_CODE NOT ENTERED FOR SOME OF THE STATIONS VESSEL_CODE = 001, CRUISE_NUMBER = 8304 4) MALE_MATURITY_CODE = '}' VESSEL_CODE = 001, CRUISE_NUMBER = 8305, STATION_NUMBER_FIRST = 038, LINE_NUMBER=0031 VESSEL_CODE = 001, CRUISE_NUMBER = 8605, STATION_NUMBER_FIRST = 139, LINE_NUMBER=0026 VESSEL_CODE = 001, CRUISE_NUMBER = 8802, STATION_NUMBER_FIRST = 031, LINE_NUMBER=0154 2021-01-07 Miyamoto, Brent M RESOLVED ISSUES: 2021-01-05 1) BANK_CODE FOR FARALLON DE MEDINILLA MISCODED AS 2060100; SHOULD BE 2060000 VESSEL_CODE = 001, CRUISE_NUMBER = 8203, STATION_NUMBER_FIRST BETWEEN 050 - 110; 1,163 RECORDS 2) DEPTH_MINIMUM > DEPTH_MAXIMUM VESSEL_CODE = 001, CRUISE_NUMBER = 8305, STATION_NUMBER_FIRST = 005, SEQUENCE_NUMBER = 00000001 - 00000077, LINE_NUMBER = 0001 - 0077 VESSEL_CODE = 001, CRUISE_NUMBER = 8305, STATION_NUMBER_FIRST = 153, SEQUENCE_NUMBER = 00002607 - 00002730, LINE_NUMBER = 0001 - 0124 3) SEX_CODE IS NULL TO 'M' VESSEL_CODE = 001, CRUISE_NUMBER = 8603, STATION_NUMBER_FIRST = 061, SEQUENCE_NUMBER = 00005437, LINE_NUMBER = 0026 4) SEX_CODE NUMERIC CODE UPDATED TO CHARACTER CODE '0' => 'M' '9' => 'F' '5' => 'I' RESOLVED ISSUES: 2021-01-07 5) SPECIES_CODE VESSEL_CODE = 001, CRUISE_NUMBER = 8305, STATION_NUMBER_FIRST = 152, SEQUENCE_NUMBER = 00002505, LINE_NUMBER = 0043, 6483460202 => 6483460302 VESSEL_CODE = 001, CRUISE_NUMBER=8701, STATION_NUMBER_FIRST = 007, SEQUENCE_NUMBER = 00000215 - 00000227, LINE_NUMBER = 0061 - 0073, H. LAEVIATUS MISCODED AS 6486460302 UPDATED TO 6483460302 VESSEL_CODE = 001, CRUISE_NUMBER = 8705, STATION_NUMBER_FIRST = 039, SEQUENCE_NUMBER = 00001595, LINE_NUMBER = 0034, 6486460302 => 6483460302 RESOLVED ISSUE: 2021-01-14 6) CARAPACE_LENGTH VESSEL_CODE = 001, CRUISE_NUMBER=8807, STATION_NUMBER_FIRST = 025, SEQUENCE_NUMBER = 00001609, LINE_NUMBER = 0112, CARAPACE_LENGTH 341.00 => 034.10 Oracle QC review prior to data entry. Further QC after data entry. Yes Unknown No No 1 year NCEI-MD 1 year PIFSC ITS performs scheduled back-ups. Data was collected in the field on PIFSC data collection forms and data entry was conducted at PIFSC to create ASCII fixed record length flat files. Flat files were later loaded into an Oracle database. 53175 Entity 63424 Entity 63423 Entity gov.noaa.nmfs.inport:5843 Christopher Tokita 2007-10-24T09:39:48 SysAdmin InPortAdmin 2025-12-03T01:00:28 2020-12-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 No 2020-12-22 1 Year 2021-12-22