> For the complete documentation index, see [llms.txt](https://docs.marpledata.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.marpledata.com/docs/marple-insight/setup-and-configuration/data-connection/supported-databases/mireo-spacetime.md).

# Mireo Spacetime

Designed for location-based data, [**Mireo Spacetime**](https://www.mireo.com/spacetime) excels in vehicle tracking and GPS analytics. Marple integrates with default Spacetime tables:

* **st.trip** → to be displayed as datasets
* **st.dsensor & st.csensor** → provide the signal lists and time-series data.
* Queries use standard **SQL**.
* Custom queries can be written for non-standard table structures.

For instance, a default query to retreive datasets would be:

```
select concat('Trip with #', trip.vid) as display_name,
        min(tel.t) / 1000.0 as timestamp_start,
        max(tel.t) / 1000.0 as timestamp_stop,
from st.trip trip
group by bid
order by bid asc
```