Base
Hardened build
minimal ports, security patches applied at build time
PostgreSQL 17 with PostGIS and MobilityDB on Ubuntu 24.04 LTS
Azure
Databases
PostgreSQL with PostGIS and MobilityDB, an open source extension for temporal and spatiotemporal data on moving objects.
Overview
This appliance pairs the PostgreSQL relational database with PostGIS and MobilityDB, extensions that turn the database into a store and analytics engine for moving objects. Instead of holding a position as a single point, a temporal geometry column records how an object moves through space over time, so one row can describe a whole vehicle, vessel or asset trajectory. You then query that trajectory directly: where an object was at a given moment, the path it took over an interval, the distance it travelled, its speed, and how close two objects ever came.
MobilityDB adds temporal types and hundreds of functions and operators on top of PostGIS geometry, and they are indexed, so spatial windows, time slices and nearest approach searches stay fast as the history grows. Because it is all inside PostgreSQL, trajectory analytics sit next to the rest of your relational data and are queried with ordinary SQL and standard clients.
Why the cloudimg image
cloudimg ships PostGIS and MobilityDB already installed and ready, with a demonstration database of vehicle trajectories and a spatiotemporal index already built, so you can ask where a vehicle was at a point in time, or which trajectories crossed a map window, within a minute of first boot. There is no default password to change: on first boot each instance mints its own database passwords and its own TLS certificate into a file only the root user can read, and remote connections are accepted only over TLS. A least privilege application role is provided for your app, separate from the administrator, and a credential guard runs on every boot and stops the database rather than serve a credential that appears in any published example. The paired deployment guide walks through real trajectory queries, and every instance carries 24/7 support.
Common uses
- Storing and querying vehicle, vessel or asset trajectories as first class temporal data
- Answering spatiotemporal questions such as position at a time, path over an interval, and nearest approach
- Running fleet, mobility and IoT movement analytics inside PostgreSQL with standard SQL