64307 RI036AA2_RSCH_V Entity Published / External 6382 Lobster Tagging and Morphometric Form data collected during NOAA R/V Townsend Cromwell cruises in 1999 in the Northwestern Hawaiian Islands Data Set Completed Lobster tagging and morphometric data collected during two NOAA R/V Townsend Cromwell cruises. Data Table Yes Lobster tagging and morphometric data collected during two 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 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., D99272. 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 gov.noaa.nmfs.inport:64307 Brent Miyamoto 2021-02-23T03:47:08 SysAdmin InPortAdmin 2022-08-09T17:11:22 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 2021-03-02 1 Year 2022-03-02