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
- 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.
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
| 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 |
