Table: FVTR_LOCATION_TO_AREAS
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34393 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Commercial Fisheries Location to Area Translation Table. Materialized view of the NEFSC table CFDBS.LOC2AREAS
DescriptionCommercial 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
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
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
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
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
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
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
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
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
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 |