Table: CTS_LOCATION_LATLONG
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7055 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table Of Valid Location Codes
DescriptionTable 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
![]() |
![]() |
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
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
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
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
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
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
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
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 |