RP004AA2_V
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 70447
| Published / External
Created: 2023-08-12
|
Last Modified: 2023-08-21
Data Set (DS) | ID: 5852
ID: 70447
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | RP004AA2_V |
---|---|
Short Name | RP004AA2_V |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Data for jig fishing for squid collected between 1981 and 1983 during Townsend Cromwell and Hokusei Maru cruises. |
* 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 |
Data for jig fishing for squid collected between 1981 and 1983 during Townsend Cromwell and Hokusei Maru cruises. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | DATASET_CODE | VARCHAR2 | Source ID Code assigned by the data entry staff. |
100 | No | No | VERSION_CODE | VARCHAR2 | Code for the format version assigned by the data entry staff. |
100 | No | No | VESSEL_CODE | VARCHAR2 | Code for the vessel. |
100 | No | No | CRUISE_NUMBER | VARCHAR2 | Last two digits of the year of the cruise and two digits incremental number of the cruise, e.g., 8205. |
100 | No | No | STATION_NUMBER | VARCHAR2 | Station number of jig fishing for squid. |
100 | No | No | YEAR | VARCHAR2 | Year of jig fishing for squid. |
100 | No | No | MONTH | VARCHAR2 | Month of jig fishing for squid. |
100 | No | No | DAY | VARCHAR2 | Day of jig fishing for squid. |
100 | No | No | START_LATITUDE_DEGREES | VARCHAR2 | Begin latitude degrees of jig fishing for squid. Units for values are degrees. |
100 | No | No | START_LATITUDE_MINUTES | VARCHAR2 | Begin latitude minutes of jig fishing for squid. Units for values are minutes. |
100 | No | No | START_LATITUDE_DIRECTION | VARCHAR2 | Begin latitude direction of jig fishing for squid. |
100 | No | No | START_LATITUDE_DD | NUMBER | Computed begin latitude, in decimal degrees, of jig fishing for squid. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
100 | No | No | START_LONGITUDE_DEGREES | VARCHAR2 | Begin longitude degrees of jig fishing for squid. Units for values are degrees. |
100 | No | No | START_LONGITUDE_MINUTES | VARCHAR2 | Begin longitude minutes of jig fishing for squid. Units for values are minutes. |
100 | No | No | START_LONGITUDE_DIRECTION | VARCHAR2 | Begin longitude direction of jig fishing for squid. |
100 | No | No | START_LONGITUDE_DD | NUMBER | Computed begin longitude, in decimal degrees, of jig fishing for squid. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
100 | No | No | END_LATITUDE_DEGREES | VARCHAR2 | End latitude degrees of jig fishing for squid. Units for values are degrees. |
100 | No | No | END_LATITUDE_MINUTES | VARCHAR2 | End latitude minutes of jig fishing for squid. Units for values are minutes. |
100 | No | No | END_LATITUDE_DIRECTION | VARCHAR2 | End latitude direction of jig fishing for squid. |
100 | No | No | END_LATITUDE_DD | NUMBER | Computed end latitude, in decimal degrees, of jig fishing for squid. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
100 | No | No | END_LONGITUDE_DEGREES | VARCHAR2 | End longitude degrees of jig fishing for squid. Units for values are degrees. |
100 | No | No | END_LONGITUDE_MINUTES | VARCHAR2 | End longitude minutes of jig fishing for squid. Units for values are minutes. |
100 | No | No | END_LONGITUDE_DIRECTION | VARCHAR2 | End longitude direction of jig fishing for squid. |
100 | No | No | END_LONGITUDE_DD | NUMBER | Computed end longitude, in decimal degrees, of jig fishing for squid. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
100 | No | No | SEA_SURFACE_TEMPERATURE | VARCHAR2 | Sea surface temperature, in tenths of a degree Celsius. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3. |
100 | No | No | TIME_STARTED | VARCHAR2 | Begin time of jig fishing for squid. |
100 | No | No | TIME_ENDED | VARCHAR2 | End time of jig fishing for squid. |
100 | No | No | BREAK_TIME | VARCHAR2 | Break time, in minutes. Units for values are minutes. |
100 | No | No | CLOUD_COVER_CODE | VARCHAR2 | Cloud cover code. |
100 | No | No | WIND_DIRECTION | VARCHAR2 | Direction, in degrees, from which the surface wind is blowing. Units for values are degrees. |
100 | No | No | MINIMUM_WIND_SPEED | VARCHAR2 | Minimum wind speed, in tenths of meters/second. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are meters/second. Measures are reported with a precision of 3. |
100 | No | No | MAXIMUM_WIND_SPEED | VARCHAR2 | Maximum wind speed, in tenths of meters/second. During data entry the decimal point was omitted; it has been inserted into the data. If only one value was recorded, it was entered in the minimum and maximum data fields. Units for values are meters/second. Measures are reported with a precision of 3. |
100 | No | No | SEA_CONDITION_CODE | VARCHAR2 | Code for sea condition. |
100 | No | No | NUMBER_MACHINES | VARCHAR2 | Number of jigging machines. |
100 | No | No | NUMBER_JIGS | VARCHAR2 | Number of jigs. |
100 | No | No | NUMBER_LINES | VARCHAR2 | Number of lines on the machine. |
100 | No | No | NUMBER_JIGS_PER_LINE | VARCHAR2 | Number of jigs per line. |
100 | No | No | NUMBER_JIGS_PER_MACHINE | VARCHAR2 | Number of jigs per machine. |
100 | No | No | BOTTOM_DEPTH | VARCHAR2 | Bottom depth, in meters. |
100 | No | No | FISHING_DEPTH | VARCHAR2 | Fishing depth, in meters. |
100 | No | No | MINIMUM_FISHING_DEPTH | VARCHAR2 | Minimum fishing depth, in tenths of a meter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are meters. Measures are reported with a precision of 3. |
100 | No | No | MAXIMUM_FISHING_DEPTH | VARCHAR2 | Maximum fishing depth, in tenths of a meter. During data entry the decimal point was omitted; it has been inserted into the data. If only one value was recorded, it was entered in the minimum and maximum data fields. Units for values are meters. Measures are reported with a precision of 3. |
100 | No | No | SPECIES_CODE | VARCHAR2 | Ten-digit CZM species code. |
100 | No | No | NUMBER_CAUGHT | VARCHAR2 | Number caught of the species. |
100 | No | No | WEIGHT | VARCHAR2 | Weight, in grams. Units for values are grams. |
100 | No | No | GEAR_CODE | VARCHAR2 | Code for other gear used to catch the species. |
100 | No | No | JOB_NUMBER | VARCHAR2 | A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D83200. |
100 | No | No | SEQUENCE_NUMBER | VARCHAR2 | 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 | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Source ID Code assigned by the data entry staff. |
General Data Type | VARCHAR2 |
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 | VERSION_CODE |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
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 | VARCHAR2 |
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 | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the vessel. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 001 = NOAA R/V TOWNSEND CROMWELL; 995 = HOKUSEI MARU, A JAPANESE RESEARCH AND TRAINING VESSEL |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CRUISE_NUMBER |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
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, e.g., 8205. |
General Data Type | VARCHAR2 |
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 | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Station number of jig fishing for squid. |
General Data Type | VARCHAR2 |
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 | YEAR |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Year of jig fishing for squid. |
General Data Type | VARCHAR2 |
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 | MONTH |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Month of jig fishing for squid. |
General Data Type | VARCHAR2 |
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 | DAY |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Day of jig fishing for squid. |
General Data Type | VARCHAR2 |
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 | START_LATITUDE_DEGREES |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Begin latitude degrees of jig fishing for squid. Units for values are degrees. |
General Data Type | VARCHAR2 |
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 | START_LATITUDE_MINUTES |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Begin latitude minutes of jig fishing for squid. Units for values are minutes. |
General Data Type | VARCHAR2 |
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 | START_LATITUDE_DIRECTION |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Begin latitude direction of jig fishing for squid. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N = NORTH |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | START_LATITUDE_DD |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 41 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 38 |
Status | Active |
Description |
Computed begin latitude, in decimal degrees, of jig fishing for squid. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
General Data Type | NUMBER |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | START_LONGITUDE_DEGREES |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Begin longitude degrees of jig fishing for squid. Units for values are degrees. |
General Data Type | VARCHAR2 |
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 | START_LONGITUDE_MINUTES |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Begin longitude minutes of jig fishing for squid. Units for values are minutes. |
General Data Type | VARCHAR2 |
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 | START_LONGITUDE_DIRECTION |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Begin longitude direction of jig fishing for squid. |
General Data Type | VARCHAR2 |
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 | START_LONGITUDE_DD |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 41 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 36 |
Status | Active |
Description |
Computed begin longitude, in decimal degrees, of jig fishing for squid. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
General Data Type | NUMBER |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_LATITUDE_DEGREES |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End latitude degrees of jig fishing for squid. Units for values are degrees. |
General Data Type | VARCHAR2 |
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 | END_LATITUDE_MINUTES |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End latitude minutes of jig fishing for squid. Units for values are minutes. |
General Data Type | VARCHAR2 |
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 | END_LATITUDE_DIRECTION |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End latitude direction of jig fishing for squid. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N = NORTH |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_LATITUDE_DD |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | 41 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 38 |
Status | Active |
Description |
Computed end latitude, in decimal degrees, of jig fishing for squid. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
General Data Type | NUMBER |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_LONGITUDE_DEGREES |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End longitude degrees of jig fishing for squid. Units for values are degrees. |
General Data Type | VARCHAR2 |
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 | END_LONGITUDE_MINUTES |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End longitude minutes of jig fishing for squid. Units for values are minutes. |
General Data Type | VARCHAR2 |
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 | END_LONGITUDE_DIRECTION |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End longitude direction of jig fishing for squid. |
General Data Type | VARCHAR2 |
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 | END_LONGITUDE_DD |
---|---|
Seq. Order | 24 |
Data Storage Type | NUMBER |
Max Length | 41 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 36 |
Status | Active |
Description |
Computed end longitude, in decimal degrees, of jig fishing for squid. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
General Data Type | NUMBER |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEA_SURFACE_TEMPERATURE |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 1 |
Status | Active |
Description |
Sea surface temperature, in tenths of a degree Celsius. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3. |
General Data Type | VARCHAR2 |
Unit of Measure | degrees Celsius |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TIME_STARTED |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Begin time of jig fishing for squid. |
General Data Type | VARCHAR2 |
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_ENDED |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End time of jig fishing for squid. |
General Data Type | VARCHAR2 |
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 | BREAK_TIME |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Break time, in minutes. Units for values are minutes. |
General Data Type | VARCHAR2 |
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 | CLOUD_COVER_CODE |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Cloud cover code. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 00 = 00/10; 01 = 01/10; 02 = 02/10; 03 = 03/10; 04 = 04/10; 05 = 05/10; 06 = 06/10; 07 = 07/10; 08 = 08/10; 09 = 09/10; 10 = 10/10 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WIND_DIRECTION |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Direction, in degrees, from which the surface wind is blowing. Units for values are degrees. |
General Data Type | VARCHAR2 |
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 | MINIMUM_WIND_SPEED |
---|---|
Seq. Order | 31 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 1 |
Status | Active |
Description |
Minimum wind speed, in tenths of meters/second. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are meters/second. Measures are reported with a precision of 3. |
General Data Type | VARCHAR2 |
Unit of Measure | meters/second |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MAXIMUM_WIND_SPEED |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 1 |
Status | Active |
Description |
Maximum wind speed, in tenths of meters/second. During data entry the decimal point was omitted; it has been inserted into the data. If only one value was recorded, it was entered in the minimum and maximum data fields. Units for values are meters/second. Measures are reported with a precision of 3. |
General Data Type | VARCHAR2 |
Unit of Measure | meters/second |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEA_CONDITION_CODE |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for sea condition. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 00 = CALM; 01 = SLIGHT; 02 = MODERATE; 03 = ROUGH (RP004AA1); 03 = CHOPPY (RP004AA2); 04 = NOT DEFINED (RP004AA1); 04 = 12-15 FT SWELLS (RP004AA2) |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_MACHINES |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of jigging machines. |
General Data Type | VARCHAR2 |
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_JIGS |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of jigs. |
General Data Type | VARCHAR2 |
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_LINES |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of lines on the machine. |
General Data Type | VARCHAR2 |
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_JIGS_PER_LINE |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of jigs per line. |
General Data Type | VARCHAR2 |
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_JIGS_PER_MACHINE |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of jigs per machine. |
General Data Type | VARCHAR2 |
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 | BOTTOM_DEPTH |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bottom depth, in meters. |
General Data Type | VARCHAR2 |
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_DEPTH |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fishing depth, in meters. |
General Data Type | VARCHAR2 |
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 | MINIMUM_FISHING_DEPTH |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 1 |
Status | Active |
Description |
Minimum fishing depth, in tenths of a meter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are meters. Measures are reported with a precision of 3. |
General Data Type | VARCHAR2 |
Unit of Measure | meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MAXIMUM_FISHING_DEPTH |
---|---|
Seq. Order | 42 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 1 |
Status | Active |
Description |
Maximum fishing depth, in tenths of a meter. During data entry the decimal point was omitted; it has been inserted into the data. If only one value was recorded, it was entered in the minimum and maximum data fields. Units for values are meters. Measures are reported with a precision of 3. |
General Data Type | VARCHAR2 |
Unit of Measure | meters |
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 | 43 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Ten-digit CZM species code. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0000000000 = NO CATCH; 7073090101 = ONYCHOTEUTHIS COMPACTA; 7073090103 = ONYCHOTEUTHIS BANKSII; 7073300501 = NOTOTODARUS HAWAIIENSIS; 7073300701 = OMMASTREPHES BARTRAMI; 7073301001 = SYMPLECTOTEUTHIS OUALANIENSIS; 7073301002 = SYMPLECTOTEUTHIS LUMINOSA; 8516120506 = CARCHARHINUS LONGIMANUS |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_CAUGHT |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number caught of the species. |
General Data Type | VARCHAR2 |
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 | WEIGHT |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight, in grams. Units for values are grams. |
General Data Type | VARCHAR2 |
Unit of Measure | grams |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GEAR_CODE |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for other gear used to catch the species. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 01 = POLE AND LINE; 04 = HANDLINE; 08 = ROD AND REEL; 92 = SQUID JIGGING MACHINE (AUTOMATIC) |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | JOB_NUMBER |
---|---|
Seq. Order | 47 |
Data Storage Type | VARCHAR2 |
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., D83200. |
General Data Type | VARCHAR2 |
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 | 48 |
Data Storage Type | VARCHAR2 |
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 | VARCHAR2 |
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 | 49 |
Data Storage Type | DATE |
Max Length | 22 |
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 | 70447 |
---|---|
Metadata Record Created By | Brent M Miyamoto |
Metadata Record Created | 2023-08-12 03:33+0000 |
Metadata Record Last Modified By | Brent M Miyamoto |
» Metadata Record Last Modified | 2023-08-21 20:45+0000 |
Metadata Record Published | 2023-08-21 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2023-08-21 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2024-08-21 |
Tags |
---|