29952
Table: AREA_CODE_LOOKUP_25X25_VI
AREA_CODE_LOOKUP_25X25_VI
Entity
Published / External
1920
U.S. Virgin Islands Commercial Landings Statistics 1974 and more recent in compatible format with Accumulated Landings System (ALS) data
Data Set
Completed
Lookup table for USVI 2.5x2.5 minute fishing area grids as described in TIP and on the CCL landings map.
Loaded by batch 7906, 12-22-2015 14:11
Data Table
Yes
ALS
Lookup table for USVI 2.5x2.5 minute fishing area grids as described in TIP and on the CCL landings map.
1
ID
NUMBER
22
No
No
8
2
Active
The numeric code for the 2.5x2.5 area grid as it exists in the TIP data. Primary key.
NUMBER
2
AREA_CODE
VARCHAR2
4
No
No
Active
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.
VARCHAR2
3
STATUS
VARCHAR2
30
No
No
Active
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
VARCHAR2
4
AREA_NAME
VARCHAR2
30
No
No
Active
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.
VARCHAR2
5
JURISDICTION
VARCHAR2
20
No
No
Active
Who has jurisdiction over the fishing area?
VARCHAR2
6
LAT_DEGREES
NUMBER
22
No
No
2
0
Active
The latitude in degrees for the southeast corner of the area grid.
NUMBER
7
LAT_MIN
NUMBER
22
No
No
2
0
Active
The latitude in minutes for the southeast corner of the area grid.
NUMBER
8
LAT_SEC
NUMBER
22
No
No
2
0
Active
The latitude in seconds for the southeast corner of the area grid.
NUMBER
9
LONG_DEG
NUMBER
22
No
No
2
0
Active
The longitude in degrees for the southeast corner of the area grid.
NUMBER
10
LONG_MIN
NUMBER
22
No
No
2
0
Active
The longitude in minutes for the southeast corner of the area grid.
NUMBER
11
LONG_SEC
NUMBER
22
No
No
2
0
Active
The longitude in seconds for the southeast corner of the area grid.
NUMBER
12
LAT_HEM
VARCHAR2
1
No
No
Active
Always North for these data
VARCHAR2
13
LONG_HEM
VARCHAR2
1
No
No
Active
Aways West for these data.
VARCHAR2
gov.noaa.nmfs.inport:29952
Joshua Bennett
2015-12-22T14:11:37
SysAdmin InPortAdmin
2022-08-09T17:11:13
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06