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.
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	Unique identifier for shipment, as provided by customer when shipment was created. Primary key. Foreign key.
logger_id	string	Unique identifier of logger. This is the bar code value assigned to this logger from Controlant. The bar code value is printed on one side of the logger along with the bar code. 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.

Would you like to provide feedback? Just click here to suggest edits.