Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > U.S. Virgin Islands Commercial Landings Statist... >

Table: AREA_CODE_LOOKUP_25X25_VI

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:29952  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

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

Description

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

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		The numeric code for the 2.5x2.5 area grid as it exists in the TIP data. Primary key.
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.
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
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.
JURISDICTION
VARCHAR2 		Who has jurisdiction over the fishing area?
LAT_DEGREES
NUMBER 		The latitude in degrees for the southeast corner of the area grid.
LAT_MIN
NUMBER 		The latitude in minutes for the southeast corner of the area grid.
LAT_SEC
NUMBER 		The latitude in seconds for the southeast corner of the area grid.
LONG_DEG
NUMBER 		The longitude in degrees for the southeast corner of the area grid.
LONG_MIN
NUMBER 		The longitude in minutes for the southeast corner of the area grid.
LONG_SEC
NUMBER 		The longitude in seconds for the southeast corner of the area grid.
LAT_HEM
VARCHAR2 		Always North for these data
LONG_HEM
VARCHAR2 		Aways West for these data.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

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: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06