MobilityDB is an open source software program that adds support for temporal and spatio-temporal objects to the PostgreSQL object-relational database and its spatial extension PostGIS. MobilityDB follows the Moving Features specification from the Open Geospatial Consortium (OGC).

Technically, MobilityDB is implemented as a PostgreSQL external extension.

MobilityDB is developed by the Computer & Decision Engineering Department of the Université Libre de Bruxelles (ULB) under the direction of Prof. Esteban Zimányi.

• Time types Period, PeriodSet, and TimestampSet which, in addition of the the TimestampTz type provided by PostgreSQL, are used to represent time spans.
• Temporal types tbool, tint, tfloat, and ttext which are based on the bool, int, float, and text types provided by PostgreSQL and are used to represent basic types that evolve on time.
• Spatio-temporal types tgeompoint and tgeogpoint which are based on the geometry and geography types provided by PostGIS (restricted to 2D or 3D points) and are used to represent points that evolve on time.
• Range types intrange and floatrange which are used to represent ranges of int and float values.

All these types have associated an extensive set of functions and operators. GiST and SP-GIST index support for these types are also provided.

The extension is under development. We are planning to release the first version in late 2019.

• Linux (other UNIX-like systems may work, but remain untested)
• PostgreSQL == 11
• CMake >= 3.1
• PostGIS == 2.5

Here is the gist:

$ git clone https://github.com/ULB-CoDE-WIT/MobilityDB
$ mkdir MobilityDB/build
$ cd MobilityDB/build
$ cmake ..
$ make
$ sudo make install
$ psql -c 'CREATE EXTENSION MobilityDB CASCADE'

You should also set the following in postgresql.conf:

shared_preload_libraries = 'postgis-2.5'
max_locks_per_transaction = 128

Please report any issues at the address

https://github.com/ULB-CoDE-WIT/MobilityDB/issues

HTML: https://docs.mobilitydb.com/nightly/

PDF: https://docs.mobilitydb.com/nightly/mobilitydb.pdf

EPUB: https://docs.mobilitydb.com/nightly/mobilitydb.epub

• Esteban Zimányi, Mahmoud Sakr, Arthur Lesuisse, Mohamed Bakli, MobilityDB: A Mainstream Moving Object Database System. In Proc. of the 16th International Symposium on Spatial and Temporal Databases, SSTD 2019.

• Alejandro A. Vaisman, Esteban Zimányi: Mobility Data Warehouses. ISPRS International Journal of Geo-Information, 8(4): 170, 2019.

• MobilityDB: A PostgreSQL extension for mobility data management, PGConf.Russia, 2019.

MobilityDB is provided under the PostgreSQL license.