Metadata Rubric

100%

6 / 6

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

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

	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.

Name

Type

Description

100

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