MobilityDB Workshop

Mahmoud SAKR

Université libre de Bruxelles, Belgium

Esteban ZIMÁNYI

Université libre de Bruxelles, Belgium

Abstract

Every module in this workshop illustrates a usage scenario of MobilityDB. The data sets and the tools are described inside each of the modules. Eventually, additional modules will be added to discover more MobilityDB features.

While this workshop illustrates the usage of MobilityDB functions, it does not explain them in detail. If you need help concerning the functions of MobilityDB, please refer to the documentation.

If you have questions, ideas, comments, etc., please contact me on mahmoud.sakr@ulb.ac.be.


Table of Contents

1. Managing Ship Trajectories (AIS)
Contents
Data
Tools
Preparing the Database
Loading the Data
Constructing Trajectories
Basic Data Exploration
Analyzing the Trajectories
2. Managing GTFS Data
Loading GTFS Data in PostgreSQL
Transforming GTFS Data for MobilityDB
3. Managing Google Location History
Loading Google Location History Data
4. Managing GPX Data
Loading GPX Data

List of Figures

1.1. Visualizing the input points
1.2. Visualizing the ship trajectories
1.3. Visualizing trips with abnormal lengths
1.4. Ship trajectories after filtering
1.5. Ship trajectories with big difference between speed(Trip) and SOG
1.6. Ship trajectories with big difference between azimuth(Trip) and COG
1.7. A sample ship trajectory between Rødby and Puttgarden
1.8. All ferries between Rødby and Puttgarden
1.9. Ship that come closer than 300 meters to one another
1.10. A zoom-in on a dangerous approach
1.11. Another dangerous approach
2.1. Visualization of the routes and stops for the GTFS data from Brussels.
3.1. Visualization of the Google location history loaded into MobilityDB.

List of Tables

1.1. AIS columns