RI002AA1_V
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 52578
| Published / External
Created: 2018-05-08
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 6362
ID: 52578
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | RI002AA1_V |
---|---|
Short Name | RI002AA1_V |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Handline Fishing Log data collected by R/V Townsend Cromwell and R/V Oscar E Sette in the central and western Pacific Ocean. |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» Description |
Handline Fishing Log data collected by R/V Townsend Cromwell and R/V Oscar E Sette in the central and western Pacific Ocean. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | DATASET_CODE | Character | Source ID Code assigned by the data entry staff (RI002). |
100 | No | No | VERSION_CODE | Character | Code for the format version assigned by the data entry staff. |
100 | No | No | VESSEL_CODE | Character | Code for vessel. |
100 | No | No | CRUISE_NUMBER | Number | Last two digits of the year of the cruise and two digits incremental number of the cruise for the year. |
100 | No | No | STATION_NUMBER | Number | Station number of handline fishing operation. |
100 | No | No | FISHING_YEAR | Number | Year of fishing. |
100 | No | No | FISHING_MONTH | Number | Month of fishing. |
100 | No | No | FISHING_DAY | Number | Day of fishing. |
100 | No | No | AREA_FISHED_LATITUDE_DEGREES | Number | Latitude degrees of area fished, in degrees. Units for values are degrees. |
100 | No | No | 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 | No | No | AREA_FISHED_LATITUDE_DIR | Character | Latitude direction of area fished. |
100 | No | No | 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 | No | No | AREA_FISHED_LONGITUDE_DEGREES | Number | Longitude degrees of area fished, in degrees. Units for values are degrees. |
100 | No | No | 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 | No | No | AREA_FISHED_LONGITUDE_DIR | Character | Longitude direction of area fished. |
100 | No | No | 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 | No | No | TO_LATITUDE_DEGREES | Number | Latitude degrees of area fished to, in degrees. Units for values are degrees. |
100 | No | No | 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 | No | No | TO_LATITUDE_DIR | Character | Latitude direction of area fished to. |
100 | No | No | 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 | No | No | TO_LONGITUDE_DEGREES | Number | Longitude degrees of area fished to, in degrees. Units for values are degrees. |
100 | No | No | 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 | No | No | TO_LONGITUDE_DIR | Character | Longitude direction of area fished to. |
100 | No | No | 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 | No | No | DRIFTING_ANCHORED_CODE | Number | Code for type of bottomfishing activity, drifting or anchored. |
100 | No | No | DEPTH_MINIMUM | Number | Mininum depth range of fishing, in fathoms. Units for values are fathoms. |
100 | No | No | DEPTH_MAXIMUM | Number | Maximum depth range of fishing, in fathoms. Units for values are fathoms. |
100 | No | No | BANK_CODE | Number | Code for the bank where fishing occurred. |
100 | No | No | TIME_STATION_STARTED | Number | Time fishing station started. |
100 | No | No | TIME_STATION_ENDED | Number | Time fishing station ended. |
100 | No | No | DRIFT_NUMBER | Number | Drift number. |
100 | No | No | TIME_DRIFT_STARTED | Number | Time drift started. |
100 | No | No | TIME_DRIFT_ENDED | Number | Time drift ended. |
100 | No | No | DEPTH_DRIFT_STARTED | Number | Depth when drift started, in fathoms. Units for values are fathoms. |
100 | No | No | DEPTH_DRIFT_ENDED | Number | Depth when drift ended, in fathoms. Units for values are fathoms. |
100 | No | No | 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 | No | No | 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 | No | No | NUMBER_HOOKS_SIZE_1 | Number | Number of hook_size_1 used (columns 1-2 number of hooks, columns 3-4 hook size). |
100 | No | No | NUMBER_HOOKS_SIZE_2 | Number | Number of hook_size_2 used (columns 1-2 number of hooks, columns 3-4 hook size). |
100 | No | No | NUMBER_HOOKS_SIZE_3 | Number | Number of hook_size_3 used (columns 1-2 number of hooks, columns 3-4 hook size). |
100 | No | No | NUMBER_HOOKS_SIZE_4 | Number | Number of hook_size_4 used (columns 1-2 number of hooks, columns 3-4 hook size). |
100 | No | No | BAIT_CODE | Number | Code for the kind of bait used. |
100 | No | No | FISH_NUMBER | Number | Number assigned to the fish caught and links the fish to FISH SAMPLING LOG (RI003). |
100 | No | No | TIME_CAUGHT | Number | Time fish was caught. |
100 | No | No | SPECIES_CODE | Number | Species code of the fish caught. |
100 | No | No | HOOK_SIZE | Number | Size of the hook that the fish was caught. |
100 | No | No | 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 | No | No | DEPTH_CAUGHT | Number | Depth that the species was caught, in fathoms. |
100 | No | No | 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 | No | No | SEQUENCE_NUMBER | Number | A consecutive number assigned to each record for a block of data. |
100 | No | No | DATE_LOADED | Date | Date when the record was loaded into Oracle or updated. |
Attribute Details
Attribute Name | DATASET_CODE |
---|---|
Seq. Order | 1 |
Data Storage Type | Character |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Source ID Code assigned by the data entry staff (RI002). |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | RI002 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VERSION_CODE |
---|---|
Seq. Order | 2 |
Data Storage Type | Character |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the format version assigned by the data entry staff. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VESSEL_CODE |
---|---|
Seq. Order | 3 |
Data Storage Type | Character |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for vessel. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 001 = NOAA R/V TOWNSEND CROMWELL OES = NOAA R/V OSCAR E SETTE |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CRUISE_NUMBER |
---|---|
Seq. Order | 4 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATION_NUMBER |
---|---|
Seq. Order | 5 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Station number of handline fishing operation. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FISHING_YEAR |
---|---|
Seq. Order | 6 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Year of fishing. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FISHING_MONTH |
---|---|
Seq. Order | 7 |
Data Storage Type | Number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Month of fishing. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FISHING_DAY |
---|---|
Seq. Order | 8 |
Data Storage Type | Number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Day of fishing. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA_FISHED_LATITUDE_DEGREES |
---|---|
Seq. Order | 9 |
Data Storage Type | Number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude degrees of area fished, in degrees. Units for values are degrees. |
General Data Type | Number |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA_FISHED_LATITUDE_MINUTES |
---|---|
Seq. Order | 10 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA_FISHED_LATITUDE_DIR |
---|---|
Seq. Order | 11 |
Data Storage Type | Character |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude direction of area fished. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N = NORTH S = SOUTH |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA_FISHED_LATITUDE_DD |
---|---|
Seq. Order | 12 |
Data Storage Type | Number |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
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, |
Validation Rules |
Attribute Name | AREA_FISHED_LONGITUDE_DEGREES |
---|---|
Seq. Order | 13 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude degrees of area fished, in degrees. Units for values are degrees. |
General Data Type | Number |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA_FISHED_LONGITUDE_MINUTES |
---|---|
Seq. Order | 14 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA_FISHED_LONGITUDE_DIR |
---|---|
Seq. Order | 15 |
Data Storage Type | Character |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude direction of area fished. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E = EAST W = WEST |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA_FISHED_LONGITUDE_DD |
---|---|
Seq. Order | 16 |
Data Storage Type | Number |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
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, |
Validation Rules |
Attribute Name | TO_LATITUDE_DEGREES |
---|---|
Seq. Order | 17 |
Data Storage Type | Number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude degrees of area fished to, in degrees. Units for values are degrees. |
General Data Type | Number |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TO_LATITUDE_MINUTES |
---|---|
Seq. Order | 18 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TO_LATITUDE_DIR |
---|---|
Seq. Order | 19 |
Data Storage Type | Character |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude direction of area fished to. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N = NORTH S = SOUTH |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TO_LATITUDE_DD |
---|---|
Seq. Order | 20 |
Data Storage Type | Number |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
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, |
Validation Rules |
Attribute Name | TO_LONGITUDE_DEGREES |
---|---|
Seq. Order | 21 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude degrees of area fished to, in degrees. Units for values are degrees. |
General Data Type | Number |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TO_LONGITUDE_MINUTES |
---|---|
Seq. Order | 22 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TO_LONGITUDE_DIR |
---|---|
Seq. Order | 23 |
Data Storage Type | Character |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude direction of area fished to. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E = EAST W = WEST |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TO_LONGITUDE_DD |
---|---|
Seq. Order | 24 |
Data Storage Type | Number |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
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, |
Validation Rules |
Attribute Name | DRIFTING_ANCHORED_CODE |
---|---|
Seq. Order | 25 |
Data Storage Type | Number |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for type of bottomfishing activity, drifting or anchored. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1 = DRIFTING 2 = ANCHORED |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_MINIMUM |
---|---|
Seq. Order | 26 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mininum depth range of fishing, in fathoms. Units for values are fathoms. |
General Data Type | Number |
Unit of Measure | fathoms |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_MAXIMUM |
---|---|
Seq. Order | 27 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Maximum depth range of fishing, in fathoms. Units for values are fathoms. |
General Data Type | Number |
Unit of Measure | fathoms |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BANK_CODE |
---|---|
Seq. Order | 28 |
Data Storage Type | Number |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the bank where fishing occurred. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TIME_STATION_STARTED |
---|---|
Seq. Order | 29 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time fishing station started. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TIME_STATION_ENDED |
---|---|
Seq. Order | 30 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time fishing station ended. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DRIFT_NUMBER |
---|---|
Seq. Order | 31 |
Data Storage Type | Number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Drift number. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TIME_DRIFT_STARTED |
---|---|
Seq. Order | 32 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time drift started. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TIME_DRIFT_ENDED |
---|---|
Seq. Order | 33 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time drift ended. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_DRIFT_STARTED |
---|---|
Seq. Order | 34 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Depth when drift started, in fathoms. Units for values are fathoms. |
General Data Type | Number |
Unit of Measure | fathoms |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_DRIFT_ENDED |
---|---|
Seq. Order | 35 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Depth when drift ended, in fathoms. Units for values are fathoms. |
General Data Type | Number |
Unit of Measure | fathoms |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_LINES |
---|---|
Seq. Order | 36 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_HOOKS_PER_LINE |
---|---|
Seq. Order | 37 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_HOOKS_SIZE_1 |
---|---|
Seq. Order | 38 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of hook_size_1 used (columns 1-2 number of hooks, columns 3-4 hook size). |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_HOOKS_SIZE_2 |
---|---|
Seq. Order | 39 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of hook_size_2 used (columns 1-2 number of hooks, columns 3-4 hook size). |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_HOOKS_SIZE_3 |
---|---|
Seq. Order | 40 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of hook_size_3 used (columns 1-2 number of hooks, columns 3-4 hook size). |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_HOOKS_SIZE_4 |
---|---|
Seq. Order | 41 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of hook_size_4 used (columns 1-2 number of hooks, columns 3-4 hook size). |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT_CODE |
---|---|
Seq. Order | 42 |
Data Storage Type | Number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the kind of bait used. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FISH_NUMBER |
---|---|
Seq. Order | 43 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number assigned to the fish caught and links the fish to FISH SAMPLING LOG (RI003). |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TIME_CAUGHT |
---|---|
Seq. Order | 44 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time fish was caught. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIES_CODE |
---|---|
Seq. Order | 45 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species code of the fish caught. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HOOK_SIZE |
---|---|
Seq. Order | 46 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Size of the hook that the fish was caught. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOTAL_OR_FORK_LENGTH |
---|---|
Seq. Order | 47 |
Data Storage Type | Number |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_CAUGHT |
---|---|
Seq. Order | 48 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Depth that the species was caught, in fathoms. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | JOB_NUMBER |
---|---|
Seq. Order | 49 |
Data Storage Type | Character |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEQUENCE_NUMBER |
---|---|
Seq. Order | 50 |
Data Storage Type | Number |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A consecutive number assigned to each record for a block of data. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DATE_LOADED |
---|---|
Seq. Order | 51 |
Data Storage Type | Date |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when the record was loaded into Oracle or updated. |
General Data Type | Date |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2018-05-08 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2019-05-08 |
Tags |
---|