Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Fisheries Statistics Division > Observer Programs > Pelagic Longline Observer Program > PELAGIC OBSERVER PROGRAM (POP). Catch/Effort d... >

Table: POP_FISHING_AREAS

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5338 | Updated: June 14, 2024 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

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 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

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

No Child Items for this record.

No contact information is available for this record.

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

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 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

Attribute Summary

	Name	Type	Description
100	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

Name

Type

Description

100

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 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:	Lee M Weinberger
Metadata Record Last Modified:	2024-06-14 13:53+0000
Metadata Record Published:	2024-06-14
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

Table: POP_FISHING_AREAS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

FISHING_AREA_CODE

LAT_DEG_1

LAT_MIN_1

LAT_HEM_1

LONG_DEG_1

LONG_MIN_1

LONG_HEM_1

LAT_DEG_2

LAT_MIN_2

LAT_HEM_2

LONG_DEG_2

LONG_MIN_2

LONG_HEM_2

CREATED_BY_USER_ID

CREATED_DATE

MODIFIED_BY_USER_ID

MODIFIED_DATE

Catalog Details