Metadata Rubric

100%

6 / 6

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

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 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.

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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

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 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.

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, 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.

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

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

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

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

100

SEA_SURFACE_TEMPERATURE

VARCHAR2

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

100

MAXIMUM_WIND_SPEED

VARCHAR2

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

100

MAXIMUM_FISHING_DEPTH

VARCHAR2

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

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 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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

DATASET_CODE

VERSION_CODE

VESSEL_CODE

CRUISE_NUMBER

STATION_NUMBER

YEAR

MONTH

DAY

START_LATITUDE_DEGREES

START_LATITUDE_MINUTES

START_LATITUDE_DIRECTION

START_LATITUDE_DD

START_LONGITUDE_DEGREES

START_LONGITUDE_MINUTES

START_LONGITUDE_DIRECTION

START_LONGITUDE_DD

END_LATITUDE_DEGREES

END_LATITUDE_MINUTES

END_LATITUDE_DIRECTION

END_LATITUDE_DD

END_LONGITUDE_DEGREES

END_LONGITUDE_MINUTES

END_LONGITUDE_DIRECTION

END_LONGITUDE_DD

SEA_SURFACE_TEMPERATURE

TIME_STARTED

TIME_ENDED

BREAK_TIME

CLOUD_COVER_CODE

WIND_DIRECTION

MINIMUM_WIND_SPEED

MAXIMUM_WIND_SPEED

SEA_CONDITION_CODE

NUMBER_MACHINES

NUMBER_JIGS

NUMBER_LINES

NUMBER_JIGS_PER_LINE

NUMBER_JIGS_PER_MACHINE

BOTTOM_DEPTH

FISHING_DEPTH

MINIMUM_FISHING_DEPTH

MAXIMUM_FISHING_DEPTH

SPECIES_CODE

NUMBER_CAUGHT

WEIGHT

GEAR_CODE

JOB_NUMBER

SEQUENCE_NUMBER

DATE_LOADED

Catalog Details