70843 RV001AA3_CONF_V Entity Published / External 53640 Occurrence of Birds, Aquatic Mammals, & Fish Schools Log data collected by commercial fishery vessels between 1954 and 1980 Data Set Completed Occurrence of birds, aquatic mammals and fish schools log. Data Table Yes Occurrence of birds, aquatic mammals and fish schools log. 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 4 CRUISE_NUMBER VARCHAR2 4 No No Active Four digit incremental cruise number of the vessel, e.g., 0001, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 7604. VARCHAR2 5 YEAR VARCHAR2 4 No No Active Local year of sighting. VARCHAR2 6 MONTH VARCHAR2 2 No No Active Local month of sighting. VARCHAR2 7 DAY VARCHAR2 2 No No Active Local day of sighting. VARCHAR2 8 TIME_ZONE_CODE VARCHAR2 1 No No Active Time zone code of sighting. 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 9 LOCAL_TIME VARCHAR2 4 No No Active Local time of sighting; the hour and minute fields were merged into one field. VARCHAR2 10 OCTANT_FLOCK_SCHOOL VARCHAR2 1 No No Active Octant of the bird flock or fish school sighting. 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 11 LATITUDE_DEGREES_FLOCK_SCHOOL VARCHAR2 2 No No Active Latitude degrees when the bird flock or fish school was sighted. Units for values are degrees. VARCHAR2 degrees 12 LATITUDE_MINUTES_FLOCK_SCHOOL VARCHAR2 2 No No Active Latitude minutes when the bird flock or fish school was sighted. Units for values are minutes. VARCHAR2 minutes 13 LATITUDE_DIRECTION_FLOCK_SCHOOL VARCHAR2 1 No No Active Latitude direction when the bird flock or fish school was sighted. OCTANT used to determine LATITUDE_DIRECTION_FLOCK_SCHOOL (N/S). VARCHAR2 N = NORTH; S = SOUTH 14 LATITUDE_DD_FLOCK_SCHOOL NUMBER 42 No No 38 Active Computed latitude, in decimal degrees, when the bird flock or fish school was sighted. 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 15 LONGITUDE_DEGREES_FLOCK_SCHOOL VARCHAR2 3 No No Active Longitude degrees when the bird flock or fish school was sighted. 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 16 LONGITUDE_MINUTES_FLOCK_SCHOOL VARCHAR2 2 No No Active Longitude minutes when the bird flock or fish school was sighted. Units for values are minutes. VARCHAR2 minutes 17 LONGITUDE_DIRECTION_FLOCK_SCHOOL VARCHAR2 1 No No Active Longitude direction when the bird flock or fish school was sighted. OCTANT used to determine LONGITUDE_DIRECTION_FLOCK_SCHOOL (E/W). VARCHAR2 E = EAST; W = WEST 18 LONGITUDE_DD_FLOCK_SCHOOL NUMBER 41 No No 36 Active Computed longitude, in decimal degrees, when the bird flock or fish school was sighted. 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 19 SIZE_FLOCK_CODE VARCHAR2 1 No No Active Code for the size of the bird flock. VARCHAR2 FOR YEARS 1954 - 1963: 1 = 1; 2 = 2 - 5; 3 = 6 - 10; 4 = 11 - 25; 5 = 26 - 50; 6 = 51 - 100; 7 = 101 - 500; 8 = 501 - 1000; 9 = PRESENT BUT NUMBERS NOT KNOWN; FOR YEARS 1964 - 1980: 1 = 1 - 5; 2 = 6 - 10; 3 = 11 - 25; 4 = 26 - 50; 5 = 51 - 100; 6 = 101 - 500; 7 = 501 - 1000; 8 = OVER 1000; 9 = PRESENT BUT NUMBERS NOT KNOWN 20 SOOTY_TERN_PRESENT_CODE VARCHAR2 1 No No Active Code whether SOOTY TERN was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 21 NODDY_TERN_PRESENT_CODE VARCHAR2 1 No No Active Code whether NOODY TERN was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 22 WHITE_TERN_PRESENT_CODE VARCHAR2 1 No No Active Code whether WHITE TERN was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 23 BOOBY_PRESENT_CODE VARCHAR2 1 No No Active Code whether BOOBY was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 24 TROPIC_BIRD_PRESENT_CODE VARCHAR2 1 No No Active Code whether TROPIC BIRD was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 25 FRIGATE_BIRD_PRESENT_CODE VARCHAR2 1 No No Active Code whether FRIGATE BIRD was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 26 PETREL_SHEARWATER_PRESENT_CODE VARCHAR2 1 No No Active Code whether PETREL or SHEARWATER was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 27 STORM_PETREL_PRESENT_CODE VARCHAR2 1 No No Active Code whether STORM PETREL was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 28 ALBATROSS_PRESENT_CODE VARCHAR2 1 No No Active Code whether ALBATROSS was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 29 OTHER_BIRDS_PRESENT_CODE VARCHAR2 1 No No Active Code whether OTHER BIRDS were present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 30 SPECIES_CODE_FLOCK_SCHOOL_2 VARCHAR2 2 No No Active Two-digit species code of the bird flock or fish school. VARCHAR2 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 90 = COMBINATION IN SCHOOLS SKIPJACK-YELLOWFIN; 99 = UNIDENTIFIED 31 SPECIES_CODE_FLOCK_SCHOOL_5 VARCHAR2 5 No No Active Five-digit CZM species code of the bird flock or fish school. VARCHAR2 20332 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 99999 = UNIDENTIFIED 32 SPECIES_CODE_FLOCK_SCHOOL VARCHAR2 10 No No Active Ten-digit CZM species code of the bird flock or fish school. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. VARCHAR2 8555740401 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 8555740703 = THUNNUS ALBACARES, YELLOWFINFIN TUNA, AHI; 9999999998 = COMBINATION IN SCHOOLS - KATSUWONUS PELAMIS & THUNNUS ALBACARES; 9999999999 = UNIDENTIFIED 33 AVERAGE_SIZE_FISH_KG VARCHAR2 3 No No Active Average fish weight, in kilograms. Units for values are kilograms. VARCHAR2 kilograms 34 AVERAGE_SIZE_FISH_LB VARCHAR2 3 No No Active Average fish weight, in pounds. Units for values are pounds. VARCHAR2 pounds 35 SIZE_SCHOOL_CODE VARCHAR2 1 No No Active Code for the size of the fish school. VARCHAR2 S = SMALL; M = MEDIUM; L = LARGE 36 TIME_POSITION_TAKEN VARCHAR2 4 No No Active Time position taken; the hour field and minute field were merged into one field. VARCHAR2 37 OCTANT_SCATTER VARCHAR2 1 No No Active Octant of the sighting of scattered species. 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 38 LATITUDE_DEGREES_SCATTER VARCHAR2 2 No No Active Latitude degrees when the scattered species was sighted. Units for values are degrees. VARCHAR2 degrees 39 LATITUDE_MINUTES_SCATTER VARCHAR2 2 No No Active Latitude minutes when the scattered species was sighted. Units for values are minutes. VARCHAR2 minutes 40 LATITUDE_DIRECTION_SCATTER VARCHAR2 1 No No Active Latitude direction when the scattered species was sighted. OCTANT used to determine LATITUDE_DIRECTION_SCATTER (N/S). VARCHAR2 N = NORTH; S = SOUTH 41 LATITUDE_DD_SCATTER NUMBER 42 No No 38 Active Computed latitude, in decimal degree, when the scattered species was sighted. 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 42 LONGITUDE_DEGREES_SCATTER VARCHAR2 3 No No Active Longitude degrees when the scattered species was sighted. 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 43 LONGITUDE_MINUTES_SCATTER VARCHAR2 2 No No Active Longitude minutes when the scattered species was sighted. Units for values are minutes. VARCHAR2 minutes 44 LONGITUDE_DIRECTION_SCATTER VARCHAR2 1 No No Active Longitude direction when the scattered species was sighted. OCTANT used to determine LONGITUDE_DIRECTION_SCATTER (E/W). VARCHAR2 E = EAST; W = WEST 45 LONGITUDE_DD_SCATTER NUMBER 41 No No 36 Active Computed longitude, in decimal degrees, when the scattered species was sighted. 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 46 SOOTY_TERN_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered SOOTY TERN sighted. See SIZE_FLOCK_CODE. VARCHAR2 47 NODDY_TERN_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered NODDY TERN sighted. See SIZE_FLOCK_CODE. VARCHAR2 48 WHITE_TERN_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered WHITE TERN sighted. See SIZE_FLOCK_CODE. VARCHAR2 49 BOOBY_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered BOOBY sighted. See SIZE_FLOCK_CODE. VARCHAR2 50 TROPIC_BIRD_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered TROPIC BIRD TERN sighted. See SIZE_FLOCK_CODE. VARCHAR2 51 FRIGATE_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered FRIGATE BIRD sighted. See SIZE_FLOCK_CODE. VARCHAR2 52 PETREL_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered PETREL or SHEARWATER sighted. See SIZE_FLOCK_CODE. VARCHAR2 53 STORM_PETREL_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered STORM PETREL sighted. See SIZE_FLOCK_CODE. VARCHAR2 54 ALBATROSS_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered ALBATROSS sighted. See SIZE_FLOCK_CODE. VARCHAR2 55 OTHER_BIRDS_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered OTHER BIRDS sighted. See SIZE_FLOCK_CODE. VARCHAR2 56 WHALES_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered WHALES sighted. See SIZE_FLOCK_CODE. VARCHAR2 57 PORPOISES_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered PORPOISES sighted. See SIZE_FLOCK_CODE. VARCHAR2 58 SEALS_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered SEALS sighted. See SIZE_FLOCK_CODE. VARCHAR2 59 SPECIES_CODE_OTHERS_SCATTER_2 VARCHAR2 2 No No Active Two-digit species code of scattered other species sighted. VARCHAR2 60 SPECIES_CODE_OTHERS_SCATTER_5 VARCHAR2 5 No No Active Five-digit CZM species code of scattered other species sighted. VARCHAR2 61 SPECIES_CODE_OTHERS_SCATTER VARCHAR2 10 No No Active Ten-digit CZM species code of scattered other species sighted. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. VARCHAR2 62 OTHERS_SCATTER_COUNT VARCHAR2 5 No No Active Count of scattered other species sighted. VARCHAR2 63 OTHERS_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for scattered other species sighted. See SIZE_FLOCK_CODE. VARCHAR2 64 NUMBER_HOURS_WATCHED_0800 VARCHAR2 1 No No Active Number of hours watched ending at 0800 or the time the position was taken (FIELD 36). VARCHAR2 65 NUMBER_HOURS_WATCHED_1200 VARCHAR2 1 No No Active Number of hours watched ending at 1200 or the time the position was taken (FIELD 36). VARCHAR2 66 NUMBER_HOURS_WATCHED_1600 VARCHAR2 1 No No Active Number of hours watched ending at 1600 or the time the position was taken (FIELD 36). VARCHAR2 67 NUMBER_HOURS_WATCHED_2000 VARCHAR2 1 No No Active Number of hours watched ending a 2000 or the time the position was taken (FIELD 36). VARCHAR2 68 JOB_NUMBER VARCHAR2 6 No No Active A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84109. VARCHAR2 69 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 70 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE gov.noaa.nmfs.inport:70843 Brent Miyamoto 2023-09-15T00:48:03 Brent Miyamoto 2023-10-07T02:44:29 2023-10-07 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 2023-10-07 1 Year 2024-10-07