Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Population Biology Branch > Apex Predators Program > Coastal Shark Bottom Longline Survey >

Table: MRLOCATIONS

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:36270 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Location information used to calculate latitude and longitude from a reported location

Description

Location information used to calculate latitude and longitude from a reported location

Entity Type
Data Table

Data Attribute / Type	Description
LOCCD VARCHAR2	Location code.
LOC_DESC VARCHAR2	Location description.
FISHERY_STRING VARCHAR2	Fisheries to which species is affiliated (comma separated list of fishery codes).
ONLAND VARCHAR2	on land (not used).
NOS VARCHAR2	North or south.
EOW VARCHAR2	East or west.
MAPCORRECT FLOAT	Map correct.
COUNTY VARCHAR2	County.
COAST VARCHAR2	Coast.
DOE DATE	Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
UOE VARCHAR2	The Oracle username of the individual who entered the new record.
DOC DATE	Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
UOC VARCHAR2	The Oracle username of the individual who changed the current record.
LAT_DEG VARCHAR2	Latitude degrees. (redacted)
LAT_MIN VARCHAR2	Latitude minutes. (redacted)
LAT_SEC VARCHAR2	Latitude seconds. (redacted)
LON_DEG VARCHAR2	Longitude degrees. (redacted)
LON_MIN VARCHAR2	Longitude minutes. (redacted)
LON_SEC VARCHAR2	Longitude seconds. (redacted)
MRSEQUENCE VARCHAR2	Sequencing for web application select list

Data Attribute / Type

Description

LOCCD
VARCHAR2

Location code.

LOC_DESC
VARCHAR2

Location description.

FISHERY_STRING
VARCHAR2

Fisheries to which species is affiliated (comma separated list of fishery codes).

ONLAND
VARCHAR2

on land (not used).

NOS
VARCHAR2

North or south.

EOW
VARCHAR2

East or west.

MAPCORRECT
FLOAT

Map correct.

COUNTY
VARCHAR2

County.

COAST
VARCHAR2

Coast.

DOE
DATE

Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).

UOE
VARCHAR2

The Oracle username of the individual who entered the new record.

DOC
DATE

Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).

UOC
VARCHAR2

The Oracle username of the individual who changed the current record.

LAT_DEG
VARCHAR2

Latitude degrees. (redacted)

LAT_MIN
VARCHAR2

Latitude minutes. (redacted)

LAT_SEC
VARCHAR2

Latitude seconds. (redacted)

LON_DEG
VARCHAR2

Longitude degrees. (redacted)

LON_MIN
VARCHAR2

Longitude minutes. (redacted)

LON_SEC
VARCHAR2

Longitude seconds. (redacted)

MRSEQUENCE
VARCHAR2

Sequencing for web application select list

No Child Items for this record.

No contact information is available for this record.

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

Title:	Table: MRLOCATIONS
Short Name:	MRLOCATIONS
Status:	Completed
Abstract:	Location information used to calculate latitude and longitude from a reported location
Notes:	Loaded by batch 9651, 01-12-2017 16:35

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	MRDBS
Description:	Location information used to calculate latitude and longitude from a reported location

Attribute Summary

	Name	Type	Description
100	LOCCD	VARCHAR2	Location code.
100	LOC_DESC	VARCHAR2	Location description.
100	FISHERY_STRING	VARCHAR2	Fisheries to which species is affiliated (comma separated list of fishery codes).
100	ONLAND	VARCHAR2	on land (not used).
100	NOS	VARCHAR2	North or south.
100	EOW	VARCHAR2	East or west.
100	MAPCORRECT	FLOAT	Map correct.
100	COUNTY	VARCHAR2	County.
100	COAST	VARCHAR2	Coast.
100	DOE	DATE	Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
100	UOE	VARCHAR2	The Oracle username of the individual who entered the new record.
100	DOC	DATE	Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
100	UOC	VARCHAR2	The Oracle username of the individual who changed the current record.
100	LAT_DEG	VARCHAR2	Latitude degrees. (redacted)
100	LAT_MIN	VARCHAR2	Latitude minutes. (redacted)
100	LAT_SEC	VARCHAR2	Latitude seconds. (redacted)
100	LON_DEG	VARCHAR2	Longitude degrees. (redacted)
100	LON_MIN	VARCHAR2	Longitude minutes. (redacted)
100	LON_SEC	VARCHAR2	Longitude seconds. (redacted)
100	MRSEQUENCE	VARCHAR2	Sequencing for web application select list

Name

Type

Description

100

LOCCD

VARCHAR2

Location code.

100

LOC_DESC

VARCHAR2

Location description.

100

FISHERY_STRING

VARCHAR2

Fisheries to which species is affiliated (comma separated list of fishery codes).

100

ONLAND

VARCHAR2

on land (not used).

100

NOS

VARCHAR2

North or south.

100

EOW

VARCHAR2

East or west.

100

MAPCORRECT

FLOAT

Map correct.

100

COUNTY

VARCHAR2

County.

100

COAST

VARCHAR2

Coast.

100

DOE

DATE

Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).

100

UOE

VARCHAR2

The Oracle username of the individual who entered the new record.

100

DOC

DATE

Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).

100

UOC

VARCHAR2

The Oracle username of the individual who changed the current record.

100

LAT_DEG

VARCHAR2

Latitude degrees. (redacted)

100

LAT_MIN

VARCHAR2

Latitude minutes. (redacted)

100

LAT_SEC

VARCHAR2

Latitude seconds. (redacted)

100

LON_DEG

VARCHAR2

Longitude degrees. (redacted)

100

LON_MIN

VARCHAR2

Longitude minutes. (redacted)

100

LON_SEC

VARCHAR2

Longitude seconds. (redacted)

100

MRSEQUENCE

VARCHAR2

Sequencing for web application select list

Attribute Details

LOCCD

CC ID: 374437

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Location code.
General Data Type:	VARCHAR2

LOC_DESC

CC ID: 374448

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	80
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Location description.
General Data Type:	VARCHAR2

FISHERY_STRING

CC ID: 374450

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Fisheries to which species is affiliated (comma separated list of fishery codes).
General Data Type:	VARCHAR2

ONLAND

CC ID: 374451

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	on land (not used).
General Data Type:	VARCHAR2

NOS

CC ID: 374452

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	North or south.
General Data Type:	VARCHAR2

EOW

CC ID: 374453

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	East or west.
General Data Type:	VARCHAR2

MAPCORRECT

CC ID: 374454

Seq. Order:	7
Data Storage Type:	FLOAT
Max Length:	22
Required:	No
Primary Key:	No
Precision:	126
Status:	Active
Description:	Map correct.
General Data Type:	FLOAT

COUNTY

CC ID: 374455

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	County.
General Data Type:	VARCHAR2

COAST

CC ID: 374456

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Coast.
General Data Type:	VARCHAR2

DOE

CC ID: 374438

Seq. Order:	10
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
General Data Type:	DATE

UOE

CC ID: 374439

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	The Oracle username of the individual who entered the new record.
General Data Type:	VARCHAR2

DOC

CC ID: 374440

Seq. Order:	12
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
General Data Type:	DATE

UOC

CC ID: 374441

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	The Oracle username of the individual who changed the current record.
General Data Type:	VARCHAR2

LAT_DEG

CC ID: 374442

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude degrees. (redacted)
General Data Type:	VARCHAR2

LAT_MIN

CC ID: 374443

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude minutes. (redacted)
General Data Type:	VARCHAR2

LAT_SEC

CC ID: 374444

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude seconds. (redacted)
General Data Type:	VARCHAR2

LON_DEG

CC ID: 374445

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude degrees. (redacted)
General Data Type:	VARCHAR2

LON_MIN

CC ID: 374446

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude minutes. (redacted)
General Data Type:	VARCHAR2

LON_SEC

CC ID: 374447

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude seconds. (redacted)
General Data Type:	VARCHAR2

MRSEQUENCE

CC ID: 374449

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Sequencing for web application select list
General Data Type:	VARCHAR2

Catalog Item ID:	36270
GUID:	gov.noaa.nmfs.inport:36270
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2017-01-12 16:35+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2017-01-12
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2017-01-12
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2018-01-12

Table: MRLOCATIONS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LOCCD

LOC_DESC

FISHERY_STRING

ONLAND

NOS

EOW

MAPCORRECT

COUNTY

COAST

DOE

UOE

DOC

UOC

LAT_DEG

LAT_MIN

LAT_SEC

LON_DEG

LON_MIN

LON_SEC

MRSEQUENCE

Catalog Details