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

Summary

Abstract

Commercial Fisheries Location to Area Translation Table. Materialized view of the NEFSC table CFDBS.LOC2AREAS

Description

Commercial Fisheries Location to Area Translation Table. Materialized view of the NEFSC table CFDBS.LOC2AREAS

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
LATDEG
VARCHAR2
The degrees (dd) portion of the latitude.
LONDEG
VARCHAR2
The degrees (dd) portion of the longitude.
TENMSQ
VARCHAR2
The location code for a ten minute square block within a latitude/longitude degree square; The first digit represents the longitude minute range, the second digit respresents the latitude minute range. 00=unknown.
LOC
VARCHAR2
The location code designates the center of a ten minute square block within a square degree. It is made up of the latitude and longitude degrees and the ten minute square code. The location code is used to assign a Statistical Area to a fishing trip.
QDSQ
VARCHAR2
The location code of the center of one quarter of a square degree. The 5th digit is code as follow: 1= 15 min lat, 15 min lon; 2 = 15 min lat, 45 min lon; 3 = 45 min lat,15 min lon; 4 = 45 min lat,45 min lon. 0 = unknown.
NEMAREA
VARCHAR2
The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data.
AREA
VARCHAR2
The Northwest Atlantic Fisheries Organization (NAFO) statistical area code.
FZONE
VARCHAR2
The fishing zone in which sample was taken: 0 = inside coastal boundary (NEMFIS only); 1 = within 3 miles of continental U.S.; 2 = between 3 and 12 miles off the continental U.S.; 3 = more than 12 miles off continental U.S.; 4 = off foreign shores or in international waters. blank/null=Unknown.

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

Commercial Fisheries Location to Area Translation Table. Materialized view of the NEFSC table CFDBS.LOC2AREAS

Notes:

Loaded by batch 9209, 08-23-2016 08:38

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FVTR
Description:

Commercial Fisheries Location to Area Translation Table. Materialized view of the NEFSC table CFDBS.LOC2AREAS

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
LATDEG VARCHAR2 The degrees (dd) portion of the latitude.
100
LONDEG VARCHAR2 The degrees (dd) portion of the longitude.
100
TENMSQ VARCHAR2 The location code for a ten minute square block within a latitude/longitude degree square; The first digit represents the longitude minute range, the second digit respresents the latitude minute range. 00=unknown.
100
LOC VARCHAR2 The location code designates the center of a ten minute square block within a square degree. It is made up of the latitude and longitude degrees and the ten minute square code. The location code is used to assign a Statistical Area to a fishing trip.
100
QDSQ VARCHAR2 The location code of the center of one quarter of a square degree. The 5th digit is code as follow: 1= 15 min lat, 15 min lon; 2 = 15 min lat, 45 min lon; 3 = 45 min lat,15 min lon; 4 = 45 min lat,45 min lon. 0 = unknown.
100
NEMAREA VARCHAR2 The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data.
100
AREA VARCHAR2 The Northwest Atlantic Fisheries Organization (NAFO) statistical area code.
100
FZONE VARCHAR2 The fishing zone in which sample was taken: 0 = inside coastal boundary (NEMFIS only); 1 = within 3 miles of continental U.S.; 2 = between 3 and 12 miles off the continental U.S.; 3 = more than 12 miles off continental U.S.; 4 = off foreign shores or in international waters. blank/null=Unknown.

Attribute Details

LATDEG

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

The degrees (dd) portion of the latitude.

General Data Type: VARCHAR2

LONDEG

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

The degrees (dd) portion of the longitude.

General Data Type: VARCHAR2

TENMSQ

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

The location code for a ten minute square block within a latitude/longitude degree square; The first digit represents the longitude minute range, the second digit respresents the latitude minute range. 00=unknown.

General Data Type: VARCHAR2

LOC

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

The location code designates the center of a ten minute square block within a square degree. It is made up of the latitude and longitude degrees and the ten minute square code. The location code is used to assign a Statistical Area to a fishing trip.

General Data Type: VARCHAR2

QDSQ

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

The location code of the center of one quarter of a square degree. The 5th digit is code as follow: 1= 15 min lat, 15 min lon; 2 = 15 min lat, 45 min lon; 3 = 45 min lat,15 min lon; 4 = 45 min lat,45 min lon. 0 = unknown.

General Data Type: VARCHAR2

NEMAREA

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

The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data.

General Data Type: VARCHAR2

AREA

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

The Northwest Atlantic Fisheries Organization (NAFO) statistical area code.

General Data Type: VARCHAR2

FZONE

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

The fishing zone in which sample was taken: 0 = inside coastal boundary (NEMFIS only); 1 = within 3 miles of continental U.S.; 2 = between 3 and 12 miles off the continental U.S.; 3 = more than 12 miles off continental U.S.; 4 = off foreign shores or in international waters. blank/null=Unknown.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 34393
GUID: gov.noaa.nmfs.inport:34393
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-23 08:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-23
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-23