05_berlinmod_disassemble.c File Reference

A simple program that reads from a CSV file synthetic trip data in Brussels generated by the MobilityDB-BerlinMOD generator, https://github.com/MobilityDB/MobilityDB-BerlinMOD disassembles the trips into individual observations, and write them in a CSV file named "berlinmod_instants.csv" ordered by timestamp. More...

#include <stdio.h>
#include <stdlib.h>
#include <time.h>
#include <meos.h>
#include <meos_geo.h>

Data Structures
struct	trip_record

Macros
#define	MAX_LENGTH_DATE   12
#define	MAX_LENGTH_HEADER   1024
#define	MAX_LENGTH_TRIP   400001
	Maximum length in characters of a trip in the input data. More...
#define	MAX_NO_TRIPS   256

Functions
int	main (void)

Detailed Description

A simple program that reads from a CSV file synthetic trip data in Brussels generated by the MobilityDB-BerlinMOD generator, https://github.com/MobilityDB/MobilityDB-BerlinMOD disassembles the trips into individual observations, and write them in a CSV file named "berlinmod_instants.csv" ordered by timestamp.

The input file is

• - trips.csv: 154 trips from 5 cars during 11 days obtained from the generator at scale factor 0.1. The input file has been generated with the following SQL command on the database containing the generated data

  COPY (SELECT tripid, vehid, day, seqno, asHexEWKB(trip) AS trip FROM trips WHERE vehid < 6 ORDER BY tripid) TO '/home/user/src/berlinmod_trips.csv' CSV HEADER;

  In the above file, the coordinates are given in the 3857 coordinate system, https://epsg.io/3857 and the timestamps are given in the Europe/Brussels time zone. This simple program does not cope with erroneous inputs, such as missing fields or invalid values.

The program can be build as follows

gcc -Wall -g -I/usr/local/include -o 05_berlinmod_disassemble 05_berlinmod_disassemble.c -L/usr/local/lib -lmeos