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