Slide Menu
Search Help Show/Hide Menu

Item Identification

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

At Sea Monitor Generic Haul Data

Notes:

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

Entity Information

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

At Sea Monitor Generic Haul Data

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.
100
ASMTEST_STATUS VARCHAR2 Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

Attribute Details

PROGRAM

CC ID: 333853
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: 333864
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: 333875
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: 333886
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: 333897
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: 333908
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: 333919
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: 333930
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 19
Required: Yes
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: 333932
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

OBSRFLAG

CC ID: 333854
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
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: 333855
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: 333856
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
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: 333857
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
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: 333858
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: 333859
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: 333860
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: 333861
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: 333862
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
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: 333863
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
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: 333865
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: 333866
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: 333867
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: 333868
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: 333869
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: 333870
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: 333871
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: 333872
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: 333873
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: 333874
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: 333876
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: 333877
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: 333878
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: 333879
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: 333880
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: 333881
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: 333882
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: 333883
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: 333884
Seq. Order: 38
Data Storage Type: DATE
Max Length: 8
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: 333885
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: 333887
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: 333888
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: 333889
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: 333890
Seq. Order: 43
Data Storage Type: DATE
Max Length: 8
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: 333891
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: 333892
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: 333893
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: 333894
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: 333895
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: 333896
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: 333898
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: 333899
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: 333900
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: 333901
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: 333902
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: 333903
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: 333904
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: 333905
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: 333906
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: 333907
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: 333909
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: 333910
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: 333911
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: 333912
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: 333913
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: 333914
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: 333915
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: 333916
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: 333917
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: 333918
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: 333920
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: 333921
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: 333922
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: 333923
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: 333924
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: 333925
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: 333926
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: 333927
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: 333928
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: 333929
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

ASMTEST_STATUS

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

Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33551
GUID: gov.noaa.nmfs.inport:33551
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