33285
View: OBBSH
OBBSH
Entity
Published / External
24111
Observer and At Sea Monitor Database (OBDBS)
Data Set
Completed
Observer Beach Seine Haul
Loaded by batch 8949, 07-06-2016 08:23
Data View
Yes
OBDBS
Observer Beach Seine Haul
1
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
2
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
3
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
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
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
9
GEARNUM
VARCHAR2
2
No
No
Active
Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
VARCHAR2
10
MMWATCH
VARCHAR2
1
No
No
Active
Indicator of whether a haul watch was conducted. 0=no 1 = yes.
VARCHAR2
11
NNETSET
NUMBER
22
No
No
1
0
Active
Total number of nets used for the set. Not collected before 5/1994; set to unknown.
NUMBER
12
NNETHAUL
NUMBER
22
No
No
2
0
Active
Total number of nets that are hauled back from the set. Collected for ASM where applicable.
NUMBER
13
NNETLOST
NUMBER
22
No
No
2
0
Active
Total number of nets that are lost from the set.
NUMBER
14
NACTMMDHAUL
NUMBER
22
No
No
2
0
Active
Total number of active marine mammal devices hauled. GGH: not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
NUMBER
15
NPASMMDHAUL
NUMBER
22
No
No
2
0
Active
Total number of passive marine mammal devices hauled.
NUMBER
16
NACTMMDLOST
NUMBER
22
No
No
2
0
Active
Total number of active marine mammal devices lost. Not collected prior to 2001
NUMBER
17
NPASMMDLOST
NUMBER
22
No
No
2
0
Active
Total number of passive marine mammal devices lost.
NUMBER
18
BSHCOMMENTS
VARCHAR2
250
No
No
Active
Additional information re:haul.
VARCHAR2
gov.noaa.nmfs.inport:33285
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