The 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.
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