2021-09-27.

**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
- 2. Time Types and Range Types
- 3. Temporal Types
- 4. Manipulating Bounding 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
- Multidimensional Tiling
- Distance Operators
- Spatial Relationships
- Aggregate Functions
- Utility Functions
- Indexing of Temporal Types
- Statistics and Selectivity for Temporal Types

- 6. Temporal Network Points
- A. MobilityDB Reference
- Functions and Operators for Time Types and Range Types
- Functions and Operators for Box Types
- 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
- Multidimensional Tiling
- Distance Operators
- Spatial Relationships
- Aggregate Functions
- Utility Functions

- Functions and Operators for Temporal Network Points

- B. Synthetic Data Generator
- Index

**List of Figures**

**List of Tables**