View: OPHAU
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33362 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Preliminary Observer Haul Data
DescriptionPreliminary 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |