Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: AREA_CODE_LOOKUP_25X25_PR
Short Name: AREA_CODE_LOOKUP_25X25_PR
Status: Completed
Notes:

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

Entity Information

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID NUMBER The numeric area id for the 2.5x2.5 minute grids as coded in the trip interview program area codes. Primary Key.
100
AREA_CODE VARCHAR2 The alpha-numeric codes for the 2.5x2.5 minute grid areas in the Puerto Rico Fishing area map. Foreign key to Puerto Rico Landings area_codes 1-4.
100
STATUS VARCHAR2 The type of fishing area contained in the grid: inland, marine reserve, natural resouce, near-shore, offshore, special fishing zone, or not recorded.
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 What jurisdiction does the area fall within?
100
LATITUDE_DEGREES NUMBER The latitude in degrees for the southeast corner of the area grid.
100
LATITUDE_MINUTES NUMBER The latitude in minutes for the southeast corner of the area grid.
100
LATITUDE_SECONDS NUMBER The latitude in seconds for the southeast corner of the grid.
100
LONGITUDE_DEGREES NUMBER The longitude in degrees for the southeast corner of the grid.
100
LONGITUDE_MINUTES NUMBER The longitude in minutes at the southeast corner of the area grid.
100
LONGITUDE_SECONDS NUMBER The longitude in seconds for the southeast corner of the grid.
100
LAT_HEMI VARCHAR2 Always North for purpose of these data
100
LONG_HEMI VARCHAR2 Always West for the purpose of these data.

Attribute Details

ID

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

The numeric area id for the 2.5x2.5 minute grids as coded in the trip interview program area codes. Primary Key.

General Data Type: NUMBER

AREA_CODE

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

The alpha-numeric codes for the 2.5x2.5 minute grid areas in the Puerto Rico Fishing area map. Foreign key to Puerto Rico Landings area_codes 1-4.

General Data Type: VARCHAR2

STATUS

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

The type of fishing area contained in the grid: inland, marine reserve, natural resouce, near-shore, offshore, special fishing zone, or not recorded.

General Data Type: VARCHAR2

AREA_NAME

CC ID: 267261
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: 267262
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

What jurisdiction does the area fall within?

General Data Type: VARCHAR2

LATITUDE_DEGREES

CC ID: 267263
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

LATITUDE_MINUTES

CC ID: 267264
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

LATITUDE_SECONDS

CC ID: 267265
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 grid.

General Data Type: NUMBER

LONGITUDE_DEGREES

CC ID: 267266
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 grid.

General Data Type: NUMBER

LONGITUDE_MINUTES

CC ID: 267255
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 at the southeast corner of the area grid.

General Data Type: NUMBER

LONGITUDE_SECONDS

CC ID: 267256
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 grid.

General Data Type: NUMBER

LAT_HEMI

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

Always North for purpose of these data

General Data Type: VARCHAR2

LONG_HEMI

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

Always West for the purpose of these data.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 29951
GUID: gov.noaa.nmfs.inport:29951
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