33570 OBPTG Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Pots and Traps Gear Characteristics Loaded by batch 9053, 07-27-2016 19:10 Data View Yes OBDBS Observer Pots and Traps Gear Characteristics 1 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 2 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 3 PROGRAM VARCHAR2 3 No No Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. VARCHAR2 4 YEAR VARCHAR2 4 No No Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. VARCHAR2 5 MONTH VARCHAR2 2 No No Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. VARCHAR2 6 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 7 GEARNUM VARCHAR2 2 No No Active Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. VARCHAR2 8 NEGEAR VARCHAR2 3 No No Active Northeast gear code. See OBGEAR table. Collected for ASM where applicable. VARCHAR2 9 NPOTS NUMBER 22 No No 4 0 Active Total number of individual pots used in gear. NUMBER 10 POTSHAPE VARCHAR2 2 No No Active Shape of pots used in gear. VARCHAR2 11 POTCONST VARCHAR2 1 No No Active Type of material used in construction of sides of pot. VARCHAR2 12 POTLEN NUMBER 22 No No 2 0 Active Length of the top of pots used in gear, in whole inches. NUMBER 13 POTWID NUMBER 22 No No 2 0 Active Width of the top of pots used in gear, in whole inches. NUMBER 14 POTBLEN NUMBER 22 No No 2 0 Active Length of the bottom of pots used in gear, in whole inches. NUMBER 15 POTBWID NUMBER 22 No No 2 0 Active Width of the bottom of pots used in gear, in whole inches. NUMBER 16 POTHGT NUMBER 22 No No 2 0 Active Height of pot, in whole inches. NUMBER 17 NPOTENT NUMBER 22 No No 1 0 Active Number of entrances in pots. NUMBER 18 ENTRSIZE NUMBER 22 No No 3 1 Active Inside ring diameter from entrance(s) used in pots, to nearest 10th of inch. NUMBER 19 ENTLOC VARCHAR2 1 No No Active Location of entrance(s) used in pots. VARCHAR2 20 ESCAPUSD VARCHAR2 1 No No Active Indicator whether escape vents are used in pots. Collected for ASM where applicable. VARCHAR2 21 NESCAPE NUMBER 22 No No 4 0 Active Number of escape vents used in pots. NUMBER 22 ESCAPSHP VARCHAR2 2 No No Active Shape of escape vents used in pots. VARCHAR2 23 ESCAPLEN NUMBER 22 No No 3 1 Active Length of escape vents used in pots, to nearest 10th inch. NUMBER 24 ESCAPHGT NUMBER 22 No No 2 1 Active Height of escape vents used in pots, to nearest 10th inch. NUMBER 25 ESCAPLOC VARCHAR2 1 No No Active Location of escape vents used in pots. VARCHAR2 26 BIOPNUSD VARCHAR2 1 No No Active Indicator whether biodegradable panel is used on pots. VARCHAR2 27 BIOPNTYP VARCHAR2 1 No No Active Material used to attach biodegradable panel to pots. VARCHAR2 28 BAITMET VARCHAR2 1 No No Active Methods used to bait pots. VARCHAR2 29 GRNDLINTYP VARCHAR2 1 No No Active Type of ground line used on this gear. (3/2007) See OBLINTYP table. VARCHAR2 30 GRNDLINDIA NUMBER 22 No No 4 3 Active Average diameter of groundline in decimal inches (3/2007) NUMBER 31 GRNDLINBTW NUMBER 22 No No 3 0 Active Average distance between pots, in whole feet. FORMERLY POT DIST NUMBER 32 NHIFLYERS NUMBER 22 No No 2 0 Active Number of High Fliers (3/2007 -- null unknowns and before) NUMBER 33 NBUOYS NUMBER 22 No No 2 0 Active Total number of surface (tide) buoys on this gear connected to the buoyline NUMBER 34 SURFLINTYP VARCHAR2 1 No No Active Line type betwen high flyers and buoys (3/2007). See OBLINTYP table. (all pre 3/2007 unknown) VARCHAR2 35 SURFLINLEN NUMBER 22 No No 4 0 Active Distance of line between Hi Flyer and Buoy (avg) in feet (3/2007) NUMBER 36 SURFLINDIA NUMBER 22 No No 4 3 Active Diameter of line between high flyers and buoys in decimal inches (3/2007) NUMBER 37 SURFWLUSD VARCHAR2 1 No No Active If any weak links are used on the surface system of this: 0 = no, 1 = yes, 9 = unknown (3/2007) VARCHAR2 38 SURFWLTYP VARCHAR2 1 No No Active Type of weak links used on the surface system. (3/2007) See OBWLTYP table. VARCHAR2 39 NSURFWL NUMBER 22 No No 2 0 Active Total number of surface system weak lnks on this gear. (3/2007) NUMBER 40 GNGUSD VARCHAR2 1 No No Active Gangions used: 0, false, 1, true 9, unknown VARCHAR2 41 GNGTYP VARCHAR2 1 No No Active Gangion type: 0: unknown, 1: sinking, neutrally buoyant, 2: floating 8: combination 9: other VARCHAR2 42 GNGLEN NUMBER 22 No No 3 0 Active Average gangion length in feet. NUMBER 43 GNGDIA NUMBER 22 No No 4 3 Active Diameter of gangions, to nearest 10th of millimeter. POTS AND TRAPS: in fractional inches NUMBER 44 NBUOYLINE NUMBER 22 No No 2 0 Active Number of buoylines on this gear (begun 3/2007) NUMBER 45 BUOYLINTYP VARCHAR2 1 No No Active Type of buoyline(s) used on this gear. (3/2007) See OBLINTYP table. VARCHAR2 46 BUOYLINLEN NUMBER 22 No No 4 0 Active Average length of the buoyline(s) in whole feet used on this gear.(3/2007) NUMBER 47 PCTSINKLINE NUMBER 22 No No 2 0 Active Average percent of sink line used on this gear.(3/2007) NUMBER 48 PCTFLTLINE NUMBER 22 No No 2 0 Active Average percent of float line used on gear (3/2007) NUMBER 49 BUOYLINDIA NUMBER 22 No No 4 3 Active Average fractional diameter of buoyline(s) in inches or fractions of inches NUMBER 50 ANCHUSD VARCHAR2 1 No No Active Indicator of whether an anchor was used. 0 = no 1 = yes 9 = unknown. VARCHAR2 51 ANCHTYP VARCHAR2 1 No No Active Anchor type danforth: 1, Dead weight 2, combo 8, other 9, unknown 0. 3/2007|added to Beach Seine 7-08 VARCHAR2 52 NANCH NUMBER 22 No No 2 0 Active Number of anchors used on gear. Not collected prior to 2001. Set to unknown NUMBER 53 ANCHWGT NUMBER 22 No No 4 0 Active Total weight of anchor(s) used to hold gear in place, in whole pounds. NUMBER 54 ANCHWGTYP VARCHAR2 1 No No Active Indicator of whether anchor weight was an actual or estimated weight. 0 = unknown, 1 = actual 2 = estimated. Not collected prior to 1994; all set to unknown VARCHAR2 55 ANCHLINTYP VARCHAR2 1 No No Active Anchor Line type: 0 unknown, 1: sinking, neutrally buoyant 2: floating, 8: Combination , 9: other VARCHAR2 56 ANCHLINLEN NUMBER 22 No No 4 0 Active Average length of line between anchor and closest gangion in whole feet. NUMBER 57 ANCHLINDIA NUMBER 22 No No 4 3 Active Average fractional diameter of the anchor line in inches. NUMBER 58 SURFGEARMARK VARCHAR2 1 No No Active Indicator if the surface system buoy(s) were marked to identify the vessel or fishery 1 = yes, 0 = no, 9 = unknown. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 59 BUOYLINMARK VARCHAR2 1 No No Active Indicator if the buoyline has on 4" colored mark mid-way on the buoyline. 1 = yes, 0 = no, 9 = unknown. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 60 PTGCOMMENTS VARCHAR2 250 No No Active Pots and Traps Gear Comments. Prior to 2001 only true (1), false (0) VARCHAR2 61 DOE DATE 7 No No Active Date of Entry of the associated record. DATE 62 UOE VARCHAR2 8 No No Active Oracle user ID of the person who entered the data. VARCHAR2 gov.noaa.nmfs.inport:33570 Patricia Jones 2016-07-27T19:10:31 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