View: OBLLG
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 33565
| Published / External
Created: 2016-07-27
|
Last Modified: 2022-08-09
Parent: Observer and At Sea Monitor Database (OBDBS)
Data Set (DS) | ID: 24111
Data Set (DS) | ID: 24111
ID: 33565
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | View: OBLLG |
|---|---|
| Short Name | OBLLG |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
Observer LongLine Gear Characteristics |
| * Purpose | |
| Notes |
Loaded by batch 9053, 07-27-2016 19:10 |
| Other Citation Details | |
| • Supplemental Information | |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | |
|---|---|
| • » City | |
| • » State/Province | |
| • Country | |
| • » Location Description |
Entity Information
| Entity Type | Data View |
|---|---|
| Active Version? | Y |
| Alias | |
| Schema Name | OBDBS |
| » Description |
Observer LongLine Gear Characteristics |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | No | No | LINK4 | VARCHAR2 | Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. |
| 100 | No | No | PROGRAM | VARCHAR2 | First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. |
| 100 | No | No | YEAR | VARCHAR2 | Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. |
| 100 | No | No | MONTH | VARCHAR2 | Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. |
| 100 | No | No | 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 | No | No | 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 | No | No | GEARNUM | VARCHAR2 | Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. |
| 100 | No | No | NEGEAR | VARCHAR2 | Northeast gear code. See OBGEAR table. Collected for ASM where applicable. |
| 100 | No | No | NHOOKS | NUMBER | Number of individual hooks set. Not collected prior to 5/1994; set to unknown. |
| 100 | No | No | NSECT | NUMBER | Number of sections in gear. Not collected prior to 5/1994; set to unknown. |
| 100 | No | No | SECTLEN | NUMBER | Length of section in tenths of nautical miles. Not collected before 2001; set to unknown. |
| 100 | No | No | NSTRANDS | NUMBER | GILLNET: Number of strands of twine in the net webbing. Removed with obdbs Version 10. |
| 100 | No | No | MLDIA | NUMBER | Diameter of mainline, to the nearest tenth of a millimeter. |
| 100 | No | No | MLTEST | NUMBER | Test or dry breaking strength of mainline, in whole pounds. (999 indicates > 1000) |
| 100 | No | No | MLMAT | VARCHAR2 | Material of mainline. 0=unknown; 1=monofilament nylon; 2=cotton; 3=steel wire; 4=multi-strand nylon; 9=other. |
| 100 | No | No | MLCOLOR | VARCHAR2 | Code for color of mainline. see OBCOLOR table. |
| 100 | No | No | GNGDISBT | NUMBER | Average distance along mainline between gangions, in whole feet. |
| 100 | No | No | GNGDIA | NUMBER | Diameter of gangions, to nearest 10th of millimeter. POTS AND TRAPS: in fractional inches |
| 100 | No | No | GNGTEST | NUMBER | Test or dry breaking strength of gangions, in whole pounds. |
| 100 | No | No | GNGLN1 | NUMBER | Length of first sample gangion, to nearest foot. |
| 100 | No | No | NGNG1 | NUMBER | Number of gangions for each length used. Not collected prior to 5/1994; set to unknown. |
| 100 | No | No | GNGLN2 | NUMBER | Length of second sampled gangion, to nearest foot. |
| 100 | No | No | NGNG2 | NUMBER | Number of secondary gangions for each length used. Not collected prior to 2001. |
| 100 | No | No | GNGMAT | VARCHAR2 | Material of gangion. 0=unknown; 1=monofilament nylon; 2=cotton; 3 = multi_strand nylon; 9=other. |
| 100 | No | No | GNGCOLOR | VARCHAR2 | Code for color of gangions used in gear. See OBCOLOR table. |
| 100 | No | No | FLOATUSD | VARCHAR2 | Indicator of whether floats were used on gear. 0=no, 1=yes 9= unknown. |
| 100 | No | No | FLUNKUSD | VARCHAR2 | Indicator of whether floats of unknown type were used. 0=no ,1=yes, 9 = unknown. |
| 100 | No | No | NFLUNK | NUMBER | Number of floats of unknown type. Not collected prior to 5/1994; set to unknown. |
| 100 | No | No | FLUNKNHKBT | NUMBER | Number of hooks between floats of unknown type. 0 if unknown floats are used and number is unknown. Not collected prior to 2001; set to unknown. |
| 100 | No | No | FLPBUSD | VARCHAR2 | Indicator of whether polyball used on gear. 0 = no 1 = yes 9 = unknown. |
| 100 | No | No | NFLPB | NUMBER | Number of of polyball floats used on gear. If flpbusd = 0 then 0=n/a. Iif flpbusd = 1 then 0 = unknown. |
| 100 | No | No | FLPBNHKBT | NUMBER | Average number of hooks between polyball floats. Not collected prior to 2001; set to unknown. |
| 100 | No | No | FLBDUSD | VARCHAR2 | Indicator of whether bulletdaub floats were used on gear. 0=no 1=yes 9=unknown. Not collected before 5/1994; set to unknown. |
| 100 | No | No | NFLBD | NUMBER | Number of bulletdaub floats used on gear. Not collected prior to 5/1994; set to unknown. |
| 100 | No | No | FLBDNHKBT | NUMBER | Average number of hooks between bulletdaub floats. Not collected before 2001; set to unknown. |
| 100 | No | No | FLOTHUSD | VARCHAR2 | Indicator of whether other floats were used on gear. 0=no, 1 = yes, 9 = unknown. Not collected prior to 2001; set to unknown. |
| 100 | No | No | NFLOTH | NUMBER | Number of other floats used on gear. Not collected prior to 5/1994; set to unknown. |
| 100 | No | No | FLOTHNHKBT | NUMBER | Average number of hooks between 'other' floats. Not collected prior to 2001; set to unknown. |
| 100 | No | No | LEADERUSD | VARCHAR2 | Indicator of whether leaders were used on gear. 0 = no, 1 = yes, 9 = unknown. |
| 100 | No | No | LEADERLEN | NUMBER | Length of leaders used on gear, in whole feet. |
| 100 | No | No | LEADERTEST | NUMBER | Test or dry breaking strength of leaders, in whole pounds. |
| 100 | No | No | LEADERMAT | VARCHAR2 | Code for material of leaders used. 0-unknown, 1 = monofiliament nylon, 3 = steel wire, 9 = other. |
| 100 | No | No | SWVUSD | VARCHAR2 | Indicator of whether swivels were used on gangions. 0 = no, 1 = yes. 9 = unknown. Not collected 1994 - 2000 |
| 100 | No | No | NSWV | NUMBER | Number of swivels used per gangion. If swivels used and this = 0 then unknown. If swivels not used, this = 0 means n/a. Not collected 1994 - 2000; set to unknown. |
| 100 | No | No | LTSTKUSD | VARCHAR2 | Indicator of whether light sticks were used on gear. 0=no. 1=yes ,9=unknown. |
| 100 | No | No | LTSTKCOL | VARCHAR2 | Color of light sticks if used; references OBCOLOR table. |
| 100 | No | No | NLTSTK | NUMBER | Number of light sticks used on gear. 0 if not used or if used and number unknown. Not collected prior to 5/1994 |
| 100 | No | No | ANCHUSD | VARCHAR2 | Indicator of whether an anchor was used. 0 = no 1 = yes 9 = unknown. |
| 100 | No | No | ANCHWGT | NUMBER | Total weight of anchor(s) used to hold gear in place, in whole pounds. |
| 100 | No | No | ANCHWGTYP | VARCHAR2 | Indicator of whether anchor weight was an actual or estimated weight. 0 = unknown, 1 = actual 2 = estimated. Not collected prior to 1994; all set to unknown |
| 100 | No | No | HOOK1COD | VARCHAR2 | Hook code. See OBHOOKINFO table for brand, size and pattern. Collected for ASM where applicable. |
| 100 | No | No | HOOK2COD | VARCHAR2 | Hook code. See OBHOOKINFO table for brand, size and pattern. Collected for ASM where applicable. |
| 100 | No | No | DLLEN | NUMBER | Average length of droplines used in gear in whole feet. |
| 100 | No | No | DLDSBT | NUMBER | Distance between droplines, to nearest foot. |
| 100 | No | No | NBEAC | NUMBER | Number of radio beacons used on gear. Not collected prior to 2000; set to unknown. |
| 100 | No | No | NREFL | NUMBER | Number of radar reflectors used on gear. Not recorded prior to 2001; set to unknown |
| 100 | No | No | LLGCOMMENTS | VARCHAR2 | Commentes on line gear record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable. |
| 100 | No | No | GNGLNAVG | NUMBER | Average length of Gangion. Computed from number at length of two characteristic lengths. |
| 100 | No | No | SURFGEARMARK | VARCHAR2 | Indicator if the surface system buoy(s) were marked to identify the vessel or fishery 1 = yes, 0 = no, 9 = unknown. Collected beginning with obdbs Version 10 (01/01/2011). |
| 100 | No | No | NHIFLYERS | NUMBER | Number of High Fliers (3/2007 -- null unknowns and before) |
| 100 | No | No | NBUOYS | NUMBER | Total number of surface (tide) buoys on this gear connected to the buoyline |
| 100 | No | No | SURFLINLEN | NUMBER | Distance of line between Hi Flyer and Buoy (avg) in feet (3/2007) |
| 100 | No | No | SURFLINTYP | VARCHAR2 | Line type betwen high flyers and buoys (3/2007). See OBLINTYP table. (all pre 3/2007 unknown) |
| 100 | No | No | SURFLINDIA | NUMBER | Diameter of line between high flyers and buoys in decimal inches (3/2007) |
| 100 | No | No | SURFWLUSD | VARCHAR2 | If any weak links are used on the surface system of this: 0 = no, 1 = yes, 9 = unknown (3/2007) |
| 100 | No | No | NSURFWL | NUMBER | Total number of surface system weak lnks on this gear. (3/2007) |
| 100 | No | No | SURFWLTYP | VARCHAR2 | Type of weak links used on the surface system. (3/2007) See OBWLTYP table. |
| 100 | No | No | STRWLUSD | VARCHAR2 | Weak links used on the stron g( net pandls) of gear: 0 = no, 1 = yes, 9 = unknown( 3/2007) |
| 100 | No | No | NSTRWL | NUMBER | Number weak links used on string. null if unknown or not used (3/2007) |
| 100 | No | No | STRWLTYP | VARCHAR2 | 0 = unknown, 1 = rope of appropriate breaking strength, 2= off the shelf 3 = overhand knot, 4 = hog rings 8 = combo (see comments) 9 = other (see comments) (3/2007) |
| 100 | No | No | BUOYLINMARK | VARCHAR2 | Indicator if the buoyline has on 4" colored mark mid-way on the buoyline. 1 = yes, 0 = no, 9 = unknown. Collected beginning with obdbs Version 10 (01/01/2011). |
| 100 | No | No | NBUOYLINE | NUMBER | Number of buoylines on this gear (begun 3/2007) |
| 100 | No | No | BUOYLINLEN | NUMBER | Average length of the buoyline(s) in whole feet used on this gear.(3/2007) |
| 100 | No | No | BUOYLINTYP | VARCHAR2 | Type of buoyline(s) used on this gear. (3/2007) See OBLINTYP table. |
| 100 | No | No | PCTSINKLINE | NUMBER | Average percent of sink line used on this gear.(3/2007) |
| 100 | No | No | PCTFLTLINE | NUMBER | Average percent of float line used on gear (3/2007) |
| 100 | No | No | BUOYLINDIA | NUMBER | Average fractional diameter of buoyline(s) in inches or fractions of inches |
| 100 | No | No | GRNDLINUSD | VARCHAR2 | Ground Line Used: 1 = true, 0 = false 9 = unknown (3/2007) |
| 100 | No | No | GRNDLINLEN | NUMBER | Total length of ground line on this gear in whole feet null if unknown or not used(3/2007) |
| 100 | No | No | GRNDLINTYP | VARCHAR2 | Type of ground line used on this gear. (3/2007) See OBLINTYP table. |
| 100 | No | No | GRNDLINDIA | NUMBER | Average diameter of groundline in decimal inches (3/2007) |
Attribute Details
| Attribute Name | LINK4 |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | VARCHAR2 |
| Max Length | 17 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PROGRAM |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | YEAR |
|---|---|
| Seq. Order | 3 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MONTH |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TRIPID |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | VARCHAR2 |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LINK1 |
|---|---|
| Seq. Order | 6 |
| Data Storage Type | VARCHAR2 |
| Max Length | 15 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GEARNUM |
|---|---|
| Seq. Order | 7 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NEGEAR |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Northeast gear code. See OBGEAR table. Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NHOOKS |
|---|---|
| Seq. Order | 9 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Number of individual hooks set. Not collected prior to 5/1994; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NSECT |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Number of sections in gear. Not collected prior to 5/1994; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SECTLEN |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 1 |
| Status | Active |
| Description |
Length of section in tenths of nautical miles. Not collected before 2001; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NSTRANDS |
|---|---|
| Seq. Order | 12 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 2 |
| Scale | 0 |
| Status | Active |
| Description |
GILLNET: Number of strands of twine in the net webbing. Removed with obdbs Version 10. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MLDIA |
|---|---|
| Seq. Order | 13 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 1 |
| Status | Active |
| Description |
Diameter of mainline, to the nearest tenth of a millimeter. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MLTEST |
|---|---|
| Seq. Order | 14 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Test or dry breaking strength of mainline, in whole pounds. (999 indicates > 1000) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MLMAT |
|---|---|
| Seq. Order | 15 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Material of mainline. 0=unknown; 1=monofilament nylon; 2=cotton; 3=steel wire; 4=multi-strand nylon; 9=other. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MLCOLOR |
|---|---|
| Seq. Order | 16 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for color of mainline. see OBCOLOR table. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GNGDISBT |
|---|---|
| Seq. Order | 17 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Average distance along mainline between gangions, in whole feet. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GNGDIA |
|---|---|
| Seq. Order | 18 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 2 |
| Scale | 1 |
| Status | Active |
| Description |
Diameter of gangions, to nearest 10th of millimeter. POTS AND TRAPS: in fractional inches |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GNGTEST |
|---|---|
| Seq. Order | 19 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Test or dry breaking strength of gangions, in whole pounds. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GNGLN1 |
|---|---|
| Seq. Order | 20 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Length of first sample gangion, to nearest foot. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NGNG1 |
|---|---|
| Seq. Order | 21 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Number of gangions for each length used. Not collected prior to 5/1994; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GNGLN2 |
|---|---|
| Seq. Order | 22 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Length of second sampled gangion, to nearest foot. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NGNG2 |
|---|---|
| Seq. Order | 23 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Number of secondary gangions for each length used. Not collected prior to 2001. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GNGMAT |
|---|---|
| Seq. Order | 24 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Material of gangion. 0=unknown; 1=monofilament nylon; 2=cotton; 3 = multi_strand nylon; 9=other. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GNGCOLOR |
|---|---|
| Seq. Order | 25 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for color of gangions used in gear. See OBCOLOR table. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FLOATUSD |
|---|---|
| Seq. Order | 26 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator of whether floats were used on gear. 0=no, 1=yes 9= unknown. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FLUNKUSD |
|---|---|
| Seq. Order | 27 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator of whether floats of unknown type were used. 0=no ,1=yes, 9 = unknown. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NFLUNK |
|---|---|
| Seq. Order | 28 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 2 |
| Scale | 0 |
| Status | Active |
| Description |
Number of floats of unknown type. Not collected prior to 5/1994; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FLUNKNHKBT |
|---|---|
| Seq. Order | 29 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Number of hooks between floats of unknown type. 0 if unknown floats are used and number is unknown. Not collected prior to 2001; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FLPBUSD |
|---|---|
| Seq. Order | 30 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator of whether polyball used on gear. 0 = no 1 = yes 9 = unknown. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NFLPB |
|---|---|
| Seq. Order | 31 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Number of of polyball floats used on gear. If flpbusd = 0 then 0=n/a. Iif flpbusd = 1 then 0 = unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FLPBNHKBT |
|---|---|
| Seq. Order | 32 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Average number of hooks between polyball floats. Not collected prior to 2001; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FLBDUSD |
|---|---|
| Seq. Order | 33 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator of whether bulletdaub floats were used on gear. 0=no 1=yes 9=unknown. Not collected before 5/1994; set to unknown. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NFLBD |
|---|---|
| Seq. Order | 34 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Number of bulletdaub floats used on gear. Not collected prior to 5/1994; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FLBDNHKBT |
|---|---|
| Seq. Order | 35 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Average number of hooks between bulletdaub floats. Not collected before 2001; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FLOTHUSD |
|---|---|
| Seq. Order | 36 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator of whether other floats were used on gear. 0=no, 1 = yes, 9 = unknown. Not collected prior to 2001; set to unknown. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NFLOTH |
|---|---|
| Seq. Order | 37 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Number of other floats used on gear. Not collected prior to 5/1994; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FLOTHNHKBT |
|---|---|
| Seq. Order | 38 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Average number of hooks between 'other' floats. Not collected prior to 2001; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LEADERUSD |
|---|---|
| Seq. Order | 39 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator of whether leaders were used on gear. 0 = no, 1 = yes, 9 = unknown. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LEADERLEN |
|---|---|
| Seq. Order | 40 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Length of leaders used on gear, in whole feet. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LEADERTEST |
|---|---|
| Seq. Order | 41 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Test or dry breaking strength of leaders, in whole pounds. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LEADERMAT |
|---|---|
| Seq. Order | 42 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for material of leaders used. 0-unknown, 1 = monofiliament nylon, 3 = steel wire, 9 = other. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SWVUSD |
|---|---|
| Seq. Order | 43 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator of whether swivels were used on gangions. 0 = no, 1 = yes. 9 = unknown. Not collected 1994 - 2000 |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NSWV |
|---|---|
| Seq. Order | 44 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 1 |
| Scale | 0 |
| Status | Active |
| Description |
Number of swivels used per gangion. If swivels used and this = 0 then unknown. If swivels not used, this = 0 means n/a. Not collected 1994 - 2000; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LTSTKUSD |
|---|---|
| Seq. Order | 45 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator of whether light sticks were used on gear. 0=no. 1=yes ,9=unknown. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LTSTKCOL |
|---|---|
| Seq. Order | 46 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Color of light sticks if used; references OBCOLOR table. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NLTSTK |
|---|---|
| Seq. Order | 47 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Number of light sticks used on gear. 0 if not used or if used and number unknown. Not collected prior to 5/1994 |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ANCHUSD |
|---|---|
| Seq. Order | 48 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator of whether an anchor was used. 0 = no 1 = yes 9 = unknown. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ANCHWGT |
|---|---|
| Seq. Order | 49 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Total weight of anchor(s) used to hold gear in place, in whole pounds. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ANCHWGTYP |
|---|---|
| Seq. Order | 50 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator of whether anchor weight was an actual or estimated weight. 0 = unknown, 1 = actual 2 = estimated. Not collected prior to 1994; all set to unknown |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | HOOK1COD |
|---|---|
| Seq. Order | 51 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Hook code. See OBHOOKINFO table for brand, size and pattern. Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | HOOK2COD |
|---|---|
| Seq. Order | 52 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Hook code. See OBHOOKINFO table for brand, size and pattern. Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DLLEN |
|---|---|
| Seq. Order | 53 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Average length of droplines used in gear in whole feet. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DLDSBT |
|---|---|
| Seq. Order | 54 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Distance between droplines, to nearest foot. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NBEAC |
|---|---|
| Seq. Order | 55 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Number of radio beacons used on gear. Not collected prior to 2000; set to unknown. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NREFL |
|---|---|
| Seq. Order | 56 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Number of radar reflectors used on gear. Not recorded prior to 2001; set to unknown |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LLGCOMMENTS |
|---|---|
| Seq. Order | 57 |
| Data Storage Type | VARCHAR2 |
| Max Length | 250 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Commentes on line gear record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GNGLNAVG |
|---|---|
| Seq. Order | 58 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Average length of Gangion. Computed from number at length of two characteristic lengths. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SURFGEARMARK |
|---|---|
| Seq. Order | 59 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator if the surface system buoy(s) were marked to identify the vessel or fishery 1 = yes, 0 = no, 9 = unknown. Collected beginning with obdbs Version 10 (01/01/2011). |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NHIFLYERS |
|---|---|
| Seq. Order | 60 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Number of High Fliers (3/2007 -- null unknowns and before) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NBUOYS |
|---|---|
| Seq. Order | 61 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Total number of surface (tide) buoys on this gear connected to the buoyline |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SURFLINLEN |
|---|---|
| Seq. Order | 62 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Distance of line between Hi Flyer and Buoy (avg) in feet (3/2007) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SURFLINTYP |
|---|---|
| Seq. Order | 63 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Line type betwen high flyers and buoys (3/2007). See OBLINTYP table. (all pre 3/2007 unknown) |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SURFLINDIA |
|---|---|
| Seq. Order | 64 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Diameter of line between high flyers and buoys in decimal inches (3/2007) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SURFWLUSD |
|---|---|
| Seq. Order | 65 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
If any weak links are used on the surface system of this: 0 = no, 1 = yes, 9 = unknown (3/2007) |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NSURFWL |
|---|---|
| Seq. Order | 66 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Total number of surface system weak lnks on this gear. (3/2007) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SURFWLTYP |
|---|---|
| Seq. Order | 67 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Type of weak links used on the surface system. (3/2007) See OBWLTYP table. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | STRWLUSD |
|---|---|
| Seq. Order | 68 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Weak links used on the stron g( net pandls) of gear: 0 = no, 1 = yes, 9 = unknown( 3/2007) |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NSTRWL |
|---|---|
| Seq. Order | 69 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Number weak links used on string. null if unknown or not used (3/2007) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | STRWLTYP |
|---|---|
| Seq. Order | 70 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
0 = unknown, 1 = rope of appropriate breaking strength, 2= off the shelf 3 = overhand knot, 4 = hog rings 8 = combo (see comments) 9 = other (see comments) (3/2007) |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BUOYLINMARK |
|---|---|
| Seq. Order | 71 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Indicator if the buoyline has on 4" colored mark mid-way on the buoyline. 1 = yes, 0 = no, 9 = unknown. Collected beginning with obdbs Version 10 (01/01/2011). |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NBUOYLINE |
|---|---|
| Seq. Order | 72 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Number of buoylines on this gear (begun 3/2007) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BUOYLINLEN |
|---|---|
| Seq. Order | 73 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Average length of the buoyline(s) in whole feet used on this gear.(3/2007) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BUOYLINTYP |
|---|---|
| Seq. Order | 74 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Type of buoyline(s) used on this gear. (3/2007) See OBLINTYP table. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PCTSINKLINE |
|---|---|
| Seq. Order | 75 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Average percent of sink line used on this gear.(3/2007) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PCTFLTLINE |
|---|---|
| Seq. Order | 76 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Average percent of float line used on gear (3/2007) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BUOYLINDIA |
|---|---|
| Seq. Order | 77 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Average fractional diameter of buoyline(s) in inches or fractions of inches |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GRNDLINUSD |
|---|---|
| Seq. Order | 78 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Ground Line Used: 1 = true, 0 = false 9 = unknown (3/2007) |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GRNDLINLEN |
|---|---|
| Seq. Order | 79 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Total length of ground line on this gear in whole feet null if unknown or not used(3/2007) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GRNDLINTYP |
|---|---|
| Seq. Order | 80 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Type of ground line used on this gear. (3/2007) See OBLINTYP table. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GRNDLINDIA |
|---|---|
| Seq. Order | 81 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Average diameter of groundline in decimal inches (3/2007) |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
Support Roles
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
Extents
| Currentness Reference |
|---|
Extent Group 1
| Extent Description |
|---|
Extent Group 1 / Geographic Area
| * » W° Bound | |
|---|---|
| * » E° Bound | |
| * » N° Bound | |
| * » S° Bound | |
| * » Description |
Extent Group 1 / Vertical Extent
| EPSG Code | |
|---|---|
| Vertical Minimum | |
| Vertical Maximum |
Extent Group 1 / Time Frame
| * » Time Frame Type | |
|---|---|
| * » Start | |
| End | |
| Alternate Start as of Info | |
| Alternate End as of Info | |
| Description |
Access Information
| * » Security Class | |
|---|---|
| * Security Classification System |
|
| Security Handling Description |
|
| • Data Access Policy |
|
| » Data Access Procedure |
|
| • » Data Access Constraints |
|
| • Data Use Constraints |
|
| Metadata Access Constraints |
|
| Metadata Use Constraints |
|
Distribution Information
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
Activity Log
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
Issues
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
FAQs
| Date | |
|---|---|
| Author | |
| Question | |
| Answer |
Child Items
Rubric scores updated every 15m
| Score | Type | Title |
|---|---|---|
Related Items
| Item Type | Relationship Type | Title |
|---|---|---|
Catalog Details
| Catalog Item ID | 33565 |
|---|---|
| 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 Workflow State | Published / External |
| Metadata Last Review Date | 2016-07-28 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2017-07-28 |
| Tags |
|---|