Item Identification

Title: RI036AA2_CONF_V
Short Name: RI036AA2_CONF_V
Status: Completed
Abstract:

Lobster tagging and morphometric data collected during one cruise of a commercial fishey vessel.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Lobster tagging and morphometric data collected during one cruise of a commercial fishey vessel.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE VARCHAR2 Source ID Code assigned by the data entry staff.
100
VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff.
100
VESSEL_CODE VARCHAR2 Code for the vessel.
100
CRUISE_NUMBER VARCHAR2 Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year.
100
HAUL_YEAR VARCHAR2 Year that the string was hauled.
100
HAUL_MONTH VARCHAR2 Month that the string was hauled.
100
HAUL_DAY VARCHAR2 Day that the string was hauled.
100
STRING_NUMBER VARCHAR2 String number of traps.
100
STATION_NUMBER VARCHAR2 Station number of lobster operation.
100
NUMBER_TRAPS VARCHAR2 Number of traps.
100
START_DEPTH VARCHAR2 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.
100
END_DEPTH VARCHAR2 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.
100
START_LATITUDE_DEGREES VARCHAR2 Start latitude degrees, in degrees. Units for values are degrees.
100
START_LATITUDE_MINUTES VARCHAR2 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.
100
START_LATITUDE_DIRECTION VARCHAR2 Start latitude direction.
100
START_LATITUDE_DD NUMBER 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.
100
START_LONGITUDE_DEGREES VARCHAR2 Start longitude degrees, in degrees. Units for values are degrees.
100
START_LONGITUDE_MINUTES VARCHAR2 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.
100
START_LONGITUDE_DIRECTION VARCHAR2 Start longitude direction.
100
START_LONGITUDE_DD NUMBER 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.
100
END_LATITUDE_DEGREES VARCHAR2 End latitude degrees, in degrees. Units for values are degrees.
100
END_LATITUDE_MINUTES VARCHAR2 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.
100
END_LATITUDE_DIRECTION VARCHAR2 End latitude direction.
100
END_LATITUDE_DD NUMBER 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.
100
END_LONGITUDE_DEGREES VARCHAR2 End longitude degrees, in degrees. Units for values are degrees.
100
END_LONGITUDE_MINUTES VARCHAR2 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.
100
END_LONGITUDE_DIRECTION VARCHAR2 End longitude direction.
100
END_LONGITUDE_DD NUMBER 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.
100
RELEASE_LATITUDE_DEGREES VARCHAR2 Release latitude degrees, in degrees. Units for values are degrees.
100
RELEASE_LATITUDE_MINUTES VARCHAR2 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.
100
RELEASE_LATITUDE_DIRECTION VARCHAR2 Release latitude direction.
100
RELEASE_LATITUDE_DD NUMBER 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.
100
RELEASE_LONGITUDE_DEGREES VARCHAR2 Release longitude degrees, in degrees. Units for values are degrees.
100
RELEASE_LONGITUDE_MINUTES VARCHAR2 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.
100
RELEASE_LONGITUDE_DIRECTION VARCHAR2 Release longitude direction.
100
RELEASE_LONGITUDE_DD NUMBER 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.
100
SAMPLE_NUMBER VARCHAR2 Unique consecutive number assigned to each catch on the data collection form. It starts at 001 for each string number.
100
SPECIES VARCHAR2 Species of lobster caught.
100
SEX_CODE VARCHAR2 Code for the sex of the lobster.
100
CARAPACE_LENGTH VARCHAR2 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.
100
TAIL_WIDTH VARCHAR2 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.
100
OVA_COLOR_CODE VARCHAR2 Code for the color of the ova.
100
TAG_NUMBER VARCHAR2 Unique tag number.
100
TAG_COLOR_CODE VARCHAR2 Code for the color of the tag.
100
TAG_CODE VARCHAR2 Code for TAG_NUMBER/TAG_COLOR_CODE.
100
JOB_NUMBER VARCHAR2 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.
100
SEQUENCE_NUMBER VARCHAR2 A consecutive number assigned to each record for a block of data.
100
DATE_LOADED DATE Date when the record was loaded into Oracle or updated.

Attribute Details

DATASET_CODE

CC ID: 1044517
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Source ID Code assigned by the data entry staff.

General Data Type: VARCHAR2

VERSION_CODE

CC ID: 1044518
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the format version assigned by the data entry staff.

General Data Type: VARCHAR2

VESSEL_CODE

CC ID: 1044519
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the vessel.

General Data Type: VARCHAR2

CRUISE_NUMBER

CC ID: 1044520
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year.

General Data Type: VARCHAR2

HAUL_YEAR

CC ID: 1044521
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year that the string was hauled.

General Data Type: VARCHAR2

HAUL_MONTH

CC ID: 1044522
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month that the string was hauled.

General Data Type: VARCHAR2

HAUL_DAY

CC ID: 1044523
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day that the string was hauled.

General Data Type: VARCHAR2

STRING_NUMBER

CC ID: 1044524
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

String number of traps.

General Data Type: VARCHAR2

STATION_NUMBER

CC ID: 1044525
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Station number of lobster operation.

General Data Type: VARCHAR2

NUMBER_TRAPS

CC ID: 1044526
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of traps.

General Data Type: VARCHAR2

START_DEPTH

CC ID: 1044527
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

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.

General Data Type: VARCHAR2
Unit of Measure: fathoms

END_DEPTH

CC ID: 1044528
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

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.

General Data Type: VARCHAR2
Unit of Measure: fathoms

START_LATITUDE_DEGREES

CC ID: 1044529
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Start latitude degrees, in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

START_LATITUDE_MINUTES

CC ID: 1044530
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

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.

General Data Type: VARCHAR2
Unit of Measure: minutes

START_LATITUDE_DIRECTION

CC ID: 1044531
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Start latitude direction.

General Data Type: VARCHAR2

START_LATITUDE_DD

CC ID: 1044532
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

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.

General Data Type: NUMBER
Unit of Measure: degrees

START_LONGITUDE_DEGREES

CC ID: 1044533
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Start longitude degrees, in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

START_LONGITUDE_MINUTES

CC ID: 1044534
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

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.

General Data Type: VARCHAR2
Unit of Measure: minutes

START_LONGITUDE_DIRECTION

CC ID: 1044535
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Start longitude direction.

General Data Type: VARCHAR2

START_LONGITUDE_DD

CC ID: 1044536
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

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.

General Data Type: NUMBER
Unit of Measure: degrees

END_LATITUDE_DEGREES

CC ID: 1044537
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

End latitude degrees, in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

END_LATITUDE_MINUTES

CC ID: 1044538
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

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.

General Data Type: VARCHAR2
Unit of Measure: minutes

END_LATITUDE_DIRECTION

CC ID: 1044539
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

End latitude direction.

General Data Type: VARCHAR2

END_LATITUDE_DD

CC ID: 1044540
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

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.

General Data Type: NUMBER
Unit of Measure: degrees

END_LONGITUDE_DEGREES

CC ID: 1044541
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

End longitude degrees, in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

END_LONGITUDE_MINUTES

CC ID: 1044542
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

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.

General Data Type: VARCHAR2
Unit of Measure: minutes

END_LONGITUDE_DIRECTION

CC ID: 1044543
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

End longitude direction.

General Data Type: VARCHAR2

END_LONGITUDE_DD

CC ID: 1044544
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

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.

General Data Type: NUMBER
Unit of Measure: degrees

RELEASE_LATITUDE_DEGREES

CC ID: 1044545
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release latitude degrees, in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

RELEASE_LATITUDE_MINUTES

CC ID: 1044546
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

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.

General Data Type: VARCHAR2
Unit of Measure: minutes

RELEASE_LATITUDE_DIRECTION

CC ID: 1044547
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Release latitude direction.

General Data Type: VARCHAR2

RELEASE_LATITUDE_DD

CC ID: 1044548
Seq. Order: 32
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

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.

General Data Type: NUMBER
Unit of Measure: degrees

RELEASE_LONGITUDE_DEGREES

CC ID: 1044549
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Release longitude degrees, in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

RELEASE_LONGITUDE_MINUTES

CC ID: 1044550
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

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.

General Data Type: VARCHAR2
Unit of Measure: minutes

RELEASE_LONGITUDE_DIRECTION

CC ID: 1044551
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Release longitude direction.

General Data Type: VARCHAR2

RELEASE_LONGITUDE_DD

CC ID: 1044552
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

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.

General Data Type: NUMBER
Unit of Measure: degrees

SAMPLE_NUMBER

CC ID: 1044553
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Unique consecutive number assigned to each catch on the data collection form. It starts at 001 for each string number.

General Data Type: VARCHAR2

SPECIES

CC ID: 1044554
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Species of lobster caught.

General Data Type: VARCHAR2

SEX_CODE

CC ID: 1044555
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the sex of the lobster.

General Data Type: VARCHAR2

CARAPACE_LENGTH

CC ID: 1044556
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

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.

General Data Type: VARCHAR2
Unit of Measure: millimeters

TAIL_WIDTH

CC ID: 1044557
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

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.

General Data Type: VARCHAR2
Unit of Measure: millimeters

OVA_COLOR_CODE

CC ID: 1044558
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the color of the ova.

General Data Type: VARCHAR2

TAG_NUMBER

CC ID: 1044559
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Unique tag number.

General Data Type: VARCHAR2

TAG_COLOR_CODE

CC ID: 1044560
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the color of the tag.

General Data Type: VARCHAR2

TAG_CODE

CC ID: 1044561
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for TAG_NUMBER/TAG_COLOR_CODE.

General Data Type: VARCHAR2

JOB_NUMBER

CC ID: 1044562
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1044563
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned to each record for a block of data.

General Data Type: VARCHAR2

DATE_LOADED

CC ID: 1044564
Seq. Order: 48
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was loaded into Oracle or updated.

General Data Type: DATE

Catalog Details

Catalog Item ID: 64309
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-02-23 03:49+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2021-03-02 21:39+0000
Metadata Record Published: 2021-03-02
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-03-03