Skip to main content

Controlant Support Center

Shipment_geolocations table

In this section:

The Shipment_geolocations table contains the geolocation history of loggers while assigned to a shipment.

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.

int

Integer, whole number.

string

String, text.

ts

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

Table 3. Shipment_geolocations

Item

Data type

Description

shipment_reference

string

Primary key. Foreign key.

logger_id

string

Primary key.

timestamp

ts

Date and time geolocation measurement was recorded, in YYYY-MM-DDTHH:MM:SSZ format.

Primary key.

latitude

double

Latitude coordinates for the measurement.

Must adhere to the World Geodetic System 1984 (WGS 84) standard.

longitude

double

Longitude coordinates for the measurement.

Must adhere to the World Geodetic System 1984 (WGS 84) standard.

accuracy_in_meters

int

Accuracy of the location measurement, in meters.