Skip to main content

Shipment_geolocations table

In this section:

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

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 3. Shipment_geolocations

Item

Data type

Description

shipment_reference

  • n/a

string

Primary key. Foreign key.

logger_id

  • n/a

string

Primary key.

timestamp

  • n/a

ts

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

Primary key.

latitude

  • n/a

double

Latitude coordinates for the measurement.

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

longitude

  • n/a

double

Longitude coordinates for the measurement.

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

accuracy_in_meters

  • n/a

int

Accuracy of the location measurement, in meters.