RP014AA1_RSCH_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:64773 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | RP014AA1_RSCH_V |
---|---|
Short Name: | RP014AA1_RSCH_V |
Status: | Completed |
Abstract: |
Tuna Morphometric Log Data collected during NOAA research vessel cruises between 1949 and 1957. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Tuna Morphometric Log Data collected during NOAA research vessel cruises between 1949 and 1957. |
Data Attributes
Attribute Summary
![]() |
![]() |
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 | Four digit incremental cruise number of the vessel, e.g., 0032. | |
100
|
YEAR | VARCHAR2 | Year. | |
100
|
MONTH | VARCHAR2 | Month. | |
100
|
DAY | VARCHAR2 | Day. | |
100
|
GEAR_CODE | VARCHAR2 | Code for the gear type used. | |
100
|
OCTANT | VARCHAR2 | Octant of the globe, used to determine the LATITUDE_DIRECTION, LONGITUDE_DEGREES (first digit 0 or 1) and LONGITUDE_DIRECTION. | |
100
|
LATITUDE_DEGREES | VARCHAR2 | Latitude degrees where fish was taken. Units for values are degrees. | |
100
|
LATITUDE_MINUTES | VARCHAR2 | Latitude minutes where fish was taken. Units for values are minutes. | |
100
|
LATITUDE_DIRECTION | VARCHAR2 | Latitude direction where fish was taken, determined using OCTANT. | |
100
|
LATITUDE_DD | NUMBER | Computed latitude, in decimal degrees, where fish was taken. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
LONGITUDE_DEGREES | VARCHAR2 | Longitude degrees where fish was taken. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data, determined using OCTANT. Units for values are degrees. | |
100
|
LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes where fish was taken. Units for values are minutes. | |
100
|
LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction where fish was taken, determined using OCTANT. | |
100
|
LONGITUDE_DD | NUMBER | Computed longitude, in decimal degrees, where the fish was taken. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
SPECIES_CODE | VARCHAR2 | Species code of fish. | |
100
|
SEX_MATURITY_CODE | VARCHAR2 | Sex and maturity code of fish. | |
100
|
WEIGHT | VARCHAR2 | Weight of fish, in pounds. Units for values are pounds. | |
100
|
WEIGHT_2 | VARCHAR2 | Weight of fish, in tenths of a pound, for VESSEL_CODE = 005 and CRUISE_NUMBER = 0032. Data in WEIGHT_2 was rounded to whole pounds using Rounded Half to Even and inserted into WEIGHT. Units for values are pounds. Measures are reported with a precision of 4. | |
100
|
FORK_LENGTH | VARCHAR2 | Fork length, in millimeters. Units for values are millimeters. | |
100
|
HEAD_LENGTH | VARCHAR2 | Head length, in millimeters. Units for values are millimeters. | |
100
|
SNOUT_TO_INS_FIRST_DORSAL | VARCHAR2 | Snout to Insertion First Dorsal, in millimeters. Units for values are millimeters. | |
100
|
SNOUT_TO_INS_SECOND_DORSAL | VARCHAR2 | Snout to Insertion Second Dorsal, in millimeters. Units for values are millimeters. | |
100
|
SNOUT_TO_INS_ANAL | VARCHAR2 | Snout to Insertion Anal, in millimeters. Units for values are millimeters. | |
100
|
SNOUT_TO_INS_VENTRAL | VARCHAR2 | Snout to Insertion Ventral, in millimeters. Units for values are millimeters. | |
100
|
INS_VENTRAL_TO_ANTER_EDGE_VENT | VARCHAR2 | Insertion Ventrals to Anterior Edge Vent, in millimeters. Units for values are millimeters. | |
100
|
GREATEST_BODY_DEPTH | VARCHAR2 | Greatest Body Depth, in millimeters. Units for values are millimeters. | |
100
|
AT_SPINE_NUM | VARCHAR2 | Dorsal spine number of Greatest Body Depth. Units for values are millimeters. | |
100
|
LENGTH_PECTORAL | VARCHAR2 | Length Pectoral, in millimeters. Units for values are millimeters. | |
100
|
HEIGHT_SECOND_DORSAL | VARCHAR2 | Height (or length) of Second Dorsal, in millimeters. Units for values are millimeters. | |
100
|
HEIGHT_ANAL | VARCHAR2 | Height (or length) of Anal, in millimeters. Units for values are millimeters. | |
100
|
DIAMETER_IRIS | VARCHAR2 | Diameter of the iris, in millimeters. Units for values are millimeters. | |
100
|
NUMBER_GILL_RAKERS_1 | VARCHAR2 | Number of Gill Rakers, two numbers separated by a plus sign (XX+XX) on the data collection form, separated into two columns. | |
100
|
NUMBER_GILL_RAKERS_2 | VARCHAR2 | Number of Gill Rakers, two numbers separated by a plus sign (XX+XX) on the data collection form, separated into two columns. | |
100
|
TOTAL_LENGTH | VARCHAR2 | Total Length, in millimeters. The first character, "}" and "J", was replaced with a "0" or "1". Units for values are millimeters. | |
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
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
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
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 |
Allowed Values: | 004 = HUGH M. SMITH; 005 = JOHN R. MANNING; 006 = HENRY O'MALLEY; 007 = CHARLES H. GILBERT |
CRUISE_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Four digit incremental cruise number of the vessel, e.g., 0032. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day. |
General Data Type: | VARCHAR2 |
GEAR_CODE
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the gear type used. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = TROLLING; 2 = POLE AND LINE; 3 = LONGLINE; 4 = GILL NET |
OCTANT
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Octant of the globe, used to determine the LATITUDE_DIRECTION, LONGITUDE_DEGREES (first digit 0 or 1) and LONGITUDE_DIRECTION. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = NORTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 1 = NORTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 2 = NORTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 3 = NORTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE; 5 = SOUTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 6 = SOUTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 7 = SOUTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 8 = SOUTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE |
LATITUDE_DEGREES
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude degrees where fish was taken. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LATITUDE_MINUTES
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude minutes where fish was taken. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LATITUDE_DIRECTION
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude direction where fish was taken, determined using OCTANT. |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S = SOUTH |
LATITUDE_DD
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 37 |
Status: | Active |
Description: |
Computed latitude, in decimal degrees, where fish was taken. 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 |
LONGITUDE_DEGREES
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude degrees where fish was taken. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data, determined using OCTANT. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LONGITUDE_MINUTES
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude minutes where fish was taken. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LONGITUDE_DIRECTION
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude direction where fish was taken, determined using OCTANT. |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
LONGITUDE_DD
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed longitude, in decimal degrees, where the fish was taken. 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 |
SPECIES_CODE
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species code of fish. |
General Data Type: | VARCHAR2 |
Allowed Values: | 32 = SKIPJACK; 33 = LITTLE TUNNY; 34 = BIGEYE; 35 = YELLOWFIN; 36 = ALBACORE |
SEX_MATURITY_CODE
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sex and maturity code of fish. |
General Data Type: | VARCHAR2 |
Allowed Values: | NULL = NOT EXAMINED (ALTERNATE CODE = BLANK); A = IMMATURE, SEX NOT DETERMINED (ALTERNATE CODE = BLANK); B = MALE, MATURITY UNDETERMINED (ALTERNATE CODE = 0); C = MALE, IMMATURE (ALTERNATE CODE = 1); D = MALE, MATURING (ALTERNATE CODE = 2); E = MALE, RIPE (ALTERNATE CODE = 3); F = MALE, SPENT (ALTERNATE CODE = 4); G = FEMALE, IMMATURE (ALTERNATE CODE = 5); H = FEMALE, MATURING (ALTERNATE CODE = 6); I = FEMALE, RIPE (ALTERNATE CODE = 7); J = FEMALE, SPENT (ALTERNATE CODE = 8); K = FEMALE, MATURITY UNDETERMINED (ALTERNATE CODE = 9) |
WEIGHT
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight of fish, in pounds. Units for values are pounds. |
General Data Type: | VARCHAR2 |
Unit of Measure: | pounds |
WEIGHT_2
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Weight of fish, in tenths of a pound, for VESSEL_CODE = 005 and CRUISE_NUMBER = 0032. Data in WEIGHT_2 was rounded to whole pounds using Rounded Half to Even and inserted into WEIGHT. Units for values are pounds. Measures are reported with a precision of 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | pounds |
FORK_LENGTH
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fork length, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
HEAD_LENGTH
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Head length, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
SNOUT_TO_INS_FIRST_DORSAL
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Snout to Insertion First Dorsal, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
SNOUT_TO_INS_SECOND_DORSAL
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Snout to Insertion Second Dorsal, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
SNOUT_TO_INS_ANAL
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Snout to Insertion Anal, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
SNOUT_TO_INS_VENTRAL
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Snout to Insertion Ventral, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
INS_VENTRAL_TO_ANTER_EDGE_VENT
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Insertion Ventrals to Anterior Edge Vent, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
GREATEST_BODY_DEPTH
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Greatest Body Depth, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
AT_SPINE_NUM
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Dorsal spine number of Greatest Body Depth. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
LENGTH_PECTORAL
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length Pectoral, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
HEIGHT_SECOND_DORSAL
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Height (or length) of Second Dorsal, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
HEIGHT_ANAL
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Height (or length) of Anal, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
DIAMETER_IRIS
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Diameter of the iris, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
NUMBER_GILL_RAKERS_1
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Gill Rakers, two numbers separated by a plus sign (XX+XX) on the data collection form, separated into two columns. |
General Data Type: | VARCHAR2 |
NUMBER_GILL_RAKERS_2
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Gill Rakers, two numbers separated by a plus sign (XX+XX) on the data collection form, separated into two columns. |
General Data Type: | VARCHAR2 |
TOTAL_LENGTH
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total Length, in millimeters. The first character, "}" and "J", was replaced with a "0" or "1". Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
SEQUENCE_NUMBER
Seq. Order: | 38 |
---|---|
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
Seq. Order: | 39 |
---|---|
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: | 64773 |
---|---|
GUID: | gov.noaa.nmfs.inport:64773 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2021-06-09 00:01+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:12+0000 |
Metadata Record Published: | 2021-07-08 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-07-08 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-07-08 |