RP020AA1_RSCH_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:65434 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Tag recapture data collected between 1957 and 1958.
DescriptionTag recapture data collected between 1957 and 1958.
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. |
DISTANCE_MOVED
VARCHAR2 |
Distance, in kilometers, between release and recapture location. Units for values are kilometers. |
YEAR
VARCHAR2 |
Year that the tagged fish was recaptured. |
MONTH
VARCHAR2 |
Month that the tagged fish was recaptured. |
DAY
VARCHAR2 |
Day that the tagged fish was recaptured. |
NUMBER_DAYS_OUT
VARCHAR2 |
Number of days the tag was out. |
GEAR_CODE
VARCHAR2 |
Code for the gear used to recapture the fish. |
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 then 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. |
HAWAII_DAR_STATISTICAL_AREA
VARCHAR2 |
Hawaii DAR Statistical Area of fish recapture. |
GROWTH_INCREMENT
VARCHAR2 |
Increase in growth, in millimeters. Units for values are millimeters. |
FORK_LENGTH
VARCHAR2 |
Fork length, in millimeters. Units for values are millimeters. |
WEIGHT_RECORDED
VARCHAR2 |
Weight, in kilograms. The data collection form indicates that data was recorded in kilograms. Units for values are kilograms. |
WEIGHT
VARCHAR2 |
Weight, in hundredths of a kilogram, based on the length-weight plot found in Figure 2 of https://horizon.documentation.ird.fr/exl-doc/pleins_textes/divers17-01/010067418.pdf. Units for values are kilograms. Measures are reported with a precision of 4. |
SEX_MATURITY_CODE
VARCHAR2 |
Code for the sex and maturity of the species. |
SPECIES_CODE
VARCHAR2 |
Two digit species code for skipjack tuna. |
TAG_NUMBER
VARCHAR2 |
Tag number. |
TAG_TYPE_CODE
VARCHAR2 |
Code for the tag type. |
TAG_COLOR_CODE
VARCHAR2 |
Code for the tag color. |
RELEASE_VESSEL_CODE
VARCHAR2 |
Code for the vessel that released the tagged fish. |
RELEASE_CRUISE_NUMBER
VARCHAR2 |
Cruise number of the vessel that released the tagged fish. |
RELEASE_STATION_NUMBER
VARCHAR2 |
Station number of the tagged fish release. |
RELEASE_OCTANT
VARCHAR2 |
Octant of the globe. OCTANT was used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of logitude degrees (0/1). |
RELEASE_LATITUDE_DEGREES
VARCHAR2 |
Latitude degrees. Units for values are degrees. |
RELEASE_LATITUDE_MINUTES
VARCHAR2 |
Latitude minutes. Units for values are minutes. |
RELEASE_LATITUDE_DIRECTION
VARCHAR2 |
Latitude direction. OCTANT was used to determine latitude direction (N/S). |
RELEASE_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. |
RELEASE_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 then inserted. Units for values are degrees. |
RELEASE_LONGITUDE_MINUTES
VARCHAR2 |
Longitude minutes. Units for values are minutes. |
RELEASE_LONGITUDE_DIRECTION
VARCHAR2 |
Longitude direction. OCTANT was used to determine longitude direction (E/W). |
RELEASE_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. |
RELEASE_YEAR
VARCHAR2 |
Year that the tagged fish was released. |
RELEASE_MONTH
VARCHAR2 |
Month that the tagged fish was released. |
RELEASE_DAY
VARCHAR2 |
Day that the tagged fish was released. |
RELEASE_GEAR_CODE
VARCHAR2 |
Code for the gear used to catch the fish before tagging. |
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: | RP020AA1_RSCH_V |
---|---|
Short Name: | RP020AA1_RSCH_V |
Status: | Completed |
Abstract: |
Tag recapture data collected between 1957 and 1958. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Tag recapture data collected between 1957 and 1958. |
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
|
DISTANCE_MOVED | VARCHAR2 | Distance, in kilometers, between release and recapture location. Units for values are kilometers. | |
100
|
YEAR | VARCHAR2 | Year that the tagged fish was recaptured. | |
100
|
MONTH | VARCHAR2 | Month that the tagged fish was recaptured. | |
100
|
DAY | VARCHAR2 | Day that the tagged fish was recaptured. | |
100
|
NUMBER_DAYS_OUT | VARCHAR2 | Number of days the tag was out. | |
100
|
GEAR_CODE | VARCHAR2 | Code for the gear used to recapture the fish. | |
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 then 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
|
HAWAII_DAR_STATISTICAL_AREA | VARCHAR2 | Hawaii DAR Statistical Area of fish recapture. | |
100
|
GROWTH_INCREMENT | VARCHAR2 | Increase in growth, in millimeters. Units for values are millimeters. | |
100
|
FORK_LENGTH | VARCHAR2 | Fork length, in millimeters. Units for values are millimeters. | |
100
|
WEIGHT_RECORDED | VARCHAR2 | Weight, in kilograms. The data collection form indicates that data was recorded in kilograms. Units for values are kilograms. | |
100
|
WEIGHT | VARCHAR2 | Weight, in hundredths of a kilogram, based on the length-weight plot found in Figure 2 of https://horizon.documentation.ird.fr/exl-doc/pleins_textes/divers17-01/010067418.pdf. Units for values are kilograms. Measures are reported with a precision of 4. | |
100
|
SEX_MATURITY_CODE | VARCHAR2 | Code for the sex and maturity of the species. | |
100
|
SPECIES_CODE | VARCHAR2 | Two digit species code for skipjack tuna. | |
100
|
TAG_NUMBER | VARCHAR2 | Tag number. | |
100
|
TAG_TYPE_CODE | VARCHAR2 | Code for the tag type. | |
100
|
TAG_COLOR_CODE | VARCHAR2 | Code for the tag color. | |
100
|
RELEASE_VESSEL_CODE | VARCHAR2 | Code for the vessel that released the tagged fish. | |
100
|
RELEASE_CRUISE_NUMBER | VARCHAR2 | Cruise number of the vessel that released the tagged fish. | |
100
|
RELEASE_STATION_NUMBER | VARCHAR2 | Station number of the tagged fish release. | |
100
|
RELEASE_OCTANT | VARCHAR2 | Octant of the globe. OCTANT was used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of logitude degrees (0/1). | |
100
|
RELEASE_LATITUDE_DEGREES | VARCHAR2 | Latitude degrees. Units for values are degrees. | |
100
|
RELEASE_LATITUDE_MINUTES | VARCHAR2 | Latitude minutes. Units for values are minutes. | |
100
|
RELEASE_LATITUDE_DIRECTION | VARCHAR2 | Latitude direction. OCTANT was used to determine latitude direction (N/S). | |
100
|
RELEASE_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
|
RELEASE_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 then inserted. Units for values are degrees. | |
100
|
RELEASE_LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes. Units for values are minutes. | |
100
|
RELEASE_LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction. OCTANT was used to determine longitude direction (E/W). | |
100
|
RELEASE_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
|
RELEASE_YEAR | VARCHAR2 | Year that the tagged fish was released. | |
100
|
RELEASE_MONTH | VARCHAR2 | Month that the tagged fish was released. | |
100
|
RELEASE_DAY | VARCHAR2 | Day that the tagged fish was released. | |
100
|
RELEASE_GEAR_CODE | VARCHAR2 | Code for the gear used to catch the fish before tagging. | |
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 |
Allowed Values: | 05 = NOAA R/V JOHN R. MANNING; 07 = NOAA R/V CHARLES H. GILBERT |
DISTANCE_MOVED
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Distance, in kilometers, between release and recapture location. Units for values are kilometers. |
General Data Type: | VARCHAR2 |
Unit of Measure: | kilometers |
YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year that the tagged fish was recaptured. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month that the tagged fish was recaptured. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day that the tagged fish was recaptured. |
General Data Type: | VARCHAR2 |
NUMBER_DAYS_OUT
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of days the tag was out. |
General Data Type: | VARCHAR2 |
GEAR_CODE
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the gear used to recapture the fish. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1= TROLLING; 2 = POLE-AND-LINE FISHING; 3 = LONGLINING; 4 = GILL NETTING; 5 = PURSE SEINE; 6 = OTHER TYPES (SPECIFY) |
OCTANT
Seq. Order: | 10 |
---|---|
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: | 0 = NORTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 1 = NORTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 2 = NORTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 3 = NORTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE; 5 = SOUTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 6 = SOUTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 7 = SOUTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 8 = SOUTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE |
LATITUDE_DEGREES
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
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
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
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Precision: | 40 |
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: | 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 then inserted. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LONGITUDE_MINUTES
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
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
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Precision: | 39 |
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 |
HAWAII_DAR_STATISTICAL_AREA
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Hawaii DAR Statistical Area of fish recapture. |
General Data Type: | VARCHAR2 |
GROWTH_INCREMENT
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Increase in growth, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
FORK_LENGTH
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fork length, in millimeters. Units for values are millimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
WEIGHT_RECORDED
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight, in kilograms. The data collection form indicates that data was recorded in kilograms. Units for values are kilograms. |
General Data Type: | VARCHAR2 |
Unit of Measure: | kilograms |
WEIGHT
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 2 |
Status: | Active |
Description: |
Weight, in hundredths of a kilogram, based on the length-weight plot found in Figure 2 of https://horizon.documentation.ird.fr/exl-doc/pleins_textes/divers17-01/010067418.pdf. Units for values are kilograms. Measures are reported with a precision of 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | kilograms |
SEX_MATURITY_CODE
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the sex and maturity of the species. |
General Data Type: | VARCHAR2 |
Allowed Values: | BLANK = NOT EXAMINED, IMMATURE, SEX NOT DETERMINED; 0 = MALE, MATURITY UNDETERMINED; 1 = MALE, IMMATURE; 2 = MALE, MATURING; 3 = MALE, RIPE; 4 = MALE, SPENT; 5 = FEMALE, IMMATURE; 6 = FEMALE, MATURING; 7 = FEMALE, RIPE; 8 = FEMALE, SPENT; 9 = FEMALE, MATURITY UNDTERMINED |
SPECIES_CODE
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Two digit species code for skipjack tuna. |
General Data Type: | VARCHAR2 |
Allowed Values: | 32 = SKIPJACK TUNA |
TAG_NUMBER
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tag number. |
General Data Type: | VARCHAR2 |
TAG_TYPE_CODE
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the tag type. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = MIXED TYPES; 1 = SPAGHETTI, LOOP OR CALIFORNIA "G"; 2 = F-1 OR D-2 DART; 3 = FLOY DART |
TAG_COLOR_CODE
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the tag color. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = MIXED COLORS; 1 = RED; 2 = BLUE; 3 = WHITE; 4 = YELLOW |
RELEASE_VESSEL_CODE
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the vessel that released the tagged fish. |
General Data Type: | VARCHAR2 |
Allowed Values: | 05 = NOAA R/V JOHN R. MANNING; 07 = NOAA R/V CHARLES H. GILBERT |
RELEASE_CRUISE_NUMBER
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Cruise number of the vessel that released the tagged fish. |
General Data Type: | VARCHAR2 |
RELEASE_STATION_NUMBER
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station number of the tagged fish release. |
General Data Type: | VARCHAR2 |
RELEASE_OCTANT
Seq. Order: | 32 |
---|---|
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 logitude degrees (0/1). |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = NORTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 1 = NORTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 2 = NORTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 3 = NORTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE; 5 = SOUTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 6 = SOUTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 7 = SOUTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 8 = SOUTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE |
RELEASE_LATITUDE_DEGREES
Seq. Order: | 33 |
---|---|
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 |
RELEASE_LATITUDE_MINUTES
Seq. Order: | 34 |
---|---|
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 |
RELEASE_LATITUDE_DIRECTION
Seq. Order: | 35 |
---|---|
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 |
RELEASE_LATITUDE_DD
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Precision: | 40 |
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 |
RELEASE_LONGITUDE_DEGREES
Seq. Order: | 37 |
---|---|
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 then inserted. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
RELEASE_LONGITUDE_MINUTES
Seq. Order: | 38 |
---|---|
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 |
RELEASE_LONGITUDE_DIRECTION
Seq. Order: | 39 |
---|---|
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 |
RELEASE_LONGITUDE_DD
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Precision: | 39 |
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 |
RELEASE_YEAR
Seq. Order: | 41 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year that the tagged fish was released. |
General Data Type: | VARCHAR2 |
RELEASE_MONTH
Seq. Order: | 42 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month that the tagged fish was released. |
General Data Type: | VARCHAR2 |
RELEASE_DAY
Seq. Order: | 43 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day that the tagged fish was released. |
General Data Type: | VARCHAR2 |
RELEASE_GEAR_CODE
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the gear used to catch the fish before tagging. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1= TROLLING; 2 = POLE-AND-LINE FISHING; 3 = LONGLINING; 4 = GILL NETTING; 5 = PURSE SEINE; 6 = OTHER TYPES (SPECIFY) |
SEQUENCE_NUMBER
Seq. Order: | 45 |
---|---|
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: | 46 |
---|---|
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: | 65434 |
---|---|
GUID: | gov.noaa.nmfs.inport:65434 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2021-09-11 02:37+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-09-13 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-09-13 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-09-13 |