Changes
On February 1, 2023 at 11:40:25 AM +0200, hylli:
-
Added resource ev_charging_station_power_quality_available_measurements.xlsx to Kampusareena electric vehicle charging power consumption and 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 | "data_owner": "University Properties of Finland", | 5 | "data_owner": "University Properties of Finland", | ||
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 | 9 | to the | ||
10 | ving-collaboration-platform-hervanta-campus#switcher-trigger-overview) | 10 | ving-collaboration-platform-hervanta-campus#switcher-trigger-overview) | ||
11 | building. Kampusareena is a modern office building that provides | 11 | building. Kampusareena is a modern office building that provides | ||
12 | spaces for the personnel of companies, university staff and students, | 12 | spaces for the personnel of companies, university staff and students, | ||
13 | and e.g, for the library of the whole campus. The building was | 13 | and e.g, for the library of the whole campus. The building was | ||
14 | completed in 2015 and is located on the Hervanta campus of Tampere | 14 | completed in 2015 and is located on the Hervanta campus of Tampere | ||
15 | University. Its total area is 16 000 square meters spread out over 8 | 15 | University. Its total area is 16 000 square meters spread out over 8 | ||
16 | floors.\r\n\r\nThe building uses district heating and is cooled with | 16 | floors.\r\n\r\nThe building uses district heating and is cooled with | ||
17 | two cooling machines with the electrical compressor powers of 170 kW | 17 | two cooling machines with the electrical compressor powers of 170 kW | ||
18 | and 226 kW. Ventilation of the building consumes around 100 kW at | 18 | and 226 kW. Ventilation of the building consumes around 100 kW at | ||
19 | maximum. Other electrical loads of the building include two elevators | 19 | maximum. Other electrical loads of the building include two elevators | ||
20 | (max. 7 kW each), eight electric car charging spots (max. 22 kW each) | 20 | (max. 7 kW each), eight electric car charging spots (max. 22 kW each) | ||
21 | and appliances used by tenants (max. 350 kW). Additionally, the | 21 | and appliances used by tenants (max. 350 kW). Additionally, the | ||
22 | building has 57 kW solar power plant. The building is connected to a | 22 | building has 57 kW solar power plant. The building is connected to a | ||
23 | medium voltage distribution network through 20/0.4 kV | 23 | medium voltage distribution network through 20/0.4 kV | ||
24 | transformer.\r\nThe building automation system manages ventilation, | 24 | transformer.\r\nThe building automation system manages ventilation, | ||
25 | heating and cooling of the building. The system involves thousands of | 25 | heating and cooling of the building. The system involves thousands of | ||
26 | data points including indoor conditions of individual spaces, e.g. | 26 | data points including indoor conditions of individual spaces, e.g. | ||
27 | temperature and CO2 concentration, air \ufb02ows and set points for | 27 | temperature and CO2 concentration, air \ufb02ows and set points for | ||
28 | pumps. The electricity consumption of the tenants is measured with | 28 | pumps. The electricity consumption of the tenants is measured with | ||
29 | numerous simple power meters and a couple of more advanced power | 29 | numerous simple power meters and a couple of more advanced power | ||
30 | meters are located at the main distribution boards. Additionally, nine | 30 | meters are located at the main distribution boards. Additionally, nine | ||
31 | power quality meters, called eQL Quality Meters, were installed at the | 31 | power quality meters, called eQL Quality Meters, were installed at the | ||
32 | major loads of the building. These meters offer measured data of | 32 | major loads of the building. These meters offer measured data of | ||
33 | various electrical characteristics even with 100 millisecond time | 33 | various electrical characteristics even with 100 millisecond time | ||
34 | interval.\r\n\r\nMost of the data in this group is owned by University | 34 | interval.\r\n\r\nMost of the data in this group is owned by University | ||
35 | Properties of Finlan (SYK). See the data owner of each dataset to | 35 | Properties of Finlan (SYK). See the data owner of each dataset to | ||
36 | check if that particular data is owned by SYK. SYK has given | 36 | check if that particular data is owned by SYK. SYK has given | ||
37 | permission to use the data for internal university research and | 37 | permission to use the data for internal university research and | ||
38 | education. So, for example, it cannot be shared with external parties | 38 | education. So, for example, it cannot be shared with external parties | ||
39 | without a separate permission from SYK.", | 39 | without a separate permission from SYK.", | ||
40 | "display_name": "Kampusareena", | 40 | "display_name": "Kampusareena", | ||
41 | "id": "0b59cd26-0db5-44b4-9e51-8bb07cfeb0f3", | 41 | "id": "0b59cd26-0db5-44b4-9e51-8bb07cfeb0f3", | ||
42 | "image_display_url": "", | 42 | "image_display_url": "", | ||
43 | "name": "kampusareena", | 43 | "name": "kampusareena", | ||
44 | "title": "Kampusareena" | 44 | "title": "Kampusareena" | ||
45 | }, | 45 | }, | ||
46 | { | 46 | { | ||
47 | "description": "This group collects together electrical | 47 | "description": "This group collects together electrical | ||
48 | measurements collected with the commercial eQL Quality Meter. eQL is | 48 | measurements collected with the commercial eQL Quality Meter. eQL is | ||
49 | an advanced power quality meter. It collects basic electrical | 49 | an advanced power quality meter. It collects basic electrical | ||
50 | measrurements such as power, current, voltage and cumulative energy, | 50 | measrurements such as power, current, voltage and cumulative energy, | ||
51 | but also advanced power quality measurements such as symmetrical | 51 | but also advanced power quality measurements such as symmetrical | ||
52 | components of voltage, and voltage and current harmonics up to 40th | 52 | components of voltage, and voltage and current harmonics up to 40th | ||
53 | order.\r\n\r\nHere is a list of some of the more commonly used | 53 | order.\r\n\r\nHere is a list of some of the more commonly used | ||
54 | measurements with their names and descriptions. These measurement | 54 | measurements with their names and descriptions. These measurement | ||
55 | names can be found from the lists of available measurements for the | 55 | names can be found from the lists of available measurements for the | ||
56 | datasets in this group.\r\n\r\n- freq: frequency\r\n- P: active | 56 | datasets in this group.\r\n\r\n- freq: frequency\r\n- P: active | ||
57 | power\r\n- EP+: Total amount of energy produced or consumed since the | 57 | power\r\n- EP+: Total amount of energy produced or consumed since the | ||
58 | metering was started until the current measurement time.", | 58 | metering was started until the current measurement time.", | ||
59 | "display_name": "eQL quality meter", | 59 | "display_name": "eQL quality meter", | ||
60 | "id": "e5df8df3-49ae-46b5-8e0c-1fda29b64896", | 60 | "id": "e5df8df3-49ae-46b5-8e0c-1fda29b64896", | ||
61 | "image_display_url": "", | 61 | "image_display_url": "", | ||
62 | "name": "eql-quality-meter", | 62 | "name": "eql-quality-meter", | ||
63 | "title": "eQL quality meter" | 63 | "title": "eQL quality meter" | ||
64 | } | 64 | } | ||
65 | ], | 65 | ], | ||
66 | "id": "5284834e-3082-434f-b692-da8b0bafd95b", | 66 | "id": "5284834e-3082-434f-b692-da8b0bafd95b", | ||
67 | "isopen": false, | 67 | "isopen": false, | ||
68 | "license_id": "internal", | 68 | "license_id": "internal", | ||
69 | "license_title": "For internal research and education use", | 69 | "license_title": "For internal research and education use", | ||
70 | "maintainer": "Antti Hilden", | 70 | "maintainer": "Antti Hilden", | ||
71 | "maintainer_email": "antti.t.hilden@tuni.fi", | 71 | "maintainer_email": "antti.t.hilden@tuni.fi", | ||
72 | "metadata_created": "2022-12-16T13:36:08.572684", | 72 | "metadata_created": "2022-12-16T13:36:08.572684", | ||
n | 73 | "metadata_modified": "2023-01-12T08:47:52.312041", | n | 73 | "metadata_modified": "2023-02-01T09:40:25.475785", |
74 | "name": | 74 | "name": | ||
75 | kampusareena-electric-vehicle-charging-power-consumption-and-quality", | 75 | kampusareena-electric-vehicle-charging-power-consumption-and-quality", | ||
76 | "notes": "Various electrical measurements from the electric vehicle | 76 | "notes": "Various electrical measurements from the electric vehicle | ||
77 | charging station at Kampusareena. Kampusareena has 8 charging spots | 77 | charging station at Kampusareena. Kampusareena has 8 charging spots | ||
78 | with a maximum power of 22 kW for each. The measurements include basic | 78 | with a maximum power of 22 kW for each. The measurements include basic | ||
79 | electrical measrurements such as power, current, voltage and | 79 | electrical measrurements such as power, current, voltage and | ||
80 | cumulative energy, but also advanced power quality measurements such | 80 | cumulative energy, but also advanced power quality measurements such | ||
81 | as symmetrical components of voltage, and voltage and current | 81 | as symmetrical components of voltage, and voltage and current | ||
82 | harmonics up to 40th order. NOTe: before 2018-09-6 the power meter was | 82 | harmonics up to 40th order. NOTe: before 2018-09-6 the power meter was | ||
83 | installed incorrectly so that positive and negative power amounts | 83 | installed incorrectly so that positive and negative power amounts | ||
84 | where the wrong way around i.e. when power value is negative in the | 84 | where the wrong way around i.e. when power value is negative in the | ||
85 | data it really should be positive.\r\n\r\nSee the | 85 | data it really should be positive.\r\n\r\nSee the | ||
86 | [ProCem](https://ckan.energydata.rd.tuni.fi/organization/about/procem) | 86 | [ProCem](https://ckan.energydata.rd.tuni.fi/organization/about/procem) | ||
87 | project for general information about how the measurements are stored | 87 | project for general information about how the measurements are stored | ||
88 | and can be used. See the [eQL quality | 88 | and can be used. See the [eQL quality | ||
89 | ter](https://ckan.energydata.rd.tuni.fi/group/about/eql-quality-meter) | 89 | ter](https://ckan.energydata.rd.tuni.fi/group/about/eql-quality-meter) | ||
90 | group for general information about the used measurement device. See | 90 | group for general information about the used measurement device. See | ||
91 | the | 91 | the | ||
92 | usareena](https://ckan.energydata.rd.tuni.fi/group/about/kampusareena) | 92 | usareena](https://ckan.energydata.rd.tuni.fi/group/about/kampusareena) | ||
93 | group for general information about the building.\r\n\r\nNote: This is | 93 | group for general information about the building.\r\n\r\nNote: This is | ||
94 | not fully documented for example available measurements are missing.", | 94 | not fully documented for example available measurements are missing.", | ||
n | 95 | "num_resources": 0, | n | 95 | "num_resources": 1, |
96 | "num_tags": 4, | 96 | "num_tags": 4, | ||
97 | "organization": { | 97 | "organization": { | ||
98 | "approval_status": "approved", | 98 | "approval_status": "approved", | ||
99 | "created": "2022-10-14T17:57:03.019118", | 99 | "created": "2022-10-14T17:57:03.019118", | ||
100 | "description": "The ProCem ([Social Energy - Prosumer Centric | 100 | "description": "The ProCem ([Social Energy - Prosumer Centric | ||
101 | Energy Ecosystem](http://www.senecc.fi/projects/procem-2)) and | 101 | Energy Ecosystem](http://www.senecc.fi/projects/procem-2)) and | ||
102 | ProCemPlus ([Prosumer Centric Energy Communities - towards Energy | 102 | ProCemPlus ([Prosumer Centric Energy Communities - towards Energy | ||
103 | Ecosystem](https://www.senecc.fi/projects/procemplus)) projects have | 103 | Ecosystem](https://www.senecc.fi/projects/procemplus)) projects have | ||
104 | collected energy and energy community related data from the | 104 | collected energy and energy community related data from the | ||
105 | [Kampusareena](https://ckan.energydata.rd.tuni.fi/group/kampusareena) | 105 | [Kampusareena](https://ckan.energydata.rd.tuni.fi/group/kampusareena) | ||
106 | building in the Hervanta campus, the | 106 | building in the Hervanta campus, the | ||
107 | [Marjam\u00e4ki](https://ckan.energydata.rd.tuni.fi/group/marjamaki) | 107 | [Marjam\u00e4ki](https://ckan.energydata.rd.tuni.fi/group/marjamaki) | ||
108 | micro-grid area in Lemp\u00e4\u00e4l\u00e4 and open data | 108 | micro-grid area in Lemp\u00e4\u00e4l\u00e4 and open data | ||
109 | sources.\r\n\r\nThe data for all of the datasets provided by ProCem | 109 | sources.\r\n\r\nThe data for all of the datasets provided by ProCem | ||
110 | have been collected using a custom data collection platform developed | 110 | have been collected using a custom data collection platform developed | ||
111 | as part of the projects. Thus all the data is stored in the same way | 111 | as part of the projects. Thus all the data is stored in the same way | ||
112 | and in the same format and accessing all the data happens in the same | 112 | and in the same format and accessing all the data happens in the same | ||
113 | way. If you are interested in learning more about the data collection | 113 | way. If you are interested in learning more about the data collection | ||
114 | platform, it has been described in a scientific article titled \"[A | 114 | platform, it has been described in a scientific article titled \"[A | ||
115 | Data Collection and Supplementary Control Platform of a Modern | 115 | Data Collection and Supplementary Control Platform of a Modern | ||
116 | Building for Smart Energy | 116 | Building for Smart Energy | ||
117 | ct.com/science/article/pii/S2352467722001734?via%3Dihub)\".\r\n\r\nThe | 117 | ct.com/science/article/pii/S2352467722001734?via%3Dihub)\".\r\n\r\nThe | ||
118 | data is stored in simple CSV files on a network drive where select | 118 | data is stored in simple CSV files on a network drive where select | ||
119 | project researchers have access to. All data from a measurement target | 119 | project researchers have access to. All data from a measurement target | ||
120 | (Kampusarreenao or Marjam\u00e4ki) for a day are stored in one file. | 120 | (Kampusarreenao or Marjam\u00e4ki) for a day are stored in one file. | ||
121 | One line of this CSV file contains these 3 items separated by a | 121 | One line of this CSV file contains these 3 items separated by a | ||
122 | tab:\r\n\r\n- id: Each measurement point has a unique id number. These | 122 | tab:\r\n\r\n- id: Each measurement point has a unique id number. These | ||
n | 123 | are documented in each dataset.\r\n- value: The actual measurment | n | 123 | are documented in the list of available measurements for each |
124 | value.\r\n- timestamp: Unix time in milliseconds i.e. milliseconds | 124 | dataset.\r\n- value: The actual measurment value.\r\n- timestamp: Unix | ||
125 | since 1970-01-01 00:00 UTC time.\r\n\r\nIf you want to see a small | 125 | time in milliseconds i.e. milliseconds since 1970-01-01 00:00 UTC | ||
126 | example of how these files look like, you can check [this sample data | 126 | time.\r\n\r\nIf you want to see a small example of how these files | ||
127 | dataset | 127 | look like, you can check [this sample data dataset | ||
128 | ower-quality/resource/0abf89c6-bba6-4d5a-b45f-1f40fd9c5129).\r\n\r\nIf | 128 | ower-quality/resource/0abf89c6-bba6-4d5a-b45f-1f40fd9c5129).\r\n\r\nIf | ||
129 | you are interested in getting some data from the ProCem datasets, you | 129 | you are interested in getting some data from the ProCem datasets, you | ||
130 | can contact the person marked as the dataset maintainer. Since the raw | 130 | can contact the person marked as the dataset maintainer. Since the raw | ||
131 | data files are very large and contain data sensitive to the data | 131 | data files are very large and contain data sensitive to the data | ||
132 | owner, you will be provided filtered versions of the data files | 132 | owner, you will be provided filtered versions of the data files | ||
133 | containing only the data you require from the time period you want. So | 133 | containing only the data you require from the time period you want. So | ||
134 | if you already know precisely what data you want and from what time | 134 | if you already know precisely what data you want and from what time | ||
135 | period, you can provide the measurement ids of the measurements you | 135 | period, you can provide the measurement ids of the measurements you | ||
136 | want and a range of dates.\r\n\r\nNote: Though generally the data | 136 | want and a range of dates.\r\n\r\nNote: Though generally the data | ||
137 | collection has been continuous since the date marked as measurement | 137 | collection has been continuous since the date marked as measurement | ||
138 | start date, various issues with measurement devices, networking or the | 138 | start date, various issues with measurement devices, networking or the | ||
139 | collection system have caused breaks in data collection varying from | 139 | collection system have caused breaks in data collection varying from | ||
140 | minutes to days. So please take this into account when processing your | 140 | minutes to days. So please take this into account when processing your | ||
141 | data.", | 141 | data.", | ||
142 | "id": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | 142 | "id": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | ||
143 | "image_url": "", | 143 | "image_url": "", | ||
144 | "is_organization": true, | 144 | "is_organization": true, | ||
145 | "name": "procem", | 145 | "name": "procem", | ||
146 | "state": "active", | 146 | "state": "active", | ||
147 | "title": "ProCem", | 147 | "title": "ProCem", | ||
148 | "type": "organization" | 148 | "type": "organization" | ||
149 | }, | 149 | }, | ||
150 | "owner_org": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | 150 | "owner_org": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | ||
151 | "private": false, | 151 | "private": false, | ||
152 | "relationships_as_object": [], | 152 | "relationships_as_object": [], | ||
153 | "relationships_as_subject": [], | 153 | "relationships_as_subject": [], | ||
t | 154 | "resources": [], | t | 154 | "resources": [ |
155 | { | ||||
156 | "cache_last_updated": null, | ||||
157 | "cache_url": null, | ||||
158 | "created": "2023-02-01T09:40:25.496252", | ||||
159 | "datastore_active": false, | ||||
160 | "description": "List of available measurements.", | ||||
161 | "format": "XLSX", | ||||
162 | "hash": "", | ||||
163 | "id": "8d8cfbfd-65b2-4085-ae5b-292855f1ee2d", | ||||
164 | "last_modified": "2023-02-01T09:40:25.468715", | ||||
165 | "metadata_modified": "2023-02-01T09:40:25.480123", | ||||
166 | "mimetype": | ||||
167 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||||
168 | "mimetype_inner": null, | ||||
169 | "name": | ||||
170 | "ev_charging_station_power_quality_available_measurements.xlsx", | ||||
171 | "package_id": "5284834e-3082-434f-b692-da8b0bafd95b", | ||||
172 | "position": 0, | ||||
173 | "resource_type": null, | ||||
174 | "size": 15075, | ||||
175 | "state": "active", | ||||
176 | "url": | ||||
177 | wnload/ev_charging_station_power_quality_available_measurements.xlsx", | ||||
178 | "url_type": "upload" | ||||
179 | } | ||||
180 | ], | ||||
155 | "state": "active", | 181 | "state": "active", | ||
156 | "tags": [ | 182 | "tags": [ | ||
157 | { | 183 | { | ||
158 | "display_name": "Kampusareena", | 184 | "display_name": "Kampusareena", | ||
159 | "id": "509dbd7e-76cf-40b1-801b-d8892486de87", | 185 | "id": "509dbd7e-76cf-40b1-801b-d8892486de87", | ||
160 | "name": "Kampusareena", | 186 | "name": "Kampusareena", | ||
161 | "state": "active", | 187 | "state": "active", | ||
162 | "vocabulary_id": null | 188 | "vocabulary_id": null | ||
163 | }, | 189 | }, | ||
164 | { | 190 | { | ||
165 | "display_name": "electric vehicle charging", | 191 | "display_name": "electric vehicle charging", | ||
166 | "id": "a1ad194a-3d95-4600-918a-9beb95c72a60", | 192 | "id": "a1ad194a-3d95-4600-918a-9beb95c72a60", | ||
167 | "name": "electric vehicle charging", | 193 | "name": "electric vehicle charging", | ||
168 | "state": "active", | 194 | "state": "active", | ||
169 | "vocabulary_id": null | 195 | "vocabulary_id": null | ||
170 | }, | 196 | }, | ||
171 | { | 197 | { | ||
172 | "display_name": "electricity", | 198 | "display_name": "electricity", | ||
173 | "id": "0c58cb6b-5845-4112-9871-6adda7eaac59", | 199 | "id": "0c58cb6b-5845-4112-9871-6adda7eaac59", | ||
174 | "name": "electricity", | 200 | "name": "electricity", | ||
175 | "state": "active", | 201 | "state": "active", | ||
176 | "vocabulary_id": null | 202 | "vocabulary_id": null | ||
177 | }, | 203 | }, | ||
178 | { | 204 | { | ||
179 | "display_name": "power quality", | 205 | "display_name": "power quality", | ||
180 | "id": "f75b4ff7-2ba6-44ba-8468-c1e9c3ba08e4", | 206 | "id": "f75b4ff7-2ba6-44ba-8468-c1e9c3ba08e4", | ||
181 | "name": "power quality", | 207 | "name": "power quality", | ||
182 | "state": "active", | 208 | "state": "active", | ||
183 | "vocabulary_id": null | 209 | "vocabulary_id": null | ||
184 | } | 210 | } | ||
185 | ], | 211 | ], | ||
186 | "temporal_resolution": "1 second", | 212 | "temporal_resolution": "1 second", | ||
187 | "title": "Kampusareena electric vehicle charging power consumption | 213 | "title": "Kampusareena electric vehicle charging power consumption | ||
188 | and quality", | 214 | and quality", | ||
189 | "type": "dataset", | 215 | "type": "dataset", | ||
190 | "url": "", | 216 | "url": "", | ||
191 | "version": "" | 217 | "version": "" | ||
192 | } | 218 | } |