The technical architecture is characterised by a combination of modern and established frameworks and standards. The focus is on simplicity, robustness and modification for the specific application.
Architectural image
Backend Trajectory Trace Traffic Signals Camera with edge computing Sensor { tracking_id: int, time: date-time, class: int, long: float, lat: float, velocity: float, heading: float, ... } MQTT Data Bus Cache and enrich Data Database entities events API for historical and live data Web Application subscriptions for live data (dynamic/static objects and events) historical data provider API GPS tracker { sensing_id: int, time: date-time, sensor_class: str, state: json, ... } user interface user creates & manages sensor data Dynamic Object Message Static Object Message https://city.app.sdk-cloud.de/ Predic tion { event_id: int, time: date-time, event_class: str, state: json, ... } Event Message Dynamic Object Table - 1 row per entity - trajectory compressed Event Table trajectories Static Object Tables - Sensors - Sensordata Location Table User Table OpenFreeMap
Data schema