RP019AA1_CONF_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:55934 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Tag release data collected in 1955 and 1970.
DescriptionTag 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
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
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
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
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
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
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month. |
General Data Type: | VARCHAR2 |
DAY
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |