Skip to main content

Geolocation of excursions table (shipment_logger_excursion_geolocations)

In this section:

The shipment_logger_excursion_geolocations table collects information on excursions. It contains data on which device measured the excursion, where it happened (in geo co-ordinates), in which country it took place and when. This table is on device level.

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 46. shipment_logger_excursion_geolocations table

Item

Data type

Description

pois_legs_id

int

Unique identifier for point of interest or leg, as found in table shipments_pois_legs.

See Points of interest or legs table (shipments_pois_legs).

Primary key. Foreign key.

shipment_reference

string

Unique identifier of shipment in the Supply Chain Monitoring platform.

logger_id

string

excursion_timestamp

ts

Date and time of the temperature excursion, in YYYY-MM-DDTHH:MM:SSZ format.

excursion_severity

int

Severity of the temperature excursion:

geoping_latitude

double

Latitude of the device location signal that is closest in time to the temperature excursion, in the World Geodetic System 1984 (WGS 84) standard format.

Note

A device location signal indicates the device woke up and connected to the Controlant Cloud Platform.

geoping_longitude

double

Longitude of the device location signal that is closest in time to the temperature excursion, in the World Geodetic System 1984 (WGS 84) standard format.

Note

A device location signal indicates the device woke up and connected to the Controlant Cloud Platform.

geoping_country_code

string

Code for country where the temperature excursion happened.

geoping_timestamp

ts

Date and time of the device location signal that is closest in time to the temperature excursion, in YYYY-MM-DDTHH:MM:SSZ format.

Note

A device location signal indicates the device woke up and connected to the Controlant Cloud Platform.