MobilityDB 1.0 User's Manual

Esteban Zimányi

Université libre de Bruxelles, Belgium

07.01.2020

Abstract

MobilityDB is an extension to the PostgreSQL database system and its spatial extension PostGIS. It allows temporal and spatio-temporal objects to be stored in the database, that is, objects whose attribute values and/or location evolves in time. MobilityDB includes functions for analysis and processing of temporal and spatio-temporal objects and provides support for GiST and SP-GiST indexes. MobilityDB is open source and its code is available on Github. An adapter for the Python programming language is also available on Github.

MobilityDB is developed by the Computer & Decision Engineering Department of the Université Libre de Bruxelles (ULB) under the direction of Prof. Esteban Zimányi. ULB is an OGC Associate Member and member of the OGC Moving Feature Standard Working Group (MF-SWG).

This is the manual for MobilityDB v1.0. The MobilityDB Manual is licensed under a Creative Commons Attribution-Share Alike 3.0 License 3. Feel free to use this material any way you like, but we ask that you attribute credit to the MobilityDB Project and wherever possible, a link back to MobilityDB.


Table of Contents

1. Introduction
Project Steering Committee
Other Code Contributors
Corporate Sponsors
Licensing
Installation
Short Version
Get the Sources
Enabling the Database
Dependencies
Configuring
Build and Install
Testing
Support
Reporting Problems
Mailing Lists
2. Time Types and Range Types
Functions and Operators for Time Types and Range Types
Constructor Functions
Casting
Accessor Functions
Comparison Operators
Set Operators
Topological Operators
Relative Position Operators
Indexing of Time Types
3. Temporal Types
Examples of Temporal Types
Validity of Temporal Types
4. Manipulating Box Types
Input/Output of Box Types
Constructor Functions
Casting
Accessor Functions
Modification Functions
Spatial Reference System Functions
Comparison Operators
Set Operators
Topological Operators
Relative Position Operators
Indexing of Box Types
5. Manipulating Temporal Types
Input/Output of Temporal Types
Constructor Functions
Casting
Transformation Functions
Accessor Functions
Spatial Functions
Restriction Functions
Difference Functions
Comparison Operators
Ever and Always Comparison Operators
Temporal Comparison Operators
Mathematical Functions and Operators
Boolean Operators
Text Functions and Operators
Bounding Box Operators
Distance Operators
Topological Relationships for Temporal Points
Possible Spatial Relationships
Temporal Spatial Relationships
Aggregate Functions for Temporal Types
Utility Functions
Indexing of Temporal Types
Statistics and Selectivity for Temporal Types
Statistics Collection
Selectivity Estimation of Operators
Index
A. MobilityDB Reference
Functions and Operators for Time Types and Range Types
Constructor Functions
Casting
Accessor Functions
Comparison Operators
Set Operators
Topological and Relative Position Operators
Functions and Operators for Box Types
Constructor Functions
Casting
Accessor Functions
Modification Functions
Spatial Reference System Functions
Comparison Operators
Set Operators
Topological Operators
Relative Position Operators
Functions and Operators for Temporal Types
Constructor Functions
Casting
Transformation Functions
Accessor Functions
Spatial Functions
Restriction Functions
Difference Functions
Comparison Operators
Ever and Always Comparison Operators
Temporal Comparison Operators
Mathematical Functions and Operators
Boolean Operators
Text Functions and Operators
Distance Operators
Spatial Relationships for Temporal Points
Aggregate Functions for Temporal Types
Utility Functions

List of Figures

5.1. Visualizing the speed of a moving object using a color ramp in QGIS.