Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Cooperative Tagging System > Cooperative Tagging Center (CTC) >

Table: CTS_PAT_LOCATIONS

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7058  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table Of Popup Archival Tag Locations Generated Using the Light-based Geolocation Algorithm.

Description

Table Of Popup Archival Tag Locations Generated Using the Light-based Geolocation Algorithm.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ARGOS_PTT_ID
VARCHAR2 		The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider.
LONGITUDE
NUMBER 		Longitude value estimated using the midday algorithm where the highest light levels were recorded.
YEAR
NUMBER 		(Year Component) Times Of Reading
MONTH
NUMBER 		(Month Component) Times Of Reading
DAY
NUMBER 		(Day Component) Times Of Reading
MIDHOUR
NUMBER 		The hour when the lowest light level was recorded.
MIDMINUTE
NUMBER 		The minute when the lowest light level was recorded.
LATITUDE
NUMBER 		Latitude estimate using the light-based (length of day) geolocation algorithm.
LAT_MSD
FLOAT 		Mean standard deviation for latitude value.
LON_MSD
FLOAT 		Mean standard deviation for longitude value.
LOC_RECORD
NUMBER 		Location Record
GEOM
SDO_GEOMETRY 		The Oracle SDO_Geometry object used to store the point location.
ARCHIVAL_TAG_ID
VARCHAR2 		Archival Tag ID provided by the manufacturer.
ID
NUMBER 		Sequence to uniquely identify each record in this table.

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

Table Of Popup Archival Tag Locations Generated Using the Light-based Geolocation Algorithm.
Notes:

Loaded by batch 2083, 02-22-2008 12:10

Entity Information

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

Table Of Popup Archival Tag Locations Generated Using the Light-based Geolocation Algorithm.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ARGOS_PTT_ID VARCHAR2 The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider.
100
 LONGITUDE NUMBER Longitude value estimated using the midday algorithm where the highest light levels were recorded.
100
 YEAR NUMBER (Year Component) Times Of Reading
100
 MONTH NUMBER (Month Component) Times Of Reading
100
 DAY NUMBER (Day Component) Times Of Reading
100
 MIDHOUR NUMBER The hour when the lowest light level was recorded.
100
 MIDMINUTE NUMBER The minute when the lowest light level was recorded.
100
 LATITUDE NUMBER Latitude estimate using the light-based (length of day) geolocation algorithm.
100
 LAT_MSD FLOAT Mean standard deviation for latitude value.
100
 LON_MSD FLOAT Mean standard deviation for longitude value.
100
 LOC_RECORD NUMBER Location Record
100
 GEOM SDO_GEOMETRY The Oracle SDO_Geometry object used to store the point location.
100
 ARCHIVAL_TAG_ID VARCHAR2 Archival Tag ID provided by the manufacturer.
100
 Primary Key ID NUMBER Sequence to uniquely identify each record in this table.

Attribute Details

ARGOS_PTT_ID

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

The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider.
General Data Type: VARCHAR2

LONGITUDE

CC ID: 25938
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 20
Scale: 14
Status: Active
Description:

Longitude value estimated using the midday algorithm where the highest light levels were recorded.
General Data Type: NUMBER

YEAR

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

(Year Component) Times Of Reading
General Data Type: NUMBER

MONTH

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

(Month Component) Times Of Reading
General Data Type: NUMBER

DAY

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

(Day Component) Times Of Reading
General Data Type: NUMBER

MIDHOUR

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

The hour when the lowest light level was recorded.
General Data Type: NUMBER

MIDMINUTE

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

The minute when the lowest light level was recorded.
General Data Type: NUMBER

LATITUDE

CC ID: 25944
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 20
Scale: 14
Status: Active
Description:

Latitude estimate using the light-based (length of day) geolocation algorithm.
General Data Type: NUMBER

LAT_MSD

CC ID: 25945
Seq. Order: 9
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 126
Status: Active
Description:

Mean standard deviation for latitude value.
General Data Type: FLOAT

LON_MSD

CC ID: 25946
Seq. Order: 10
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 126
Status: Active
Description:

Mean standard deviation for longitude value.
General Data Type: FLOAT

LOC_RECORD

CC ID: 25947
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Location Record
General Data Type: NUMBER

GEOM

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

The Oracle SDO_Geometry object used to store the point location.
General Data Type: SDO_GEOMETRY

ARCHIVAL_TAG_ID

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

Archival Tag ID provided by the manufacturer.
General Data Type: VARCHAR2

ID

CC ID: 25949
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Sequence to uniquely identify each record in this table.
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 7058
GUID: gov.noaa.nmfs.inport:7058
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-22 12:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-05
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-05