View: OPHAU
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33362 | Updated: August 9, 2022 | Published / External
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 |