/home/esteban/src/MobilityDB/meos/examples/meos_disassemble_berlinmod.txt File Reference

Functions
	COPY (SELECT tripid, vehid, day, seqno, asHexEWKB(trip) AS trip FROM trips) TO '/home/esteban/src/MobilityDB/meos/examples/trips.csv' CSV HEADER
INSERT INTO trips SELECT	tgeompoint_contseq (array_agg(tgeompoint(geom, t) ORDER BY t)) AS trip FROM trip_instants GROUP BY tripid
CREATE TABLE	trip_instants (tripid int NOT NULL, vehid int NOT NULL, day date NOT NULL, seqno int NOT NULL, geom geometry NOT NULL, t timestamptz NOT NULL)
CREATE TABLE	trips (tripid int NOT NULL, vehid int NOT NULL, day date NOT NULL, seqno int NOT NULL, trip tgeompoint NOT NULL)

Variables
INSERT INTO trips SELECT	day
COPY trip_instants FROM home esteban src MobilityDB meos examples trip_instants csv CSV	HEADER
INSERT INTO trips SELECT	seqno
INSERT INTO trips SELECT	tripid
INSERT INTO trips SELECT	vehid