Kuopio city and municipality is situated at the region of Northern Savonia state in Finland. With a population of 119,300, Kuopio is considered to be the ninth-most populous city in Finland and the most populous city in the Eastern Finland province.* The city administration, City of Kuopio aims to ensure well-being for it's residents by representing itself as a knowledge organization and participating with other knowledge organizations to implement and benchmark the best practices across the world for general benefits.
The city administration (Valtuustotalo in Finnish) is situated in Suokatu 42, a building constructed during the 80s. The building has 5 general meeting rooms with full occupancy rate from 9:00 AM to 5:00 PM on weekdays.
This would indirectly determine decisions on renovating the building and inspect and reinstall( if needed) building ventilation system. Each meeting room has IoT sensors that can collect data on temperature, carbon dioxide amount in the room and the humidity level. Office administration uses Microsoft 365 to reserve meeting rooms and collect information about how many participants attending the meetings. However, collecting only sensor data isn't enough to aid this incentive. The data needs to be processed in order to make it interoperable in different systems. Additionally, number of occupants in meeting rooms has to be correlated with the processed data to determine environment condition of these room. The city administration needs these information visualized and represented in such a way that aids them to comprehend the situation and perform faster decision making.
Platform of Trust undertook this pilot project from the city of Kuopio to generate harmonized data collected from the sensors and visualize this data with more readability and comprehensibility. From city of Kuopio, the aim was to test the capabilities of Platform of Trust and determine if this pilot service can be made scalable in order to use in other administrative organization buildings. Platform of Trust integrated Leanheat data sources to harmonize temperature, carbon dioxide and humidity data from the meeting room sensors and visualize the data with the aid of Power BI.
In Platform of Trust, using the discovery functionality in Identity API, room
sensors situated in Valtuustotalo in Kuopio and related
data products connected to the sensors can be identified. As sensors and data products are all added as
identities, a user seeking information about the identity network of Valtuustotalo needs to have
READ access on the related identities in order to be able to discover them. Upon receiving and authenticating the request, Identity API sends corresponding data product links as the response.
The overall usage flow is following:
1. Data consumers, having permission to the Kuopio identity network and interested to use the data, sends request via a registered application in the Platform to the Broker API in Platform of Trust to get actual sensor measurements from the building rooms from relevant data products.
2. Broker API forwards the information to the Leanheat Connector (implemented by Platform of Trust and URL can be obtained from the Data Product)
3. The Connector then requests for related sensor information from Leanheat API.
4. Leanheat API retrieves the sensor information from related sensors in the building rooms.
5. Leanheat API then forwards the historic temperature, carbon dioxide, and humidity data, delimited into time periods, back to the Connector.
6. The Connector, using Platform of Trust Standards, transforms the received values into a standardized format and passes it back to the Broker API.
7. Broker API returns the standardized response (Leanheat measurements) to the application client for consumption.
It is important to remember that different data products have been used to retrieve different data (e.g. temperature, humidity, etc.) from relevant sensors.
Since in this pilot project data is available, it’s logical to say that has to be handled. Platform of Trust offered Leanheat integration in order to receive IoT data and visualization to analyze the data with one of most trending business intelligence tools, Power BI.
Having data in Excel and CSV files regarding number of people participating in the rooms and other relevant data, IoT sensor data is something Kuopio city wanted to integrate in order to see a more detailed thorough analysis of indoor conditions where IoT sensors are enabled. This data is visualized in Power BI, for now.
Data is collected through IoT sensors implemented in each of the five rooms. Connectors being provided, read data extracted from IoT sensors. From there, data is converted to JSON file format specified for Power BI usage, which is provided from Platform of Trust to our customer.
Firstly, all data is saved as JSON file. As this information is visualized in Power BI, an easy approachable access of data is needed. As a result, there is a CSV file for each data type, located in a same folder. There are five different data types that are being collected.
Visualizing measurements given, offers Kuopio city a clearer view of correlations between the data types mentioned above. In order to know if indoor conditions of five rooms are on normal average, research is done regarding to average measurements of indoor conditions in Finland. There are various dependencies, concerning building material components that can describe a measure as good or bad.