Downtime Notice: Thursday, May 29 @ 2:00pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 6.0.2. Downtime Schedule May 29, 2025 2:00pm - 3:00pm Eastern / 11:00am - 12:00pm Pacific / 8:00am - 9:00am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheri...
View All
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_LOCATION_LATLONG

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

Summary

Abstract

Table Of Valid Location Codes

Description

Table Of Valid Location Codes

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		Sequential Key
LOCATION_NAME
VARCHAR2 		Location Name
LOCALITY_1
VARCHAR2 		Locality One Description (Most specific Locality Description)
LOCALITY_2
VARCHAR2 		Locality Two Description (Next most descriptive locality description)
LOCALITY_3
VARCHAR2 		Locality Three Information (most gernal locality description. It is often at the US stete or country level)
LATITUDE
NUMBER 		Specified Latitude
LONGITUDE
NUMBER 		Specified Longitude

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

Table Of Valid Location Codes
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 Valid Location Codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ID NUMBER Sequential Key
100
 LOCATION_NAME VARCHAR2 Location Name
100
 LOCALITY_1 VARCHAR2 Locality One Description (Most specific Locality Description)
100
 LOCALITY_2 VARCHAR2 Locality Two Description (Next most descriptive locality description)
100
 LOCALITY_3 VARCHAR2 Locality Three Information (most gernal locality description. It is often at the US stete or country level)
100
 LATITUDE NUMBER Specified Latitude
100
 LONGITUDE NUMBER Specified Longitude

Attribute Details

ID

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

Sequential Key
General Data Type: NUMBER

LOCATION_NAME

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

Location Name
General Data Type: VARCHAR2

LOCALITY_1

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

Locality One Description (Most specific Locality Description)
General Data Type: VARCHAR2

LOCALITY_2

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

Locality Two Description (Next most descriptive locality description)
General Data Type: VARCHAR2

LOCALITY_3

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

Locality Three Information (most gernal locality description. It is often at the US stete or country level)
General Data Type: VARCHAR2

LATITUDE

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

Specified Latitude
General Data Type: NUMBER

LONGITUDE

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

Specified Longitude
General Data Type: NUMBER

Catalog Details

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