Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

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

Rubric Score Primary Key? 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

CC ID: 1056089
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

CC ID: 1056090
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

CC ID: 1056091
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

CC ID: 1056092
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

CC ID: 1056093
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

CC ID: 1056094
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

CC ID: 1056095
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

CC ID: 1056096
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

CC ID: 1056097
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

CC ID: 1056098
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

CC ID: 1056099
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

CC ID: 1056100
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

CC ID: 1056101
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

CC ID: 1056102
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

CC ID: 1056103
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

CC ID: 1056104
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

CC ID: 1056105
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

CC ID: 1056106
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

CC ID: 1056107
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

CC ID: 1056108
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

CC ID: 1056109
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

CC ID: 1056110
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

CC ID: 1056111
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

CC ID: 1056112
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

CC ID: 1056113
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

CC ID: 1056114
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

CC ID: 1056115
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

CC ID: 1056116
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

CC ID: 1056117
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

CC ID: 1056118
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

CC ID: 1056119
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

CC ID: 1056120
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

CC ID: 1056121
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