67555 RP053AA1_V Entity Published / External 5899 Surface School Fishing data collected during NOAA research cruises between 1953 and 1970 in the central Pacific Data Set Completed Surface school fishing data collected during NOAA research cruises. Data Table Yes Surface school fishing data collected during NOAA research cruises. 1 DATASET_CODE VARCHAR2 5 No No Active Source ID Code assigned by the data entry staff. VARCHAR2 2 VERSION_CODE VARCHAR2 3 No No Active Code for the format version assigned by the data entry staff. VARCHAR2 3 VESSEL_CODE VARCHAR2 3 No No Active Code for the vessel. VARCHAR2 004 = HUGH M SMITH; 005 = JOHN R MANNING; 007 = CHARLES H GILBERT 4 CRUISE_NUMBER VARCHAR2 4 No No Active Four digit incremental number of the cruise, e.g., 0022. VARCHAR2 5 YEAR VARCHAR2 4 No No Active Local year. VARCHAR2 6 MONTH VARCHAR2 2 No No Active Local month. VARCHAR2 7 DAY VARCHAR2 2 No No Active Local day. VARCHAR2 8 LOCAL_TIME VARCHAR2 4 No No Active Local time school sighted. VARCHAR2 9 OCTANT VARCHAR2 1 No No Active 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). VARCHAR2 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 10 LATITUDE_DEGREES VARCHAR2 2 No No Active Latitude degrees. Units for values are degrees. VARCHAR2 degrees 11 LATITUDE_MINUTES VARCHAR2 2 No No Active Latitude minutes. Units for values are minutes. VARCHAR2 minutes 12 LATITUDE_DIRECTION VARCHAR2 1 No No Active Latitude direction. OCTANT was used to determine LATITUDE_DIRECTION (N/S). VARCHAR2 N = NORTH; S = SOUTH 13 LATITUDE_DD NUMBER 42 No No 38 Active 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. NUMBER degrees 14 LONGITUDE_DEGREES VARCHAR2 3 No No Active 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. VARCHAR2 degrees 15 LONGITUDE_MINUTES VARCHAR2 2 No No Active Longitude minutes. Units for values are minutes. VARCHAR2 minutes 16 LONGITUDE_DIRECTION VARCHAR2 1 No No Active Longitude direction. OCTANT was used to determine LONGITUDE_DIRECTION (E/W). VARCHAR2 E = EAST; W = WEST 17 LONGITUDE_DD NUMBER 41 No No 36 Active 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. NUMBER degrees 18 STATION_NUMBER VARCHAR2 3 No No Active Station number. VARCHAR2 19 PASS_NUMBER VARCHAR2 2 No No Active Pass number of the school. VARCHAR2 20 LOCAL_TIME_PASS_BEGAN VARCHAR2 4 No No Active Local time pass began. VARCHAR2 21 LOCAL_TIME_PASS_ENDED VARCHAR2 4 No No Active Local time pass ended. VARCHAR2 22 CHUM_SPECIES_CODE VARCHAR2 2 No No Active 2-digit species code of the chum. VARCHAR2 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 23 NUMBER_BUCKETS_CHUM VARCHAR2 2 No No Active Number of buckets of chum used. VARCHAR2 24 CATCH_SPECIES_CODE VARCHAR2 2 No No Active 2-digit species code of the catch. VARCHAR2 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 25 NUMBER_CAUGHT_DURING_PASS VARCHAR2 4 No No Active Number of fish caught during the pass. VARCHAR2 26 QUIT_FISHING_CODE VARCHAR2 1 No No Active Code for the reason to quit fishing on the last pass of the fishing station. VARCHAR2 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) 27 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 28 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE gov.noaa.nmfs.inport:67555 Brent Miyamoto 2022-07-19T21:30:56 SysAdmin InPortAdmin 2022-08-09T17:11:22 2022-07-20 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No 2022-07-20 1 Year 2023-07-20