Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: RP004AA2_V
Short Name: RP004AA2_V
Status: Completed
Abstract:

Data for jig fishing for squid collected between 1981 and 1983 during Townsend Cromwell and Hokusei Maru cruises.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Data for jig fishing for squid collected between 1981 and 1983 during Townsend Cromwell and Hokusei Maru cruises.

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, e.g., 8205.
100
STATION_NUMBER VARCHAR2 Station number of jig fishing for squid.
100
YEAR VARCHAR2 Year of jig fishing for squid.
100
MONTH VARCHAR2 Month of jig fishing for squid.
100
DAY VARCHAR2 Day of jig fishing for squid.
100
START_LATITUDE_DEGREES VARCHAR2 Begin latitude degrees of jig fishing for squid. Units for values are degrees.
100
START_LATITUDE_MINUTES VARCHAR2 Begin latitude minutes of jig fishing for squid. Units for values are minutes.
100
START_LATITUDE_DIRECTION VARCHAR2 Begin latitude direction of jig fishing for squid.
100
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
START_LONGITUDE_DEGREES VARCHAR2 Begin longitude degrees of jig fishing for squid. Units for values are degrees.
100
START_LONGITUDE_MINUTES VARCHAR2 Begin longitude minutes of jig fishing for squid. Units for values are minutes.
100
START_LONGITUDE_DIRECTION VARCHAR2 Begin longitude direction of jig fishing for squid.
100
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
END_LATITUDE_DEGREES VARCHAR2 End latitude degrees of jig fishing for squid. Units for values are degrees.
100
END_LATITUDE_MINUTES VARCHAR2 End latitude minutes of jig fishing for squid. Units for values are minutes.
100
END_LATITUDE_DIRECTION VARCHAR2 End latitude direction of jig fishing for squid.
100
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
END_LONGITUDE_DEGREES VARCHAR2 End longitude degrees of jig fishing for squid. Units for values are degrees.
100
END_LONGITUDE_MINUTES VARCHAR2 End longitude minutes of jig fishing for squid. Units for values are minutes.
100
END_LONGITUDE_DIRECTION VARCHAR2 End longitude direction of jig fishing for squid.
100
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
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
TIME_STARTED VARCHAR2 Begin time of jig fishing for squid.
100
TIME_ENDED VARCHAR2 End time of jig fishing for squid.
100
BREAK_TIME VARCHAR2 Break time, in minutes. Units for values are minutes.
100
CLOUD_COVER_CODE VARCHAR2 Cloud cover code.
100
WIND_DIRECTION VARCHAR2 Direction, in degrees, from which the surface wind is blowing. Units for values are degrees.
100
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
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
SEA_CONDITION_CODE VARCHAR2 Code for sea condition.
100
NUMBER_MACHINES VARCHAR2 Number of jigging machines.
100
NUMBER_JIGS VARCHAR2 Number of jigs.
100
NUMBER_LINES VARCHAR2 Number of lines on the machine.
100
NUMBER_JIGS_PER_LINE VARCHAR2 Number of jigs per line.
100
NUMBER_JIGS_PER_MACHINE VARCHAR2 Number of jigs per machine.
100
BOTTOM_DEPTH VARCHAR2 Bottom depth, in meters.
100
FISHING_DEPTH VARCHAR2 Fishing depth, in meters.
100
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
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
SPECIES_CODE VARCHAR2 Ten-digit CZM species code.
100
NUMBER_CAUGHT VARCHAR2 Number caught of the species.
100
WEIGHT VARCHAR2 Weight, in grams. Units for values are grams.
100
GEAR_CODE VARCHAR2 Code for other gear used to catch the species.
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., D83200.
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: 1264697
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: 1264698
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: 1264699
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, A JAPANESE RESEARCH AND TRAINING VESSEL

CRUISE_NUMBER

CC ID: 1264700
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, e.g., 8205.

General Data Type: VARCHAR2

STATION_NUMBER

CC ID: 1264701
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Station number of jig fishing for squid.

General Data Type: VARCHAR2

YEAR

CC ID: 1264702
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year of jig fishing for squid.

General Data Type: VARCHAR2

MONTH

CC ID: 1264703
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month of jig fishing for squid.

General Data Type: VARCHAR2

DAY

CC ID: 1264704
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day of jig fishing for squid.

General Data Type: VARCHAR2

START_LATITUDE_DEGREES

CC ID: 1264705
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Begin latitude degrees of jig fishing for squid. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

START_LATITUDE_MINUTES

CC ID: 1264706
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Begin latitude minutes of jig fishing for squid. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

START_LATITUDE_DIRECTION

CC ID: 1264707
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Begin latitude direction of jig fishing for squid.

General Data Type: VARCHAR2
Allowed Values: N = NORTH

START_LATITUDE_DD

CC ID: 1264708
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
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

START_LONGITUDE_DEGREES

CC ID: 1264709
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Begin longitude degrees of jig fishing for squid. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

START_LONGITUDE_MINUTES

CC ID: 1264710
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Begin longitude minutes of jig fishing for squid. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

START_LONGITUDE_DIRECTION

CC ID: 1264711
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Begin longitude direction of jig fishing for squid.

General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

START_LONGITUDE_DD

CC ID: 1264712
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
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

END_LATITUDE_DEGREES

CC ID: 1264713
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

End latitude degrees of jig fishing for squid. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

END_LATITUDE_MINUTES

CC ID: 1264714
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

End latitude minutes of jig fishing for squid. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

END_LATITUDE_DIRECTION

CC ID: 1264715
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

End latitude direction of jig fishing for squid.

General Data Type: VARCHAR2
Allowed Values: N = NORTH

END_LATITUDE_DD

CC ID: 1264716
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
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

END_LONGITUDE_DEGREES

CC ID: 1264717
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

End longitude degrees of jig fishing for squid. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

END_LONGITUDE_MINUTES

CC ID: 1264718
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

End longitude minutes of jig fishing for squid. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

END_LONGITUDE_DIRECTION

CC ID: 1264719
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

End longitude direction of jig fishing for squid.

General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

END_LONGITUDE_DD

CC ID: 1264720
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
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

SEA_SURFACE_TEMPERATURE

CC ID: 1264721
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
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

TIME_STARTED

CC ID: 1264722
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Begin time of jig fishing for squid.

General Data Type: VARCHAR2

TIME_ENDED

CC ID: 1264723
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

End time of jig fishing for squid.

General Data Type: VARCHAR2

BREAK_TIME

CC ID: 1264724
Seq. Order: 28
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

CLOUD_COVER_CODE

CC ID: 1264725
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Cloud cover code.

General Data Type: VARCHAR2
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

WIND_DIRECTION

CC ID: 1264726
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
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

MINIMUM_WIND_SPEED

CC ID: 1264727
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
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

MAXIMUM_WIND_SPEED

CC ID: 1264728
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
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

SEA_CONDITION_CODE

CC ID: 1264729
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code for sea condition.

General Data Type: VARCHAR2
Allowed Values: 00 = CALM; 01 = SLIGHT; 02 = MODERATE; 03 = ROUGH (RP004AA1); 03 = CHOPPY (RP004AA2); 04 = NOT DEFINED (RP004AA1); 04 = 12-15 FT SWELLS (RP004AA2)

NUMBER_MACHINES

CC ID: 1264730
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of jigging machines.

General Data Type: VARCHAR2

NUMBER_JIGS

CC ID: 1264731
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of jigs.

General Data Type: VARCHAR2

NUMBER_LINES

CC ID: 1264732
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Number of lines on the machine.

General Data Type: VARCHAR2

NUMBER_JIGS_PER_LINE

CC ID: 1264733
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of jigs per line.

General Data Type: VARCHAR2

NUMBER_JIGS_PER_MACHINE

CC ID: 1264734
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of jigs per machine.

General Data Type: VARCHAR2

BOTTOM_DEPTH

CC ID: 1264735
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Bottom depth, in meters.

General Data Type: VARCHAR2

FISHING_DEPTH

CC ID: 1264736
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Fishing depth, in meters.

General Data Type: VARCHAR2

MINIMUM_FISHING_DEPTH

CC ID: 1264737
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
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

MAXIMUM_FISHING_DEPTH

CC ID: 1264738
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
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

SPECIES_CODE

CC ID: 1264739
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Ten-digit CZM species code.

General Data Type: VARCHAR2
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

NUMBER_CAUGHT

CC ID: 1264740
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number caught of the species.

General Data Type: VARCHAR2

WEIGHT

CC ID: 1264741
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Weight, in grams. Units for values are grams.

General Data Type: VARCHAR2
Unit of Measure: grams

GEAR_CODE

CC ID: 1264742
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code for other gear used to catch the species.

General Data Type: VARCHAR2
Allowed Values: 01 = POLE AND LINE; 04 = HANDLINE; 08 = ROD AND REEL; 92 = SQUID JIGGING MACHINE (AUTOMATIC)

JOB_NUMBER

CC ID: 1264743
Seq. Order: 47
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., D83200.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1264744
Seq. Order: 48
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: 1264745
Seq. Order: 49
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: 70447
GUID: gov.noaa.nmfs.inport: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 Last Review Date: 2023-08-21
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2024-08-21