Metadata Rubric

100%

6 / 6

View Report

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fishery Monitoring Operations Branch (FMOB) > Observer Preliminary Database (OBPRELIM) >

View: OPHAU

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33362 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Preliminary Observer Haul Data

Description

Preliminary Observer Haul Data

Entity Type
Data View

Data Attribute / Type	Description
LINK1 VARCHAR2	15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
LINK3 VARCHAR2	19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4)
YEAR VARCHAR2	Year landed. Characters 4-7 of LINK1.
TRIPID VARCHAR2	6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.
HAULNUM VARCHAR2	Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.
NEGEAR VARCHAR2	Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR.
OBSRFLAG VARCHAR2	Indicator of whether haul was observed for discards. 0=No, 1=Yes.
CATEXIST VARCHAR2	Indicator of whether gear from haul holds any catch, kept or discarded. 0=No, 1=Yes.
LATHBEG VARCHAR2	Latitude location where haul began.
LONHBEG VARCHAR2	Longitude location where haul began.
GIS_LATHBEG VARCHAR2	GIS converted LATHBEG.
GIS_LONHBEG VARCHAR2	GIS converted LONHBEG. This number is negative.
LATHEND VARCHAR2	Latitude location where haul ended or position information where take occurred for incidental take.
LONHEND VARCHAR2	Longitude location where haul ended or position information where take occurred for incidental take.
GIS_LATHEND VARCHAR2	GIS converted LATHEND.
GIS_LONHEND VARCHAR2	GIS converted LONHEND. This number is negative.
AREA VARCHAR2	Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul.
HAUCOMMENTS VARCHAR2	Additional information regarding the haul.

Data Attribute / Type

Description

LINK1
VARCHAR2

15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)

LINK3
VARCHAR2

19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4)

YEAR
VARCHAR2

Year landed. Characters 4-7 of LINK1.

TRIPID
VARCHAR2

6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.

HAULNUM
VARCHAR2

Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.

NEGEAR
VARCHAR2

Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR.

OBSRFLAG
VARCHAR2

Indicator of whether haul was observed for discards. 0=No, 1=Yes.

CATEXIST
VARCHAR2

Indicator of whether gear from haul holds any catch, kept or discarded. 0=No, 1=Yes.

LATHBEG
VARCHAR2

Latitude location where haul began.

LONHBEG
VARCHAR2

Longitude location where haul began.

GIS_LATHBEG
VARCHAR2

GIS converted LATHBEG.

GIS_LONHBEG
VARCHAR2

GIS converted LONHBEG. This number is negative.

LATHEND
VARCHAR2

Latitude location where haul ended or position information where take occurred for incidental take.

LONHEND
VARCHAR2

Longitude location where haul ended or position information where take occurred for incidental take.

GIS_LATHEND
VARCHAR2

GIS converted LATHEND.

GIS_LONHEND
VARCHAR2

GIS converted LONHEND. This number is negative.

AREA
VARCHAR2

Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul.

HAUCOMMENTS
VARCHAR2

Additional information regarding the haul.

No Child Items for this record.

No contact information is available for this record.

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

Title:	View: OPHAU
Short Name:	OPHAU
Status:	Completed
Abstract:	Preliminary Observer Haul Data
Notes:	Loaded by batch 8952, 07-06-2016 15:07

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBPRELIM
Description:	Preliminary Observer Haul Data

Attribute Summary

	Name	Type	Description
100	LINK1	VARCHAR2	15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
100	LINK3	VARCHAR2	19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4)
100	YEAR	VARCHAR2	Year landed. Characters 4-7 of LINK1.
100	TRIPID	VARCHAR2	6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.
100	HAULNUM	VARCHAR2	Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.
100	NEGEAR	VARCHAR2	Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR.
100	OBSRFLAG	VARCHAR2	Indicator of whether haul was observed for discards. 0=No, 1=Yes.
100	CATEXIST	VARCHAR2	Indicator of whether gear from haul holds any catch, kept or discarded. 0=No, 1=Yes.
100	LATHBEG	VARCHAR2	Latitude location where haul began.
100	LONHBEG	VARCHAR2	Longitude location where haul began.
100	GIS_LATHBEG	VARCHAR2	GIS converted LATHBEG.
100	GIS_LONHBEG	VARCHAR2	GIS converted LONHBEG. This number is negative.
100	LATHEND	VARCHAR2	Latitude location where haul ended or position information where take occurred for incidental take.
100	LONHEND	VARCHAR2	Longitude location where haul ended or position information where take occurred for incidental take.
100	GIS_LATHEND	VARCHAR2	GIS converted LATHEND.
100	GIS_LONHEND	VARCHAR2	GIS converted LONHEND. This number is negative.
100	AREA	VARCHAR2	Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul.
100	HAUCOMMENTS	VARCHAR2	Additional information regarding the haul.

Name

Type

Description

100

LINK1

VARCHAR2

15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)

100

LINK3

VARCHAR2

19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4)

100

YEAR

VARCHAR2

Year landed. Characters 4-7 of LINK1.

100

TRIPID

VARCHAR2

6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.

100

HAULNUM

VARCHAR2

Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.

100

NEGEAR

VARCHAR2

Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR.

100

OBSRFLAG

VARCHAR2

Indicator of whether haul was observed for discards. 0=No, 1=Yes.

100

CATEXIST

VARCHAR2

Indicator of whether gear from haul holds any catch, kept or discarded. 0=No, 1=Yes.

100

LATHBEG

VARCHAR2

Latitude location where haul began.

100

LONHBEG

VARCHAR2

Longitude location where haul began.

100

GIS_LATHBEG

VARCHAR2

GIS converted LATHBEG.

100

GIS_LONHBEG

VARCHAR2

GIS converted LONHBEG. This number is negative.

100

LATHEND

VARCHAR2

Latitude location where haul ended or position information where take occurred for incidental take.

100

LONHEND

VARCHAR2

Longitude location where haul ended or position information where take occurred for incidental take.

100

GIS_LATHEND

VARCHAR2

GIS converted LATHEND.

100

GIS_LONHEND

VARCHAR2

GIS converted LONHEND. This number is negative.

100

AREA

VARCHAR2

Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul.

100

HAUCOMMENTS

VARCHAR2

Additional information regarding the haul.

Attribute Details

LINK1

CC ID: 331374

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
General Data Type:	VARCHAR2

LINK3

CC ID: 331384

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	19
Required:	No
Primary Key:	No
Status:	Active
Description:	19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4)
General Data Type:	VARCHAR2

YEAR

CC ID: 331385

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Year landed. Characters 4-7 of LINK1.
General Data Type:	VARCHAR2

TRIPID

CC ID: 331386

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.
General Data Type:	VARCHAR2

HAULNUM

CC ID: 331387

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.
General Data Type:	VARCHAR2

NEGEAR

CC ID: 331388

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR.
General Data Type:	VARCHAR2

OBSRFLAG

CC ID: 331389

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Indicator of whether haul was observed for discards. 0=No, 1=Yes.
General Data Type:	VARCHAR2

CATEXIST

CC ID: 331390

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether gear from haul holds any catch, kept or discarded. 0=No, 1=Yes.
General Data Type:	VARCHAR2

LATHBEG

CC ID: 331391

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude location where haul began.
General Data Type:	VARCHAR2

LONHBEG

CC ID: 331375

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude location where haul began.
General Data Type:	VARCHAR2

GIS_LATHBEG

CC ID: 331376

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	GIS converted LATHBEG.
General Data Type:	VARCHAR2

GIS_LONHBEG

CC ID: 331377

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	GIS converted LONHBEG. This number is negative.
General Data Type:	VARCHAR2

LATHEND

CC ID: 331378

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude location where haul ended or position information where take occurred for incidental take.
General Data Type:	VARCHAR2

LONHEND

CC ID: 331379

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude location where haul ended or position information where take occurred for incidental take.
General Data Type:	VARCHAR2

GIS_LATHEND

CC ID: 331380

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	GIS converted LATHEND.
General Data Type:	VARCHAR2

GIS_LONHEND

CC ID: 331381

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	GIS converted LONHEND. This number is negative.
General Data Type:	VARCHAR2

AREA

CC ID: 331382

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul.
General Data Type:	VARCHAR2

HAUCOMMENTS

CC ID: 331383

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information regarding the haul.
General Data Type:	VARCHAR2

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

View: OPHAU

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LINK1

LINK3

YEAR

TRIPID

HAULNUM

NEGEAR

OBSRFLAG

CATEXIST

LATHBEG

LONHBEG

GIS_LATHBEG

GIS_LONHBEG

LATHEND

LONHEND

GIS_LATHEND

GIS_LONHEND

AREA

HAUCOMMENTS

Catalog Details