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

Summary

Abstract

Tag release data collected in 1955 and 1970.

Description

Tag release data collected in 1955 and 1970.

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
Four digit incremental cruise number of the vessel, e.g., 0020.
YEAR
VARCHAR2
Year.
MONTH
VARCHAR2
Month.
DAY
VARCHAR2
Day.
LOCAL_TIME
VARCHAR2
Local time.
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. 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.
STATION_NUMBER
VARCHAR2
Station number.
GEAR_CODE
VARCHAR2
Code for the gear used to catch the fish.
SPECIES_CODE
VARCHAR2
Two digit species code.
RELEASE_LOT_NUMBER
VARCHAR2
Release Lot Number.
RELEASE_LOT_NUMBER_RELEASED
VARCHAR2
Release Lot Number Released.
RELEASE_LOT_NUMBER_MEASURED
VARCHAR2
Release Lot Number Measured.
RELEASE_LOT_MEAN_FORK_LENGTH
VARCHAR2
Release Lot Mean Fork Length, in whole millimeters. Units for values are millimeters.
RELEASE_LOT_STANDARD_DEVIATION
VARCHAR2
Release Lot Standard Deviaton, in tenths of a millimeter. During data entry, the decimal point was omitted (0000 = 000.0); it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 4.
TAG_NUMBER
VARCHAR2
Individual tag number.
FORK_LENGTH
VARCHAR2
Individual fork length, in millimeters. Units for values are millimeters.
FORK_LENGTH_CM
VARCHAR2
Individual fork length, in centimeter. Units for values are centimeters.
FISH_MEASURING_DEVICE_CODE
VARCHAR2
Code for the fish measuring device.
TAG_TYPE_CODE
VARCHAR2
Code for the type of the tag.
TAG_COLOR_CODE
VARCHAR2
Code for the color of the tag.
TIME_ZONE_CODE
VARCHAR2
Code for the time zone.
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: RP019AA1_CONF_V
Short Name: RP019AA1_CONF_V
Status: Completed
Abstract:

Tag release data collected in 1955 and 1970.

Entity Information

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

Tag release data collected in 1955 and 1970.

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 Four digit incremental cruise number of the vessel, e.g., 0020.
100
YEAR VARCHAR2 Year.
100
MONTH VARCHAR2 Month.
100
DAY VARCHAR2 Day.
100
LOCAL_TIME VARCHAR2 Local time.
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. 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
STATION_NUMBER VARCHAR2 Station number.
100
GEAR_CODE VARCHAR2 Code for the gear used to catch the fish.
100
SPECIES_CODE VARCHAR2 Two digit species code.
100
RELEASE_LOT_NUMBER VARCHAR2 Release Lot Number.
100
RELEASE_LOT_NUMBER_RELEASED VARCHAR2 Release Lot Number Released.
100
RELEASE_LOT_NUMBER_MEASURED VARCHAR2 Release Lot Number Measured.
100
RELEASE_LOT_MEAN_FORK_LENGTH VARCHAR2 Release Lot Mean Fork Length, in whole millimeters. Units for values are millimeters.
100
RELEASE_LOT_STANDARD_DEVIATION VARCHAR2 Release Lot Standard Deviaton, in tenths of a millimeter. During data entry, the decimal point was omitted (0000 = 000.0); it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 4.
100
TAG_NUMBER VARCHAR2 Individual tag number.
100
FORK_LENGTH VARCHAR2 Individual fork length, in millimeters. Units for values are millimeters.
100
FORK_LENGTH_CM VARCHAR2 Individual fork length, in centimeter. Units for values are centimeters.
100
FISH_MEASURING_DEVICE_CODE VARCHAR2 Code for the fish measuring device.
100
TAG_TYPE_CODE VARCHAR2 Code for the type of the tag.
100
TAG_COLOR_CODE VARCHAR2 Code for the color of the tag.
100
TIME_ZONE_CODE VARCHAR2 Code for the time zone.
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: 1079131
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: 1079132
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: 1079133
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

CRUISE_NUMBER

CC ID: 1079134
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Four digit incremental cruise number of the vessel, e.g., 0020.

General Data Type: VARCHAR2

YEAR

CC ID: 1079135
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year.

General Data Type: VARCHAR2

MONTH

CC ID: 1079136
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month.

General Data Type: VARCHAR2

DAY

CC ID: 1079137
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day.

General Data Type: VARCHAR2

LOCAL_TIME

CC ID: 1079138
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Local time.

General Data Type: VARCHAR2

OCTANT

CC ID: 1079139
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4
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: 1 = NORTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 6 = SOUTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 7 = SOUTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE

LATITUDE_DEGREES

CC ID: 1079140
Seq. Order: 10
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: 1079141
Seq. Order: 11
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: 1079142
Seq. Order: 12
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: 1079143
Seq. Order: 13
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: 1079144
Seq. Order: 14
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. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

CC ID: 1079145
Seq. Order: 15
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: 1079146
Seq. Order: 16
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
Allowed Values: E = EAST; W = WEST

LONGITUDE_DD

CC ID: 1079147
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 41
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

STATION_NUMBER

CC ID: 1079148
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Station number.

General Data Type: VARCHAR2

GEAR_CODE

CC ID: 1079149
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the gear used to catch the fish.

General Data Type: VARCHAR2
Allowed Values: 1 = TROLLING; 2 = POLE-AND-LINE FISHING; 3 = LONGLINING; 4 = GILL NETTING; 5 = ROD AND REEL

SPECIES_CODE

CC ID: 1079150
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two digit species code.

General Data Type: VARCHAR2
Allowed Values: 32 = SKIPJACK; 33 = LITTLE TUNNY, KAWAKAWA; 34 = BIGEYE TUNA; 35 = YELLOWFIN TUNA; 36 = ALBACORE; 44 = WAHOO; 47 = SHORTBILL SPEARFISH; 51 = STRIPED MARLIN; 55 = CARANGIDAE; 75 = BONITO OR MAKO SHARK; 81 = GREAT BLUE SHARK; 90 = COMBINATION IN SCHOOL SKIPJACK-YELLOWFIN TUNA

RELEASE_LOT_NUMBER

CC ID: 1079151
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Release Lot Number.

General Data Type: VARCHAR2

RELEASE_LOT_NUMBER_RELEASED

CC ID: 1079152
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Release Lot Number Released.

General Data Type: VARCHAR2

RELEASE_LOT_NUMBER_MEASURED

CC ID: 1079153
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Lot Number Measured.

General Data Type: VARCHAR2

RELEASE_LOT_MEAN_FORK_LENGTH

CC ID: 1079154
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Release Lot Mean Fork Length, in whole millimeters. Units for values are millimeters.

General Data Type: VARCHAR2
Unit of Measure: millimeters

RELEASE_LOT_STANDARD_DEVIATION

CC ID: 1079155
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Release Lot Standard Deviaton, in tenths of a millimeter. During data entry, the decimal point was omitted (0000 = 000.0); it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 4.

General Data Type: VARCHAR2
Unit of Measure: millimeters

TAG_NUMBER

CC ID: 1079156
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Individual tag number.

General Data Type: VARCHAR2

FORK_LENGTH

CC ID: 1079157
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Individual fork length, in millimeters. Units for values are millimeters.

General Data Type: VARCHAR2
Unit of Measure: millimeters

FORK_LENGTH_CM

CC ID: 1079158
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Individual fork length, in centimeter. Units for values are centimeters.

General Data Type: VARCHAR2
Unit of Measure: centimeters

FISH_MEASURING_DEVICE_CODE

CC ID: 1079159
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the fish measuring device.

General Data Type: VARCHAR2
Allowed Values: 1 = CALIPER; 2 = MEASURING BOARD; 3 = PHOTO; 4 = STEEL TAPE

TAG_TYPE_CODE

CC ID: 1079160
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the type of the tag.

General Data Type: VARCHAR2
Allowed Values: 0 = MIXED TYPES; 1 = SPAH\GHETTI, LOOP OR CALIFORNIA "G"; 2 = D-2 DART (ALL PARTS THROUGH 1968); 3 = FLOY DART (5/29/1968 ON)

TAG_COLOR_CODE

CC ID: 1079161
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the color of the tag.

General Data Type: VARCHAR2
Allowed Values: 0 = MIXED COLORS; 1 = RED; 2 = BLUE; 3 = WHITE; 4 = YELLOW

TIME_ZONE_CODE

CC ID: 1079162
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the time zone.

General Data Type: VARCHAR2
Allowed Values: L = MINUS 11; M = MINUS 12; U = PLUS 8; V = PLUS 9; W = PLUS 10; X = PLUS 11; Z = PLUS 12

SEQUENCE_NUMBER

CC ID: 1079163
Seq. Order: 33
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: 1079164
Seq. Order: 34
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: 55934
GUID: gov.noaa.nmfs.inport:55934
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-03-22 15:37+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-09-15
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-09-15
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-09-15