Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Observer Meshsize Support Table

Description

Observer Meshsize Support Table

Entity Information

Entity Type
Data View

Data Attribute / Type Description
SECGEARFISH
VARCHAR2
Sector gear fishery code from VTR gear code. Collected for ASM. Derived using VTR gear codes in OBGEAR as reference.
GEARNM
VARCHAR2
Common name(s) for negear code.
NEGEAR
VARCHAR2
Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
MESHSIZE_NM
VARCHAR2
Descriptive name of meshsize.
MESHSIZE_ABB
VARCHAR2
Meshsize abbreviation. See OBMESHSIZE View. Derived using OBMESHSIZE as reference.
MESHSIZE_RANGE
VARCHAR2
Meshsize range (lower and upper range).
MESHSIZE_LOWER
NUMBER
Lower boundary of meshsize range.
MESHSIZE_UPPER
NUMBER
Upper boundary of meshsize range.
MESHSIZE_DEFAULT
NUMBER
Default used when meshsize not provided.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

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

Observer Meshsize Support Table

Notes:

Loaded by batch 8950, 07-06-2016 08:24

Entity Information

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

Observer Meshsize Support Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SECGEARFISH VARCHAR2 Sector gear fishery code from VTR gear code. Collected for ASM. Derived using VTR gear codes in OBGEAR as reference.
100
GEARNM VARCHAR2 Common name(s) for negear code.
100
NEGEAR VARCHAR2 Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
100
MESHSIZE_NM VARCHAR2 Descriptive name of meshsize.
100
MESHSIZE_ABB VARCHAR2 Meshsize abbreviation. See OBMESHSIZE View. Derived using OBMESHSIZE as reference.
100
MESHSIZE_RANGE VARCHAR2 Meshsize range (lower and upper range).
100
MESHSIZE_LOWER NUMBER Lower boundary of meshsize range.
100
MESHSIZE_UPPER NUMBER Upper boundary of meshsize range.
100
MESHSIZE_DEFAULT NUMBER Default used when meshsize not provided.

Attribute Details

SECGEARFISH

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

Sector gear fishery code from VTR gear code. Collected for ASM. Derived using VTR gear codes in OBGEAR as reference.

General Data Type: VARCHAR2

GEARNM

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

Common name(s) for negear code.

General Data Type: VARCHAR2

NEGEAR

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

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

General Data Type: VARCHAR2

MESHSIZE_NM

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

Descriptive name of meshsize.

General Data Type: VARCHAR2

MESHSIZE_ABB

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

Meshsize abbreviation. See OBMESHSIZE View. Derived using OBMESHSIZE as reference.

General Data Type: VARCHAR2

MESHSIZE_RANGE

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

Meshsize range (lower and upper range).

General Data Type: VARCHAR2

MESHSIZE_LOWER

CC ID: 331112
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Lower boundary of meshsize range.

General Data Type: NUMBER

MESHSIZE_UPPER

CC ID: 331113
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Upper boundary of meshsize range.

General Data Type: NUMBER

MESHSIZE_DEFAULT

CC ID: 331114
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Default used when meshsize not provided.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 33343
GUID: gov.noaa.nmfs.inport:33343
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-06 08:24+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