Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Insular Metadata Portfolio > Fish tagging data collected during NOAA R/V Tow... >

RI006AA2_V

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Fish tagging data collected on NOAA R/V Townsend Cromwell.

Description

Fish tagging data collected on NOAA R/V Townsend Cromwell.

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.
AGENCY_CODE VARCHAR2	Code for the agency that collected the data.
LINE_NUMBER VARCHAR2	Consecutive number on the collection form for each fish recorded on the form.
YEAR VARCHAR2	Year.
MONTH VARCHAR2	Month.
DAY VARCHAR2	Day.
STATION_NUMBER VARCHAR2	Station number.
BANK_CODE VARCHAR2	7-digit code of bank.
LATITUDE_DEGREES VARCHAR2	Latitude degrees. Units for values are degrees.
LATITUDE_MINUTES VARCHAR2	Latitude minutes, in tenths of a minute. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
LATITUDE_DIRECTION VARCHAR2	Latitude direction.
LATITUDE_DD NUMBER	Computed latitude, in decimal degrees. Positive values are North latitude and negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
LONGITUDE_DEGREES VARCHAR2	Longitude degrees. Units for values are degrees.
LONGITUDE_MINUTES VARCHAR2	Longitude minutes, in tenths of a minute, of capture. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
LONGITUDE_DIRECTION VARCHAR2	Longitude direction.
LONGITUDE_DD NUMBER	Computed longitude, in decimal degrees. Positive values are East longitude and negative values are West longitude. Units for values are degrees. Measures are reported with a precision of 39.
SPECIES_CODE VARCHAR2	CZM 10-digit species code of fish.
LENGTH VARCHAR2	Total or fork length of fish, in tenths of a centimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 6.
DEPTH VARCHAR2	Depth, in fathoms. Units for values are fathoms.
GEAR_CODE VARCHAR2	Code for the type of gear that caught the species.
TAG_NUMBER VARCHAR2	Tag number.
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., D83023.
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.

AGENCY_CODE
VARCHAR2

Code for the agency that collected the data.

LINE_NUMBER
VARCHAR2

Consecutive number on the collection form for each fish recorded on the form.

YEAR
VARCHAR2

Year.

MONTH
VARCHAR2

Month.

DAY
VARCHAR2

Day.

STATION_NUMBER
VARCHAR2

Station number.

BANK_CODE
VARCHAR2

7-digit code of bank.

LATITUDE_DEGREES
VARCHAR2

Latitude degrees. Units for values are degrees.

LATITUDE_MINUTES
VARCHAR2

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

LATITUDE_DIRECTION
VARCHAR2

Latitude direction.

LATITUDE_DD
NUMBER

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

LONGITUDE_DEGREES
VARCHAR2

Longitude degrees. Units for values are degrees.

LONGITUDE_MINUTES
VARCHAR2

Longitude minutes, in tenths of a minute, of capture. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.

LONGITUDE_DIRECTION
VARCHAR2

Longitude direction.

LONGITUDE_DD
NUMBER

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

SPECIES_CODE
VARCHAR2

CZM 10-digit species code of fish.

LENGTH
VARCHAR2

Total or fork length of fish, in tenths of a centimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 6.

DEPTH
VARCHAR2

Depth, in fathoms. Units for values are fathoms.

GEAR_CODE
VARCHAR2

Code for the type of gear that caught the species.

TAG_NUMBER
VARCHAR2

Tag number.

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

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:	RI006AA2_V
Short Name:	RI006AA2_V
Status:	Completed
Abstract:	Fish tagging data collected on NOAA R/V Townsend Cromwell.

Entity Type:	Data Table
Active Version?:	Yes
Description:	Fish tagging data collected on NOAA R/V Townsend Cromwell.

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.
100	AGENCY_CODE	VARCHAR2	Code for the agency that collected the data.
100	LINE_NUMBER	VARCHAR2	Consecutive number on the collection form for each fish recorded on the form.
100	YEAR	VARCHAR2	Year.
100	MONTH	VARCHAR2	Month.
100	DAY	VARCHAR2	Day.
100	STATION_NUMBER	VARCHAR2	Station number.
100	BANK_CODE	VARCHAR2	7-digit code of bank.
100	LATITUDE_DEGREES	VARCHAR2	Latitude degrees. Units for values are degrees.
100	LATITUDE_MINUTES	VARCHAR2	Latitude minutes, in tenths of a minute. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
100	LATITUDE_DIRECTION	VARCHAR2	Latitude direction.
100	LATITUDE_DD	NUMBER	Computed latitude, in decimal degrees. Positive values are North latitude and negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100	LONGITUDE_DEGREES	VARCHAR2	Longitude degrees. Units for values are degrees.
100	LONGITUDE_MINUTES	VARCHAR2	Longitude minutes, in tenths of a minute, of capture. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
100	LONGITUDE_DIRECTION	VARCHAR2	Longitude direction.
100	LONGITUDE_DD	NUMBER	Computed longitude, in decimal degrees. Positive values are East longitude and negative values are West longitude. Units for values are degrees. Measures are reported with a precision of 39.
100	SPECIES_CODE	VARCHAR2	CZM 10-digit species code of fish.
100	LENGTH	VARCHAR2	Total or fork length of fish, in tenths of a centimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 6.
100	DEPTH	VARCHAR2	Depth, in fathoms. Units for values are fathoms.
100	GEAR_CODE	VARCHAR2	Code for the type of gear that caught the species.
100	TAG_NUMBER	VARCHAR2	Tag number.
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., D83023.
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.

100

AGENCY_CODE

VARCHAR2

Code for the agency that collected the data.

100

LINE_NUMBER

VARCHAR2

Consecutive number on the collection form for each fish recorded on the form.

100

YEAR

VARCHAR2

Year.

100

MONTH

VARCHAR2

Month.

100

DAY

VARCHAR2

Day.

100

STATION_NUMBER

VARCHAR2

Station number.

100

BANK_CODE

VARCHAR2

7-digit code of bank.

100

LATITUDE_DEGREES

VARCHAR2

Latitude degrees. Units for values are degrees.

100

LATITUDE_MINUTES

VARCHAR2

100

LATITUDE_DIRECTION

VARCHAR2

Latitude direction.

100

LATITUDE_DD

NUMBER

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

100

LONGITUDE_DEGREES

VARCHAR2

Longitude degrees. Units for values are degrees.

100

LONGITUDE_MINUTES

VARCHAR2

100

LONGITUDE_DIRECTION

VARCHAR2

Longitude direction.

100

LONGITUDE_DD

NUMBER

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

100

SPECIES_CODE

VARCHAR2

CZM 10-digit species code of fish.

100

LENGTH

VARCHAR2

100

DEPTH

VARCHAR2

Depth, in fathoms. Units for values are fathoms.

100

GEAR_CODE

VARCHAR2

Code for the type of gear that caught the species.

100

TAG_NUMBER

VARCHAR2

Tag number.

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

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

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

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

CRUISE_NUMBER

CC ID: 988449

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

AGENCY_CODE

CC ID: 988450

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the agency that collected the data.
General Data Type:	VARCHAR2
Allowed Values:	NMFS = NATIONAL MARINE FISHERIES SERVICE

LINE_NUMBER

CC ID: 988451

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Consecutive number on the collection form for each fish recorded on the form.
General Data Type:	VARCHAR2

YEAR

CC ID: 988452

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

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

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

STATION_NUMBER

CC ID: 988455

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Station number.
General Data Type:	VARCHAR2

BANK_CODE

CC ID: 988456

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	7-digit code of bank.
General Data Type:	VARCHAR2
Allowed Values:	1071100 = NECKER ISLAND; 1101100 = RAITA BANK; 1270100 = SOUTH-EAST HANCOCK SEAMOUNT; 1270200 = NORTH-WEST HANCOCK SEAMOUNT; 2040200 = TINIAN; 2050100 = ARAKANE REEF; 2180000 = AGRIHAN; 2430000 = PATHFINDER REEF;

LATITUDE_DEGREES

CC ID: 988457

Seq. Order:	12
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: 988458

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

LATITUDE_DIRECTION

CC ID: 988459

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude direction.
General Data Type:	VARCHAR2
Allowed Values:	N = NORTH; S = SOUTH

LATITUDE_DD

CC ID: 988460

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

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

LONGITUDE_MINUTES

CC ID: 988462

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

LONGITUDE_DIRECTION

CC ID: 988463

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude direction.
General Data Type:	VARCHAR2
Allowed Values:	E = EAST; W = WEST

LONGITUDE_DD

CC ID: 988464

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	41
Required:	No
Primary Key:	No
Scale:	37
Status:	Active
Description:	Computed longitude, in decimal degrees. Positive values are East longitude and negative values are West longitude. Units for values are degrees. Measures are reported with a precision of 39.
General Data Type:	NUMBER
Unit of Measure:	degrees

SPECIES_CODE

CC ID: 988465

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	CZM 10-digit species code of fish.
General Data Type:	VARCHAR2

LENGTH

CC ID: 988466

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Total or fork length of fish, in tenths of a centimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 6.
General Data Type:	VARCHAR2
Unit of Measure:	centimeters

DEPTH

CC ID: 988467

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

GEAR_CODE

CC ID: 988468

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the type of gear that caught the species.
General Data Type:	VARCHAR2
Allowed Values:	02 = LONGLINE; 04 = HANDLINE; 05 = KAKA LINE; 06 = TROLLING LINE; 08 = ROD AND REEL; 14 = MACKEREL HANDLINE; 15 = NIGHT LIGHT; 19 = FISH TRAP (GENERAL); 21 = BOTTOM LONGLINE WITH MAGNESIUM TIMERS (5 HOOKS PER PVC DROPPER) (FIRST USED ON TC 86-05); 34 = SURFACE LONGLINE WITH SINGLE HOOK 1-M MONOFILAMENT DROPPERS OFF 5/16 IN NYLON MAIN LINE (3248 M LONG MAIN LINE CONSISTS OF 400-450 HOOKS OFF 72 24-FM SECTIONS WITH FLOATS 48 FM APART) (FIRST USED ON TC 89-09)

TAG_NUMBER

CC ID: 988469

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Tag number.
General Data Type:	VARCHAR2

JOB_NUMBER

CC ID: 988470

Seq. Order:	25
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., D83023.
General Data Type:	VARCHAR2

SEQUENCE_NUMBER

CC ID: 988471

Seq. Order:	26
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: 988472

Seq. Order:	27
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:	62823
GUID:	gov.noaa.nmfs.inport:62823
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2020-08-30 03:04+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2020-10-01
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2020-10-01
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2021-10-01

RI006AA2_V

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

AGENCY_CODE

LINE_NUMBER

YEAR

MONTH

DAY

STATION_NUMBER

BANK_CODE

LATITUDE_DEGREES

LATITUDE_MINUTES

LATITUDE_DIRECTION

LATITUDE_DD

LONGITUDE_DEGREES

LONGITUDE_MINUTES

LONGITUDE_DIRECTION

LONGITUDE_DD

SPECIES_CODE

LENGTH

DEPTH

GEAR_CODE

TAG_NUMBER

JOB_NUMBER

SEQUENCE_NUMBER

DATE_LOADED

Catalog Details