RP053AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:67555 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Surface school fishing data collected during NOAA research cruises.
DescriptionSurface school fishing data collected during NOAA research cruises.
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 number of the cruise, e.g., 0022. |
YEAR
VARCHAR2 |
Local year. |
MONTH
VARCHAR2 |
Local month. |
DAY
VARCHAR2 |
Local day. |
LOCAL_TIME
VARCHAR2 |
Local time school sighted. |
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. It has been inserted into the data using OCTANT. 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. |
PASS_NUMBER
VARCHAR2 |
Pass number of the school. |
LOCAL_TIME_PASS_BEGAN
VARCHAR2 |
Local time pass began. |
LOCAL_TIME_PASS_ENDED
VARCHAR2 |
Local time pass ended. |
CHUM_SPECIES_CODE
VARCHAR2 |
2-digit species code of the chum. |
NUMBER_BUCKETS_CHUM
VARCHAR2 |
Number of buckets of chum used. |
CATCH_SPECIES_CODE
VARCHAR2 |
2-digit species code of the catch. |
NUMBER_CAUGHT_DURING_PASS
VARCHAR2 |
Number of fish caught during the pass. |
QUIT_FISHING_CODE
VARCHAR2 |
Code for the reason to quit fishing on the last pass of the fishing station. |
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: | RP053AA1_V |
---|---|
Short Name: | RP053AA1_V |
Status: | Completed |
Abstract: |
Surface school fishing data collected during NOAA research cruises. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Surface school fishing data collected during NOAA research cruises. |
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 number of the cruise, e.g., 0022. | |
100
|
YEAR | VARCHAR2 | Local year. | |
100
|
MONTH | VARCHAR2 | Local month. | |
100
|
DAY | VARCHAR2 | Local day. | |
100
|
LOCAL_TIME | VARCHAR2 | Local time school sighted. | |
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. It has been inserted into the data using OCTANT. 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
|
PASS_NUMBER | VARCHAR2 | Pass number of the school. | |
100
|
LOCAL_TIME_PASS_BEGAN | VARCHAR2 | Local time pass began. | |
100
|
LOCAL_TIME_PASS_ENDED | VARCHAR2 | Local time pass ended. | |
100
|
CHUM_SPECIES_CODE | VARCHAR2 | 2-digit species code of the chum. | |
100
|
NUMBER_BUCKETS_CHUM | VARCHAR2 | Number of buckets of chum used. | |
100
|
CATCH_SPECIES_CODE | VARCHAR2 | 2-digit species code of the catch. | |
100
|
NUMBER_CAUGHT_DURING_PASS | VARCHAR2 | Number of fish caught during the pass. | |
100
|
QUIT_FISHING_CODE | VARCHAR2 | Code for the reason to quit fishing on the last pass of the fishing station. | |
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: | 004 = HUGH M SMITH; 005 = JOHN R MANNING; 007 = CHARLES H GILBERT |
CRUISE_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Four digit incremental number of the cruise, e.g., 0022. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local year. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local month. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local 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 school sighted. |
General Data Type: | VARCHAR2 |
OCTANT
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
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 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 1 = NORTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 2 = NORTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 3 = NORTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE; 5 = SOUTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 6 = SOUTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 7 = SOUTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 8 = SOUTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN 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: | 42 |
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. It has been inserted into the data using OCTANT. 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 |
PASS_NUMBER
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Pass number of the school. |
General Data Type: | VARCHAR2 |
LOCAL_TIME_PASS_BEGAN
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local time pass began. |
General Data Type: | VARCHAR2 |
LOCAL_TIME_PASS_ENDED
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local time pass ended. |
General Data Type: | VARCHAR2 |
CHUM_SPECIES_CODE
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2-digit species code of the chum. |
General Data Type: | VARCHAR2 |
Allowed Values: | 00 = COMBINATIONS OF BAITFISH AS CHUM; 01 = ELOPIDAE, TENPOUNDERS, AWAAWA; 03 = HARENGULA VITTATA, MARQUESAN SARDINE; 05 = ETRUMEUS MICROPUS, ROUND HERRING, MAKIAWA; 06 = SPRATTELOIDES DELICATULUS, ROUND HERRING, PIHA; 07 = STOLEPHORUS PURPUREUS, ANCHOVY, NEHU; 22 = POECILIIDAE, TOP MINNOWS, MOSQUITO FISH, SWORDTAILS, MOLLIES; 28 = ATHERINIDAE, SILVERSIDES, IAO; 30 = MUGILIDAE, MULLETS, AMAAMA, UOUOA; 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 3A = THREADFIN SHAD (FRESHWATER); 55 = CARANGIDAE, JACKS, SCAD, AMBERJACKS; 56 = KUHLIIDAE, MOUNTAIN BASSES, AHOLEHOLE; 59 = MULLIDAE, GOATFISHES, SURMULLETS, WEKE, MOANA, KUMU, OAMA, UPENEUS ARGE; 60 = CICHLIDAE, TILAPIAS; 97 = BAITFISH COMBINATION; 98 = OTHER THINGS; 99 = UNIDENTIFIED |
NUMBER_BUCKETS_CHUM
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of buckets of chum used. |
General Data Type: | VARCHAR2 |
CATCH_SPECIES_CODE
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2-digit species code of the catch. |
General Data Type: | VARCHAR2 |
Allowed Values: | 00 = NO FISH; 07 = STOLEPHORUS PURPUREUS, ANCHOVY, NEHU; 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 33 = EUTHYNNUS SPP., LITTLE TUNNY, KAWAKAWA; 34 = THUNNUS OBESUS, BIGEYE TUNA, AHI; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 41 = AUXIS SPP., FRIGATE MACKEREL; 53 = CORYPHAENIDAE, DOLPHINFISH; MAHIMAHI; 73 = MODIDAE, HEADFISHES OR SUNFISHES, MOLAMOLA; 90 = COMBINATION IN SCHOOLS SKIPJACK-YELLOWFIN; 91 = COMBINATION IN SCHOOLS SKIPJACK-LITTLE TUNNY; 93 = COMBINATION IN SCHOOLS SKIPJACK-BIGEYE; 94 = COMBINATION IN SCHOOLS SKIPJACK-MAHIMAHI; 95 = COMBINATION IN SCHOOLS YELLOWFIN-MAHIMAHI; 96 = COMBINATION IN SCHOOLS OTHER FISH IN COMBINATION; 98 = OTHER THINGS; 99 = UNIDENTIFIED |
NUMBER_CAUGHT_DURING_PASS
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of fish caught during the pass. |
General Data Type: | VARCHAR2 |
QUIT_FISHING_CODE
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the reason to quit fishing on the last pass of the fishing station. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = SUFFICIENT COLLECTION; 2 = SCHOOL SOUNDED; 3 = NO MORE BAIT; 4 = GETTING DARK; 5 = QUIT BITING, OR BITING TOO SLOWLY; 6 = NO RESPONSE, SO ABANDONDED; 7 = WRONG SPECIES; 8 = FISH WILD (ABANDONED) |
SEQUENCE_NUMBER
Seq. Order: | 27 |
---|---|
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: | 28 |
---|---|
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: | 67555 |
---|---|
GUID: | gov.noaa.nmfs.inport:67555 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2022-07-19 21:30+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2022-07-20 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2022-07-20 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2023-07-20 |