Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: View: OBHAU
Short Name: OBHAU
Status: Completed
Abstract:

Observer Generic Haul Data from standard observer trips

Notes:

Loaded by batch 9053, 07-27-2016 19:10

Entity Information

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

Observer Generic Haul Data from standard observer trips

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
QTR NUMBER Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. 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
NEGEAR VARCHAR2 Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
100
OBSRFLAG VARCHAR2 Indicator of whether haul was observed for discards (all hauls are observed for catch except for offwatch (sdo, sto, cdo) hauls). 0=no; 1=yes. Collected for ASM where applicable.
100
CATEXIST VARCHAR2 Indicator of whether gear from haul holds any catch, kept or discarded. 0=no; 1=yes.
100
INCTAKE VARCHAR2 Indicator of whether Sea Turtle, Marine Mammal, or Sea Bird is caught by gear in haul. 0 = no 1 = yes. Collected for ASM where applicable.
100
WEATHER VARCHAR2 HAUL: Code for weather at beginning of haul. EVENT: Code for weather at time event occurred. See support table OBWEATHER for codes. Collected for ASM where applicable.
100
WINDSP NUMBER Wind speed at beginning of haul, in whole knots.
100
WINDDIR VARCHAR2 Wind direction (compass direction) from which the wind is blowing at beginning of haul.
100
WAVEHGT NUMBER HAUL: Wave height at beginning of haul, in whole feet. EVENT: Wave height at beginning of event, in whole feet. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
100
DEPTH NUMBER Water depth at beginning of haul, in whole fathoms.
100
GEARCOND VARCHAR2 Condition of gear at Haul. See OBGEARCOND table. Collected for ASM where applicable.
100
TARGSPEC1 VARCHAR2 NESPP4 for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.
100
TARGSPEC2 VARCHAR2 NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.
100
TARGSPEC3 VARCHAR2 NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
100
TARGSPEC4 VARCHAR2 NESPP4 code for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
100
TARGSPEC5 VARCHAR2 NESPP4 for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
100
YEARSBEG VARCHAR2 Year set began, four digits.Not collected before 5/1994; set to unknown.
100
MONTHSBEG VARCHAR2 Two digit month set began. Not collected 1989 - 4/1994;
100
DAYSBEG VARCHAR2 Day set began, two digits.
100
TIMESBEG VARCHAR2 Time set began, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown
100
DATESBEG DATE Date the set began. Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field
100
YEARSEND VARCHAR2 Year set ended, four digits. Not collected before 5/1994; set to unknown.
100
MONTHSEND VARCHAR2 Two digit month the set ended.
100
DAYSEND VARCHAR2 Day set ended, two digits.Not recorded prior to 5/1994; set to unknown
100
TIMESEND VARCHAR2 Time set ended, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown
100
DATESEND DATE Date the set of the gear ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field
100
YEARHBEG VARCHAR2 Year haul began, four digits. Collected for ASM where applicable.
100
MONTHHBEG VARCHAR2 Month haul began, two digits. Collected for ASM where applicable.
100
DAYHBEG VARCHAR2 Day haul began, two digits. Collected for ASM where applicable.
100
TIMEHBEG VARCHAR2 Time haul began, local time using 24 hour clock (0000-2359). Collected for ASM where applicable.
100
DATEHBEG DATE Date haul began. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
100
YEARHEND VARCHAR2 Year haul ended, four digits.Not collected before 5/1994; set to unknown.
100
MONTHEND VARCHAR2 Month haul ended, two digits. Collected for ASM where applicable.
100
DAYHEND VARCHAR2 Day haul ended, two digits.Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
100
TIMEHEND VARCHAR2 Time haul ended, local time using 24 hour clock (0000-2359). Collected for ASM where applicable.
100
DATEHEND DATE Date the haul ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
100
YEARFBEG VARCHAR2 Year that the gear was fully deployed and actively fishing (3/2007)
100
MONTHFBEG VARCHAR2 Month that the gear was fully deployed and actively fishing (3/2007)
100
DAYFBEG VARCHAR2 Day that the gear was fully deployed and actively fishing (3/2007)
100
TIMEFBEG VARCHAR2 Time (24 hour clock) that the gear was fully deployed and actively fishing (3/2007)
100
DATEFBEG DATE Date that the gear is fully deployed and actively fishing(3/2007) NOTE: if time fishing begins (TIMEFBEG) is unknown it defaults to midnight.
100
YEARGONBD VARCHAR2 YEAR when all gear was out of the water. (3/2007)
100
MONTHGONBD VARCHAR2 Month (local time) that the gear from the haul is completely out of the water (3/2007)
100
DAYGONBD VARCHAR2 Day (local time) that the gear form the haul is completely out of the water (3/2007)
100
TIMEGONBD VARCHAR2 4-digit local time (24-hour clock) when all gear was out of the water. (3/2007)
100
DATEGONBD DATE Local date and time that the gear form the haul is completely out of the water (3/2007)
100
LATSBEG VARCHAR2 Latitude where set began (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
100
LATSEND VARCHAR2 Latitude (DDMMSS) where set ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
100
LATHBEG VARCHAR2 Latitude location, (DDMMSS) where haul began. Pre 2001 : SS rounded to 30 where no loran. Collected for ASM where applicable.
100
LATHEND VARCHAR2 Latitude (DDMMSS) where haul ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans. Collected for ASM where applicable.
100
LONSBEG VARCHAR2 Longitude location of where set began, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
100
LONSEND VARCHAR2 Longitude where set ended, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans
100
LONHBEG VARCHAR2 Longitude location of where haul began, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.
100
LONHEND VARCHAR2 Longitude location of where haul ended, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.
100
GIS_LATSBEG NUMBER GIS format (decimal degrees) for set begin latitude
100
GIS_LATSEND NUMBER GIS format (decimal degrees) for set end latitude
100
GIS_LATHBEG NUMBER GIS format (decimal degrees) for haul begin latitude. Collected for ASM where applicable.
100
GIS_LATHEND NUMBER GIS format (decimal degrees) for haul end latitude. Collected for ASM where applicable.
100
GIS_LONSBEG NUMBER GIS format (decimal degrees) for set begin longitude
100
GIS_LONSEND NUMBER GIS format (decimal degrees) for set end longitude
100
GIS_LONHBEG NUMBER GIS format (decimal degrees) for haul begin longitude. Collected for ASM where applicable.
100
GIS_LONHEND NUMBER GIS format (decimal degrees) for haul end longitude. Collected for ASM where applicable.
100
WTMP NUMBER The surface sea water Fahrenheit temperature, to the nearest tenth, when haul ended. Not entered before 5/1994
100
SOAKDUR NUMBER Fixed gear only. Amount of time that the gear for haul is in the water, to the nearest tenth of an hour (haul begin - set end). BEACH SEINE: estimated; Time from when the gear is secured to the beach until hauling of the warpline begins. Collected for ASM where applicable.
100
SETDUR NUMBER (fixed gears only) Time it takes to set out the gear; Time set end - time set begin;
100
HAULDUR NUMBER GILLNET, LONGLINE, POTS: Length of time (hours) from beginning to haul the gear out until all the gear is out. (Haul end - Haul begin). BEACH SEINE: Length of time (hours)from the beginning of haul of warpline until last portion of net exits the surf zone. OTTER TRAWL, SCALLOP DREDGE: Length of time (hours) from when the net hits the water until hauling equipment put in gear . PAIR TRAWL: Length of time (hours) from when the net hits the water until legs retrieved and aboard both vessels. Calculated for ASM where applicable.
100
QDSQ VARCHAR2 Quarter Degree Square, lookup in LOC2AREAS table.
100
TENMSQ VARCHAR2 Position in grid computed from lat/lon; relative minute position in a degree square 1-6 west to east for longitude and 1-6 north to south for latitude.
100
NEMAREA VARCHAR2 Inshore area codes. See Loc2areas table. Not collected before 5/1994; set to statistical area.
100
AREA VARCHAR2 Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.
100
ONEFFORT VARCHAR2 Indicator whether the observer is intentionally present to witness the haulback 1 = yes, 0 = no, 9 = unknown Collected beginning with obdbs Version 10 (01/01/2011).
100
HAUCOMMENTS VARCHAR2 Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

Attribute Details

PROGRAM

CC ID: 334401
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: 334412
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: 334423
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: 334434
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: 334445
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: 334456
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

QTR

CC ID: 334467
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable.

General Data Type: NUMBER

LINK3

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

NEGEAR

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

Northeast gear code. See OBGEAR table. Collected for ASM where applicable.

General Data Type: VARCHAR2

OBSRFLAG

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

Indicator of whether haul was observed for discards (all hauls are observed for catch except for offwatch (sdo, sto, cdo) hauls). 0=no; 1=yes. Collected for ASM where applicable.

General Data Type: VARCHAR2

CATEXIST

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

INCTAKE

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

Indicator of whether Sea Turtle, Marine Mammal, or Sea Bird is caught by gear in haul. 0 = no 1 = yes. Collected for ASM where applicable.

General Data Type: VARCHAR2

WEATHER

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

HAUL: Code for weather at beginning of haul. EVENT: Code for weather at time event occurred. See support table OBWEATHER for codes. Collected for ASM where applicable.

General Data Type: VARCHAR2

WINDSP

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

Wind speed at beginning of haul, in whole knots.

General Data Type: NUMBER

WINDDIR

CC ID: 334407
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Wind direction (compass direction) from which the wind is blowing at beginning of haul.

General Data Type: VARCHAR2

WAVEHGT

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

HAUL: Wave height at beginning of haul, in whole feet. EVENT: Wave height at beginning of event, in whole feet. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.

General Data Type: NUMBER

DEPTH

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

Water depth at beginning of haul, in whole fathoms.

General Data Type: NUMBER

GEARCOND

CC ID: 334410
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Condition of gear at Haul. See OBGEARCOND table. Collected for ASM where applicable.

General Data Type: VARCHAR2

TARGSPEC1

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

NESPP4 for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.

General Data Type: VARCHAR2

TARGSPEC2

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

NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.

General Data Type: VARCHAR2

TARGSPEC3

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

NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.

General Data Type: VARCHAR2

TARGSPEC4

CC ID: 334415
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

NESPP4 code for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.

General Data Type: VARCHAR2

TARGSPEC5

CC ID: 334416
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

NESPP4 for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.

General Data Type: VARCHAR2

YEARSBEG

CC ID: 334417
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year set began, four digits.Not collected before 5/1994; set to unknown.

General Data Type: VARCHAR2

MONTHSBEG

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

Two digit month set began. Not collected 1989 - 4/1994;

General Data Type: VARCHAR2

DAYSBEG

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

Day set began, two digits.

General Data Type: VARCHAR2

TIMESBEG

CC ID: 334420
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time set began, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown

General Data Type: VARCHAR2

DATESBEG

CC ID: 334421
Seq. Order: 28
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date the set began. Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field

General Data Type: DATE

YEARSEND

CC ID: 334422
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year set ended, four digits. Not collected before 5/1994; set to unknown.

General Data Type: VARCHAR2

MONTHSEND

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

Two digit month the set ended.

General Data Type: VARCHAR2

DAYSEND

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

Day set ended, two digits.Not recorded prior to 5/1994; set to unknown

General Data Type: VARCHAR2

TIMESEND

CC ID: 334426
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time set ended, local time using 24 hour clock (0000-2359). Not collected before 5/1994; set to unknown

General Data Type: VARCHAR2

DATESEND

CC ID: 334427
Seq. Order: 33
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date the set of the gear ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field

General Data Type: DATE

YEARHBEG

CC ID: 334428
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year haul began, four digits. Collected for ASM where applicable.

General Data Type: VARCHAR2

MONTHHBEG

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

Month haul began, two digits. Collected for ASM where applicable.

General Data Type: VARCHAR2

DAYHBEG

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

Day haul began, two digits. Collected for ASM where applicable.

General Data Type: VARCHAR2

TIMEHBEG

CC ID: 334431
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time haul began, local time using 24 hour clock (0000-2359). Collected for ASM where applicable.

General Data Type: VARCHAR2

DATEHBEG

CC ID: 334432
Seq. Order: 38
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date haul began. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.

General Data Type: DATE

YEARHEND

CC ID: 334433
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year haul ended, four digits.Not collected before 5/1994; set to unknown.

General Data Type: VARCHAR2

MONTHEND

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

Month haul ended, two digits. Collected for ASM where applicable.

General Data Type: VARCHAR2

DAYHEND

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

Day haul ended, two digits.Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.

General Data Type: VARCHAR2

TIMEHEND

CC ID: 334437
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time haul ended, local time using 24 hour clock (0000-2359). Collected for ASM where applicable.

General Data Type: VARCHAR2

DATEHEND

CC ID: 334438
Seq. Order: 43
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date the haul ended.Not recorded prior to 5/1994; set to unknown NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.

General Data Type: DATE

YEARFBEG

CC ID: 334439
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year that the gear was fully deployed and actively fishing (3/2007)

General Data Type: VARCHAR2

MONTHFBEG

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

Month that the gear was fully deployed and actively fishing (3/2007)

General Data Type: VARCHAR2

DAYFBEG

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

Day that the gear was fully deployed and actively fishing (3/2007)

General Data Type: VARCHAR2

TIMEFBEG

CC ID: 334442
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time (24 hour clock) that the gear was fully deployed and actively fishing (3/2007)

General Data Type: VARCHAR2

DATEFBEG

CC ID: 334443
Seq. Order: 48
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date that the gear is fully deployed and actively fishing(3/2007) NOTE: if time fishing begins (TIMEFBEG) is unknown it defaults to midnight.

General Data Type: DATE

YEARGONBD

CC ID: 334444
Seq. Order: 49
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

YEAR when all gear was out of the water. (3/2007)

General Data Type: VARCHAR2

MONTHGONBD

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

Month (local time) that the gear from the haul is completely out of the water (3/2007)

General Data Type: VARCHAR2

DAYGONBD

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

Day (local time) that the gear form the haul is completely out of the water (3/2007)

General Data Type: VARCHAR2

TIMEGONBD

CC ID: 334448
Seq. Order: 52
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

4-digit local time (24-hour clock) when all gear was out of the water. (3/2007)

General Data Type: VARCHAR2

DATEGONBD

CC ID: 334449
Seq. Order: 53
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Local date and time that the gear form the haul is completely out of the water (3/2007)

General Data Type: DATE

LATSBEG

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

Latitude where set began (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans

General Data Type: VARCHAR2

LATSEND

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

Latitude (DDMMSS) where set ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans

General Data Type: VARCHAR2

LATHBEG

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

Latitude location, (DDMMSS) where haul began. Pre 2001 : SS rounded to 30 where no loran. Collected for ASM where applicable.

General Data Type: VARCHAR2

LATHEND

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

Latitude (DDMMSS) where haul ended. Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans. Collected for ASM where applicable.

General Data Type: VARCHAR2

LONSBEG

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

Longitude location of where set began, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans

General Data Type: VARCHAR2

LONSEND

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

Longitude where set ended, (DDMMSS). Not recorded 1989 - 5/1994 5/1994 - 12/2000: SS rounded to 30 where no lorans

General Data Type: VARCHAR2

LONHBEG

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

Longitude location of where haul began, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.

General Data Type: VARCHAR2

LONHEND

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

Longitude location of where haul ended, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.

General Data Type: VARCHAR2

GIS_LATSBEG

CC ID: 334459
Seq. Order: 62
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 6
Status: Active
Description:

GIS format (decimal degrees) for set begin latitude

General Data Type: NUMBER

GIS_LATSEND

CC ID: 334460
Seq. Order: 63
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 6
Status: Active
Description:

GIS format (decimal degrees) for set end latitude

General Data Type: NUMBER

GIS_LATHBEG

CC ID: 334461
Seq. Order: 64
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 6
Status: Active
Description:

GIS format (decimal degrees) for haul begin latitude. Collected for ASM where applicable.

General Data Type: NUMBER

GIS_LATHEND

CC ID: 334462
Seq. Order: 65
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 6
Status: Active
Description:

GIS format (decimal degrees) for haul end latitude. Collected for ASM where applicable.

General Data Type: NUMBER

GIS_LONSBEG

CC ID: 334463
Seq. Order: 66
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

GIS format (decimal degrees) for set begin longitude

General Data Type: NUMBER

GIS_LONSEND

CC ID: 334464
Seq. Order: 67
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

GIS format (decimal degrees) for set end longitude

General Data Type: NUMBER

GIS_LONHBEG

CC ID: 334465
Seq. Order: 68
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

GIS format (decimal degrees) for haul begin longitude. Collected for ASM where applicable.

General Data Type: NUMBER

GIS_LONHEND

CC ID: 334466
Seq. Order: 69
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

GIS format (decimal degrees) for haul end longitude. Collected for ASM where applicable.

General Data Type: NUMBER

WTMP

CC ID: 334468
Seq. Order: 70
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

The surface sea water Fahrenheit temperature, to the nearest tenth, when haul ended. Not entered before 5/1994

General Data Type: NUMBER

SOAKDUR

CC ID: 334469
Seq. Order: 71
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Fixed gear only. Amount of time that the gear for haul is in the water, to the nearest tenth of an hour (haul begin - set end). BEACH SEINE: estimated; Time from when the gear is secured to the beach until hauling of the warpline begins. Collected for ASM where applicable.

General Data Type: NUMBER

SETDUR

CC ID: 334470
Seq. Order: 72
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

(fixed gears only) Time it takes to set out the gear; Time set end - time set begin;

General Data Type: NUMBER

HAULDUR

CC ID: 334471
Seq. Order: 73
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

GILLNET, LONGLINE, POTS: Length of time (hours) from beginning to haul the gear out until all the gear is out. (Haul end - Haul begin). BEACH SEINE: Length of time (hours)from the beginning of haul of warpline until last portion of net exits the surf zone. OTTER TRAWL, SCALLOP DREDGE: Length of time (hours) from when the net hits the water until hauling equipment put in gear . PAIR TRAWL: Length of time (hours) from when the net hits the water until legs retrieved and aboard both vessels. Calculated for ASM where applicable.

General Data Type: NUMBER

QDSQ

CC ID: 334472
Seq. Order: 74
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Quarter Degree Square, lookup in LOC2AREAS table.

General Data Type: VARCHAR2

TENMSQ

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

Position in grid computed from lat/lon; relative minute position in a degree square 1-6 west to east for longitude and 1-6 north to south for latitude.

General Data Type: VARCHAR2

NEMAREA

CC ID: 334474
Seq. Order: 76
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Inshore area codes. See Loc2areas table. Not collected before 5/1994; set to statistical area.

General Data Type: VARCHAR2

AREA

CC ID: 334475
Seq. Order: 77
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.

General Data Type: VARCHAR2

ONEFFORT

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

Indicator whether the observer is intentionally present to witness the haulback 1 = yes, 0 = no, 9 = unknown Collected beginning with obdbs Version 10 (01/01/2011).

General Data Type: VARCHAR2

HAUCOMMENTS

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

Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33563
GUID: gov.noaa.nmfs.inport:33563
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-27 19:10+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