Postgres 9.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

created_at	latitude	longitude	trip_log_id
2018-10-11T15:16:32.775	52.504873	13.396681	1
2018-10-11T15:16:32.807	52.505225	13.396976	1
2018-10-11T15:16:32.835	52.505372	13.397035	1
2018-10-11T11:22:54.666	52.5242370846803	13.3443558528637	2
2018-10-11T11:22:54.727	52.5242366166393	13.3443558656828	2

SELECT 5

json_agg
[[{"recorded_at" : "2018-10-11T15:16:32.775", "latitude" : 52.504873, "longitude" : 13.396681}, {"recorded_at" : "2018-10-11T15:16:32.807", "latitude" : 52.505225, "longitude" : 13.396976}, {"recorded_at" : "2018-10-11T15:16:32.835", "latitude" : 52.505372, "longitude" : 13.397035}], [{"recorded_at" : "2018-10-11T11:22:54.666", "latitude" : 52.5242370846803, "longitude" : 13.3443558528637}, {"recorded_at" : "2018-10-11T11:22:54.727", "latitude" : 52.5242366166393, "longitude" : 13.3443558656828}]]

json_agg

[[{"recorded_at" : "2018-10-11T15:16:32.775", "latitude" : 52.504873, "longitude" : 13.396681}, {"recorded_at" : "2018-10-11T15:16:32.807", "latitude" : 52.505225, "longitude" : 13.396976}, {"recorded_at" : "2018-10-11T15:16:32.835", "latitude" : 52.505372, "longitude" : 13.397035}], [{"recorded_at" : "2018-10-11T11:22:54.666", "latitude" : 52.5242370846803, "longitude" : 13.3443558528637}, {"recorded_at" : "2018-10-11T11:22:54.727", "latitude" : 52.5242366166393, "longitude" : 13.3443558656828}]]

SELECT 1