53108 RI020 Shrimp Morphometric Log (CONF) Data Set Published / External 5822 Historical Research Insular Metadata Portfolio Project Completed 1998-11 Shrimp morphometry data was collected by a commercial fishery vessel in 1984 in Guam waters. Data includes capture date, location, depth, carapace length, sex and fecundity data. Assess availability and catchability around Guam of Heterocarpus laevigatus Record count: 912 SOURCE ID: RI020 Theme PIFSC Theme PIFSC Historical Theme RI Theme SIS Theme shrimp fecundity Theme shrimp morphometry Spatial Guam 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. 53177 RI020AA2_CONF_V Published / External Completed Shrimp Morphometric Log data collected on a commercial fishery vessel - CONFIDENTIAL. Data Table Yes Shrimp Morphometric Log data collected on a commercial fishery vessel - CONFIDENTIAL. 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 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 and entered. 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. Data was collected but not entered. VARCHAR2 degrees 11 LATITUDE_MINUTES VARCHAR2 4 No No 1 Active Latitude minutes, in tenths of a minute. Units for values are minutes. Data was collected but not entered. VARCHAR2 minutes 12 LATITUDE_DIRECTION VARCHAR2 1 No No Active Latitude direction. Data was collected but not entered. VARCHAR2 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. Data was collected but not entered. VARCHAR2 degrees 15 LONGITUDE_MINUTES VARCHAR2 4 No No 1 Active Longitude minutes, in tenths of a minute. Units for values are minutes. Data was collected but not entered. VARCHAR2 minutes 16 LONGITUDE_DIRECTION VARCHAR2 1 No No Active Longitude direction. Data was collected but not entered. VARCHAR2 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 2020100 = GUAM 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 6483460301 = HETEROCARPUS ENSIFER; 6483460302 = HETEROCARPUS LAEVIGATUS; 6483460303 = HETEROCARPUS SIBOGAE; 6483460304 = HETEROCARPUS DORSALIS; 6483460305 = HETEROCARPUS LEPIDUS 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. Units for values are millimeters. VARCHAR2 millimeters 31 TOTAL_LENGTH NUMERIC 6 No No 2 Active Total length, in hundredths of a millimeter. Units for values are millimeters. NUMERIC millimeters 32 WEIGHT VARCHAR2 4 No No 1 Active Weight, in tenths of a gram. Units for values are grams. VARCHAR2 grams 33 SEX_CODE VARCHAR2 1 No No Active Code for the sex of the species. VARCHAR2 F = FEMALE; M = MALE 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) 35 MALE_MATURITY_CODE VARCHAR2 1 No No Active Code for the maturity of the male. VARCHAR2 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., D84371. 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 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 Guam Discrete 1984-08 Sensitive Sent written request to PIFSC and requires approval by the PIFSC data owner. Requires signing a PIFSC non-disclosure statement for fisheries confidential data. None None 2021-01-05 Miyamoto, Brent M RESOLVED ISSUES: -SEX_CODE UPDATED FROM '0' TO 'M': 514 RECORDS -SEX_CODE UPDATED FROM '9' TO 'F': 398 RECORDS Oracle No omissions; 912 records collected and accessible. QC review prior to data entry. Further QC after data entry. Yes Unknown Yes Yes 1 year To Be Determined Unknown 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. 53177 Entity gov.noaa.nmfs.inport:53108 Brent Miyamoto 2018-07-23T16:05:55 SysAdmin InPortAdmin 2025-12-03T01:00:28 2021-01-14 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 2021-01-14 1 Year 2022-01-14