53637 RI036 Lobster Tagging and Morphometric Form (CONF) Data Set Published / External 5822 Historical Research Insular Metadata Portfolio Project Completed 1999-11-15 2021-02-24 Lobster Tagging and Morphometric Form data collected on a commercial fishery vessel in 1998 in the Northwestern Hawaiian Islands. Data collected include species, sex, carapace length, tail width, ova color, tag color and number, capture and release positions. Research Record count: 3,893 SOURCE_ID: RI036 Theme PIFSC Theme RI Theme SIS Theme Slipper lobster Theme Spiny lobster Spatial Northwestern Hawaiian Islands NWHI 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. 64309 RI036AA2_CONF_V Published / External Completed Lobster tagging and morphometric data collected during one cruise of a commercial fishey vessel. Data Table Yes Lobster tagging and morphometric data collected during one cruise of a commercial fishey vessel. 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 HAUL_YEAR VARCHAR2 4 No No Active Year that the string was hauled. VARCHAR2 6 HAUL_MONTH VARCHAR2 2 No No Active Month that the string was hauled. VARCHAR2 7 HAUL_DAY VARCHAR2 2 No No Active Day that the string was hauled. VARCHAR2 8 STRING_NUMBER VARCHAR2 3 No No Active String number of traps. VARCHAR2 9 STATION_NUMBER VARCHAR2 3 No No Active Station number of lobster operation. VARCHAR2 10 NUMBER_TRAPS VARCHAR2 4 No No Active Number of traps. VARCHAR2 11 START_DEPTH VARCHAR2 6 No No 1 Active Start depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5. VARCHAR2 fathoms 12 END_DEPTH VARCHAR2 6 No No 1 Active End depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5. VARCHAR2 fathoms 13 START_LATITUDE_DEGREES VARCHAR2 2 No No Active Start latitude degrees, in degrees. Units for values are degrees. VARCHAR2 degrees 14 START_LATITUDE_MINUTES VARCHAR2 5 No No 2 Active Start latitude minutes, in hundredths 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 4. VARCHAR2 minutes 15 START_LATITUDE_DIRECTION VARCHAR2 1 No No Active Start latitude direction. VARCHAR2 16 START_LATITUDE_DD NUMBER 41 No No 38 Active Computed start 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. NUMBER degrees 17 START_LONGITUDE_DEGREES VARCHAR2 3 No No Active Start longitude degrees, in degrees. Units for values are degrees. VARCHAR2 degrees 18 START_LONGITUDE_MINUTES VARCHAR2 5 No No 2 Active Start longitude minutes, in hundredths 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 4. VARCHAR2 minutes 19 START_LONGITUDE_DIRECTION VARCHAR2 1 No No Active Start longitude direction. VARCHAR2 20 START_LONGITUDE_DD NUMBER 41 No No 36 Active Computed start 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. NUMBER degrees 21 END_LATITUDE_DEGREES VARCHAR2 2 No No Active End latitude degrees, in degrees. Units for values are degrees. VARCHAR2 degrees 22 END_LATITUDE_MINUTES VARCHAR2 5 No No 2 Active End latitude minutes, in hundredths 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 4. VARCHAR2 minutes 23 END_LATITUDE_DIRECTION VARCHAR2 1 No No Active End latitude direction. VARCHAR2 24 END_LATITUDE_DD NUMBER 41 No No 38 Active Computed end 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. NUMBER degrees 25 END_LONGITUDE_DEGREES VARCHAR2 3 No No Active End longitude degrees, in degrees. Units for values are degrees. VARCHAR2 degrees 26 END_LONGITUDE_MINUTES VARCHAR2 5 No No 2 Active End longitude minutes, in hundredths 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 4. VARCHAR2 minutes 27 END_LONGITUDE_DIRECTION VARCHAR2 1 No No Active End longitude direction. VARCHAR2 28 END_LONGITUDE_DD NUMBER 41 No No 36 Active Computed end 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. NUMBER degrees 29 RELEASE_LATITUDE_DEGREES VARCHAR2 2 No No Active Release latitude degrees, in degrees. Units for values are degrees. VARCHAR2 degrees 30 RELEASE_LATITUDE_MINUTES VARCHAR2 3 No No 2 Active Release latitude minutes, in hundredths 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 4. VARCHAR2 minutes 31 RELEASE_LATITUDE_DIRECTION VARCHAR2 1 No No Active Release latitude direction. VARCHAR2 32 RELEASE_LATITUDE_DD NUMBER 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. NUMBER degrees 33 RELEASE_LONGITUDE_DEGREES VARCHAR2 3 No No Active Release longitude degrees, in degrees. Units for values are degrees. VARCHAR2 degrees 34 RELEASE_LONGITUDE_MINUTES VARCHAR2 5 No No 2 Active Release longitude minutes, in hundredths 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 4. VARCHAR2 minutes 35 RELEASE_LONGITUDE_DIRECTION VARCHAR2 1 No No Active Release longitude direction. VARCHAR2 36 RELEASE_LONGITUDE_DD NUMBER 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. NUMBER degrees 37 SAMPLE_NUMBER VARCHAR2 3 No No Active Unique consecutive number assigned to each catch on the data collection form. It starts at 001 for each string number. VARCHAR2 38 SPECIES VARCHAR2 10 No No Active Species of lobster caught. VARCHAR2 39 SEX_CODE VARCHAR2 1 No No Active Code for the sex of the lobster. VARCHAR2 40 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 41 TAIL_WIDTH VARCHAR2 6 No No 2 Active Tail 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 42 OVA_COLOR_CODE VARCHAR2 1 No No Active Code for the color of the ova. VARCHAR2 43 TAG_NUMBER VARCHAR2 5 No No Active Unique tag number. VARCHAR2 44 TAG_COLOR_CODE VARCHAR2 1 No No Active Code for the color of the tag. VARCHAR2 45 TAG_CODE VARCHAR2 3 No No Active Code for TAG_NUMBER/TAG_COLOR_CODE. VARCHAR2 46 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., D99002. VARCHAR2 47 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 48 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE Data Steward 2015-04 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 Data Steward 2007-11-08 2015-03 Person DiNardo, Gerard T gerard.dinardo@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5397 Distributor 2007-03 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 2015-04 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 2010-10 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 Point of Contact 2007-03-27 2010-09-14 Person Kikkawa, Bert S bert.kikkawa@noaa.gov 2570 Dole Street Honlulu HI 96822 USA (808)983-5328 (808)983-2902 8:00 a.m. - 4:30 p.m. HST -165 -164 24 23 Northwestern Hawaiian Islands Discrete 1998-09 Sensitive Send 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-02-23 Miyamoto, Brent M RESOLVED DATA ISSUES - 2/16/2021 1) END_LONGITUDE_DEGREES 167 => 164 FOR CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=16, STRING_NUMBER=003, SAMPLE_NUMBER=001-021 2) END_LONGITUDE_MINUTES 86.72 => 36.72 FOR CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=16, STRING_NUMBER=003, SAMPLE_NUMBER=001-021 3) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=02194Y => 02192Y FOR CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=19, STRING_NUMBER=003, SAMPLE_NUMBER=046 4) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=02228Y => 02278Y FOR CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=19, STRING_NUMBER=008, SAMPLE_NUMBER=005 5) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=03042R => 03142R FOR CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=22, STRING_NUMBER=004, SAMPLE_NUMBER=004 6) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=03239R => 03739R FOR CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=004, SAMPLE_NUMBER=003 7) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=03310R = > 03360R FOR CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=23, STRING_NUMBER=004, SAMPLE_NUMBER=020 8) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=03399R => 03379R FOR CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=23, STRING_NUMBER=004, SAMPLE_NUMBER=039 9) DUPLICATE SAMPLE_NUMBER=001 => 002 FOR CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=002, SEQUENCE_NUMBER=00000616 2021-02-23 Miyamoto, Brent M UNRESOLVED DATA ISSUES - 02/16/2021 1) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=01275Y FOR: - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=14, STRING_NUMBER=001, SAMPLE_NUMBER=053 - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=14, STRING_NUMBER=001, SAMPLE_NUMBER=001 2) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=01965Y FOR: - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=18, STRING_NUMBER=005, SAMPLE_NUMBER=043 - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=18, STRING_NUMBER=006, SAMPLE_NUMBER=001 3) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=03737R FOR: - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=001, SAMPLE_NUMBER=018 - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=004, SAMPLE_NUMBER=001 4) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=03738R FOR: - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=001, SAMPLE_NUMBER=019 - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=004, SAMPLE_NUMBER=002 5) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=03739R FOR: - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=001, SAMPLE_NUMBER=020 - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=004, SAMPLE_NUMBER=003 6) DUPLCIATE TAG_NUMBER/TAG_COLOR_CODE=03740R FOR: - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=001, SAMPLE_NUMBER=021 - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=004, SAMPLE_NUMBER=004 7) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=03785R - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=002, SAMPLE_NUMBER=002 - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=008, SAMPLE_NUMBER=020 8) DUPLICATE TAG_NUMBER/TAG_COLOR_CODE=03890R FOR: - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=22, STRING_NUMBER=005, SAMPLE_NUMBER=025 - CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=25, STRING_NUMBER=005, SAMPLE_NUMBER=027 9) TAG_NUMBER/TAG_COLOR_CODE=04701R MAY BE 03701R FOR CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=24, STRING_NUMBER=009, SAMPLE_NUMBER=019 10) TAG_NUMBER/TAG_COLOR_CODE=04702R MAY BE 03702R FOR CRUISE_NUMBER=9801, HAUL_YEAR=1998, HAUL_MONTH=09, HAUL_DAY=24, STRING_NUMBER=009, SAMPLE_NUMBER=020 Oracle QC review prior to data entry. Further QC after data entry. Yes Unknown Yes Yes 1 year To Be Determined Unknown PIFSC ITS performs regular scheduled back-ups. Data were collected in the field on PIFSC data collection form, and data entry was conducted at PIFSC to create ASCII fixed record length flat files. The flat files were later loaded into an Oracle database. 64309 Entity 6382 Data Set Part of a Seamless Database gov.noaa.nmfs.inport:53637 Brent Miyamoto 2018-09-10T16:24:40 SysAdmin InPortAdmin 2025-12-03T01:00:28 2021-03-02 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-03-02 1 Year 2022-03-02