33563 OBHAU Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Generic Haul Data from standard observer trips Loaded by batch 9053, 07-27-2016 19:10 Data View Yes OBDBS Observer Generic Haul Data 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 QTR NUMBER 22 No No 38 Active Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable. NUMBER 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 NEGEAR VARCHAR2 3 No No Active Northeast gear code. See OBGEAR table. Collected for ASM where applicable. VARCHAR2 10 OBSRFLAG VARCHAR2 1 No No Active Indicator of whether haul was observed for discards (all hauls are observed for catch except for offwatch (sdo, sto, cdo) hauls). 0=no; 1=yes. Collected for ASM where applicable. VARCHAR2 11 CATEXIST VARCHAR2 1 No No Active Indicator of whether gear from haul holds any catch, kept or discarded. 0=no; 1=yes. VARCHAR2 12 INCTAKE VARCHAR2 1 No No Active Indicator of whether Sea Turtle, Marine Mammal, or Sea Bird is caught by gear in haul. 0 = no 1 = yes. Collected for ASM where applicable. VARCHAR2 13 WEATHER VARCHAR2 2 No No Active HAUL: Code for weather at beginning of haul. EVENT: Code for weather at time event occurred. See support table OBWEATHER for codes. Collected for ASM where applicable. VARCHAR2 14 WINDSP NUMBER 22 No No 2 0 Active Wind speed at beginning of haul, in whole knots. NUMBER 15 WINDDIR VARCHAR2 3 No No Active Wind direction (compass direction) from which the wind is blowing at beginning of haul. VARCHAR2 16 WAVEHGT NUMBER 22 No No 2 0 Active HAUL: Wave height at beginning of haul, in whole feet. EVENT: Wave height at beginning of event, in whole feet. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable. NUMBER 17 DEPTH NUMBER 22 No No 4 0 Active Water depth at beginning of haul, in whole fathoms. NUMBER 18 GEARCOND VARCHAR2 3 No No Active Condition of gear at Haul. See OBGEARCOND table. Collected for ASM where applicable. VARCHAR2 19 TARGSPEC1 VARCHAR2 4 No No Active NESPP4 for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable. VARCHAR2 20 TARGSPEC2 VARCHAR2 4 No No Active NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable. VARCHAR2 21 TARGSPEC3 VARCHAR2 4 No No Active NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. VARCHAR2 22 TARGSPEC4 VARCHAR2 4 No No Active NESPP4 code for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. VARCHAR2 23 TARGSPEC5 VARCHAR2 4 No No Active NESPP4 for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. VARCHAR2 24 YEARSBEG VARCHAR2 4 No No Active Year set began, four digits.Not collected before 5/1994; set to unknown. VARCHAR2 25 MONTHSBEG VARCHAR2 2 No No Active Two digit month set began. Not collected 1989 - 4/1994; VARCHAR2 26 DAYSBEG VARCHAR2 2 No No Active Day set began, two digits. VARCHAR2 27 TIMESBEG VARCHAR2 4 No No Active Time set began, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown VARCHAR2 28 DATESBEG DATE 7 No No Active Date the set began. Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field DATE 29 YEARSEND VARCHAR2 4 No No Active Year set ended, four digits. Not collected before 5/1994; set to unknown. VARCHAR2 30 MONTHSEND VARCHAR2 2 No No Active Two digit month the set ended. VARCHAR2 31 DAYSEND VARCHAR2 2 No No Active Day set ended, two digits.Not recorded prior to 5/1994; set to unknown VARCHAR2 32 TIMESEND VARCHAR2 4 No No Active Time set ended, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown VARCHAR2 33 DATESEND DATE 7 No No Active Date the set of the gear ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field DATE 34 YEARHBEG VARCHAR2 4 No No Active Year haul began, four digits. Collected for ASM where applicable. VARCHAR2 35 MONTHHBEG VARCHAR2 2 No No Active Month haul began, two digits. Collected for ASM where applicable. VARCHAR2 36 DAYHBEG VARCHAR2 2 No No Active Day haul began, two digits. Collected for ASM where applicable. VARCHAR2 37 TIMEHBEG VARCHAR2 4 No No Active Time haul began, local time using 24 hour clock (0000-2359). Collected for ASM where applicable. VARCHAR2 38 DATEHBEG DATE 7 No No Active Date haul began. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. DATE 39 YEARHEND VARCHAR2 4 No No Active Year haul ended, four digits.Not collected before 5/1994; set to unknown. VARCHAR2 40 MONTHEND VARCHAR2 2 No No Active Month haul ended, two digits. Collected for ASM where applicable. VARCHAR2 41 DAYHEND VARCHAR2 2 No No Active Day haul ended, two digits.Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. VARCHAR2 42 TIMEHEND VARCHAR2 4 No No Active Time haul ended, local time using 24 hour clock (0000-2359). Collected for ASM where applicable. VARCHAR2 43 DATEHEND DATE 7 No No Active Date the haul ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. DATE 44 YEARFBEG VARCHAR2 4 No No Active Year that the gear was fully deployed and actively fishing (3/2007) VARCHAR2 45 MONTHFBEG VARCHAR2 2 No No Active Month that the gear was fully deployed and actively fishing (3/2007) VARCHAR2 46 DAYFBEG VARCHAR2 2 No No Active Day that the gear was fully deployed and actively fishing (3/2007) VARCHAR2 47 TIMEFBEG VARCHAR2 4 No No Active Time (24 hour clock) that the gear was fully deployed and actively fishing (3/2007) VARCHAR2 48 DATEFBEG DATE 7 No No Active Date that the gear is fully deployed and actively fishing(3/2007) NOTE: if time fishing begins (TIMEFBEG) is unknown it defaults to midnight. DATE 49 YEARGONBD VARCHAR2 4 No No Active YEAR when all gear was out of the water. (3/2007) VARCHAR2 50 MONTHGONBD VARCHAR2 2 No No Active Month (local time) that the gear from the haul is completely out of the water (3/2007) VARCHAR2 51 DAYGONBD VARCHAR2 2 No No Active Day (local time) that the gear form the haul is completely out of the water (3/2007) VARCHAR2 52 TIMEGONBD VARCHAR2 4 No No Active 4-digit local time (24-hour clock) when all gear was out of the water. (3/2007) VARCHAR2 53 DATEGONBD DATE 7 No No Active Local date and time that the gear form the haul is completely out of the water (3/2007) DATE 54 LATSBEG VARCHAR2 6 No No Active Latitude where set began (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans VARCHAR2 55 LATSEND VARCHAR2 6 No No Active Latitude (DDMMSS) where set ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans VARCHAR2 56 LATHBEG VARCHAR2 6 No No Active Latitude location, (DDMMSS) where haul began. Pre 2001 : SS rounded to 30 where no loran. Collected for ASM where applicable. VARCHAR2 57 LATHEND VARCHAR2 6 No No Active Latitude (DDMMSS) where haul ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans. Collected for ASM where applicable. VARCHAR2 58 LONSBEG VARCHAR2 6 No No Active Longitude location of where set began, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans VARCHAR2 59 LONSEND VARCHAR2 6 No No Active Longitude where set ended, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans VARCHAR2 60 LONHBEG VARCHAR2 6 No No Active Longitude location of where haul began, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable. VARCHAR2 61 LONHEND VARCHAR2 6 No No Active Longitude location of where haul ended, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable. VARCHAR2 62 GIS_LATSBEG NUMBER 22 No No 8 6 Active GIS format (decimal degrees) for set begin latitude NUMBER 63 GIS_LATSEND NUMBER 22 No No 8 6 Active GIS format (decimal degrees) for set end latitude NUMBER 64 GIS_LATHBEG NUMBER 22 No No 8 6 Active GIS format (decimal degrees) for haul begin latitude. Collected for ASM where applicable. NUMBER 65 GIS_LATHEND NUMBER 22 No No 8 6 Active GIS format (decimal degrees) for haul end latitude. Collected for ASM where applicable. NUMBER 66 GIS_LONSBEG NUMBER 22 No No 38 Active GIS format (decimal degrees) for set begin longitude NUMBER 67 GIS_LONSEND NUMBER 22 No No 38 Active GIS format (decimal degrees) for set end longitude NUMBER 68 GIS_LONHBEG NUMBER 22 No No 38 Active GIS format (decimal degrees) for haul begin longitude. Collected for ASM where applicable. NUMBER 69 GIS_LONHEND NUMBER 22 No No 38 Active GIS format (decimal degrees) for haul end longitude. Collected for ASM where applicable. NUMBER 70 WTMP NUMBER 22 No No 3 1 Active The surface sea water Fahrenheit temperature, to the nearest tenth, when haul ended. Not entered before 5/1994 NUMBER 71 SOAKDUR NUMBER 22 No No 5 1 Active Fixed gear only. Amount of time that the gear for haul is in the water, to the nearest tenth of an hour (haul begin - set end). BEACH SEINE: estimated; Time from when the gear is secured to the beach until hauling of the warpline begins. Collected for ASM where applicable. NUMBER 72 SETDUR NUMBER 22 No No 3 1 Active (fixed gears only) Time it takes to set out the gear; Time set end - time set begin; NUMBER 73 HAULDUR NUMBER 22 No No 5 1 Active GILLNET, LONGLINE, POTS: Length of time (hours) from beginning to haul the gear out until all the gear is out. (Haul end - Haul begin). BEACH SEINE: Length of time (hours)from the beginning of haul of warpline until last portion of net exits the surf zone. OTTER TRAWL, SCALLOP DREDGE: Length of time (hours) from when the net hits the water until hauling equipment put in gear . PAIR TRAWL: Length of time (hours) from when the net hits the water until legs retrieved and aboard both vessels. Calculated for ASM where applicable. NUMBER 74 QDSQ VARCHAR2 5 No No Active Quarter Degree Square, lookup in LOC2AREAS table. VARCHAR2 75 TENMSQ VARCHAR2 2 No No Active Position in grid computed from lat/lon; relative minute position in a degree square 1-6 west to east for longitude and 1-6 north to south for latitude. VARCHAR2 76 NEMAREA VARCHAR2 3 No No Active Inshore area codes. See Loc2areas table. Not collected before 5/1994; set to statistical area. VARCHAR2 77 AREA VARCHAR2 3 No No Active Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable. VARCHAR2 78 ONEFFORT VARCHAR2 1 No No Active Indicator whether the observer is intentionally present to witness the haulback 1 = yes, 0 = no, 9 = unknown Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 79 HAUCOMMENTS VARCHAR2 250 No No Active Prior to 2001 only true (1), false (0). Collected for ASM where applicable. VARCHAR2 gov.noaa.nmfs.inport:33563 Patricia Jones 2016-07-27T19:10:30 SysAdmin InPortAdmin 2022-08-09T17:11:12 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