Geolocation of excursions table (shipment_logger_excursion_geolocations)
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 | Description |
|---|---|
bigint | Big integer, large number. |
decimal | Number with decimal point, in |
double | Double; 8-byte double-precision floating point numbers. |
int | Integer, whole number. |
string | String, text. |
ts | Timestamp, in |
Item | Data type | Description |
|---|---|---|
pois_legs_id | int | Unique identifier for point of interest or leg, as found in table 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 |
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. NoteA 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. NoteA 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 NoteA device location signal indicates the device woke up and connected to the Controlant Cloud Platform. |