06_berlinmod_clip.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 and generate statics about the Brussels communes (or municipalities) traversed by the trips. More...

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

Data Structures
struct	commune_record
struct	region_record
struct	trip_record

Macros
#define	MAX_LEN_DATE   12
#define	MAX_LEN_GEOM   100001
#define	MAX_LEN_HEADER   1024
#define	MAX_LEN_MATRIX   65536
#define	MAX_LEN_NAME   101
#define	MAX_LEN_TRIP   400001
	Maximum length in characters of a trip in the input data. More...
#define	NUM_COMMUNES   19
#define	NUM_VEHICLES   5

Functions
int	main (void)
void	matrix_print (double distance[NUM_VEHICLES+1][NUM_COMMUNES+3], bool all_communes)
	Print a distance matrix in tabular form. More...
int	read_brussels_region (void)
int	read_communes (void)

Variables
region_record	brussels_region
commune_record	communes [NUM_COMMUNES]
char	date_buffer [MAX_LEN_DATE]
double	distance [NUM_VEHICLES+1][NUM_COMMUNES+3] = {0}
char	geo_buffer [MAX_LEN_GEOM]
char	header_buffer [MAX_LEN_HEADER]
char	trip_buffer [MAX_LEN_TRIP]

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 and generate statics about the Brussels communes (or municipalities) traversed by the trips.

The input files are

• communes.csv: data from the 19 communes composing Brussels obtained from OSM and publicly available statistical data
• brussels_region.csv: geometry of the Brussels region obtained from OSM. It is the spatial union of the 19 communes
• 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 files, 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 06_berlinmod_clip 06_berlinmod_clip.c -L/usr/local/lib -lmeos