Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Pelagics Metadata Portfolio > Squid Morphometrics data collected by the Hokus... >

RP035AA1_V

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:67460 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Squid morphometry collected in 1981 by the Hokusei Maru.

Description

Squid morphometry collected in 1981 by the Hokusei Maru.

Entity Type
Data Table

Data Attribute / Type	Description
DATASET_CODE VARCHAR2	Source ID Code assigned by the data entry staff.
VERSION_CODE VARCHAR2	Code for the format version assigned by the data entry staff.
VESSEL_CODE VARCHAR2	Code for the vessel.
CRUISE_NUMBER VARCHAR2	Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101.
STATION_NUMBER VARCHAR2	Station number of the fishing operation.
SPECIES_CODE VARCHAR2	Czm 5-digit species code.
YEAR VARCHAR2	Year.
MONTH VARCHAR2	Month.
DAY VARCHAR2	Day.
OCTANT VARCHAR2	Octant of the globe. OCTANT was used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).
LATITUDE_DEGREES VARCHAR2	Latitude degrees. Units for values are degrees.
LATITUDE_MINUTES VARCHAR2	Latitude minutes. Units for values are minutes.
LATITUDE_DIRECTION VARCHAR2	Latitude direction. OCTANT was used to determine latitude direction (N/S).
LATITUDE_DD NUMBER	Computed latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
LONGITUDE_DEGREES VARCHAR2	Longitude degrees. During data entry the first digit (0 or 1) was omitted. OCTANT was used to determine the first digit (0 or 1) and inserted into the data. Units for values are degrees.
LONGITUDE_MINUTES VARCHAR2	Longitude minutes. Units for values are minutes.
LONGITUDE_DIRECTION VARCHAR2	Longitude direction. OCTANT was used to determine longitude direction (E/W).
LONGITUDE_DD NUMBER	Computed longitude, in decimal degrees. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
MESH_SIZE VARCHAR2	Mesh size as "stretched" mesh measurement of the gillnet.
AUTOMATIC_JIGGING_CODE VARCHAR2	Code if automatic jigging was used.
HAND_JIGGING_CODE VARCHAR2	Code if hand jigging was used.
LINE_NUMBER VARCHAR2	A consecutive number assigned to each data record on the collection form.
MANTLE_LENGTH VARCHAR2	Mantle length, in millimeters. Units for values are millimeters.
BODY_WEIGHT VARCHAR2	Body weight, in grams.
SEX_CODE VARCHAR2	Code for the sex of the squid.
NIDAMENTAL_GLAND_LENGTH VARCHAR2	Nidamental gland length, in millimeters. Units for values are millimeters.
NIDAMENTAL_GLAND_WEIGHT VARCHAR2	Nidamental gland weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 4.
VAN_DEFERENS_LENGTH VARCHAR2	Vas Deferens length, in millimeters. Units for values are millimeters.
NEEDHAMS_SAC_WEIGHT VARCHAR2	Needham's Sac weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.
OVIDUCT_WEIGHT VARCHAR2	Oviduct weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.
GONAD_WEIGHT_TESTIS VARCHAR2	Testis weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.
GONAD_WEIGHT_OVARY VARCHAR2	Ovary weight, in tenths of a gram. Units for values are grams. Measures are reported with a precision of 4.
MATURITY_IMMATURE_CODE VARCHAR2	Code if the squid was immature.
MATURITY_MATURE_CODE VARCHAR2	Code if the squid was mature.
COITION_PRESENT_CODE VARCHAR2	Code for coition present.
COITION_NONE_CODE VARCHAR2	Code for coition none.
LIVER_WEIGHT VARCHAR2	Liver weight, in grams. Units for values are grams.
STOMACH_CONTENT_WEIGHT VARCHAR2	Stomach weight, units not provided. During data entry the decimal point was omitted; it has been inserted into the data.
STOMACH_CONTENT_CODE VARCHAR2	Code for stomach contents.
BODY_WEIGHT_LESS_INTERNAL_ORGAN VARCHAR2	Body weight, except internal organs. Units not provided.
GEAR_CODE VARCHAR2	Gear code for fishing.
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 for the year, e.g., 8101.

STATION_NUMBER
VARCHAR2

Station number of the fishing operation.

SPECIES_CODE
VARCHAR2

Czm 5-digit species code.

YEAR
VARCHAR2

Year.

MONTH
VARCHAR2

Month.

DAY
VARCHAR2

Day.

OCTANT
VARCHAR2

Octant of the globe. OCTANT was used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).

LATITUDE_DEGREES
VARCHAR2

Latitude degrees. Units for values are degrees.

LATITUDE_MINUTES
VARCHAR2

Latitude minutes. Units for values are minutes.

LATITUDE_DIRECTION
VARCHAR2

Latitude direction. OCTANT was used to determine latitude direction (N/S).

LATITUDE_DD
NUMBER

Computed latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.

LONGITUDE_DEGREES
VARCHAR2

Longitude degrees. During data entry the first digit (0 or 1) was omitted. OCTANT was used to determine the first digit (0 or 1) and inserted into the data. Units for values are degrees.

LONGITUDE_MINUTES
VARCHAR2

Longitude minutes. Units for values are minutes.

LONGITUDE_DIRECTION
VARCHAR2

Longitude direction. OCTANT was used to determine longitude direction (E/W).

LONGITUDE_DD
NUMBER

Computed longitude, in decimal degrees. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.

MESH_SIZE
VARCHAR2

Mesh size as "stretched" mesh measurement of the gillnet.

AUTOMATIC_JIGGING_CODE
VARCHAR2

Code if automatic jigging was used.

HAND_JIGGING_CODE
VARCHAR2

Code if hand jigging was used.

LINE_NUMBER
VARCHAR2

A consecutive number assigned to each data record on the collection form.

MANTLE_LENGTH
VARCHAR2

Mantle length, in millimeters. Units for values are millimeters.

BODY_WEIGHT
VARCHAR2

Body weight, in grams.

SEX_CODE
VARCHAR2

Code for the sex of the squid.

NIDAMENTAL_GLAND_LENGTH
VARCHAR2

Nidamental gland length, in millimeters. Units for values are millimeters.

NIDAMENTAL_GLAND_WEIGHT
VARCHAR2

Nidamental gland weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 4.

VAN_DEFERENS_LENGTH
VARCHAR2

Vas Deferens length, in millimeters. Units for values are millimeters.

NEEDHAMS_SAC_WEIGHT
VARCHAR2

Needham's Sac weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.

OVIDUCT_WEIGHT
VARCHAR2

Oviduct weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.

GONAD_WEIGHT_TESTIS
VARCHAR2

Testis weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.

GONAD_WEIGHT_OVARY
VARCHAR2

Ovary weight, in tenths of a gram. Units for values are grams. Measures are reported with a precision of 4.

MATURITY_IMMATURE_CODE
VARCHAR2

Code if the squid was immature.

MATURITY_MATURE_CODE
VARCHAR2

Code if the squid was mature.

COITION_PRESENT_CODE
VARCHAR2

Code for coition present.

COITION_NONE_CODE
VARCHAR2

Code for coition none.

LIVER_WEIGHT
VARCHAR2

Liver weight, in grams. Units for values are grams.

STOMACH_CONTENT_WEIGHT
VARCHAR2

Stomach weight, units not provided. During data entry the decimal point was omitted; it has been inserted into the data.

STOMACH_CONTENT_CODE
VARCHAR2

Code for stomach contents.

BODY_WEIGHT_LESS_INTERNAL_ORGAN
VARCHAR2

Body weight, except internal organs. Units not provided.

GEAR_CODE
VARCHAR2

Gear code for fishing.

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:	RP035AA1_V
Short Name:	RP035AA1_V
Status:	Completed
Abstract:	Squid morphometry collected in 1981 by the Hokusei Maru.

Entity Type:	Data Table
Active Version?:	Yes
Description:	Squid morphometry collected in 1981 by the Hokusei Maru.

Attribute Summary

	Name	Type	Description
100	DATASET_CODE	VARCHAR2	Source ID Code assigned by the data entry staff.
100	VERSION_CODE	VARCHAR2	Code for the format version assigned by the data entry staff.
100	VESSEL_CODE	VARCHAR2	Code for the vessel.
100	CRUISE_NUMBER	VARCHAR2	Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101.
100	STATION_NUMBER	VARCHAR2	Station number of the fishing operation.
100	SPECIES_CODE	VARCHAR2	Czm 5-digit species code.
100	YEAR	VARCHAR2	Year.
100	MONTH	VARCHAR2	Month.
100	DAY	VARCHAR2	Day.
100	OCTANT	VARCHAR2	Octant of the globe. OCTANT was used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).
100	LATITUDE_DEGREES	VARCHAR2	Latitude degrees. Units for values are degrees.
100	LATITUDE_MINUTES	VARCHAR2	Latitude minutes. Units for values are minutes.
100	LATITUDE_DIRECTION	VARCHAR2	Latitude direction. OCTANT was used to determine latitude direction (N/S).
100	LATITUDE_DD	NUMBER	Computed latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100	LONGITUDE_DEGREES	VARCHAR2	Longitude degrees. During data entry the first digit (0 or 1) was omitted. OCTANT was used to determine the first digit (0 or 1) and inserted into the data. Units for values are degrees.
100	LONGITUDE_MINUTES	VARCHAR2	Longitude minutes. Units for values are minutes.
100	LONGITUDE_DIRECTION	VARCHAR2	Longitude direction. OCTANT was used to determine longitude direction (E/W).
100	LONGITUDE_DD	NUMBER	Computed longitude, in decimal degrees. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100	MESH_SIZE	VARCHAR2	Mesh size as "stretched" mesh measurement of the gillnet.
100	AUTOMATIC_JIGGING_CODE	VARCHAR2	Code if automatic jigging was used.
100	HAND_JIGGING_CODE	VARCHAR2	Code if hand jigging was used.
100	LINE_NUMBER	VARCHAR2	A consecutive number assigned to each data record on the collection form.
100	MANTLE_LENGTH	VARCHAR2	Mantle length, in millimeters. Units for values are millimeters.
100	BODY_WEIGHT	VARCHAR2	Body weight, in grams.
100	SEX_CODE	VARCHAR2	Code for the sex of the squid.
100	NIDAMENTAL_GLAND_LENGTH	VARCHAR2	Nidamental gland length, in millimeters. Units for values are millimeters.
100	NIDAMENTAL_GLAND_WEIGHT	VARCHAR2	Nidamental gland weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 4.
100	VAN_DEFERENS_LENGTH	VARCHAR2	Vas Deferens length, in millimeters. Units for values are millimeters.
100	NEEDHAMS_SAC_WEIGHT	VARCHAR2	Needham's Sac weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.
100	OVIDUCT_WEIGHT	VARCHAR2	Oviduct weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.
100	GONAD_WEIGHT_TESTIS	VARCHAR2	Testis weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.
100	GONAD_WEIGHT_OVARY	VARCHAR2	Ovary weight, in tenths of a gram. Units for values are grams. Measures are reported with a precision of 4.
100	MATURITY_IMMATURE_CODE	VARCHAR2	Code if the squid was immature.
100	MATURITY_MATURE_CODE	VARCHAR2	Code if the squid was mature.
100	COITION_PRESENT_CODE	VARCHAR2	Code for coition present.
100	COITION_NONE_CODE	VARCHAR2	Code for coition none.
100	LIVER_WEIGHT	VARCHAR2	Liver weight, in grams. Units for values are grams.
100	STOMACH_CONTENT_WEIGHT	VARCHAR2	Stomach weight, units not provided. During data entry the decimal point was omitted; it has been inserted into the data.
100	STOMACH_CONTENT_CODE	VARCHAR2	Code for stomach contents.
100	BODY_WEIGHT_LESS_INTERNAL_ORGAN	VARCHAR2	Body weight, except internal organs. Units not provided.
100	GEAR_CODE	VARCHAR2	Gear code for fishing.
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 for the year, e.g., 8101.

100

STATION_NUMBER

VARCHAR2

Station number of the fishing operation.

100

SPECIES_CODE

VARCHAR2

Czm 5-digit species code.

100

YEAR

VARCHAR2

Year.

100

MONTH

VARCHAR2

Month.

100

DAY

VARCHAR2

Day.

100

OCTANT

VARCHAR2

Octant of the globe. OCTANT was used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).

100

LATITUDE_DEGREES

VARCHAR2

Latitude degrees. Units for values are degrees.

100

LATITUDE_MINUTES

VARCHAR2

Latitude minutes. Units for values are minutes.

100

LATITUDE_DIRECTION

VARCHAR2

Latitude direction. OCTANT was used to determine latitude direction (N/S).

100

LATITUDE_DD

NUMBER

Computed latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.

100

LONGITUDE_DEGREES

VARCHAR2

Longitude degrees. During data entry the first digit (0 or 1) was omitted. OCTANT was used to determine the first digit (0 or 1) and inserted into the data. Units for values are degrees.

100

LONGITUDE_MINUTES

VARCHAR2

Longitude minutes. Units for values are minutes.

100

LONGITUDE_DIRECTION

VARCHAR2

Longitude direction. OCTANT was used to determine longitude direction (E/W).

100

LONGITUDE_DD

NUMBER

Computed longitude, in decimal degrees. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.

100

MESH_SIZE

VARCHAR2

Mesh size as "stretched" mesh measurement of the gillnet.

100

AUTOMATIC_JIGGING_CODE

VARCHAR2

Code if automatic jigging was used.

100

HAND_JIGGING_CODE

VARCHAR2

Code if hand jigging was used.

100

LINE_NUMBER

VARCHAR2

A consecutive number assigned to each data record on the collection form.

100

MANTLE_LENGTH

VARCHAR2

Mantle length, in millimeters. Units for values are millimeters.

100

BODY_WEIGHT

VARCHAR2

Body weight, in grams.

100

SEX_CODE

VARCHAR2

Code for the sex of the squid.

100

NIDAMENTAL_GLAND_LENGTH

VARCHAR2

Nidamental gland length, in millimeters. Units for values are millimeters.

100

NIDAMENTAL_GLAND_WEIGHT

VARCHAR2

100

VAN_DEFERENS_LENGTH

VARCHAR2

Vas Deferens length, in millimeters. Units for values are millimeters.

100

NEEDHAMS_SAC_WEIGHT

VARCHAR2

100

OVIDUCT_WEIGHT

VARCHAR2

Oviduct weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.

100

GONAD_WEIGHT_TESTIS

VARCHAR2

Testis weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.

100

GONAD_WEIGHT_OVARY

VARCHAR2

Ovary weight, in tenths of a gram. Units for values are grams. Measures are reported with a precision of 4.

100

MATURITY_IMMATURE_CODE

VARCHAR2

Code if the squid was immature.

100

MATURITY_MATURE_CODE

VARCHAR2

Code if the squid was mature.

100

COITION_PRESENT_CODE

VARCHAR2

Code for coition present.

100

COITION_NONE_CODE

VARCHAR2

Code for coition none.

100

LIVER_WEIGHT

VARCHAR2

Liver weight, in grams. Units for values are grams.

100

STOMACH_CONTENT_WEIGHT

VARCHAR2

Stomach weight, units not provided. During data entry the decimal point was omitted; it has been inserted into the data.

100

STOMACH_CONTENT_CODE

VARCHAR2

Code for stomach contents.

100

BODY_WEIGHT_LESS_INTERNAL_ORGAN

VARCHAR2

Body weight, except internal organs. Units not provided.

100

GEAR_CODE

VARCHAR2

Gear code for fishing.

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

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

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

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:	995 = HOKUSEI MARU

CRUISE_NUMBER

CC ID: 1176706

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

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

SPECIES_CODE

CC ID: 1176708

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Czm 5-digit species code.
General Data Type:	VARCHAR2
Allowed Values:	50302 = OMMASTREPHES BARTRAMI (LESUEUR); 50311 = SYMPLECTOTEUTHIS OUALANIENSIS (LESSON); 50701 = ONYCHOTEUTHIS BOREALIJAPONICUS (OKADA)

YEAR

CC ID: 1176709

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year.
General Data Type:	VARCHAR2

MONTH

CC ID: 1176710

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month.
General Data Type:	VARCHAR2

DAY

CC ID: 1176711

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day.
General Data Type:	VARCHAR2

OCTANT

CC ID: 1176712

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Octant of the globe. OCTANT was used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).
General Data Type:	VARCHAR2
Allowed Values:	0 = NORTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 1 = NORTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 2 = NORTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 3 = NORTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE; 5 = SOUTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 6 = SOUTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 7 = SOUTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 8 = SOUTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE

LATITUDE_DEGREES

CC ID: 1176713

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude degrees. Units for values are degrees.
General Data Type:	VARCHAR2
Unit of Measure:	degrees

LATITUDE_MINUTES

CC ID: 1176714

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude minutes. Units for values are minutes.
General Data Type:	VARCHAR2
Unit of Measure:	minutes

LATITUDE_DIRECTION

CC ID: 1176715

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude direction. OCTANT was used to determine latitude direction (N/S).
General Data Type:	VARCHAR2
Allowed Values:	N = NORTH; S = SOUTH

LATITUDE_DD

CC ID: 1176716

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	41
Required:	No
Primary Key:	No
Scale:	38
Status:	Active
Description:	Computed latitude, in decimal degrees. 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

LONGITUDE_DEGREES

CC ID: 1176717

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude degrees. During data entry the first digit (0 or 1) was omitted. OCTANT was used to determine the first digit (0 or 1) and inserted into the data. Units for values are degrees.
General Data Type:	VARCHAR2
Unit of Measure:	degrees

LONGITUDE_MINUTES

CC ID: 1176718

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude minutes. Units for values are minutes.
General Data Type:	VARCHAR2
Unit of Measure:	minutes

LONGITUDE_DIRECTION

CC ID: 1176719

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude direction. OCTANT was used to determine longitude direction (E/W).
General Data Type:	VARCHAR2
Default Value:	E = EAST; W = WEST

LONGITUDE_DD

CC ID: 1176720

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	40
Required:	No
Primary Key:	No
Scale:	36
Status:	Active
Description:	Computed longitude, in decimal degrees. 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

MESH_SIZE

CC ID: 1176721

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Mesh size as "stretched" mesh measurement of the gillnet.
General Data Type:	VARCHAR2

AUTOMATIC_JIGGING_CODE

CC ID: 1176722

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code if automatic jigging was used.
General Data Type:	VARCHAR2
Allowed Values:	1 = 0 ON COLLECTION FORM

HAND_JIGGING_CODE

CC ID: 1176723

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code if hand jigging was used.
General Data Type:	VARCHAR2
Allowed Values:	1 = 0 ON COLLECTION FORM

LINE_NUMBER

CC ID: 1176724

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	A consecutive number assigned to each data record on the collection form.
General Data Type:	VARCHAR2

MANTLE_LENGTH

CC ID: 1176725

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Mantle length, in millimeters. Units for values are millimeters.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

BODY_WEIGHT

CC ID: 1176726

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Body weight, in grams.
General Data Type:	VARCHAR2

SEX_CODE

CC ID: 1176727

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the sex of the squid.
General Data Type:	VARCHAR2
Allowed Values:	F = FEMALE; M = MALE

NIDAMENTAL_GLAND_LENGTH

CC ID: 1176728

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Nidamental gland length, in millimeters. Units for values are millimeters.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

NIDAMENTAL_GLAND_WEIGHT

CC ID: 1176729

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Nidamental gland weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 4.
General Data Type:	VARCHAR2
Unit of Measure:	grams

VAN_DEFERENS_LENGTH

CC ID: 1176730

Seq. Order:	28
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Vas Deferens length, in millimeters. Units for values are millimeters.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

NEEDHAMS_SAC_WEIGHT

CC ID: 1176731

Seq. Order:	29
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Needham's Sac weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	grams

OVIDUCT_WEIGHT

CC ID: 1176732

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Oviduct weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	grams

GONAD_WEIGHT_TESTIS

CC ID: 1176733

Seq. Order:	31
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Testis weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	grams

GONAD_WEIGHT_OVARY

CC ID: 1176734

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Ovary weight, in tenths of a gram. Units for values are grams. Measures are reported with a precision of 4.
General Data Type:	VARCHAR2
Unit of Measure:	grams

MATURITY_IMMATURE_CODE

CC ID: 1176735

Seq. Order:	33
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code if the squid was immature.
General Data Type:	VARCHAR2
Allowed Values:	1 = 0 ON COLLECTION FORM

MATURITY_MATURE_CODE

CC ID: 1176736

Seq. Order:	34
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code if the squid was mature.
General Data Type:	VARCHAR2
Allowed Values:	1 = 0 ON COLLECTION FORM

COITION_PRESENT_CODE

CC ID: 1176737

Seq. Order:	35
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for coition present.
General Data Type:	VARCHAR2
Allowed Values:	1 = 0 ON COLLECTION FORM

COITION_NONE_CODE

CC ID: 1176738

Seq. Order:	36
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for coition none.
General Data Type:	VARCHAR2
Allowed Values:	1 = 0 ON COLLECTION FORM

LIVER_WEIGHT

CC ID: 1176739

Seq. Order:	37
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Liver weight, in grams. Units for values are grams.
General Data Type:	VARCHAR2
Unit of Measure:	grams

STOMACH_CONTENT_WEIGHT

CC ID: 1176740

Seq. Order:	38
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Stomach weight, units not provided. During data entry the decimal point was omitted; it has been inserted into the data.
General Data Type:	VARCHAR2

STOMACH_CONTENT_CODE

CC ID: 1176741

Seq. Order:	39
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for stomach contents.
General Data Type:	VARCHAR2
Allowed Values:	01 = CRUSTACEA; 02 = DISSOLVED MATERIAL; 03 = EMPTY; 04 = FISH; 05 = SQUID; 06 = SQUID FISH

BODY_WEIGHT_LESS_INTERNAL_ORGAN

CC ID: 1176742

Seq. Order:	40
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Body weight, except internal organs. Units not provided.
General Data Type:	VARCHAR2

GEAR_CODE

CC ID: 1176743

Seq. Order:	41
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Gear code for fishing.
General Data Type:	VARCHAR2
Allowed Values:	G = GILL NET; J = JIGGING

SEQUENCE_NUMBER

CC ID: 1176744

Seq. Order:	42
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: 1176745

Seq. Order:	43
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:	67460
GUID:	gov.noaa.nmfs.inport:67460
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2022-06-23 00:21+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2022-06-24
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2022-06-24
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2023-06-24

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

SPECIES_CODE

YEAR

MONTH

DAY

OCTANT

LATITUDE_DEGREES

LATITUDE_MINUTES

LATITUDE_DIRECTION

LATITUDE_DD

LONGITUDE_DEGREES

LONGITUDE_MINUTES

LONGITUDE_DIRECTION

LONGITUDE_DD

MESH_SIZE

AUTOMATIC_JIGGING_CODE

HAND_JIGGING_CODE

LINE_NUMBER

MANTLE_LENGTH

BODY_WEIGHT

SEX_CODE

NIDAMENTAL_GLAND_LENGTH

NIDAMENTAL_GLAND_WEIGHT

VAN_DEFERENS_LENGTH

NEEDHAMS_SAC_WEIGHT

OVIDUCT_WEIGHT

GONAD_WEIGHT_TESTIS

GONAD_WEIGHT_OVARY

MATURITY_IMMATURE_CODE

MATURITY_MATURE_CODE

COITION_PRESENT_CODE

COITION_NONE_CODE

LIVER_WEIGHT

STOMACH_CONTENT_WEIGHT

STOMACH_CONTENT_CODE

BODY_WEIGHT_LESS_INTERNAL_ORGAN

GEAR_CODE

SEQUENCE_NUMBER

DATE_LOADED

Catalog Details