geographicLocation

The geographicLocation table stores geographic location information for network entities. It does this by creating collections of entities at a specific location.

The following table describes the geographicLocation table.

Table 1. geographicLocation table 
Column name Type Constraints Description
altitude Integer  

Vertical height above World Geodetic System WGS84 datum surface (EGM96) at the particular geographical location.
altitudeUnits 11-character string  
Units to use for the altitude.
  • 0 – Meters
  • 1 – Kilometers
  • 2 – Centimeters
  • 3 - Feet
  • 4 – Yards
  • 5 - Miles
  • 6 - Inches
entityId Integer NOT NULL The identifier of a geographical location entity from the entityData table.
latitude Fixed-point decimal (up to 10 digits with 8 to the right of the decimal point)  

Measurement of latitude for this entity. This is the angular distance (north and south) from the equator on the earth's surface; for example, 78.838753. The value of this attribute is determined based on World Geodetic System WGS84 standard.
locationId 64-character string NOT NULL

The location identifier by which the location is know to the end-user.
longitude Fixed-point decimal (up to 11 digits with 8 to the right of the decimal point)  

Measurement of longitude for this entity. This is the angular distance (east and west) from the prime meridian on the earth's surface; for example, 35.832636. The value of this attribute is determined based on World Geodetic System WGS84 standard.
locationDescription 255-character string  

Free-format textual description of location
timezoneOffset 9-character string  

Offset of local time from UTC in format UTC-HH:MM or UTC+HH:MM; for example, UTC+10:30, UTC-6:00.