Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Used to Calculate Fishing Area by entering the code and the Latitude and Longitude Ranges To Use

Description

Used to Calculate Fishing Area by entering the code and the Latitude and Longitude Ranges To Use

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FISHING_AREA_CODE
VARCHAR2
Fishing Area Code
LAT_DEG_1
NUMBER
Higher Value In Latitude Degrees Of Point In Fishing Area Rectangle
LAT_MIN_1
NUMBER
Higher Value In Latitude Minutes Of Point In Fishing Area Rectangle
LAT_HEM_1
VARCHAR2
Higher Value of Latitude Hemisphere Of Point In Fishing Area Rectangle
LONG_DEG_1
NUMBER
HigherValue In Longitude Degrees Of Point In Fishing Area Rectangle
LONG_MIN_1
NUMBER
Higher Value In Longitude Minutes Of Point In Fishing Area Rectangle
LONG_HEM_1
VARCHAR2
HigherValue In Lonitude Hemisphere Of Point In Fishing Area Rectangle
LAT_DEG_2
NUMBER
Lower Value In Latitude Degrees Of Point In Fishing Area Rectangle
LAT_MIN_2
NUMBER
Lower Value In Latitude Minutes Of Point In Fishing Area Rectangle
LAT_HEM_2
VARCHAR2
Lower Value In Latitude Hemisphere Of Point In Fishing Area Rectangle
LONG_DEG_2
NUMBER
Lower Value In Longitude Degrees Of Point In Fishing Area Rectangle
LONG_MIN_2
NUMBER
Lower Value In Longitude Minutes Of Point In Fishing Area Rectangle
LONG_HEM_2
VARCHAR2
Lower Value In Longitude Hemisphere Of Point In Fishing Area Rectangle
CREATED_BY_USER_ID
VARCHAR2
Who created the record
CREATED_DATE
DATE
When the record was created
MODIFIED_BY_USER_ID
VARCHAR2
Who last changed the record
MODIFIED_DATE
DATE
When was the record last changed

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: POP_FISHING_AREAS
Short Name: POP_FISHING_AREAS
Status: Completed
Abstract:

Used to Calculate Fishing Area by entering the code and the Latitude and Longitude Ranges To Use

Notes:

Loaded by batch 1683, 10-12-2007 05:01

Entity Information

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

Used to Calculate Fishing Area by entering the code and the Latitude and Longitude Ranges To Use

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FISHING_AREA_CODE VARCHAR2 Fishing Area Code
100
LAT_DEG_1 NUMBER Higher Value In Latitude Degrees Of Point In Fishing Area Rectangle
100
LAT_MIN_1 NUMBER Higher Value In Latitude Minutes Of Point In Fishing Area Rectangle
100
LAT_HEM_1 VARCHAR2 Higher Value of Latitude Hemisphere Of Point In Fishing Area Rectangle
100
LONG_DEG_1 NUMBER HigherValue In Longitude Degrees Of Point In Fishing Area Rectangle
100
LONG_MIN_1 NUMBER Higher Value In Longitude Minutes Of Point In Fishing Area Rectangle
100
LONG_HEM_1 VARCHAR2 HigherValue In Lonitude Hemisphere Of Point In Fishing Area Rectangle
100
LAT_DEG_2 NUMBER Lower Value In Latitude Degrees Of Point In Fishing Area Rectangle
100
LAT_MIN_2 NUMBER Lower Value In Latitude Minutes Of Point In Fishing Area Rectangle
100
LAT_HEM_2 VARCHAR2 Lower Value In Latitude Hemisphere Of Point In Fishing Area Rectangle
100
LONG_DEG_2 NUMBER Lower Value In Longitude Degrees Of Point In Fishing Area Rectangle
100
LONG_MIN_2 NUMBER Lower Value In Longitude Minutes Of Point In Fishing Area Rectangle
100
LONG_HEM_2 VARCHAR2 Lower Value In Longitude Hemisphere Of Point In Fishing Area Rectangle
100
CREATED_BY_USER_ID VARCHAR2 Who created the record
100
CREATED_DATE DATE When the record was created
100
MODIFIED_BY_USER_ID VARCHAR2 Who last changed the record
100
MODIFIED_DATE DATE When was the record last changed

Attribute Details

FISHING_AREA_CODE

CC ID: 15733
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: Yes
Status: Active
Description:

Fishing Area Code

General Data Type: VARCHAR2

LAT_DEG_1

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

Higher Value In Latitude Degrees Of Point In Fishing Area Rectangle

General Data Type: NUMBER

LAT_MIN_1

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

Higher Value In Latitude Minutes Of Point In Fishing Area Rectangle

General Data Type: NUMBER

LAT_HEM_1

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

Higher Value of Latitude Hemisphere Of Point In Fishing Area Rectangle

General Data Type: VARCHAR2

LONG_DEG_1

CC ID: 15729
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

HigherValue In Longitude Degrees Of Point In Fishing Area Rectangle

General Data Type: NUMBER

LONG_MIN_1

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

Higher Value In Longitude Minutes Of Point In Fishing Area Rectangle

General Data Type: NUMBER

LONG_HEM_1

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

HigherValue In Lonitude Hemisphere Of Point In Fishing Area Rectangle

General Data Type: VARCHAR2

LAT_DEG_2

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

Lower Value In Latitude Degrees Of Point In Fishing Area Rectangle

General Data Type: NUMBER

LAT_MIN_2

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

Lower Value In Latitude Minutes Of Point In Fishing Area Rectangle

General Data Type: NUMBER

LAT_HEM_2

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

Lower Value In Latitude Hemisphere Of Point In Fishing Area Rectangle

General Data Type: VARCHAR2

LONG_DEG_2

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

Lower Value In Longitude Degrees Of Point In Fishing Area Rectangle

General Data Type: NUMBER

LONG_MIN_2

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

Lower Value In Longitude Minutes Of Point In Fishing Area Rectangle

General Data Type: NUMBER

LONG_HEM_2

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

Lower Value In Longitude Hemisphere Of Point In Fishing Area Rectangle

General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

Who created the record

General Data Type: VARCHAR2

CREATED_DATE

CC ID: 15719
Seq. Order: 15
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

When the record was created

General Data Type: DATE

MODIFIED_BY_USER_ID

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

Who last changed the record

General Data Type: VARCHAR2

MODIFIED_DATE

CC ID: 15717
Seq. Order: 17
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

When was the record last changed

General Data Type: DATE

Catalog Details

Catalog Item ID: 5338
GUID: gov.noaa.nmfs.inport:5338
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-12 05:01+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