Vai al contenuto

Data integration platform for the Smart City

Technologies and techniques to integrate, normalise and visualise urban data with IoT, connector-based middleware, REST APIs, MQTT and dynamic geographic dashboards

Subjects involved

Municipality of Parma (public administration), things2i S.r.l. (solution provider)

Benefits

A single view of city data, instead of separate systems for each service. Integration of heterogeneous “vertical” systems without replacing them. Continuous monitoring of mobility, environment and water resources, also through a synthetic sustainability indicator. The platform can grow over time by adding new application areas (“pillars”).

city2i

The Challenge

The problem was the fragmentation of urban data. Mobility, environmental monitoring, the water network, LoRaWAN networks and other IoT systems or external software were managed by different platforms, often from different suppliers and with different protocols. There was no overall view, and the data could not be compared with each other: this made it difficult to use them for decision-making and urban planning.

The Solution

The chosen system was developed by things2i, a company born within the University of Parma ecosystem that designs IoT solutions and software platforms to collect, integrate and make the most of data from sensor networks and heterogeneous systems.

city2i® is a modular platform that acts as middleware between data sources and their users. The system:

  • collects data from the various sources (mobility, environmental monitoring, water, LoRaPark, other IoT networks, external software) through HTTP, MQTT and other protocol connectors;
  • normalises the data and classifies them according to a common taxonomy, then processes them in a dedicated module;
  • makes them available to applications and services through REST APIs over HTTPS, MQTT/MQTTS and WebSocket;
  • manages the node registry, authentication and access control (AAA) and dynamic data visualisation.

Municipal operators use a PHP web portal with a map of the area and a panel organised by thematic “pillars”: park-and-ride car parks, goods loading/unloading, 30 km/h zones, water monitoring, cycle paths, noise pollution. The interface is set up through dynamic configuration files, so adding a new area requires no code development.

The main results:

  • Integrated view of the area (data from several urban services on a single map),
  • Interoperability (integration of existing systems without having to replace them),
  • Scalability (new pillars and new data sources added in a modular way).

References:

L. Belli, L. Davoli and G. Ferrari, “Smart city as an urban intelligent digital system: the case of Parma,” Computer, vol. 56, no. 7, pp. 106-109, July 2023. DOI: 10.1109/MC.2023.3267245.
L. Davoli, L. Belli, A. Dall’Olio, F. Di Nocera, P. Adorni, A. Cantelli, G. Ferrari, “Data integration in a Smart City: a real case,” book chapter in Springer book, “The City Project” book series, 2023, to appear.
L. Belli, A. Cilfone, L. Davoli, G. Ferrari, P. Adorni, F. Di Nocera, A. Dall’Olio, C. Pellegrini, M. Mordacci, and E. Bertolotti, “IoT-enabled smart sustainable cities: challenges and approaches,” Smart Cities, vol. 3, no. 3, pp. 1039-1071, 2020. DOI: 10.3390/smartcities3030052.

city2i platform diagram

Ecosystem partners involved

things2i

things2i is a spin-off company of the University of Parma dedicated to the Internet of Things (IoT) and…

Innovation enablerInnovative Startup / SMETech provider

Parma (PR)

View profile

Are you interested in adopting this methodology?