RI002AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:52578 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Handline Fishing Log data collected by R/V Townsend Cromwell and R/V Oscar E Sette in the central and western Pacific Ocean.
DescriptionHandline Fishing Log data collected by R/V Townsend Cromwell and R/V Oscar E Sette in the central and western Pacific Ocean.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
DATASET_CODE
Character |
Source ID Code assigned by the data entry staff (RI002). |
VERSION_CODE
Character |
Code for the format version assigned by the data entry staff. |
VESSEL_CODE
Character |
Code for vessel. |
CRUISE_NUMBER
Number |
Last two digits of the year of the cruise and two digits incremental number of the cruise for the year. |
STATION_NUMBER
Number |
Station number of handline fishing operation. |
FISHING_YEAR
Number |
Year of fishing. |
FISHING_MONTH
Number |
Month of fishing. |
FISHING_DAY
Number |
Day of fishing. |
AREA_FISHED_LATITUDE_DEGREES
Number |
Latitude degrees of area fished, in degrees. Units for values are degrees. |
AREA_FISHED_LATITUDE_MINUTES
Number |
Latitude minutes of area fished, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
AREA_FISHED_LATITUDE_DIR
Character |
Latitude direction of area fished. |
AREA_FISHED_LATITUDE_DD
Number |
Latitude of area fished, in decimal degrees, computed using area_fished_latitude_degrees, area_fished_latitude_minutes, and area_fished_latitude_dir. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15. |
AREA_FISHED_LONGITUDE_DEGREES
Number |
Longitude degrees of area fished, in degrees. Units for values are degrees. |
AREA_FISHED_LONGITUDE_MINUTES
Number |
Longitude minutes of area fished, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
AREA_FISHED_LONGITUDE_DIR
Character |
Longitude direction of area fished. |
AREA_FISHED_LONGITUDE_DD
Number |
Longitude of area fished, in decimal degrees, computed using area_fished_longitude_degrees, area_fished_longitude_minutes, and area_fished_longitude_dir. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15. |
TO_LATITUDE_DEGREES
Number |
Latitude degrees of area fished to, in degrees. Units for values are degrees. |
TO_LATITUDE_MINUTES
Number |
Latitude minutes of area fished to, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
TO_LATITUDE_DIR
Character |
Latitude direction of area fished to. |
TO_LATITUDE_DD
Number |
Latitude of area fished to, in decimal degrees, computed using to_latitude_degrees, to_latitude_minutes, and to_latitude_dir. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15. |
TO_LONGITUDE_DEGREES
Number |
Longitude degrees of area fished to, in degrees. Units for values are degrees. |
TO_LONGITUDE_MINUTES
Number |
Longitude minutes of area fished to, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
TO_LONGITUDE_DIR
Character |
Longitude direction of area fished to. |
TO_LONGITUDE_DD
Number |
Longitude of area fished to, in decimal degrees, computed using to_longitude_degrees, to_longitude_minutes, and to_longitude_dir. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15. |
DRIFTING_ANCHORED_CODE
Number |
Code for type of bottomfishing activity, drifting or anchored. |
DEPTH_MINIMUM
Number |
Mininum depth range of fishing, in fathoms. Units for values are fathoms. |
DEPTH_MAXIMUM
Number |
Maximum depth range of fishing, in fathoms. Units for values are fathoms. |
BANK_CODE
Number |
Code for the bank where fishing occurred. |
TIME_STATION_STARTED
Number |
Time fishing station started. |
TIME_STATION_ENDED
Number |
Time fishing station ended. |
DRIFT_NUMBER
Number |
Drift number. |
TIME_DRIFT_STARTED
Number |
Time drift started. |
TIME_DRIFT_ENDED
Number |
Time drift ended. |
DEPTH_DRIFT_STARTED
Number |
Depth when drift started, in fathoms. Units for values are fathoms. |
DEPTH_DRIFT_ENDED
Number |
Depth when drift ended, in fathoms. Units for values are fathoms. |
NUMBER_LINES
Number |
Average number of lines fishing, in tenths. The decimal point was left off during data entry; it has been inserted into the data. Measures are reported with a precision of 3. |
NUMBER_HOOKS_PER_LINE
Number |
Average number of hooks per line, in tenths. The decimal point was left off during data entry; it has been inserted into the data. Measures are reported with a precision of 3. |
NUMBER_HOOKS_SIZE_1
Number |
Number of hook_size_1 used (columns 1-2 number of hooks, columns 3-4 hook size). |
NUMBER_HOOKS_SIZE_2
Number |
Number of hook_size_2 used (columns 1-2 number of hooks, columns 3-4 hook size). |
NUMBER_HOOKS_SIZE_3
Number |
Number of hook_size_3 used (columns 1-2 number of hooks, columns 3-4 hook size). |
NUMBER_HOOKS_SIZE_4
Number |
Number of hook_size_4 used (columns 1-2 number of hooks, columns 3-4 hook size). |
BAIT_CODE
Number |
Code for the kind of bait used. |
FISH_NUMBER
Number |
Number assigned to the fish caught and links the fish to FISH SAMPLING LOG (RI003). |
TIME_CAUGHT
Number |
Time fish was caught. |
SPECIES_CODE
Number |
Species code of the fish caught. |
HOOK_SIZE
Number |
Size of the hook that the fish was caught. |
TOTAL_OR_FORK_LENGTH
Number |
Total or fork length of species, in tenths of a centimeter. The decimal point was left off during data entry; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4. |
DEPTH_CAUGHT
Number |
Depth that the species was caught, in fathoms. |
JOB_NUMBER
Character |
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., D95084. |
SEQUENCE_NUMBER
Number |
A consecutive number assigned to each record for a block of data. |
DATE_LOADED
Date |
Date when the record was loaded into Oracle or updated. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (PIFSC) for inquiries on this record.
Item Identification
Title: | RI002AA1_V |
---|---|
Short Name: | RI002AA1_V |
Status: | Completed |
Abstract: |
Handline Fishing Log data collected by R/V Townsend Cromwell and R/V Oscar E Sette in the central and western Pacific Ocean. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Handline Fishing Log data collected by R/V Townsend Cromwell and R/V Oscar E Sette in the central and western Pacific Ocean. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
DATASET_CODE | Character | Source ID Code assigned by the data entry staff (RI002). | |
100
|
VERSION_CODE | Character | Code for the format version assigned by the data entry staff. | |
100
|
VESSEL_CODE | Character | Code for vessel. | |
100
|
CRUISE_NUMBER | Number | Last two digits of the year of the cruise and two digits incremental number of the cruise for the year. | |
100
|
STATION_NUMBER | Number | Station number of handline fishing operation. | |
100
|
FISHING_YEAR | Number | Year of fishing. | |
100
|
FISHING_MONTH | Number | Month of fishing. | |
100
|
FISHING_DAY | Number | Day of fishing. | |
100
|
AREA_FISHED_LATITUDE_DEGREES | Number | Latitude degrees of area fished, in degrees. Units for values are degrees. | |
100
|
AREA_FISHED_LATITUDE_MINUTES | Number | Latitude minutes of area fished, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. | |
100
|
AREA_FISHED_LATITUDE_DIR | Character | Latitude direction of area fished. | |
100
|
AREA_FISHED_LATITUDE_DD | Number | Latitude of area fished, in decimal degrees, computed using area_fished_latitude_degrees, area_fished_latitude_minutes, and area_fished_latitude_dir. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15. | |
100
|
AREA_FISHED_LONGITUDE_DEGREES | Number | Longitude degrees of area fished, in degrees. Units for values are degrees. | |
100
|
AREA_FISHED_LONGITUDE_MINUTES | Number | Longitude minutes of area fished, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. | |
100
|
AREA_FISHED_LONGITUDE_DIR | Character | Longitude direction of area fished. | |
100
|
AREA_FISHED_LONGITUDE_DD | Number | Longitude of area fished, in decimal degrees, computed using area_fished_longitude_degrees, area_fished_longitude_minutes, and area_fished_longitude_dir. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15. | |
100
|
TO_LATITUDE_DEGREES | Number | Latitude degrees of area fished to, in degrees. Units for values are degrees. | |
100
|
TO_LATITUDE_MINUTES | Number | Latitude minutes of area fished to, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. | |
100
|
TO_LATITUDE_DIR | Character | Latitude direction of area fished to. | |
100
|
TO_LATITUDE_DD | Number | Latitude of area fished to, in decimal degrees, computed using to_latitude_degrees, to_latitude_minutes, and to_latitude_dir. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15. | |
100
|
TO_LONGITUDE_DEGREES | Number | Longitude degrees of area fished to, in degrees. Units for values are degrees. | |
100
|
TO_LONGITUDE_MINUTES | Number | Longitude minutes of area fished to, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. | |
100
|
TO_LONGITUDE_DIR | Character | Longitude direction of area fished to. | |
100
|
TO_LONGITUDE_DD | Number | Longitude of area fished to, in decimal degrees, computed using to_longitude_degrees, to_longitude_minutes, and to_longitude_dir. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15. | |
100
|
DRIFTING_ANCHORED_CODE | Number | Code for type of bottomfishing activity, drifting or anchored. | |
100
|
DEPTH_MINIMUM | Number | Mininum depth range of fishing, in fathoms. Units for values are fathoms. | |
100
|
DEPTH_MAXIMUM | Number | Maximum depth range of fishing, in fathoms. Units for values are fathoms. | |
100
|
BANK_CODE | Number | Code for the bank where fishing occurred. | |
100
|
TIME_STATION_STARTED | Number | Time fishing station started. | |
100
|
TIME_STATION_ENDED | Number | Time fishing station ended. | |
100
|
DRIFT_NUMBER | Number | Drift number. | |
100
|
TIME_DRIFT_STARTED | Number | Time drift started. | |
100
|
TIME_DRIFT_ENDED | Number | Time drift ended. | |
100
|
DEPTH_DRIFT_STARTED | Number | Depth when drift started, in fathoms. Units for values are fathoms. | |
100
|
DEPTH_DRIFT_ENDED | Number | Depth when drift ended, in fathoms. Units for values are fathoms. | |
100
|
NUMBER_LINES | Number | Average number of lines fishing, in tenths. The decimal point was left off during data entry; it has been inserted into the data. Measures are reported with a precision of 3. | |
100
|
NUMBER_HOOKS_PER_LINE | Number | Average number of hooks per line, in tenths. The decimal point was left off during data entry; it has been inserted into the data. Measures are reported with a precision of 3. | |
100
|
NUMBER_HOOKS_SIZE_1 | Number | Number of hook_size_1 used (columns 1-2 number of hooks, columns 3-4 hook size). | |
100
|
NUMBER_HOOKS_SIZE_2 | Number | Number of hook_size_2 used (columns 1-2 number of hooks, columns 3-4 hook size). | |
100
|
NUMBER_HOOKS_SIZE_3 | Number | Number of hook_size_3 used (columns 1-2 number of hooks, columns 3-4 hook size). | |
100
|
NUMBER_HOOKS_SIZE_4 | Number | Number of hook_size_4 used (columns 1-2 number of hooks, columns 3-4 hook size). | |
100
|
BAIT_CODE | Number | Code for the kind of bait used. | |
100
|
FISH_NUMBER | Number | Number assigned to the fish caught and links the fish to FISH SAMPLING LOG (RI003). | |
100
|
TIME_CAUGHT | Number | Time fish was caught. | |
100
|
SPECIES_CODE | Number | Species code of the fish caught. | |
100
|
HOOK_SIZE | Number | Size of the hook that the fish was caught. | |
100
|
TOTAL_OR_FORK_LENGTH | Number | Total or fork length of species, in tenths of a centimeter. The decimal point was left off during data entry; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4. | |
100
|
DEPTH_CAUGHT | Number | Depth that the species was caught, in fathoms. | |
100
|
JOB_NUMBER | Character | 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., D95084. | |
100
|
SEQUENCE_NUMBER | Number | 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: | Character |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Source ID Code assigned by the data entry staff (RI002). |
General Data Type: | Character |
Allowed Values: | RI002 |
VERSION_CODE
Seq. Order: | 2 |
---|---|
Data Storage Type: | Character |
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: | Character |
VESSEL_CODE
Seq. Order: | 3 |
---|---|
Data Storage Type: | Character |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for vessel. |
General Data Type: | Character |
Allowed Values: | 001 = NOAA R/V TOWNSEND CROMWELL OES = NOAA R/V OSCAR E SETTE |
CRUISE_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Last two digits of the year of the cruise and two digits incremental number of the cruise for the year. |
General Data Type: | Number |
STATION_NUMBER
Seq. Order: | 5 |
---|---|
Data Storage Type: | Number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station number of handline fishing operation. |
General Data Type: | Number |
FISHING_YEAR
Seq. Order: | 6 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year of fishing. |
General Data Type: | Number |
FISHING_MONTH
Seq. Order: | 7 |
---|---|
Data Storage Type: | Number |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month of fishing. |
General Data Type: | Number |
FISHING_DAY
Seq. Order: | 8 |
---|---|
Data Storage Type: | Number |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day of fishing. |
General Data Type: | Number |
AREA_FISHED_LATITUDE_DEGREES
Seq. Order: | 9 |
---|---|
Data Storage Type: | Number |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude degrees of area fished, in degrees. Units for values are degrees. |
General Data Type: | Number |
Unit of Measure: | degrees |
AREA_FISHED_LATITUDE_MINUTES
Seq. Order: | 10 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Latitude minutes of area fished, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
General Data Type: | Number |
Unit of Measure: | minutes |
AREA_FISHED_LATITUDE_DIR
Seq. Order: | 11 |
---|---|
Data Storage Type: | Character |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude direction of area fished. |
General Data Type: | Character |
Allowed Values: | N = NORTH S = SOUTH |
AREA_FISHED_LATITUDE_DD
Seq. Order: | 12 |
---|---|
Data Storage Type: | Number |
Max Length: | 17 |
Required: | No |
Primary Key: | No |
Scale: | 13 |
Status: | Active |
Description: |
Latitude of area fished, in decimal degrees, computed using area_fished_latitude_degrees, area_fished_latitude_minutes, and area_fished_latitude_dir. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15. |
General Data Type: | Number |
Unit of Measure: | degrees |
Derivation: |
case when area_fished_latitude_dir = 'N' then (area_fished_latitude_degrees + ((area_fished_latitude_minutes/10.0)/60.0)) when area_fished_latitude_dir = 'S' then -1.0 *(area_fished_latitude_degrees + ((area_fished_latitude_minutes/10.0)/60.0)) else NULL END AREA_FISHED_LATITUDE_DD, |
AREA_FISHED_LONGITUDE_DEGREES
Seq. Order: | 13 |
---|---|
Data Storage Type: | Number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude degrees of area fished, in degrees. Units for values are degrees. |
General Data Type: | Number |
Unit of Measure: | degrees |
AREA_FISHED_LONGITUDE_MINUTES
Seq. Order: | 14 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Longitude minutes of area fished, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
General Data Type: | Number |
Unit of Measure: | minutes |
AREA_FISHED_LONGITUDE_DIR
Seq. Order: | 15 |
---|---|
Data Storage Type: | Character |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude direction of area fished. |
General Data Type: | Character |
Allowed Values: | E = EAST W = WEST |
AREA_FISHED_LONGITUDE_DD
Seq. Order: | 16 |
---|---|
Data Storage Type: | Number |
Max Length: | 17 |
Required: | No |
Primary Key: | No |
Scale: | 12 |
Status: | Active |
Description: |
Longitude of area fished, in decimal degrees, computed using area_fished_longitude_degrees, area_fished_longitude_minutes, and area_fished_longitude_dir. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15. |
General Data Type: | Number |
Unit of Measure: | degrees |
Derivation: |
case when area_fished_longitude_dir = 'E' then (area_fished_longitude_degrees + ((area_fished_longitude_minutes/10.0)/60.0)) when area_fished_longitude_dir = 'W' then -1.0 *(area_fished_longitude_degrees + ((area_fished_longitude_minutes/10.0)/60.0)) else NULL END AREA_FISHED_LONGITUDE_DD, |
TO_LATITUDE_DEGREES
Seq. Order: | 17 |
---|---|
Data Storage Type: | Number |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude degrees of area fished to, in degrees. Units for values are degrees. |
General Data Type: | Number |
Unit of Measure: | degrees |
TO_LATITUDE_MINUTES
Seq. Order: | 18 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Latitude minutes of area fished to, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
General Data Type: | Number |
Unit of Measure: | minutes |
TO_LATITUDE_DIR
Seq. Order: | 19 |
---|---|
Data Storage Type: | Character |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude direction of area fished to. |
General Data Type: | Character |
Allowed Values: | N = NORTH S = SOUTH |
TO_LATITUDE_DD
Seq. Order: | 20 |
---|---|
Data Storage Type: | Number |
Max Length: | 17 |
Required: | No |
Primary Key: | No |
Scale: | 13 |
Status: | Active |
Description: |
Latitude of area fished to, in decimal degrees, computed using to_latitude_degrees, to_latitude_minutes, and to_latitude_dir. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15. |
General Data Type: | Number |
Unit of Measure: | degrees |
Derivation: |
case when to_latitude_dir = 'N' then (to_latitude_degrees + ((to_latitude_minutes/10.0)/60.0)) when to_latitude_dir = 'S' then -1.0 *(to_latitude_degrees + ((to_latitude_minutes/10.0)/60.0)) else NULL END TO_LATITUDE_DD, |
TO_LONGITUDE_DEGREES
Seq. Order: | 21 |
---|---|
Data Storage Type: | Number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude degrees of area fished to, in degrees. Units for values are degrees. |
General Data Type: | Number |
Unit of Measure: | degrees |
TO_LONGITUDE_MINUTES
Seq. Order: | 22 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Longitude minutes of area fished to, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
General Data Type: | Number |
Unit of Measure: | minutes |
TO_LONGITUDE_DIR
Seq. Order: | 23 |
---|---|
Data Storage Type: | Character |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude direction of area fished to. |
General Data Type: | Character |
Allowed Values: | E = EAST W = WEST |
TO_LONGITUDE_DD
Seq. Order: | 24 |
---|---|
Data Storage Type: | Number |
Max Length: | 17 |
Required: | No |
Primary Key: | No |
Scale: | 12 |
Status: | Active |
Description: |
Longitude of area fished to, in decimal degrees, computed using to_longitude_degrees, to_longitude_minutes, and to_longitude_dir. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15. |
General Data Type: | Number |
Unit of Measure: | degrees |
Derivation: |
case when to_longitude_dir = 'E' then (to_longitude_degrees + ((to_longitude_minutes/10.0)/60.0)) when to_longitude_dir = 'W' then -1.0 *(to_longitude_degrees + ((to_longitude_minutes/10.0)/60.0)) else NULL END TO_LONGITUDE_DD, |
DRIFTING_ANCHORED_CODE
Seq. Order: | 25 |
---|---|
Data Storage Type: | Number |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for type of bottomfishing activity, drifting or anchored. |
General Data Type: | Number |
Allowed Values: | 1 = DRIFTING 2 = ANCHORED |
DEPTH_MINIMUM
Seq. Order: | 26 |
---|---|
Data Storage Type: | Number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Mininum depth range of fishing, in fathoms. Units for values are fathoms. |
General Data Type: | Number |
Unit of Measure: | fathoms |
DEPTH_MAXIMUM
Seq. Order: | 27 |
---|---|
Data Storage Type: | Number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Maximum depth range of fishing, in fathoms. Units for values are fathoms. |
General Data Type: | Number |
Unit of Measure: | fathoms |
BANK_CODE
Seq. Order: | 28 |
---|---|
Data Storage Type: | Number |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the bank where fishing occurred. |
General Data Type: | Number |
TIME_STATION_STARTED
Seq. Order: | 29 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time fishing station started. |
General Data Type: | Number |
TIME_STATION_ENDED
Seq. Order: | 30 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time fishing station ended. |
General Data Type: | Number |
DRIFT_NUMBER
Seq. Order: | 31 |
---|---|
Data Storage Type: | Number |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Drift number. |
General Data Type: | Number |
TIME_DRIFT_STARTED
Seq. Order: | 32 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time drift started. |
General Data Type: | Number |
TIME_DRIFT_ENDED
Seq. Order: | 33 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time drift ended. |
General Data Type: | Number |
DEPTH_DRIFT_STARTED
Seq. Order: | 34 |
---|---|
Data Storage Type: | Number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Depth when drift started, in fathoms. Units for values are fathoms. |
General Data Type: | Number |
Unit of Measure: | fathoms |
DEPTH_DRIFT_ENDED
Seq. Order: | 35 |
---|---|
Data Storage Type: | Number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Depth when drift ended, in fathoms. Units for values are fathoms. |
General Data Type: | Number |
Unit of Measure: | fathoms |
NUMBER_LINES
Seq. Order: | 36 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Average number of lines fishing, in tenths. The decimal point was left off during data entry; it has been inserted into the data. Measures are reported with a precision of 3. |
General Data Type: | Number |
NUMBER_HOOKS_PER_LINE
Seq. Order: | 37 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Average number of hooks per line, in tenths. The decimal point was left off during data entry; it has been inserted into the data. Measures are reported with a precision of 3. |
General Data Type: | Number |
NUMBER_HOOKS_SIZE_1
Seq. Order: | 38 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hook_size_1 used (columns 1-2 number of hooks, columns 3-4 hook size). |
General Data Type: | Number |
NUMBER_HOOKS_SIZE_2
Seq. Order: | 39 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hook_size_2 used (columns 1-2 number of hooks, columns 3-4 hook size). |
General Data Type: | Number |
NUMBER_HOOKS_SIZE_3
Seq. Order: | 40 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hook_size_3 used (columns 1-2 number of hooks, columns 3-4 hook size). |
General Data Type: | Number |
NUMBER_HOOKS_SIZE_4
Seq. Order: | 41 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hook_size_4 used (columns 1-2 number of hooks, columns 3-4 hook size). |
General Data Type: | Number |
BAIT_CODE
Seq. Order: | 42 |
---|---|
Data Storage Type: | Number |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the kind of bait used. |
General Data Type: | Number |
FISH_NUMBER
Seq. Order: | 43 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number assigned to the fish caught and links the fish to FISH SAMPLING LOG (RI003). |
General Data Type: | Number |
TIME_CAUGHT
Seq. Order: | 44 |
---|---|
Data Storage Type: | Number |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time fish was caught. |
General Data Type: | Number |
SPECIES_CODE
Seq. Order: | 45 |
---|---|
Data Storage Type: | Number |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species code of the fish caught. |
General Data Type: | Number |
HOOK_SIZE
Seq. Order: | 46 |
---|---|
Data Storage Type: | Number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Size of the hook that the fish was caught. |
General Data Type: | Number |
TOTAL_OR_FORK_LENGTH
Seq. Order: | 47 |
---|---|
Data Storage Type: | Number |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Total or fork length of species, in tenths of a centimeter. The decimal point was left off during data entry; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4. |
General Data Type: | Number |
Unit of Measure: | centimeters |
DEPTH_CAUGHT
Seq. Order: | 48 |
---|---|
Data Storage Type: | Number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Depth that the species was caught, in fathoms. |
General Data Type: | Number |
JOB_NUMBER
Seq. Order: | 49 |
---|---|
Data Storage Type: | Character |
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., D95084. |
General Data Type: | Character |
SEQUENCE_NUMBER
Seq. Order: | 50 |
---|---|
Data Storage Type: | Number |
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: | Number |
DATE_LOADED
Seq. Order: | 51 |
---|---|
Data Storage Type: | Date |
Max Length: | 11 |
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: | 52578 |
---|---|
GUID: | gov.noaa.nmfs.inport:52578 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2018-05-08 18:54+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-05-08 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-05-08 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-05-08 |