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

Summary

Abstract

Observer Fishery Management Locations Support Table used to identify U.S./Canada Management Area and U.S./Canada Haddock SAP.

Description

Observer Fishery Management Locations Support Table used to identify U.S./Canada Management Area and U.S./Canada Haddock SAP.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
LATDEG
VARCHAR2
Two-character latitude degrees -- all positive integers
LONDEG
VARCHAR2
2-character longitude -- all positive integers
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.
LOC
VARCHAR2
6 character location: 2 char lat || 2-char lon ||2-char ten minute square
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.
USCANMGT
VARCHAR2
U.S./ Canada Management Area values: E (eastern) W (western)
EHADSAP
VARCHAR2
Eastern U.S./ Canada Area Haddock SAP values: E or null

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: OBMGTLOC
Short Name: OBMGTLOC
Status: Completed
Abstract:

Observer Fishery Management Locations Support Table used to identify U.S./Canada Management Area and U.S./Canada Haddock SAP.

Notes:

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

Entity Information

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

Observer Fishery Management Locations Support Table used to identify U.S./Canada Management Area and U.S./Canada Haddock SAP.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
LATDEG VARCHAR2 Two-character latitude degrees -- all positive integers
100
LONDEG VARCHAR2 2-character longitude -- all positive integers
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
LOC VARCHAR2 6 character location: 2 char lat || 2-char lon ||2-char ten minute square
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
USCANMGT VARCHAR2 U.S./ Canada Management Area values: E (eastern) W (western)
100
EHADSAP VARCHAR2 Eastern U.S./ Canada Area Haddock SAP values: E or null

Attribute Details

LATDEG

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

Two-character latitude degrees -- all positive integers

General Data Type: VARCHAR2

LONDEG

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

2-character longitude -- all positive integers

General Data Type: VARCHAR2

TENMSQ

CC ID: 331117
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
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

LOC

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

6 character location: 2 char lat || 2-char lon ||2-char ten minute square

General Data Type: VARCHAR2

AREA

CC ID: 331119
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
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

USCANMGT

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

U.S./ Canada Management Area values: E (eastern) W (western)

General Data Type: VARCHAR2

EHADSAP

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

Eastern U.S./ Canada Area Haddock SAP values: E or null

General Data Type: VARCHAR2

Catalog Details

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