![]() |
MobilityDB 1.3
|
A simple program that reads from the regions.csv file obtained from the BerlinMOD benchmark https://github.com/MobilityDB/MobilityDB-BerlinMOD and applies one of the PostGIS functions ST_ClusterIntersecting
or ST_ClusterWithin
to the entire file.
More...
#include <ctype.h>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <time.h>
#include <meos.h>
#include <meos_geo.h>
Macros | |
#define | CLUSTER_INTERSECTING false |
#define | MAX_LINE_LENGTH 4096 |
#define | MAX_ROWS 100 |
Functions | |
int | main (void) |
A simple program that reads from the regions.csv file obtained from the BerlinMOD benchmark https://github.com/MobilityDB/MobilityDB-BerlinMOD and applies one of the PostGIS functions ST_ClusterIntersecting
or ST_ClusterWithin
to the entire file.
The program corresponds to one of the following SQL queries
or
The program can be build as follows
The program expects the file data/regions.csv
and produces a new file data/regions_new.csv
with a new column cluster added to each geometry. This file can be input in PostgreSQL using the following SQL command, after which it can be visualized with QGIS.