Skip to main content

Points of interest locations table (poi_locations)

In this section:

The poi_locations table contains details of all POIs (points-of-interest) in the supply chain network; airports, harbors or customer locations. Location groups are constructed from aggregating similar customer locations that share the same geographical location, and logistical locations such as airports or harbors from the Open Street Map project.

Data type legend

Data type

Description

bigint

Big integer, large number.

decimal

Number with decimal point, in 11,7 format: 11 digits before decimal point, 7 digits after decimal point.

double

Double; 8-byte double-precision floating point numbers.

hex

Hexadecimal value. See more. HIDDEN AS IT WAS ONLY USED FOR logger_id, WHICH NOW USES STRING

int

Integer, whole number.

string

String, text.

ts

Timestamp, in YYYY-MM-DDTHH:MM:SSZ format.

Table 40. poi_locations table

Item

Data type

Description

location_group_name

string

Name of location group in location_groups table.

See Location groups table (location_groups).

location_group_id

bigint

Unique identifier of location group in location_groups table.

See Location groups table (location_groups).

country_code

string

Code for country where point of interest is located.

location_type

string

Type of location, as configured by customer, but typically will include:

latitude

double

Latitude of the point of interest location, in the World Geodetic System 1984 (WGS 84) standard format.

longitude

double

Longitude of the point of interest location, in the World Geodetic System 1984 (WGS 84) standard format.