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