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: OBTRG

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

Summary

Abstract

Observer Trip-Gear Data from standard observer trips

Description

Observer Trip-Gear Data 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.
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.
NEGEAR
VARCHAR2 		Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
PRIMGEAR
VARCHAR2 		Indicator that negear is principal gear used on trip. 0=no 1 = yes. Collected for ASM where applicable.
GEARUSD
VARCHAR2 		Indicator of whether the gear was used during the trip. 0 = No, 1 = yes.
NONBOARD
NUMBER 		Number of gear of this negear code onboard the vessel. Not collected prior to 5/1994; set to unknown.
NSOAKING
NUMBER 		Number of gear indicated by negear Captain has soaking in water at beginning of trip. Not collected prior to 5/1994; set to unknown for set gear, 0 for mobile gear.
CAPTYRS
NUMBER 		In whole year, the number of years Captain in fishery with type of gear recorded in negear
TARGSPEC1
VARCHAR2 		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.
TARGSPEC2
VARCHAR2 		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.
TARGSPEC3
VARCHAR2 		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.
TARGSPEC4
VARCHAR2 		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.
TARGSPEC5
VARCHAR2 		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.
TRGCOMMENTS
VARCHAR2 		Additional information regarding the trip/gear. Prior to 2001 only true or false. 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: OBTRG
Short Name: OBTRG
Status: Completed
Abstract:

Observer Trip-Gear Data 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 Trip-Gear Data 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
 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
 NEGEAR VARCHAR2 Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
100
 PRIMGEAR VARCHAR2 Indicator that negear is principal gear used on trip. 0=no 1 = yes. Collected for ASM where applicable.
100
 GEARUSD VARCHAR2 Indicator of whether the gear was used during the trip. 0 = No, 1 = yes.
100
 NONBOARD NUMBER Number of gear of this negear code onboard the vessel. Not collected prior to 5/1994; set to unknown.
100
 NSOAKING NUMBER Number of gear indicated by negear Captain has soaking in water at beginning of trip. Not collected prior to 5/1994; set to unknown for set gear, 0 for mobile gear.
100
 CAPTYRS NUMBER In whole year, the number of years Captain in fishery with type of gear recorded in negear
100
 TARGSPEC1 VARCHAR2 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.
100
 TARGSPEC2 VARCHAR2 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.
100
 TARGSPEC3 VARCHAR2 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.
100
 TARGSPEC4 VARCHAR2 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.
100
 TARGSPEC5 VARCHAR2 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.
100
 TRGCOMMENTS VARCHAR2 Additional information regarding the trip/gear. Prior to 2001 only true or false. Collected for ASM where applicable.

Attribute Details

PROGRAM

CC ID: 330699
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: 330708
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: 330709
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: 330710
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

LINK1

CC ID: 330711
Seq. Order: 5
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

NEGEAR

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

Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
General Data Type: VARCHAR2

PRIMGEAR

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

Indicator that negear is principal gear used on trip. 0=no 1 = yes. Collected for ASM where applicable.
General Data Type: VARCHAR2

GEARUSD

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

Indicator of whether the gear was used during the trip. 0 = No, 1 = yes.
General Data Type: VARCHAR2

NONBOARD

CC ID: 330715
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Number of gear of this negear code onboard the vessel. Not collected prior to 5/1994; set to unknown.
General Data Type: NUMBER

NSOAKING

CC ID: 330700
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Number of gear indicated by negear Captain has soaking in water at beginning of trip. Not collected prior to 5/1994; set to unknown for set gear, 0 for mobile gear.
General Data Type: NUMBER

CAPTYRS

CC ID: 330701
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

In whole year, the number of years Captain in fishery with type of gear recorded in negear
General Data Type: NUMBER

TARGSPEC1

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

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

TARGSPEC2

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

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

TARGSPEC3

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

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

TARGSPEC4

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

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

TARGSPEC5

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

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

TRGCOMMENTS

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

Additional information regarding the trip/gear. Prior to 2001 only true or false. Collected for ASM where applicable.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33321
GUID: gov.noaa.nmfs.inport:33321
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