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

Summary

Abstract

Surface school fishing data collected during NOAA research cruises.

Description

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

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 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

CC ID: 1178508
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: 1178509
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: 1178510
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

CC ID: 1178511
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

CC ID: 1178512
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

CC ID: 1178513
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

CC ID: 1178514
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

CC ID: 1178515
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

CC ID: 1178516
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

CC ID: 1178517
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: 1178518
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: 1178519
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: 1178520
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

CC ID: 1178521
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

CC ID: 1178522
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: 1178523
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: 1178524
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: 1178525
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

CC ID: 1178526
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

CC ID: 1178527
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

CC ID: 1178528
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

CC ID: 1178529
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

CC ID: 1178530
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

CC ID: 1178531
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

CC ID: 1178532
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

CC ID: 1178533
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

CC ID: 1178534
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

CC ID: 1178535
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