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
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Surface school fishing data collected during NOAA research cruises.
Surface 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 |
