53637
Lobster Tagging and Morphometric Form data collected on a commercial fishery vessel in 1998 in the Northwestern Hawaiian Islands
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
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
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.
64308
Entity
RI036AA2 - DO NOT PUBLISH
64309
Entity
RI036AA2_CONF_V
53638
Entity
RI036AA3_CONF
6382
Data Set
Lobster Tagging and Morphometric Form data collected during NOAA R/V Townsend Cromwell cruises in 1999 in the Northwestern Hawaiian Islands
Part of a Seamless Database
gov.noaa.nmfs.inport:53637
Brent Miyamoto
2018-09-10T16:24:40
SysAdmin InPortAdmin
2022-10-20T02:17:37
2021-03-02
Pacific Islands Fisheries Science Center
PIFSC
1845 Wasp Blvd.
Honolulu
HI
96818
USA
808-725-5300
http://www.pifsc.noaa.gov
8:00 a.m. - 4:30 p.m.
1001
Public
No
2021-03-02
1 Year
2022-03-02