2026-07-01
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. A binding 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).
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. Set and Span Types
- 3. Bounding Box Types
- 4. Temporal Types (Part 1)
- 5. Temporal Types (Part 2)
- 6. Temporal Alphanumeric Types
- 7. Temporal Geometry Types (Part 1)
- 8. Temporal Geometry Types (Part 2)
- 9. Temporal Types: Analytics Operations
- 10. Temporal Types: Aggregation and Indexing
- 11. Temporal Poses
- 12. Temporal Network Points
- Static Network Types
- Temporal Network Points
- Validity of Temporal Network Points
- Constructors
- Conversions
- MF-JSON Input and Output
- Accessors
- Transformations
- Modifications
- Restrictions
- Distance Operations
- Spatial Operations
- Bounding Box Operations
- Spatial Relationships
- Comparisons
- Aggregations
- Indexing
- Aggregation
- Production guidance
- 13. Temporal Circular Buffers
- 14. Temporal Rigid Geometries
- 15. JSON Types in MobilityDB
- 16. Temporal H3 Cell Indices
- 17. Temporal QUADBIN Cell Indices
- 18. Temporal Point Clouds
- Quickstart
- Static Types
pcpointandpcpatch - Set Types
pcpointsetandpcpatchset - Bounding Box
tpcbox - Temporal Type
tpcpoint - Temporal Type
tpcpatch - Indexes
- Aggregations
- Binary representation and portability
- MF-JSON output
- PDAL integration:
readers.tpcpatchandwriters.tpcpatch - PCL bridge: SQL-callable filters and registration
- Caveats
- 19. Raster Sampling
- A. MobilityDB Reference
- 20. Portable Named-Function Dialect
- B. Synthetic Data Generator
List of Figures
- 3.1. Multiresolution grid on Brussels data obtained using the BerlinMOD generator. Each cell contains at most 10,000 (left) and 1,000 (right) instants across the entire simulation period (four days in this case). On the left, we can see the high density of the traffic in the ring around Brussels, while on the right we can see other main axes in the city.
- 5.1. Insert operation for temporal values.
- 5.2. Update and delete operation for temporal values.
- 5.3. Modification operations for temporal tables in SQL
- 7.1. Hierarchy of spatiotemporal types in MobilityDB.
- 7.2. Illustration of the use of the
tgeompoint(top) and thetgeometry(bottom) types for modelling the trajectory and the wind swath of tropical storms in 2024. - 7.3. Visualizing the speed of a moving object using a color ramp in QGIS.
- 9.1. Difference between the spatial and the synchronous distance.
- 9.2. Sampling of temporal floats with discrete, step, and linear interpolation.
- 9.3. Changing the precision of temporal floats with discrete, step, and linear interpolation.
- 9.4. Multidimensional tiling for temporal floats.
- 13.1. Illustration of the use of the
tcbuffertype for modelling the circular buffer around the wind swath of tropical storms in 2024.