33295 OBIAL Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Individual Animal Logs from standard observer trips Loaded by batch 8949, 07-06-2016 08:23 Data View Yes OBDBS Observer Individual Animal Logs from standard observer trips 1 PROGRAM VARCHAR2 3 No No Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. VARCHAR2 2 YEAR VARCHAR2 4 No No Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. VARCHAR2 3 MONTH VARCHAR2 2 No No Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. VARCHAR2 4 TRIPID VARCHAR2 6 No No Active May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable. VARCHAR2 5 HAULNUM VARCHAR2 4 No No Active Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. VARCHAR2 6 LINK1 VARCHAR2 15 No No Active 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. VARCHAR2 7 LINK4 VARCHAR2 17 No No Active Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. VARCHAR2 8 LINK3 VARCHAR2 19 No No Active Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable. VARCHAR2 9 SEQNUM VARCHAR2 3 No No Active Sequential numbers (by haul) assigned to each animal or debris item recorded on IAL log. Collected for ASM where applicable. VARCHAR2 10 GEARNUM VARCHAR2 2 No No Active Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. VARCHAR2 11 NESPP4 VARCHAR2 4 No No Active Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable. VARCHAR2 12 STATBEG VARCHAR2 1 No No Active Status of each animal caught as it comes up. 0 = unknown 1 = alive 2 = dead 3 = dead, damaged 4 = dead, head only. VARCHAR2 13 FISHDISP VARCHAR2 3 No No Active Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable. VARCHAR2 14 CATDISP VARCHAR2 1 No No Active Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. Collected for ASM where applicable. VARCHAR2 15 PROCCODE VARCHAR2 2 No No Active Processing code. See table OBPROCESSING. VARCHAR2 16 STATEND VARCHAR2 1 No No Active Final status of each animal caught. 0 = unknown 1 = alive 2 = dead 3 = dead, damaged 4 = dead, head only. Collected for ASM where applicable. VARCHAR2 17 ANMLWGT NUMBER 22 No No 7 1 Active Dressed or round weight of animal/debris in pounds. Actual weights may be recorded to the nearest 10th of a pound. Collected for ASM where applicable. NUMBER 18 DRFLAG VARCHAR2 1 No No Active Indicator of whether the species in the record was dressed =1 or round =2, unknown= 0; SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable. VARCHAR2 19 WGTTYPE VARCHAR2 1 No No Active One digit code denoting type of weight of species. 1=actual; 2=estimated; 0=unknown. SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable. VARCHAR2 20 TAGNUM1 VARCHAR2 12 No No Active Complete alpha-numeric number(s) of first tag on animal. Collected for ASM where applicable. VARCHAR2 21 TAGCODE1 VARCHAR2 1 No No Active One digit code indicates origin of the first tag on the animal.0 = unknown 1 = tag applied by observer 2 = no tag 3 = tag already present, left on 4 = tag already present, removed 5 = carcass tagged (fish only). Collected for ASM where applicable. VARCHAR2 22 TAGNUM2 VARCHAR2 12 No No Active Complete alpha-numeric number(s) of second tag on animal. Collected for ASM where applicable. VARCHAR2 23 TAGCODE2 VARCHAR2 1 No No Active One digit code indicates origin of the second tag on the animal.0 = unknown 1 = tag applied by observer 2 = no tag 3 = tag already present, left on 4 = tag already present, removed 5 = carcass tagged (fish only). Collected for ASM where applicable. VARCHAR2 24 STDLEN1 NUMBER 22 No No 4 0 Active Length in whole centimeters according to standards for species (see sampling manual for details). Swordfish and billfish: LJFL; Tuna, shark sturgeon other: FL; ray, terrapin TL. Collected for ASM where applicable. NUMBER 25 STDLEN2 NUMBER 22 No No 4 0 Active Length in whole centimeters according to standards for species (see sampling manual for details) swordfish : ck; billfish , tuna: pfl shark : tl ray dw, terrapin nl sturgeon , other: none. Not recorded before 5/1994; set to unknown. NUMBER 26 ESTLEN NUMBER 22 No No 4 0 Active Estimated total length of animal, in whole centimeters. NUMBER 27 SEX VARCHAR2 1 No No Active One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female. VARCHAR2 28 SAMPTAKN VARCHAR2 1 No No Active Indicator of whether biological sample was collected. 1 = yes, 0 = no. Not recorded previous to 2001; set to unknown = 9; VARCHAR2 29 PHOTO VARCHAR2 1 No No Active Indicator of whether photograph(s) were taken of animal. 1 = yes 0 = no, 0= unknown. Collected for ASM where applicable. VARCHAR2 30 ESTMETH VARCHAR2 2 No No Active Method used to estimate the catch weight of each species (including debris). See OBESTMETH table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. VARCHAR2 31 DSTAG VARCHAR2 1 No No Active Indicator for data storage tag. 1 = yes, 0 = no, 9 = unknown. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 32 IALCOMMENTS VARCHAR2 250 No No Active Comments on individual animal record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable. VARCHAR2 gov.noaa.nmfs.inport:33295 Patricia Jones 2016-07-06T08:23:39 SysAdmin InPortAdmin 2022-08-09T17:11:11 2016-07-28 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2016-07-28 1 Year 2017-07-28