33287 OBBTU Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Sea Turtle Biological Samples from standard observer trips Loaded by batch 8949, 07-06-2016 08:23 Data View Yes OBDBS Observer Sea Turtle Biological Samples from standard observer trips 1 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 2 PSID VARCHAR2 3 No No Active Consecutive identification number assigned each animal incidentally taken on board. Collected for ASM where applicable. VARCHAR2 3 LINK6 VARCHAR2 18 No No Active Key field linking marine mammal and turtle biological sample tables (OBBMM, OBBTU) to the incidental take (OBINC) Collected for ASM where applicable.; link6 is made up of: link1 + PSID. VARCHAR2 4 PROGRAM VARCHAR2 3 No No Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. VARCHAR2 5 YEAR VARCHAR2 4 No No Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. VARCHAR2 6 MONTH VARCHAR2 2 No No Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. VARCHAR2 7 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 8 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 9 SCANNED VARCHAR2 1 No No Active Indicator of whether all four flippers, head and shoulder areas were scanned for presence of PIT tags. 0 = no 1 = yes. Not part of protocol before 2002 (set to 0 = no) VARCHAR2 10 PITTAG VARCHAR2 12 No No Active Complete alphnumeric number for PIT tag. VARCHAR2 11 NOTTIPLEN NUMBER 22 No No 4 1 Active Curvilinear length of the carapace from the nuchal notch to posterior marginal tip, to nearest 10th of centimeter. NUMBER 12 NOTNOTLEN NUMBER 22 No No 4 1 Active Curvilinear length of the carapace from the nuchal notch to posterior marginal notch, to nearest 10th of centimeter. Not recorded prior to 2001(set to null = unknown) NUMBER 13 WIDCAR NUMBER 22 No No 4 1 Active Curvilinear width of the carapace across widest part of shell, in centimeters. NUMBER 14 VSCUTE NUMBER 22 No No 2 0 Active Number of vertical scutes (plates that run down middle of carapace). Not collected prior to 1994(set to null = unknown) NUMBER 15 LSCUTE NUMBER 22 No No 2 0 Active Number of lateral scutes. Not collected prior to 1994 (set to null = unknown) NUMBER 16 ISCUTE NUMBER 22 No No 2 0 Active Number of inframarginal scutes. Not collected prior to 1994 (set to null = unknown) NUMBER 17 PAIRPF VARCHAR2 1 No No Active Indicator of whether the turtle has one pair of prefrontal scales.0=no, 1=yes, 9 = unknown. Not collected prior to 1994; set to 9 = unknown VARCHAR2 18 OLAP VARCHAR2 1 No No Active Indicator of whether turtle has overlapping scutes on carapace. 0 = no, 1 = yes , 9 = unknown. VARCHAR2 19 TURCOLOR VARCHAR2 2 No No Active Code for dorsal coloration of sea turtle. 00 = unknown 01 = black 02 = gray / green 03 = orange, red/brown 04 = brown 99 = other. Not recorded prior to 2001; set to 00 unknown. VARCHAR2 20 WHOLE VARCHAR2 1 No No Active Indicator of whether animal is retained by observer to be brought to shore. 0 = no, 1 = yes. Not recorded prior to 1994 (set to 0 = false) VARCHAR2 21 SKIN NUMBER 22 No No 1 0 Active Number of skin biopsies taken. Not collected prior to 2001. NUMBER 22 OTHSAMP NUMBER 22 No No 1 0 Active Number of other samples collected of types not accounted for in other categories. NUMBER 23 BTUCOMMENTS VARCHAR2 1000 No No Active Comments on turtle bio sampling. Prior to 2001 only true (1), false (0) VARCHAR2 gov.noaa.nmfs.inport:33287 Patricia Jones 2016-07-06T08:23:37 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