Changes
On October 31, 2022 at 3:38:29 PM +0200, hylli:
-
Uploaded a new file to resource elevators_available_measurements.xlsx in Kampusareena elevators power quality
f | 1 | { | f | 1 | { |
2 | "author": "", | 2 | "author": "", | ||
3 | "author_email": "", | 3 | "author_email": "", | ||
4 | "creator_user_id": "c028eea2-1878-47b8-843b-aa298066c249", | 4 | "creator_user_id": "c028eea2-1878-47b8-843b-aa298066c249", | ||
5 | "extras": [], | 5 | "extras": [], | ||
6 | "groups": [ | 6 | "groups": [ | ||
7 | { | 7 | { | ||
8 | "description": "This group collects together data sets related | 8 | "description": "This group collects together data sets related | ||
9 | to the Kampusareena building. Kampusareena is a modern office building | 9 | to the Kampusareena building. Kampusareena is a modern office building | ||
10 | that provides spaces for the personnel of companies, university staff | 10 | that provides spaces for the personnel of companies, university staff | ||
11 | and students, and e.g, for the library of the whole campus. The | 11 | and students, and e.g, for the library of the whole campus. The | ||
n | 12 | building was completed in 2015 and is located on the campus of Tampere | n | 12 | building was completed in 2015 and is located on the Hervanta campus |
13 | University in Finland.\r\nThe building uses district heating and is | 13 | of Tampere University.\r\nThe building uses district heating and is | ||
14 | cooled with two cooling machines with the electrical compressor powers | 14 | cooled with two cooling machines with the electrical compressor powers | ||
15 | of 170 kW and 226 kW. Ventilation of the building consumes around 100 | 15 | of 170 kW and 226 kW. Ventilation of the building consumes around 100 | ||
16 | kW at maximum. Other electrical loads of the building include two | 16 | kW at maximum. Other electrical loads of the building include two | ||
17 | elevators (max. 7 kW each), eight electric car charging spots (max. 22 | 17 | elevators (max. 7 kW each), eight electric car charging spots (max. 22 | ||
18 | kW each) and appliances used by tenants (max. 350 kW). Additionally, | 18 | kW each) and appliances used by tenants (max. 350 kW). Additionally, | ||
19 | the building has 57 kW solar power plant. The building is connected to | 19 | the building has 57 kW solar power plant. The building is connected to | ||
20 | a medium voltage distribution network through 20/0.4 kV | 20 | a medium voltage distribution network through 20/0.4 kV | ||
21 | transformer.\r\nThe building automation system manages ventilation, | 21 | transformer.\r\nThe building automation system manages ventilation, | ||
22 | heating and cooling of the building. The system involves thousands of | 22 | heating and cooling of the building. The system involves thousands of | ||
23 | data points including indoor conditions of individual spaces, e.g. | 23 | data points including indoor conditions of individual spaces, e.g. | ||
24 | temperature and CO2 concentration, air \ufb02ows and set points for | 24 | temperature and CO2 concentration, air \ufb02ows and set points for | ||
25 | pumps. The electricity consumption of the tenants is measured with | 25 | pumps. The electricity consumption of the tenants is measured with | ||
26 | numerous simple power meters and a couple of more advanced power | 26 | numerous simple power meters and a couple of more advanced power | ||
27 | meters are located at the main distribution boards. Additionally, nine | 27 | meters are located at the main distribution boards. Additionally, nine | ||
n | 28 | power quality meters, called eQL Quality Meters [9], were installed at | n | 28 | power quality meters, called eQL Quality Meters, were installed at the |
29 | the major loads of the building. These meters offer measured data of | 29 | major loads of the building. These meters offer measured data of | ||
30 | various electrical characteristics even with 100 millisecond time | 30 | various electrical characteristics even with 100 millisecond time | ||
31 | interval.", | 31 | interval.", | ||
32 | "display_name": "Kampusareena", | 32 | "display_name": "Kampusareena", | ||
33 | "id": "0b59cd26-0db5-44b4-9e51-8bb07cfeb0f3", | 33 | "id": "0b59cd26-0db5-44b4-9e51-8bb07cfeb0f3", | ||
34 | "image_display_url": "", | 34 | "image_display_url": "", | ||
35 | "name": "kampusareena", | 35 | "name": "kampusareena", | ||
36 | "title": "Kampusareena" | 36 | "title": "Kampusareena" | ||
37 | }, | 37 | }, | ||
38 | { | 38 | { | ||
n | 39 | "description": "This group collects together power quality | n | 39 | "description": "This group collects together electrical |
40 | measurements collected with the commercial eQL Quality Meter. This | 40 | measurements collected with the commercial eQL Quality Meter. eQL is | ||
41 | would then explain more about what kinds of measurements are | 41 | an advanced power quality meter. It collects basic electrical | ||
42 | available.", | 42 | measrurements such as power, current, voltage and cumulative energy, | ||
43 | but also advanced power quality measurements such as symmetrical | ||||
44 | components of voltage, and voltage and current harmonics up to 40th | ||||
45 | order.\r\n\r\nHere is a list of some of the more commonly used | ||||
46 | measurements with their names and descriptions. These measurement | ||||
47 | names can be found from the lists of available measurements for the | ||||
48 | datasets in this group.\r\n\r\n- freq: frequency\r\n- P: active | ||||
49 | power\r\n- EP+: Total amount of energy produced or consumed since the | ||||
50 | metering was started until the current measurement time.", | ||||
43 | "display_name": "eQL quality meter", | 51 | "display_name": "eQL quality meter", | ||
44 | "id": "e5df8df3-49ae-46b5-8e0c-1fda29b64896", | 52 | "id": "e5df8df3-49ae-46b5-8e0c-1fda29b64896", | ||
45 | "image_display_url": "", | 53 | "image_display_url": "", | ||
46 | "name": "eql-quality-meter", | 54 | "name": "eql-quality-meter", | ||
47 | "title": "eQL quality meter" | 55 | "title": "eQL quality meter" | ||
48 | } | 56 | } | ||
49 | ], | 57 | ], | ||
50 | "id": "236be3fd-a6b7-418e-8d63-55561433a6a8", | 58 | "id": "236be3fd-a6b7-418e-8d63-55561433a6a8", | ||
51 | "isopen": false, | 59 | "isopen": false, | ||
52 | "license_id": "other-closed", | 60 | "license_id": "other-closed", | ||
53 | "license_title": "Other (Not Open)", | 61 | "license_title": "Other (Not Open)", | ||
54 | "maintainer": "", | 62 | "maintainer": "", | ||
55 | "maintainer_email": "", | 63 | "maintainer_email": "", | ||
56 | "metadata_created": "2022-10-14T15:13:49.724264", | 64 | "metadata_created": "2022-10-14T15:13:49.724264", | ||
n | 57 | "metadata_modified": "2022-10-17T06:29:22.642997", | n | 65 | "metadata_modified": "2022-10-31T13:38:29.060371", |
58 | "name": "kampusareena-elevators-power-quality", | 66 | "name": "kampusareena-elevators-power-quality", | ||
59 | "notes": "Power quality measurements from two elevators of | 67 | "notes": "Power quality measurements from two elevators of | ||
60 | Kampusareena measured with the eQL Quality Meter. See the | 68 | Kampusareena measured with the eQL Quality Meter. See the | ||
61 | [ProCem](https://ckan.energydata.rd.tuni.fi/organization/procem) | 69 | [ProCem](https://ckan.energydata.rd.tuni.fi/organization/procem) | ||
62 | project for general information about how the measurements are stored | 70 | project for general information about how the measurements are stored | ||
63 | and can be used. See the [eQL quality | 71 | and can be used. See the [eQL quality | ||
64 | meter](https://ckan.energydata.rd.tuni.fi/group/eql-quality-meter) | 72 | meter](https://ckan.energydata.rd.tuni.fi/group/eql-quality-meter) | ||
65 | group for general information about the used measurement device. See | 73 | group for general information about the used measurement device. See | ||
66 | the | 74 | the | ||
67 | [Kampusareena](https://ckan.energydata.rd.tuni.fi/group/kampusareena) | 75 | [Kampusareena](https://ckan.energydata.rd.tuni.fi/group/kampusareena) | ||
68 | group for general information about the building.", | 76 | group for general information about the building.", | ||
69 | "num_resources": 1, | 77 | "num_resources": 1, | ||
70 | "num_tags": 3, | 78 | "num_tags": 3, | ||
71 | "organization": { | 79 | "organization": { | ||
72 | "approval_status": "approved", | 80 | "approval_status": "approved", | ||
73 | "created": "2022-10-14T17:57:03.019118", | 81 | "created": "2022-10-14T17:57:03.019118", | ||
n | 74 | "description": "The ProCem (Social Energy - Prosumer Centric | n | 82 | "description": "The ProCem ([Social Energy - Prosumer Centric |
75 | Energy Ecosystem) and ProCemPlus (Prosumer Centric Energy Communities | 83 | Energy Ecosystem](http://www.senecc.fi/projects/procem-2)) and | ||
76 | - towards Energy Ecosystem) projects have collected energy and energy | 84 | ProCemPlus ([Prosumer Centric Energy Communities - towards Energy | ||
77 | community related data from the Kampusareena building in the Hervanta | 85 | Ecosystem](https://www.senecc.fi/projects/procemplus)) projects have | ||
78 | campus, the Marjam\u00e4ki micro-grid area in Lemp\u00e4\u00e4l\u00e4 | 86 | collected energy and energy community related data from the | ||
79 | and open data sources. This would then also explain how the procem | 87 | [Kampusareena](https://ckan.energydata.rd.tuni.fi/group/kampusareena) | ||
80 | data is stored in to CSV files and what is the used format.", | 88 | building in the Hervanta campus, the | ||
89 | [Marjam\u00e4ki](https://ckan.energydata.rd.tuni.fi/group/marjamaki) | ||||
90 | micro-grid area in Lemp\u00e4\u00e4l\u00e4 and open data | ||||
91 | sources.\r\n\r\nThe data for all of the datasets provided by ProCem | ||||
92 | have been collected using a custom data collection platform developed | ||||
93 | as part of the projects. Thus all the data is stored in the same way | ||||
94 | and in the same format and accessing all the data happens in the same | ||||
95 | way. If you are interested in learning more about the data collection | ||||
96 | platform, it has been described in a scientific article titled \"[A | ||||
97 | Data Collection and Supplementary Control Platform of a Modern | ||||
98 | Building for Smart Energy | ||||
99 | ct.com/science/article/pii/S2352467722001734?via%3Dihub)\".\r\n\r\nThe | ||||
100 | data is stored in simple CSV files on a network drive where select | ||||
101 | project researchers have access to. All data from a measurement target | ||||
102 | (Kampusarreenao or Marjam\u00e4ki) for a day are stored in one file. | ||||
103 | One line of this CSV file contains these 3 items separated by a | ||||
104 | tab:\r\n\r\n- id: Each measurement point has a unique id number. These | ||||
105 | are documented in each dataset.\r\n- value: The actual measurment | ||||
106 | value.\r\n- timestamp: Unix time in milliseconds i.e. milliseconds | ||||
107 | since 1970-01-01 00:00 UTC time.\r\n\r\nIf you want to see a small | ||||
108 | example of how these files look like, you can check [this sample data | ||||
109 | dataset | ||||
110 | ower-quality/resource/0abf89c6-bba6-4d5a-b45f-1f40fd9c5129).\r\n\r\nIf | ||||
111 | you are interested in getting some data from the ProCem datasets, you | ||||
112 | can contact the person marked as the dataset maintainer. Since the raw | ||||
113 | data files are very large and contain data sensitive to the data | ||||
114 | owner, you will be provided filtered versions of the data files | ||||
115 | containing only the data you require from the time period you want. So | ||||
116 | if you already know precisely what data you want and from what time | ||||
117 | period, you can provide the measurement ids of the measurements you | ||||
118 | want and a range of dates.\r\n\r\nNote: Though generally the data | ||||
119 | collection has been continuous since the date marked as measurement | ||||
120 | start date, various issues with measurement devices, networking or the | ||||
121 | collection system have caused breaks in data collection varying from | ||||
122 | minutes to days. So please take this into account when processing your | ||||
123 | data.", | ||||
81 | "id": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | 124 | "id": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | ||
82 | "image_url": "", | 125 | "image_url": "", | ||
83 | "is_organization": true, | 126 | "is_organization": true, | ||
84 | "name": "procem", | 127 | "name": "procem", | ||
85 | "state": "active", | 128 | "state": "active", | ||
86 | "title": "ProCem", | 129 | "title": "ProCem", | ||
87 | "type": "organization" | 130 | "type": "organization" | ||
88 | }, | 131 | }, | ||
89 | "owner_org": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | 132 | "owner_org": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | ||
90 | "private": false, | 133 | "private": false, | ||
91 | "relationships_as_object": [], | 134 | "relationships_as_object": [], | ||
92 | "relationships_as_subject": [], | 135 | "relationships_as_subject": [], | ||
93 | "resources": [ | 136 | "resources": [ | ||
94 | { | 137 | { | ||
95 | "cache_last_updated": null, | 138 | "cache_last_updated": null, | ||
96 | "cache_url": null, | 139 | "cache_url": null, | ||
97 | "created": "2022-10-14T15:15:14.739428", | 140 | "created": "2022-10-14T15:15:14.739428", | ||
98 | "datastore_active": false, | 141 | "datastore_active": false, | ||
99 | "description": "List of available measurements.", | 142 | "description": "List of available measurements.", | ||
100 | "format": "XLSX", | 143 | "format": "XLSX", | ||
101 | "hash": "", | 144 | "hash": "", | ||
102 | "id": "14755afb-d0e2-4bdc-a225-eedb4629d0e3", | 145 | "id": "14755afb-d0e2-4bdc-a225-eedb4629d0e3", | ||
n | 103 | "last_modified": "2022-10-14T15:15:14.712448", | n | 146 | "last_modified": "2022-10-31T13:38:29.054248", |
104 | "metadata_modified": "2022-10-14T15:15:16.505076", | 147 | "metadata_modified": "2022-10-31T13:38:29.064389", | ||
105 | "mimetype": | 148 | "mimetype": | ||
106 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | 149 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||
107 | "mimetype_inner": null, | 150 | "mimetype_inner": null, | ||
108 | "name": "elevators_available_measurements.xlsx", | 151 | "name": "elevators_available_measurements.xlsx", | ||
109 | "package_id": "236be3fd-a6b7-418e-8d63-55561433a6a8", | 152 | "package_id": "236be3fd-a6b7-418e-8d63-55561433a6a8", | ||
110 | "position": 0, | 153 | "position": 0, | ||
111 | "resource_type": null, | 154 | "resource_type": null, | ||
n | 112 | "size": 10678, | n | 155 | "size": 11638, |
113 | "state": "active", | 156 | "state": "active", | ||
114 | "url": | 157 | "url": | ||
t | 115 | dc-a225-eedb4629d0e3/download/elevator_1_available_measurements.xlsx", | t | 158 | c-a225-eedb4629d0e3/download/elevator_1_available_measurements2.xlsx", |
116 | "url_type": "upload" | 159 | "url_type": "upload" | ||
117 | } | 160 | } | ||
118 | ], | 161 | ], | ||
119 | "state": "active", | 162 | "state": "active", | ||
120 | "tags": [ | 163 | "tags": [ | ||
121 | { | 164 | { | ||
122 | "display_name": "Kampusareena", | 165 | "display_name": "Kampusareena", | ||
123 | "id": "509dbd7e-76cf-40b1-801b-d8892486de87", | 166 | "id": "509dbd7e-76cf-40b1-801b-d8892486de87", | ||
124 | "name": "Kampusareena", | 167 | "name": "Kampusareena", | ||
125 | "state": "active", | 168 | "state": "active", | ||
126 | "vocabulary_id": null | 169 | "vocabulary_id": null | ||
127 | }, | 170 | }, | ||
128 | { | 171 | { | ||
129 | "display_name": "electricity", | 172 | "display_name": "electricity", | ||
130 | "id": "0c58cb6b-5845-4112-9871-6adda7eaac59", | 173 | "id": "0c58cb6b-5845-4112-9871-6adda7eaac59", | ||
131 | "name": "electricity", | 174 | "name": "electricity", | ||
132 | "state": "active", | 175 | "state": "active", | ||
133 | "vocabulary_id": null | 176 | "vocabulary_id": null | ||
134 | }, | 177 | }, | ||
135 | { | 178 | { | ||
136 | "display_name": "power quality", | 179 | "display_name": "power quality", | ||
137 | "id": "f75b4ff7-2ba6-44ba-8468-c1e9c3ba08e4", | 180 | "id": "f75b4ff7-2ba6-44ba-8468-c1e9c3ba08e4", | ||
138 | "name": "power quality", | 181 | "name": "power quality", | ||
139 | "state": "active", | 182 | "state": "active", | ||
140 | "vocabulary_id": null | 183 | "vocabulary_id": null | ||
141 | } | 184 | } | ||
142 | ], | 185 | ], | ||
143 | "title": "Kampusareena elevators power quality", | 186 | "title": "Kampusareena elevators power quality", | ||
144 | "type": "dataset", | 187 | "type": "dataset", | ||
145 | "url": "", | 188 | "url": "", | ||
146 | "version": "" | 189 | "version": "" | ||
147 | } | 190 | } |