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

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

Summary

Abstract

At Sea Monitor Gillnet Hauls

Description

At Sea Monitor Gillnet Hauls

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.
HAULNUM
VARCHAR2 		Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. 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.
LINK4
VARCHAR2 		Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. 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.
GEARNUM
VARCHAR2 		Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
MMWATCH
VARCHAR2 		Indicator of whether a haul watch was conducted. 0=no 1 = yes.
LEADLINDEPTH
NUMBER 		Depth from the surface at which leadline fishes for haul, in whole fathoms. Not collected prior to2001. Set to unknown
NNETSET
NUMBER 		Total number of nets used for the set. Not collected before 5/1994; set to unknown.
NNETHAUL
NUMBER 		Total number of nets that are hauled back from the set. Collected for ASM where applicable.
NNETLOST
NUMBER 		Total number of nets that are lost from the set.
NACTMMDHAUL
NUMBER 		Total number of active marine mammal devices hauled. GGH: not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
NPASMMDHAUL
NUMBER 		Total number of passive marine mammal devices hauled.
NACTMMDLOST
NUMBER 		Total number of active marine mammal devices lost. Not collected prior to 2001
NPASMMDLOST
NUMBER 		Total number of passive marine mammal devices lost.
SETMETHOD
VARCHAR2 		Method of manner in which gear was set for haul. See OBSETMETHOD table.
GGHCOMMENTS
VARCHAR2 		Comments on gillnet haul record . Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
ASMTEST_STATUS
VARCHAR2 		Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

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: ASMGGH
Short Name: ASMGGH
Status: Completed
Abstract:

At Sea Monitor Gillnet Hauls
Notes:

Loaded by batch 8948, 07-06-2016 08:22

Entity Information

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

At Sea Monitor Gillnet Hauls

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
 HAULNUM VARCHAR2 Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. 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
 LINK4 VARCHAR2 Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. 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
 GEARNUM VARCHAR2 Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100
 MMWATCH VARCHAR2 Indicator of whether a haul watch was conducted. 0=no 1 = yes.
100
 LEADLINDEPTH NUMBER Depth from the surface at which leadline fishes for haul, in whole fathoms. Not collected prior to2001. Set to unknown
100
 NNETSET NUMBER Total number of nets used for the set. Not collected before 5/1994; set to unknown.
100
 NNETHAUL NUMBER Total number of nets that are hauled back from the set. Collected for ASM where applicable.
100
 NNETLOST NUMBER Total number of nets that are lost from the set.
100
 NACTMMDHAUL NUMBER Total number of active marine mammal devices hauled. GGH: not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
100
 NPASMMDHAUL NUMBER Total number of passive marine mammal devices hauled.
100
 NACTMMDLOST NUMBER Total number of active marine mammal devices lost. Not collected prior to 2001
100
 NPASMMDLOST NUMBER Total number of passive marine mammal devices lost.
100
 SETMETHOD VARCHAR2 Method of manner in which gear was set for haul. See OBSETMETHOD table.
100
 GGHCOMMENTS VARCHAR2 Comments on gillnet haul record . Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
100
 ASMTEST_STATUS VARCHAR2 Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

Attribute Details

PROGRAM

CC ID: 328836
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: 328847
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: 328850
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: 328851
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

HAULNUM

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

LINK1

CC ID: 328853
Seq. Order: 6
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

LINK4

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

LINK3

CC ID: 328855
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 19
Required: Yes
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

GEARNUM

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

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

MMWATCH

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

Indicator of whether a haul watch was conducted. 0=no 1 = yes.
General Data Type: VARCHAR2

LEADLINDEPTH

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

Depth from the surface at which leadline fishes for haul, in whole fathoms. Not collected prior to2001. Set to unknown
General Data Type: NUMBER

NNETSET

CC ID: 328839
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Total number of nets used for the set. Not collected before 5/1994; set to unknown.
General Data Type: NUMBER

NNETHAUL

CC ID: 328840
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Total number of nets that are hauled back from the set. Collected for ASM where applicable.
General Data Type: NUMBER

NNETLOST

CC ID: 328841
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Total number of nets that are lost from the set.
General Data Type: NUMBER

NACTMMDHAUL

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

Total number of active marine mammal devices hauled. GGH: not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
General Data Type: NUMBER

NPASMMDHAUL

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

Total number of passive marine mammal devices hauled.
General Data Type: NUMBER

NACTMMDLOST

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

Total number of active marine mammal devices lost. Not collected prior to 2001
General Data Type: NUMBER

NPASMMDLOST

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

Total number of passive marine mammal devices lost.
General Data Type: NUMBER

SETMETHOD

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

Method of manner in which gear was set for haul. See OBSETMETHOD table.
General Data Type: VARCHAR2

GGHCOMMENTS

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

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

ASMTEST_STATUS

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

Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33268
GUID: gov.noaa.nmfs.inport:33268
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-06 08:22+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