Mireo Spacetime

Designed for location-based data, Mireo 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