Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

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

Description

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

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

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: RI006AA2_V
Short Name: RI006AA2_V
Status: Completed
Abstract:

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

Entity Information

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

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

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

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 Details

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