RP003AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:64446 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Squid Sampling and Size Frequency Log collected between 1981 and 1983 and in 1989.
DescriptionSquid Sampling and Size Frequency Log collected between 1981 and 1989.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
DATASET_CODE
VARCHAR2 |
Source ID Code assigned by the data entry staff. |
VERSION_CODE
VARCHAR2 |
Code for the format version assigned by the data entry staff. |
VESSEL_CODE
VARCHAR2 |
Code for the vessel. |
CRUISE_NUMBER
VARCHAR2 |
Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101. |
STATION_NUMBER
VARCHAR2 |
Station number of the fishing operation. |
YEAR
VARCHAR2 |
Year of fishing. |
MONTH
VARCHAR2 |
Month of fishing. |
DAY
VARCHAR2 |
Day of fishing. |
TIME_STARTED
VARCHAR2 |
Time fishing started. |
TIME_ENDED
VARCHAR2 |
Time fishing ended. |
WIND_DIRECTION
VARCHAR2 |
Wind direction (0-360) in degrees. Units for values are degrees. |
WIND_SPEED
VARCHAR2 |
Wind speed in tenths of a meter/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. |
SEA_CONDITION_CODE
VARCHAR2 |
Code for the sea condition. |
CLOUD_COVER
VARCHAR2 |
Cloud cover in tenths. |
MOON_PHASE
VARCHAR2 |
Moon phase in eights. |
MOON_HEIGHT
VARCHAR2 |
Moon height in degrees. Units for values are degrees. |
NUMBER_MACHINES
VARCHAR2 |
Number of machines used. |
MINIMUM_DEPTH_FISHED
VARCHAR2 |
Minimum depth fished in meters. Units for values are meters. |
MAXIMUM_DEPTH_FISHED
VARCHAR2 |
Maximum depth fished in meters. Units for values are meters. |
BREAK_TIME
VARCHAR2 |
Break time in minutes. Units for values are minutes. |
NUMBER_CAUGHT_MACHINE
VARCHAR2 |
Number caught by machine. |
NUMBER_SAMPLED_MACHINE
VARCHAR2 |
Number sampled that were caught by machine. |
NUMBER_CAUGHT_POLE_LINE
VARCHAR2 |
Number caught by pole and line. |
NUMBER_SAMPLED_POLE_LINE
VARCHAR2 |
Number sampled that were caught by pole and line. |
SPECIES_CODE
VARCHAR2 |
Ten-digt CZM species code. |
SPECIES_LINE_NUMBER
VARCHAR2 |
A consecutive number assigned to each data record of a given species. |
LENGTH
VARCHAR2 |
Length in millimeters. Units for values are millimeters. |
WEIGHT
VARCHAR2 |
Weight in grams. Units for values are grams. |
SEX_CODE
VARCHAR2 |
Sex code of species. |
GEAR_CODE
VARCHAR2 |
Code for gear used for fishing. |
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., D83017. |
SEQUENCE_NUMBER
VARCHAR2 |
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: | RP003AA1_V |
---|---|
Short Name: | RP003AA1_V |
Status: | Completed |
Abstract: |
Squid Sampling and Size Frequency Log collected between 1981 and 1983 and in 1989. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Squid Sampling and Size Frequency Log collected between 1981 and 1989. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
DATASET_CODE | VARCHAR2 | Source ID Code assigned by the data entry staff. | |
100
|
VERSION_CODE | VARCHAR2 | Code for the format version assigned by the data entry staff. | |
100
|
VESSEL_CODE | VARCHAR2 | Code for the vessel. | |
100
|
CRUISE_NUMBER | VARCHAR2 | Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101. | |
100
|
STATION_NUMBER | VARCHAR2 | Station number of the fishing operation. | |
100
|
YEAR | VARCHAR2 | Year of fishing. | |
100
|
MONTH | VARCHAR2 | Month of fishing. | |
100
|
DAY | VARCHAR2 | Day of fishing. | |
100
|
TIME_STARTED | VARCHAR2 | Time fishing started. | |
100
|
TIME_ENDED | VARCHAR2 | Time fishing ended. | |
100
|
WIND_DIRECTION | VARCHAR2 | Wind direction (0-360) in degrees. Units for values are degrees. | |
100
|
WIND_SPEED | VARCHAR2 | Wind speed in tenths of a meter/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
|
SEA_CONDITION_CODE | VARCHAR2 | Code for the sea condition. | |
100
|
CLOUD_COVER | VARCHAR2 | Cloud cover in tenths. | |
100
|
MOON_PHASE | VARCHAR2 | Moon phase in eights. | |
100
|
MOON_HEIGHT | VARCHAR2 | Moon height in degrees. Units for values are degrees. | |
100
|
NUMBER_MACHINES | VARCHAR2 | Number of machines used. | |
100
|
MINIMUM_DEPTH_FISHED | VARCHAR2 | Minimum depth fished in meters. Units for values are meters. | |
100
|
MAXIMUM_DEPTH_FISHED | VARCHAR2 | Maximum depth fished in meters. Units for values are meters. | |
100
|
BREAK_TIME | VARCHAR2 | Break time in minutes. Units for values are minutes. | |
100
|
NUMBER_CAUGHT_MACHINE | VARCHAR2 | Number caught by machine. | |
100
|
NUMBER_SAMPLED_MACHINE | VARCHAR2 | Number sampled that were caught by machine. | |
100
|
NUMBER_CAUGHT_POLE_LINE | VARCHAR2 | Number caught by pole and line. | |
100
|
NUMBER_SAMPLED_POLE_LINE | VARCHAR2 | Number sampled that were caught by pole and line. | |
100
|
SPECIES_CODE | VARCHAR2 | Ten-digt CZM species code. | |
100
|
SPECIES_LINE_NUMBER | VARCHAR2 | A consecutive number assigned to each data record of a given species. | |
100
|
LENGTH | VARCHAR2 | Length in millimeters. Units for values are millimeters. | |
100
|
WEIGHT | VARCHAR2 | Weight in grams. Units for values are grams. | |
100
|
SEX_CODE | VARCHAR2 | Sex code of species. | |
100
|
GEAR_CODE | VARCHAR2 | Code for gear used for fishing. | |
100
|
JOB_NUMBER | VARCHAR2 | A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D83017. | |
100
|
SEQUENCE_NUMBER | VARCHAR2 | A consecutive number assigned to each record for a block of data. | |
100
|
DATE_LOADED | DATE | Date when the record was loaded into Oracle or updated. |
Attribute Details
DATASET_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Source ID Code assigned by the data entry staff. |
General Data Type: | VARCHAR2 |
VERSION_CODE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the format version assigned by the data entry staff. |
General Data Type: | VARCHAR2 |
VESSEL_CODE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the vessel. |
General Data Type: | VARCHAR2 |
Allowed Values: | 001 = NOAA R/V TOWNSEND CROMWELL; 995 = HOKUSEI MARU |
CRUISE_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
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, e.g., 8101. |
General Data Type: | VARCHAR2 |
STATION_NUMBER
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station number of the fishing operation. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year of fishing. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month of fishing. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day of fishing. |
General Data Type: | VARCHAR2 |
TIME_STARTED
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time fishing started. |
General Data Type: | VARCHAR2 |
TIME_ENDED
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time fishing ended. |
General Data Type: | VARCHAR2 |
WIND_DIRECTION
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Wind direction (0-360) in degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
WIND_SPEED
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Wind speed in tenths of a meter/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 |
SEA_CONDITION_CODE
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the sea condition. |
General Data Type: | VARCHAR2 |
Allowed Values: | 00 = CALM; 01 = SLIGHT; 02 = MODERATE; C = CALM; S = SLIGHT; M = MODERATE; R = ROUGH |
CLOUD_COVER
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Cloud cover in tenths. |
General Data Type: | VARCHAR2 |
MOON_PHASE
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Moon phase in eights. |
General Data Type: | VARCHAR2 |
MOON_HEIGHT
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Moon height in degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
NUMBER_MACHINES
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of machines used. |
General Data Type: | VARCHAR2 |
MINIMUM_DEPTH_FISHED
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Minimum depth fished in meters. Units for values are meters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | meters |
MAXIMUM_DEPTH_FISHED
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Maximum depth fished in meters. Units for values are meters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | meters |
BREAK_TIME
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Break time in minutes. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
NUMBER_CAUGHT_MACHINE
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number caught by machine. |
General Data Type: | VARCHAR2 |
NUMBER_SAMPLED_MACHINE
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number sampled that were caught by machine. |
General Data Type: | VARCHAR2 |
NUMBER_CAUGHT_POLE_LINE
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number caught by pole and line. |
General Data Type: | VARCHAR2 |
NUMBER_SAMPLED_POLE_LINE
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number sampled that were caught by pole and line. |
General Data Type: | VARCHAR2 |
SPECIES_CODE
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Ten-digt CZM species code. |
General Data Type: | VARCHAR2 |
Allowed Values: | 7073090100 = ONYCHOTEUTHIS SP.; 7073090101 = ONYCHOTEUTHIS COMPACTA; 7073090103 = ONYCHOTEUTHIS BANKSII; 7073300701 = OMMASTREPHES BARTRAMI; 7073301001 = SYMPLECTOTEUTHIS OUALANIENSIS; 7073301002 = SYMPLECTOTEUTHIS LUMINOSA |
SPECIES_LINE_NUMBER
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A consecutive number assigned to each data record of a given species. |
General Data Type: | VARCHAR2 |
LENGTH
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
WEIGHT
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight in grams. Units for values are grams. |
General Data Type: | VARCHAR2 |
Unit of Measure: | grams |
SEX_CODE
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sex code of species. |
General Data Type: | VARCHAR2 |
Allowed Values: | F = FEMALE; I = ; M = MALE |
GEAR_CODE
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for gear used for fishing. |
General Data Type: | VARCHAR2 |
Allowed Values: | 01 = POLE AND LINE; 08 = ROD AND REEL; 92 = SQUID JIGGING MACHINE (AUTOMATIC); 95 = DIP NET |
JOB_NUMBER
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D83017. |
General Data Type: | VARCHAR2 |
SEQUENCE_NUMBER
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A consecutive number assigned to each record for a block of data. |
General Data Type: | VARCHAR2 |
DATE_LOADED
Seq. Order: | 33 |
---|---|
Data Storage Type: | DATE |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when the record was loaded into Oracle or updated. |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 64446 |
---|---|
GUID: | gov.noaa.nmfs.inport:64446 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2021-03-26 00:38+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-04-05 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-04-05 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-04-05 |