Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: AREA_CODE_LOOKUP_25X25_VI
Short Name: AREA_CODE_LOOKUP_25X25_VI
Status: Completed
Abstract:

Lookup table for USVI 2.5x2.5 minute fishing area grids as described in TIP and on the CCL landings map.

Notes:

Loaded by batch 7906, 12-22-2015 14:11

Entity Information

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

Lookup table for USVI 2.5x2.5 minute fishing area grids as described in TIP and on the CCL landings map.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID NUMBER The numeric code for the 2.5x2.5 area grid as it exists in the TIP data. Primary key.
100
AREA_CODE VARCHAR2 The 4 character alpha-numeric code for the 2.5x2.5 minute fishing area grid as it exists in the landings data. Also a primary key.
100
STATUS VARCHAR2 The type of fishing area: MARINE RESERVE AREA WITHIN GRID, NATURAL RESOURCE AREA WITHIN GRId, NEAR-SHORE WATERS, NOT RECORDED, OFFSHORE WATERS, SPECIAL FISHING ZONE
100
AREA_NAME VARCHAR2 The name of the fishing area(s). If the grid is within a fishing area named in the regulations, that area name is supplied here.
100
JURISDICTION VARCHAR2 Who has jurisdiction over the fishing area?
100
LAT_DEGREES NUMBER The latitude in degrees for the southeast corner of the area grid.
100
LAT_MIN NUMBER The latitude in minutes for the southeast corner of the area grid.
100
LAT_SEC NUMBER The latitude in seconds for the southeast corner of the area grid.
100
LONG_DEG NUMBER The longitude in degrees for the southeast corner of the area grid.
100
LONG_MIN NUMBER The longitude in minutes for the southeast corner of the area grid.
100
LONG_SEC NUMBER The longitude in seconds for the southeast corner of the area grid.
100
LAT_HEM VARCHAR2 Always North for these data
100
LONG_HEM VARCHAR2 Aways West for these data.

Attribute Details

ID

CC ID: 267267
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 2
Status: Active
Description:

The numeric code for the 2.5x2.5 area grid as it exists in the TIP data. Primary key.

General Data Type: NUMBER

AREA_CODE

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

The 4 character alpha-numeric code for the 2.5x2.5 minute fishing area grid as it exists in the landings data. Also a primary key.

General Data Type: VARCHAR2

STATUS

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

The type of fishing area: MARINE RESERVE AREA WITHIN GRID, NATURAL RESOURCE AREA WITHIN GRId, NEAR-SHORE WATERS, NOT RECORDED, OFFSHORE WATERS, SPECIAL FISHING ZONE

General Data Type: VARCHAR2

AREA_NAME

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

The name of the fishing area(s). If the grid is within a fishing area named in the regulations, that area name is supplied here.

General Data Type: VARCHAR2

JURISDICTION

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

Who has jurisdiction over the fishing area?

General Data Type: VARCHAR2

LAT_DEGREES

CC ID: 267276
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

The latitude in degrees for the southeast corner of the area grid.

General Data Type: NUMBER

LAT_MIN

CC ID: 267277
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

The latitude in minutes for the southeast corner of the area grid.

General Data Type: NUMBER

LAT_SEC

CC ID: 267278
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

The latitude in seconds for the southeast corner of the area grid.

General Data Type: NUMBER

LONG_DEG

CC ID: 267279
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

The longitude in degrees for the southeast corner of the area grid.

General Data Type: NUMBER

LONG_MIN

CC ID: 267268
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

The longitude in minutes for the southeast corner of the area grid.

General Data Type: NUMBER

LONG_SEC

CC ID: 267269
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

The longitude in seconds for the southeast corner of the area grid.

General Data Type: NUMBER

LAT_HEM

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

Always North for these data

General Data Type: VARCHAR2

LONG_HEM

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

Aways West for these data.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 29952
GUID: gov.noaa.nmfs.inport:29952
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-12-22 14:11+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07