Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Pelagics Metadata Portfolio > Squid Jig Fishing Log data collected during res... >

RP004AA2_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:70447  |  Updated: August 21, 2023  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

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

Description

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

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