Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBINC

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33296  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Observer Incidental Takes . from standard observer trips

Description

Observer Incidental Takes . from standard observer trips

Entity Information

Entity Type
Data View

Data Attribute / Type Description
PROGRAM
VARCHAR2 		First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
YEAR
VARCHAR2 		Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
MONTH
VARCHAR2 		Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
TRIPID
VARCHAR2 		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.
LINK3
VARCHAR2 		Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
LINK4
VARCHAR2 		Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
LINK6
VARCHAR2 		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.
LINK1
VARCHAR2 		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.
HAULNUM
VARCHAR2 		Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
PSID
VARCHAR2 		Consecutive identification number assigned each animal incidentally taken on board. Collected for ASM where applicable.
GEARNUM
VARCHAR2 		Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
NETNUM
VARCHAR2 		Net number along string in which animal was taken. If taken in scallop gear: P(port) S(starboard) U(unknown), A(aft). Not recorded prior to 5/1994; set to unknown.
TIMEBRUP
VARCHAR2 		Local time using 24 hour clock when animal was brought onboard or alongside vessel.
ACTMMDCOND
VARCHAR2 		Condition of active deterrent device following an incidental take: 0 = unknown, 1 = No pingers used on gear, 2 = audible, 3 = inaudible, tested and working, 4 = inaudible tested and not working, 5 = inaudible, not tested, 6 = absent (lost), 9 = other, described in COMMENTS. Not collected prior to 2001; all set to unknown.
NESPP4
VARCHAR2 		Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
TAGNUM1
VARCHAR2 		Complete alpha-numeric number(s) of first tag on animal. Collected for ASM where applicable.
TAGCODE1
VARCHAR2 		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.
TAGNUM2
VARCHAR2 		Complete alpha-numeric number(s) of second tag on animal. Collected for ASM where applicable.
TAGCODE2
VARCHAR2 		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.
TAGNUM3
VARCHAR2 		Complete alpha-numeric number(s) of third tag on animal.
TAGCODE3
VARCHAR2 		One digit code indicates origin of the third 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)
TAGNUM4
VARCHAR2 		Complete alpha-numeric number(s) of fourth tag on animal.
TAGCODE4
VARCHAR2 		One digit code indicates origin of the fourth tag on 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).
ENTANGLE
VARCHAR2 		Initial entanglement situation of the animal. See table OBENTANGLE. Not recorded prior to 5/1994; set to unknown; Collected for ASM where applicable.
ANMLCOND
VARCHAR2 		Condition of animal when released or sighted. See OBANMLCOND table. Collected for ASM where applicable.
ANMLONBD
VARCHAR2 		Indicator of whether animal was brought on board vessel. 0 = no, 1 = yes, 9 = unknown.
PHOTO
VARCHAR2 		Indicator of whether photograph(s) were taken of animal. 1 = yes 0 = no, 0= unknown. Collected for ASM where applicable.
SAMPLED
VARCHAR2 		Indicator of whether animal is recorded on Marine Mammal or Sea Turtle Biological Sample log. Renamed from SAMPLOG with OBDBS Version 10 changes.
ESTLEN
NUMBER 		Estimated total length of animal, in whole centimeters.
INCCOMMENTS
VARCHAR2 		Comments on incidental take record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: View: OBINC
Short Name: OBINC
Status: Completed
Abstract:

Observer Incidental Takes . from standard observer trips
Notes:

Loaded by batch 8949, 07-06-2016 08:23

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: OBDBS
Description:

Observer Incidental Takes . from standard observer trips

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 PROGRAM VARCHAR2 First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
100
 YEAR VARCHAR2 Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
100
 MONTH VARCHAR2 Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
100
 TRIPID VARCHAR2 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.
100
 LINK3 VARCHAR2 Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
100
 LINK4 VARCHAR2 Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
100
 LINK6 VARCHAR2 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.
100
 LINK1 VARCHAR2 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.
100
 HAULNUM VARCHAR2 Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
100
 PSID VARCHAR2 Consecutive identification number assigned each animal incidentally taken on board. Collected for ASM where applicable.
100
 GEARNUM VARCHAR2 Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100
 NETNUM VARCHAR2 Net number along string in which animal was taken. If taken in scallop gear: P(port) S(starboard) U(unknown), A(aft). Not recorded prior to 5/1994; set to unknown.
100
 TIMEBRUP VARCHAR2 Local time using 24 hour clock when animal was brought onboard or alongside vessel.
100
 ACTMMDCOND VARCHAR2 Condition of active deterrent device following an incidental take: 0 = unknown, 1 = No pingers used on gear, 2 = audible, 3 = inaudible, tested and working, 4 = inaudible tested and not working, 5 = inaudible, not tested, 6 = absent (lost), 9 = other, described in COMMENTS. Not collected prior to 2001; all set to unknown.
100
 NESPP4 VARCHAR2 Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
100
 TAGNUM1 VARCHAR2 Complete alpha-numeric number(s) of first tag on animal. Collected for ASM where applicable.
100
 TAGCODE1 VARCHAR2 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.
100
 TAGNUM2 VARCHAR2 Complete alpha-numeric number(s) of second tag on animal. Collected for ASM where applicable.
100
 TAGCODE2 VARCHAR2 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.
100
 TAGNUM3 VARCHAR2 Complete alpha-numeric number(s) of third tag on animal.
100
 TAGCODE3 VARCHAR2 One digit code indicates origin of the third 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)
100
 TAGNUM4 VARCHAR2 Complete alpha-numeric number(s) of fourth tag on animal.
100
 TAGCODE4 VARCHAR2 One digit code indicates origin of the fourth tag on 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).
100
 ENTANGLE VARCHAR2 Initial entanglement situation of the animal. See table OBENTANGLE. Not recorded prior to 5/1994; set to unknown; Collected for ASM where applicable.
100
 ANMLCOND VARCHAR2 Condition of animal when released or sighted. See OBANMLCOND table. Collected for ASM where applicable.
100
 ANMLONBD VARCHAR2 Indicator of whether animal was brought on board vessel. 0 = no, 1 = yes, 9 = unknown.
100
 PHOTO VARCHAR2 Indicator of whether photograph(s) were taken of animal. 1 = yes 0 = no, 0= unknown. Collected for ASM where applicable.
100
 SAMPLED VARCHAR2 Indicator of whether animal is recorded on Marine Mammal or Sea Turtle Biological Sample log. Renamed from SAMPLOG with OBDBS Version 10 changes.
100
 ESTLEN NUMBER Estimated total length of animal, in whole centimeters.
100
 INCCOMMENTS VARCHAR2 Comments on incidental take record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

Attribute Details

PROGRAM

CC ID: 329788
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
General Data Type: VARCHAR2

YEAR

CC ID: 329799
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
General Data Type: VARCHAR2

MONTH

CC ID: 329810
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
General Data Type: VARCHAR2

TRIPID

CC ID: 329812
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

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.
General Data Type: VARCHAR2

LINK3

CC ID: 329813
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 19
Required: No
Primary Key: No
Status: Active
Description:

Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
General Data Type: VARCHAR2

LINK4

CC ID: 329814
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 17
Required: No
Primary Key: No
Status: Active
Description:

Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
General Data Type: VARCHAR2

LINK6

CC ID: 329815
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

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.
General Data Type: VARCHAR2

LINK1

CC ID: 329816
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

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.
General Data Type: VARCHAR2

HAULNUM

CC ID: 329817
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
General Data Type: VARCHAR2

PSID

CC ID: 329789
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Consecutive identification number assigned each animal incidentally taken on board. Collected for ASM where applicable.
General Data Type: VARCHAR2

GEARNUM

CC ID: 329790
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
General Data Type: VARCHAR2

NETNUM

CC ID: 329791
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Net number along string in which animal was taken. If taken in scallop gear: P(port) S(starboard) U(unknown), A(aft). Not recorded prior to 5/1994; set to unknown.
General Data Type: VARCHAR2

TIMEBRUP

CC ID: 329792
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Local time using 24 hour clock when animal was brought onboard or alongside vessel.
General Data Type: VARCHAR2

ACTMMDCOND

CC ID: 329793
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Condition of active deterrent device following an incidental take: 0 = unknown, 1 = No pingers used on gear, 2 = audible, 3 = inaudible, tested and working, 4 = inaudible tested and not working, 5 = inaudible, not tested, 6 = absent (lost), 9 = other, described in COMMENTS. Not collected prior to 2001; all set to unknown.
General Data Type: VARCHAR2

NESPP4

CC ID: 329794
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
General Data Type: VARCHAR2

TAGNUM1

CC ID: 329795
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Complete alpha-numeric number(s) of first tag on animal. Collected for ASM where applicable.
General Data Type: VARCHAR2

TAGCODE1

CC ID: 329796
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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.
General Data Type: VARCHAR2

TAGNUM2

CC ID: 329797
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Complete alpha-numeric number(s) of second tag on animal. Collected for ASM where applicable.
General Data Type: VARCHAR2

TAGCODE2

CC ID: 329798
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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.
General Data Type: VARCHAR2

TAGNUM3

CC ID: 329800
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Complete alpha-numeric number(s) of third tag on animal.
General Data Type: VARCHAR2

TAGCODE3

CC ID: 329801
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

One digit code indicates origin of the third 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)
General Data Type: VARCHAR2

TAGNUM4

CC ID: 329802
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Complete alpha-numeric number(s) of fourth tag on animal.
General Data Type: VARCHAR2

TAGCODE4

CC ID: 329803
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

One digit code indicates origin of the fourth tag on 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).
General Data Type: VARCHAR2

ENTANGLE

CC ID: 329804
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Initial entanglement situation of the animal. See table OBENTANGLE. Not recorded prior to 5/1994; set to unknown; Collected for ASM where applicable.
General Data Type: VARCHAR2

ANMLCOND

CC ID: 329805
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Condition of animal when released or sighted. See OBANMLCOND table. Collected for ASM where applicable.
General Data Type: VARCHAR2

ANMLONBD

CC ID: 329806
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator of whether animal was brought on board vessel. 0 = no, 1 = yes, 9 = unknown.
General Data Type: VARCHAR2

PHOTO

CC ID: 329807
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator of whether photograph(s) were taken of animal. 1 = yes 0 = no, 0= unknown. Collected for ASM where applicable.
General Data Type: VARCHAR2

SAMPLED

CC ID: 329808
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator of whether animal is recorded on Marine Mammal or Sea Turtle Biological Sample log. Renamed from SAMPLOG with OBDBS Version 10 changes.
General Data Type: VARCHAR2

ESTLEN

CC ID: 329809
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Estimated total length of animal, in whole centimeters.
General Data Type: NUMBER

INCCOMMENTS

CC ID: 329811
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

Comments on incidental take record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33296
GUID: gov.noaa.nmfs.inport:33296
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-06 08:23+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-28
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-28