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