Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: RI036AA2_RSCH_V
Short Name: RI036AA2_RSCH_V
Status: Completed
Abstract:

Lobster tagging and morphometric data collected during two NOAA R/V Townsend Cromwell cruises.

Entity Information

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

Lobster tagging and morphometric data collected during two NOAA R/V Townsend Cromwell cruises.

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., D99272.
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: 1044469
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: 1044470
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: 1044471
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: 1044472
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: 1044473
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: 1044474
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: 1044475
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: 1044476
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: 1044477
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: 1044478
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: 1044479
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: 1044480
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: 1044481
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: 1044482
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: 1044483
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: 1044484
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: 1044485
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: 1044486
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: 1044487
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: 1044488
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: 1044489
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: 1044490
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: 1044491
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: 1044492
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: 1044493
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: 1044494
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: 1044495
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: 1044496
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: 1044497
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: 1044498
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: 1044499
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: 1044500
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: 1044501
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: 1044502
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: 1044503
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: 1044504
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: 1044505
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: 1044506
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: 1044507
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: 1044508
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: 1044509
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: 1044510
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: 1044511
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: 1044512
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: 1044513
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: 1044514
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., D99272.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1044515
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: 1044516
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: 64307
GUID: gov.noaa.nmfs.inport:64307
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-02-23 03:47+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-03-02
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-03-02
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-03-02