RP037AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:64588 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | RP037AA1_V |
|---|---|
| Short Name: | RP037AA1_V |
| Status: | Completed |
| Abstract: |
Longline fishing morphometric log data collected during the 1981 cruise of the Hokusei Maru. |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Description: |
Longline morphometric data collected during the 1981 cruise of the Hokusei Maru. |
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
|
STATION_NUMBER | VARCHAR2 | Station number of the longline operation. | |
|
100
|
YEAR | VARCHAR2 | Year of the longline operation. | |
|
100
|
MONTH | VARCHAR2 | Month of the longline operation. | |
|
100
|
DAY | VARCHAR2 | Day of the longline operation. | |
|
100
|
TIME_ZONE_CODE | VARCHAR2 | Code for the time zone of the longline operation. | |
|
100
|
NUMBER_BASKETS | VARCHAR2 | Number of baskets set. | |
|
100
|
TOTAL_NUMBER_HOOKS | VARCHAR2 | Total number of hooks retrieved. | |
|
100
|
BAIT_CODE | VARCHAR2 | Code for the bait used. | |
|
100
|
DIRECTION_SET | VARCHAR2 | Direction of set, in degrees. Units for values are degrees. | |
|
100
|
BEGIN_SET_TIME | VARCHAR2 | Begin set time. | |
|
100
|
BEGIN_SET_LATITUDE_DEGREES | VARCHAR2 | Begin set latitude degrees, in degrees. Units for values are degrees. | |
|
100
|
BEGIN_SET_LATITUDE_MINUTES | VARCHAR2 | Begin set latitude minutes, in minutes. Units for values are minutes. | |
|
100
|
BEGIN_SET_LATITUDE_DIRECTION | VARCHAR2 | Not entered during data entry; derived value using BEGIN_SET_OCTANT. | |
|
100
|
BEGIN_SET_LATITUDE_DD | NUMBER | Computed 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
|
BEGIN_SET_LONGITUDE_DEGREES | VARCHAR2 | Begin set longitude degrees, in degrees. Units for values are degrees. | |
|
100
|
BEGIN_SET_LONGITUDE_MINUTES | VARCHAR2 | Begin set longitude minutes, in minutes. Units for values are minutes. | |
|
100
|
BEGIN_SET_LONGITUDE_DIRECTION | VARCHAR2 | Not entered during data entry; derived value using BEGIN_SET_OCTANT. | |
|
100
|
BEGIN_SET_LONGITUDE_DD | NUMBER | Computed 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
|
BEGIN_SET_OCTANT | VARCHAR2 | Begin set octant. | |
|
100
|
END_SET_TIME | VARCHAR2 | End set time. | |
|
100
|
END_SET_LATITUDE_DEGREES | VARCHAR2 | End set latitude degrees, in degrees. Units for values are degrees. | |
|
100
|
END_SET_LATITUDE_MINUTES | VARCHAR2 | End set latitude minutes, in minutes. Units for values are minutes. | |
|
100
|
END_SET_LATITUDE_DIRECTION | VARCHAR2 | Not entered during data entry; derived value using END_SET_OCTANT. | |
|
100
|
END_SET_LATITUDE_DD | NUMBER | Computed 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_SET_LONGITUDE_DEGREES | VARCHAR2 | End set longitude degrees, in degrees. Units for values are degrees. | |
|
100
|
END_SET_LONGITUDE_MINUTES | VARCHAR2 | End set longitude minutes, in minutes. Units for values are minutes. | |
|
100
|
END_SET_LONGITUDE_DIRECTION | VARCHAR2 | Not entered during data entry; derived value using END_SET_OCTANT. | |
|
100
|
END_SET_LONGITUDE_DD | NUMBER | Computed 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_SET_OCTANT | VARCHAR2 | End set octant. | |
|
100
|
BEGIN_HAUL_TIME | VARCHAR2 | Begin haul time. | |
|
100
|
BEGIN_HAUL_LATITUDE_DEGREES | VARCHAR2 | Begin haul latitude degrees, in degrees. Units for values are degrees. | |
|
100
|
BEGIN_HAUL_LATITUDE_MINUTES | VARCHAR2 | Begin haul latitude minutes, in minutes. Units for values are minutes. | |
|
100
|
BEGIN_HAUL_LATITUDE_DIRECTION | VARCHAR2 | Not entered during data entry; derived value using BEGIN_HAUL_OCTANT. | |
|
100
|
BEGIN_HAUL_LATITUDE_DD | NUMBER | Computed 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
|
BEGIN_HAUL_LONGITUDE_DEGREES | VARCHAR2 | Begin haul longitude degrees, in degrees. Units for values are degrees. | |
|
100
|
BEGIN_HAUL_LONGITUDE_MINUTES | VARCHAR2 | Begin haul longitude minutes, in minutes. Units for values are minutes. | |
|
100
|
BEGIN_HAUL_LONGITUDE_DIRECTION | VARCHAR2 | Not entered during data entry; derived value using BEGIN_HAUL_OCTANT. | |
|
100
|
BEGIN_HAUL_LONGITUDE_DD | NUMBER | Computed 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
|
BEGIN_HAUL_OCTANT | VARCHAR2 | Begin haul octant. | |
|
100
|
END_HAUL_TIME | VARCHAR2 | End haul time. | |
|
100
|
END_HAUL_LATITUDE_DEGREES | VARCHAR2 | End haul latitude degrees, in degrees. Units for values are degrees. | |
|
100
|
END_HAUL_LATITUDE_MINUTES | VARCHAR2 | End haul latitude minutes, in minutes. Units for values are minutes. | |
|
100
|
END_HAUL_LATITUDE_DIRECTION | VARCHAR2 | Not entered during data entry; derived value using END_HAUL_OCTANT. | |
|
100
|
END_HAUL_LATITUDE_DD | NUMBER | Computed 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_HAUL_LONGITUDE_DEGREES | VARCHAR2 | End haul longitude degrees, in degrees. Units for values are degrees. | |
|
100
|
END_HAUL_LONGITUDE_MINUTES | VARCHAR2 | End haul longitude minutes, in minutes. Units for values are minutes. | |
|
100
|
END_HAUL_LONGITUDE_DIRECTION | VARCHAR2 | Not entered during data entry; derived value using END_HAUL_OCTANT. | |
|
100
|
END_HAUL_LONGITUDE_DD | NUMBER | Computed 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_HAUL_OCTANT | VARCHAR2 | End haul octant. | |
|
100
|
FISH_NUMBER | VARCHAR2 | A consecutive number for each fish recorded on the data collection form. | |
|
100
|
SPECIES_CODE | VARCHAR2 | Five-digit CZM species code. | |
|
100
|
LENGTH | VARCHAR2 | Length of fish, in tenths of a centimeter. During data entry the decimail point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 1. | |
|
100
|
WEIGHT | VARCHAR2 | Weight of fish, in tenths of a kilogram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 1. | |
|
100
|
CONDITION_CODE | VARCHAR2 | Code for the condition of the fish. | |
|
100
|
SEX_CODE | VARCHAR2 | Code for the sex of the fish. | |
|
100
|
FISH_RELEASED_CODE | VARCHAR2 | Code whether the fish was released. | |
|
100
|
BIOLOGICAL_SAMPLE_CODE | VARCHAR2 | Code whether a biological sample was collected. | |
|
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. | |
|
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: 1064653
| 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: 1064654
| 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: 1064655
| 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: | 995 = HOKUSEI MARU |
STATION_NUMBER
CC ID: 1064656
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Station number of the longline operation. |
| General Data Type: | VARCHAR2 |
YEAR
CC ID: 1064657
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Year of the longline operation. |
| General Data Type: | VARCHAR2 |
MONTH
CC ID: 1064658
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Month of the longline operation. |
| General Data Type: | VARCHAR2 |
DAY
CC ID: 1064659
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Day of the longline operation. |
| General Data Type: | VARCHAR2 |
TIME_ZONE_CODE
CC ID: 1064660
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the time zone of the longline operation. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | X = + 11 |
NUMBER_BASKETS
CC ID: 1064661
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of baskets set. |
| General Data Type: | VARCHAR2 |
TOTAL_NUMBER_HOOKS
CC ID: 1064662
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total number of hooks retrieved. |
| General Data Type: | VARCHAR2 |
BAIT_CODE
CC ID: 1064663
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the bait used. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 10 = SAURY (SCOMBERESOCIDAE) |
DIRECTION_SET
CC ID: 1064664
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Direction of set, in degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
BEGIN_SET_TIME
CC ID: 1064665
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin set time. |
| General Data Type: | VARCHAR2 |
BEGIN_SET_LATITUDE_DEGREES
CC ID: 1064666
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin set latitude degrees, in degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
BEGIN_SET_LATITUDE_MINUTES
CC ID: 1064667
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin set latitude minutes, in minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
BEGIN_SET_LATITUDE_DIRECTION
CC ID: 1064668
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Not entered during data entry; derived value using BEGIN_SET_OCTANT. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | N = NORTH |
BEGIN_SET_LATITUDE_DD
CC ID: 1064669
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 41 |
| Required: | No |
| Primary Key: | No |
| Scale: | 38 |
| Status: | Active |
| Description: |
Computed 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 |
BEGIN_SET_LONGITUDE_DEGREES
CC ID: 1064670
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin set longitude degrees, in degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
BEGIN_SET_LONGITUDE_MINUTES
CC ID: 1064671
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin set longitude minutes, in minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
BEGIN_SET_LONGITUDE_DIRECTION
CC ID: 1064672
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Not entered during data entry; derived value using BEGIN_SET_OCTANT. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | W = WEST |
BEGIN_SET_LONGITUDE_DD
CC ID: 1064673
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 41 |
| Required: | No |
| Primary Key: | No |
| Scale: | 36 |
| Status: | Active |
| Description: |
Computed 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 |
BEGIN_SET_OCTANT
CC ID: 1064674
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin set octant. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 1 = NORTH LATITUDE; 90° WEST - 179° 59’ WEST LONGITUDE |
END_SET_TIME
CC ID: 1064675
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End set time. |
| General Data Type: | VARCHAR2 |
END_SET_LATITUDE_DEGREES
CC ID: 1064676
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End set latitude degrees, in degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
END_SET_LATITUDE_MINUTES
CC ID: 1064677
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End set latitude minutes, in minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
END_SET_LATITUDE_DIRECTION
CC ID: 1064678
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Not entered during data entry; derived value using END_SET_OCTANT. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | N = NORTH |
END_SET_LATITUDE_DD
CC ID: 1064679
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 41 |
| Required: | No |
| Primary Key: | No |
| Scale: | 38 |
| Status: | Active |
| Description: |
Computed 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_SET_LONGITUDE_DEGREES
CC ID: 1064680
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End set longitude degrees, in degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
END_SET_LONGITUDE_MINUTES
CC ID: 1064681
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End set longitude minutes, in minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
END_SET_LONGITUDE_DIRECTION
CC ID: 1064682
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Not entered during data entry; derived value using END_SET_OCTANT. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | W = WEST |
END_SET_LONGITUDE_DD
CC ID: 1064683
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 41 |
| Required: | No |
| Primary Key: | No |
| Scale: | 36 |
| Status: | Active |
| Description: |
Computed 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_SET_OCTANT
CC ID: 1064684
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End set octant. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 1 = NORTH LATITUDE; 90° WEST - 179° 59’ WEST LONGITUDE |
BEGIN_HAUL_TIME
CC ID: 1064685
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin haul time. |
| General Data Type: | VARCHAR2 |
BEGIN_HAUL_LATITUDE_DEGREES
CC ID: 1064686
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin haul latitude degrees, in degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
BEGIN_HAUL_LATITUDE_MINUTES
CC ID: 1064687
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin haul latitude minutes, in minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
BEGIN_HAUL_LATITUDE_DIRECTION
CC ID: 1064688
| Seq. Order: | 36 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Not entered during data entry; derived value using BEGIN_HAUL_OCTANT. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | N = NORTH |
BEGIN_HAUL_LATITUDE_DD
CC ID: 1064689
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 41 |
| Required: | No |
| Primary Key: | No |
| Scale: | 38 |
| Status: | Active |
| Description: |
Computed 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 |
BEGIN_HAUL_LONGITUDE_DEGREES
CC ID: 1064690
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin haul longitude degrees, in degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
BEGIN_HAUL_LONGITUDE_MINUTES
CC ID: 1064691
| Seq. Order: | 39 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin haul longitude minutes, in minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
BEGIN_HAUL_LONGITUDE_DIRECTION
CC ID: 1064692
| Seq. Order: | 40 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Not entered during data entry; derived value using BEGIN_HAUL_OCTANT. |
| General Data Type: | VARCHAR2 |
BEGIN_HAUL_LONGITUDE_DD
CC ID: 1064693
| Seq. Order: | 41 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 41 |
| Required: | No |
| Primary Key: | No |
| Scale: | 36 |
| Status: | Active |
| Description: |
Computed 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 |
BEGIN_HAUL_OCTANT
CC ID: 1064694
| Seq. Order: | 42 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Begin haul octant. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 1 = NORTH LATITUDE; 90° WEST - 179° 59’ WEST LONGITUDE |
END_HAUL_TIME
CC ID: 1064695
| Seq. Order: | 43 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End haul time. |
| General Data Type: | VARCHAR2 |
END_HAUL_LATITUDE_DEGREES
CC ID: 1064696
| Seq. Order: | 44 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End haul latitude degrees, in degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
END_HAUL_LATITUDE_MINUTES
CC ID: 1064697
| Seq. Order: | 45 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End haul latitude minutes, in minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
END_HAUL_LATITUDE_DIRECTION
CC ID: 1064698
| Seq. Order: | 46 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Not entered during data entry; derived value using END_HAUL_OCTANT. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | N = NORTH |
END_HAUL_LATITUDE_DD
CC ID: 1064699
| Seq. Order: | 47 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 41 |
| Required: | No |
| Primary Key: | No |
| Scale: | 38 |
| Status: | Active |
| Description: |
Computed 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_HAUL_LONGITUDE_DEGREES
CC ID: 1064700
| Seq. Order: | 48 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End haul longitude degrees, in degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
END_HAUL_LONGITUDE_MINUTES
CC ID: 1064701
| Seq. Order: | 49 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End haul longitude minutes, in minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
END_HAUL_LONGITUDE_DIRECTION
CC ID: 1064702
| Seq. Order: | 50 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Not entered during data entry; derived value using END_HAUL_OCTANT. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | W = WEST |
END_HAUL_LONGITUDE_DD
CC ID: 1064703
| Seq. Order: | 51 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 41 |
| Required: | No |
| Primary Key: | No |
| Scale: | 36 |
| Status: | Active |
| Description: |
Computed 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_HAUL_OCTANT
CC ID: 1064704
| Seq. Order: | 52 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End haul octant. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 1 = NORTH LATITUDE; 90° WEST - 179° 59’ WEST LONGITUDE |
FISH_NUMBER
CC ID: 1064705
| Seq. Order: | 53 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
A consecutive number for each fish recorded on the data collection form. |
| General Data Type: | VARCHAR2 |
SPECIES_CODE
CC ID: 1064706
| Seq. Order: | 54 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Five-digit CZM species code. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 10110 = ALEPISAURUS SP.; 11611 = TARACTICHTHYS STEINDACHNERI(T.LONGIPINNIS,T.STEINDACHNERI); 11631 = EUMEGISTUS ILLUSTRIS; 14821 = LEPIDOCYBIUM FLAVOBRUNNEUM; 16047 = TETRAPTERUS ANGUSTIROSTRIS; 16051 = TETRAPTERUS AUDAX; 16501 = LAMPRIS REGIUS; 20332 = KATSUWONUS PELAMIS; 20334 = THUNNUS OBESUS; 20335 = THUNNUS ALBACARES; 20336 = THUNNUS ALALUNGA; 20344 = ACANTHOCYBIUM SOLANDRI; 22052 = XIPHIAS GLADIUS |
LENGTH
CC ID: 1064707
| Seq. Order: | 55 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Length of fish, in tenths of a centimeter. During data entry the decimail point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 1. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | centimeters |
| Format Mask: | 5 |
WEIGHT
CC ID: 1064708
| Seq. Order: | 56 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Weight of fish, in tenths of a kilogram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 1. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | kilograms |
| Format Mask: | 4 |
CONDITION_CODE
CC ID: 1064709
| Seq. Order: | 57 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the condition of the fish. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 1 = A (ALIVE); 2 = D (DEAD); 3 = SE (SHARK EATEN) |
SEX_CODE
CC ID: 1064710
| Seq. Order: | 58 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the sex of the fish. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | F = FEMALE; M = MALE |
FISH_RELEASED_CODE
CC ID: 1064711
| Seq. Order: | 59 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code whether the fish was released. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 1 = YES, FISH RELEASED |
BIOLOGICAL_SAMPLE_CODE
CC ID: 1064712
| Seq. Order: | 60 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code whether a biological sample was collected. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 1 = YES, BIOLOGICAL SAMPLE KEPT |
JOB_NUMBER
CC ID: 1064713
| Seq. Order: | 61 |
|---|---|
| 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. |
| General Data Type: | VARCHAR2 |
SEQUENCE_NUMBER
CC ID: 1064714
| Seq. Order: | 62 |
|---|---|
| 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: 1064715
| Seq. Order: | 63 |
|---|---|
| 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: | 64588 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:64588 |
| Metadata Record Created By: | Brent M Miyamoto |
| Metadata Record Created: | 2021-04-30 21:49+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2021-05-07 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2021-05-07 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2022-05-07 |