67550 RP052AA1_V Entity Published / External 5898 Surface School Fishing data collected during NOAA research cruises between 1953 and 1970 in the central Pacific Data Set Completed Surface fishing data collected during NOAA research cruises. Data Table Yes Surface 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 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, of the sampling site. 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. OCTANT was used to determine the first digit (0 or 1). 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, of the sampling site. 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 LOCAL_TIME_SCHOOL_ABANDONED VARCHAR2 4 No No Active Local time school was abandoned. VARCHAR2 20 SPECIES_CODE_IN_SCHOOL VARCHAR2 2 No No Active 2-digit species code in school. VARCHAR2 00 = NO FISH; 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 21 FIRST_SPECIES_CODE_IN_CATCH VARCHAR2 2 No No Active 2-digit species code of first species in catch. This may or may not be the same as SPECIES_CODE_IN_SCHOOL. The school may have been fished witout results, or it may have been a mixed school with a mixed catch. VARCHAR2 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; 90 = COMBINATION IN SCHOOLS SKIPJACK-YELLOWFIN; 95 = COMBINATION IN SCHOOLS YELLOWFIN-MAHIMAHI; 96 = COMBINATION IN SCHOOLS OTHER FISH IN COMBINATION 22 FIRST_SPECIES_NUMBER_CAUGHT VARCHAR2 5 No No Active Number of first species caught. VARCHAR2 23 FIRST_SPECIES_AVERAGE_LENGTH VARCHAR2 3 No No Active Average length, in centimeters, of first species. Units for values are centimeters. VARCHAR2 centimeters 24 SECOND_SPECIES_CODE_IN_CATCH VARCHAR2 2 No No Active 2-digit species code of second species in catch. VARCHAR2 00 = NO FISH; 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 25 SECOND_SPECIES_NUMBER_CAUGHT VARCHAR2 5 No No Active Number of second species caught. VARCHAR2 26 SECOND_SPECIES_AVERAGE_LENGTH VARCHAR2 3 No No Active Average length, in centimeters, of second species. Units for values are centimeters. VARCHAR2 centimeters 27 TOTAL_NUMBER_PASSES VARCHAR2 1 No No Active Total number of passes. VARCHAR2 28 NUMBER_MEN_HOOKING VARCHAR2 2 No No Active Number of men hooking; the collection form field label is NUMBER_HOOKS_FISHING. VARCHAR2 29 SCHOOL_LOCATED_BY_CODE VARCHAR2 1 No No Active Code for how the school was located. VARCHAR2 0 = BIRD FLOCK; 1 = JUMPERS; 2 = SURFACE PATCH; 3 = DEBRIS; 4 = BLIND CHUMMING; 9 = OTHER 30 TYPE_OF_SCHOOL_CODE VARCHAR2 1 No No Active Code for the type of school. VARCHAR2 0 = SUB-SURFACE; 1 = JUMPING; 2 = BREEZING; 3 = FINNING 31 NUMBER_BIRDS_IN_FLOCK_CODE VARCHAR2 1 No No Active Code for the number of birds in the flock. VARCHAR2 BLANK, NULL = PRESENT BUT NUMBER NOT RECORDED; 1 = 1; 2 = 2 - 5; 3 = 6 - 10; 4 = 11 - 25; 5 = 26 - 50; 6 = 51 - 100; 7 = 101 - 500; 8 = 501 - 1000; 9 = 1001 - 2000; 0 = OVER 2000 32 FISH_TAGGED_YN VARCHAR2 1 No No Active Code for whether any fish was tagged. VARCHAR2 0 = YES; 1 = NO 33 STOMACH_CONTENTS_YN VARCHAR2 1 No No Active Code for whether the stomach contents were enumerated or preserved. VARCHAR2 0 = YES; 1 = NO 34 GONADS_YN VARCHAR2 1 No No Active Code for whether the gonads were examined or preserved. VARCHAR2 0 = YES; 1 = NO 35 ADDITIONAL_INFO_YN VARCHAR2 1 No No Active Code for whether there is additional information on other logs. VARCHAR2 0 = YES; 1 = NO 36 NUMBER_BUCKETS_BAIT_USED VARCHAR2 2 No No Active Number of buckets of bait used. VARCHAR2 37 BAIT_SPECIES_CODE VARCHAR2 2 No No Active 2-digit code for the bait species. VARCHAR2 01 = ELOPIDAE, TENPOUNDERS, AWAAWA; 03 = HARENGULA VITTATA, MARQUESAN SARDINE; 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 38 SURFACE_WATER_TEMPERATURE VARCHAR2 4 No No 1 Active Surface water temperature, in tenths of a centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centigrade. Measures are reported with a precision of 3. VARCHAR2 centigrade 39 SURFACE_SALINITY VARCHAR2 5 No No 4 Active Surface salinity, in parts per thousand. During data entry, the "3" and the decimal point were omitted; they have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 2. VARCHAR2 parts per thousand 40 NUMBER_SPECIES_MEASURED VARCHAR2 1 No No Active This is an additional field that was written on the data collection form. It had no descriptive field name, other than Column 79. And the record format sheet did not have a field name or data description. It may be the number of different species that were measured for the date and time. VARCHAR2 41 TIME_ZONE_CODE VARCHAR2 1 No No Active Code for the time zone. VARCHAR2 A = MINUS 1; B = MINUS 2; C = MINUS 3; D = MINUS 4; E = MINUS 5; F = MINUS 6; G = MINUS 7; H = MINUS 8; I = MINUS 9; K = MINUS 10; L = MINUS 11; M = MINUS 12; N = PLUS 1; O = PLUS 2; P = PLUS 3; Q = PLUS 4; R = PLUS 5; S = PLUS 6; T = PLUS 7; U = PLUS 8; V = PLUS 9; W = PLUS 10; X = PLUS 11; Y = PLUS 12; Z = 0 42 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 43 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE gov.noaa.nmfs.inport:67550 Brent Miyamoto 2022-07-15T19:14:36 SysAdmin InPortAdmin 2022-08-09T17:11:27 2022-07-16 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-16 1 Year 2023-07-16