University of Zagreb Faculty of Electrical Engineering and Computing repozitory
| Title (croatian) | Mjerenje varijabli komfora u uredima poslovne zgrade - istraživački podaci projekta DECIDE - Distribuirano upravljanje za dinamičko gospodarenje energijom u složenim sustavima naprednih gradova |
| Author | Vinko Lešić Sveučilište u Zagrebu, Fakultet elektrotehnike i računarstva |
| Author | Mihael Jakšić Sveučilište u Zagrebu, Fakultet elektrotehnike i računarstva |
| Author | Filip Vrbanc Sveučilište u Zagrebu, Fakultet elektrotehnike i računarstva |
| Scientific / art field, discipline and subdiscipline | TECHNICAL SCIENCES Electrical Engineering Automation and Robotics |
| Abstract (croatian) | Skup podataka sadrži mjerenja varijabli komfora za 23 prostorije na FER-u (jedan kat) dobivenih iz IoT "smart home" uređaja:
1. Quad Multisensor koji mjeri temperatura zraka (decimalni broj, °C), osvjetljenje (cijeli broj, Lux), pokret (binarna varijabla tipa Boolean) i otvorenost prozora (binarna varijabla tipa Boolean), te
2. Air Quality Multisensor koji mjeri temperature zraka (decimalni broj, °C), temperaturu rosišta (decimalni broj, °C), udio CO2 (cijeli broj, ppm), udio hlapljivi organski otpad (eng. Volatile organic compounds VOC, cijeli broj, ppm) i vlažnost zraka (decimalni broj, %).
Svaka prostorija ima jedan Air Quality Multisensor uređaj, dok broj postavljenih Quad Multisensor uređaja ovisi o veličini prostorije, ali se u svakoj prostoriji nalazi barem jedan. Mjerenja se uzorkuju svakih 15 minuta, a ovdje pohranjeni podaci odnose se na vremensko razdoblje između 27.7.2022. u 16:50 sati i 22.7.2023. u 13:20. Podaci su izvezeni u .csv format za svaku prostoriju zasebno.
Podaci su prikupljeni u sklopu projekta DECIDE - Distributed Control for Dynamic Energy Management of Complex Systems in Smart Cities (https://www.fer.unizg.hr/decide) kojeg je sufinancirala Hrvatska zaklada za znanost (ugovor br. UIP-2020-02-9636). |
| Abstract (english) | The data set contains measurements of comfort variables for 23 rooms on FER (one floor) obtained from IoT "smart home" devices:
1. Quad Multisensor that measures air temperature (decimal number, °C), lighting (integer, Lux), movement (binary Boolean variable) and window opening (binary Boolean variable), and
2. Air Quality Multisensor that measures air temperatures (decimal number, °C), dew point temperature (decimal number, °C), CO2 content (whole number, ppm), Volatile organic compounds - VOC, (whole number, ppm) and air humidity (decimal number, %).
Each room has one Air Quality Multisensor device, while the number of installed Quad Multisensor devices depends on the size of the room, but there is at least one in each room. Measurements are sampled every 15 minutes, and the data stored here refer to the time period between 27.7.2022. at 16:50 and 22.7.2023. at 13:20. The data is exported to .csv format and separately for each room.
The data entries are collected as part of the DECIDE project - Distributed Control for Dynamic Energy Management of Complex Systems in Smart Cities (https://www.fer.unizg.hr/decide) co-financed by the Croatian Science Foundation (contract no. UIP-2020- 02-9636). |
| Methods (croatian) | Podaci se prikupljaju na virtualnom stroju (eng. virtual machine, VM) na kojem se izvodi Python kôd s postavljenim Python Schedulerom koji svakih 15 minuta šalje zahtjev na REST API kojeg izlaže proizvođač (Zipato). Podaci se dobivaju za svaki određeni senzor (jedan se uređaj sastoji od više senzora, svaki senzor mjeri jedan od parametara u prostoriji). REST API daje odgovor u JSON formatu koji se potom procesira i pohranjuje u PostgreSQL bazu podataka. Baza je dizajnirana na temelju baze prijašnjih iskustava istraživačkih projekata i potreba aktualnog projekta te je dogovorena i dokumentirana konvencija imenovanja stupaca. Uz podatke sa senzora, u bazu podataka pohranjuje se i batch timestamp (koji označava vrijeme unosa u bazu ) i timestamp (koji označava kad je senzor zadnji put očitao mjerenu vrijednost – senzor će vrijednost na upravljačkoj jedinici osvježiti samo ako se mjerena vrijednost promijenila). Prvi unos u bazu podataka je 27.7.2022. u 16:50 sati, dok je posljednji, zbog uklanjanja opreme prije početka obnove zgrade, 22.7.2023. u 13:20. Tijekom tog perioda, skupljeno je 34.356 uzoraka po senzoru po prostoriji. Skup podataka sadrži .csv izvadke za pojedine prostorije. |
| Methods (english) | Data are collected on a virtual machine (VM) running Python code with a Python Scheduler installed, which sends a request every 15 minutes to the REST API given by the manufacturer (Zipato). Data is obtained for each specific sensor (one device consists of several sensors, each sensor measures one of the parameters in the room). The REST API provides a response in JSON format, which is then processed and stored in the PostgreSQL database. The database is designed based on the database of previous experiences of research projects and the needs of the current project, and a column naming convention was agreed and documented. In addition to data from the sensor, the database also stores batch timestamp (which indicates the time of entry into the database) and timestamp (which indicates when the sensor last read the measured value - the sensor will refresh the value on the control unit only if the measured value has changed). The first entry in the database is 27-Jul-2022. at 4:50 p.m., while the last one, due to the removal of equipment before the start of building renovation, is on 22-Jul-2023. at 13:20. During this period, 34,356 samples were collected per sensor per room. The data set contains .csv extracts for individual rooms. |
| Keywords (croatian) | |
| Keywords (english) | |
| Language | croatian |
| URN:NBN | urn:nbn:hr:168:948761 |
| Publication | 2024-01-15 |
| Created | 2022-07-27 |
| Created | 2023-07-22 |
| Version | 1.0 |
| Geolocation | Zagreb, Unska 3, Croatia |
| Project | Number: UIP-2020-02-9636 Title (croatian): Distribuirano upravljanje za dinamičko gospodarenje energijom u složenim sustavima naprednih gradova Title (english): Distributed control for dynamic energy management of complex systems in smart cities Acronym: DECIDE Leader: Vinko Lešić Jurisdiction: Croatia Funding stream: UIP-2020-02 |
| Publisher | Fakultet elektrotehnike i računarstva Faculty of Electrical Engineering and Computing |
| Access conditions | Institutional access |
| Terms of use |  |
| Public note (croatian) | U slučaju interesa za podacima, molimo javite se kontakt osobi na e-mail. |
| Public note (english) | In the case of interest in dataset, please send an e-mail to the contact person. |
| Created on | 2024-01-15 14:32:40 |
