Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Preliminary Observer Haul Data

Description

Preliminary Observer Haul Data

Entity Information

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.

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

Preliminary Observer Haul Data

Notes:

Loaded by batch 8952, 07-06-2016 15:07

Entity Information

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

Preliminary Observer Haul Data

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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 Details

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