Changes
On October 31, 2022 at 11:30:42 AM +0200, hylli:
-
Renamed resource available_measurements.xlsx to available_measurements.xls in Kampusareena solar power plant energy production and power quality
-
Changed value of field
datastore_active
toTrue
in resource available_measurements.xls in Kampusareena solar power plant energy production and 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 | { | 6 | { | ||
7 | "key": "Data owner", | 7 | "key": "Data owner", | ||
8 | "value": "University Properties of Finland" | 8 | "value": "University Properties of Finland" | ||
9 | }, | 9 | }, | ||
10 | { | 10 | { | ||
11 | "key": "Measurement start date", | 11 | "key": "Measurement start date", | ||
12 | "value": "2018-05-17" | 12 | "value": "2018-05-17" | ||
13 | }, | 13 | }, | ||
14 | { | 14 | { | ||
15 | "key": "Time resolution", | 15 | "key": "Time resolution", | ||
16 | "value": "1 second" | 16 | "value": "1 second" | ||
17 | } | 17 | } | ||
18 | ], | 18 | ], | ||
19 | "groups": [ | 19 | "groups": [ | ||
20 | { | 20 | { | ||
21 | "description": "This group collects together data sets related | 21 | "description": "This group collects together data sets related | ||
22 | to the Kampusareena building. Kampusareena is a modern office building | 22 | to the Kampusareena building. Kampusareena is a modern office building | ||
23 | that provides spaces for the personnel of companies, university staff | 23 | that provides spaces for the personnel of companies, university staff | ||
24 | and students, and e.g, for the library of the whole campus. The | 24 | and students, and e.g, for the library of the whole campus. The | ||
25 | building was completed in 2015 and is located on the campus of Tampere | 25 | building was completed in 2015 and is located on the campus of Tampere | ||
26 | University in Finland.\r\nThe building uses district heating and is | 26 | University in Finland.\r\nThe building uses district heating and is | ||
27 | cooled with two cooling machines with the electrical compressor powers | 27 | cooled with two cooling machines with the electrical compressor powers | ||
28 | of 170 kW and 226 kW. Ventilation of the building consumes around 100 | 28 | of 170 kW and 226 kW. Ventilation of the building consumes around 100 | ||
29 | kW at maximum. Other electrical loads of the building include two | 29 | kW at maximum. Other electrical loads of the building include two | ||
30 | elevators (max. 7 kW each), eight electric car charging spots (max. 22 | 30 | elevators (max. 7 kW each), eight electric car charging spots (max. 22 | ||
31 | kW each) and appliances used by tenants (max. 350 kW). Additionally, | 31 | kW each) and appliances used by tenants (max. 350 kW). Additionally, | ||
32 | the building has 57 kW solar power plant. The building is connected to | 32 | the building has 57 kW solar power plant. The building is connected to | ||
33 | a medium voltage distribution network through 20/0.4 kV | 33 | a medium voltage distribution network through 20/0.4 kV | ||
34 | transformer.\r\nThe building automation system manages ventilation, | 34 | transformer.\r\nThe building automation system manages ventilation, | ||
35 | heating and cooling of the building. The system involves thousands of | 35 | heating and cooling of the building. The system involves thousands of | ||
36 | data points including indoor conditions of individual spaces, e.g. | 36 | data points including indoor conditions of individual spaces, e.g. | ||
37 | temperature and CO2 concentration, air \ufb02ows and set points for | 37 | temperature and CO2 concentration, air \ufb02ows and set points for | ||
38 | pumps. The electricity consumption of the tenants is measured with | 38 | pumps. The electricity consumption of the tenants is measured with | ||
39 | numerous simple power meters and a couple of more advanced power | 39 | numerous simple power meters and a couple of more advanced power | ||
40 | meters are located at the main distribution boards. Additionally, nine | 40 | meters are located at the main distribution boards. Additionally, nine | ||
41 | power quality meters, called eQL Quality Meters [9], were installed at | 41 | power quality meters, called eQL Quality Meters [9], were installed at | ||
42 | the major loads of the building. These meters offer measured data of | 42 | the major loads of the building. These meters offer measured data of | ||
43 | various electrical characteristics even with 100 millisecond time | 43 | various electrical characteristics even with 100 millisecond time | ||
44 | interval.", | 44 | interval.", | ||
45 | "display_name": "Kampusareena", | 45 | "display_name": "Kampusareena", | ||
46 | "id": "0b59cd26-0db5-44b4-9e51-8bb07cfeb0f3", | 46 | "id": "0b59cd26-0db5-44b4-9e51-8bb07cfeb0f3", | ||
47 | "image_display_url": "", | 47 | "image_display_url": "", | ||
48 | "name": "kampusareena", | 48 | "name": "kampusareena", | ||
49 | "title": "Kampusareena" | 49 | "title": "Kampusareena" | ||
50 | }, | 50 | }, | ||
51 | { | 51 | { | ||
52 | "description": "This group collects together electrical | 52 | "description": "This group collects together electrical | ||
53 | measurements collected with the commercial eQL Quality Meter. eQL is | 53 | measurements collected with the commercial eQL Quality Meter. eQL is | ||
54 | an advanced power quality meter. It collects basic electrical | 54 | an advanced power quality meter. It collects basic electrical | ||
55 | measrurements such as power, current, voltage and cumulative energy, | 55 | measrurements such as power, current, voltage and cumulative energy, | ||
56 | but also advanced power quality measurements such as symmetrical | 56 | but also advanced power quality measurements such as symmetrical | ||
57 | components of voltage, and voltage and current harmonics up to 40th | 57 | components of voltage, and voltage and current harmonics up to 40th | ||
58 | order.\r\n\r\nHere is a list of some of the more commonly used | 58 | order.\r\n\r\nHere is a list of some of the more commonly used | ||
59 | measurements with their names and descriptions. These measurement | 59 | measurements with their names and descriptions. These measurement | ||
60 | names can be found from the lists of available measurements for the | 60 | names can be found from the lists of available measurements for the | ||
61 | datasets in this group.\r\n\r\n- freq: frequency\r\n- P: active | 61 | datasets in this group.\r\n\r\n- freq: frequency\r\n- P: active | ||
62 | power\r\n- EP+: Total amount of energy produced or consumed since the | 62 | power\r\n- EP+: Total amount of energy produced or consumed since the | ||
63 | metering was started until the current measurement time.", | 63 | metering was started until the current measurement time.", | ||
64 | "display_name": "eQL quality meter", | 64 | "display_name": "eQL quality meter", | ||
65 | "id": "e5df8df3-49ae-46b5-8e0c-1fda29b64896", | 65 | "id": "e5df8df3-49ae-46b5-8e0c-1fda29b64896", | ||
66 | "image_display_url": "", | 66 | "image_display_url": "", | ||
67 | "name": "eql-quality-meter", | 67 | "name": "eql-quality-meter", | ||
68 | "title": "eQL quality meter" | 68 | "title": "eQL quality meter" | ||
69 | } | 69 | } | ||
70 | ], | 70 | ], | ||
71 | "id": "262e9cd6-3ae1-4586-b1ac-39c49a7addd3", | 71 | "id": "262e9cd6-3ae1-4586-b1ac-39c49a7addd3", | ||
72 | "isopen": false, | 72 | "isopen": false, | ||
73 | "license_id": "other-closed", | 73 | "license_id": "other-closed", | ||
74 | "license_title": "Other (Not Open)", | 74 | "license_title": "Other (Not Open)", | ||
75 | "maintainer": "Antti Hilden", | 75 | "maintainer": "Antti Hilden", | ||
76 | "maintainer_email": "antti.t.hilden@tuni.fi", | 76 | "maintainer_email": "antti.t.hilden@tuni.fi", | ||
77 | "metadata_created": "2022-10-17T07:09:19.656148", | 77 | "metadata_created": "2022-10-17T07:09:19.656148", | ||
n | 78 | "metadata_modified": "2022-10-31T09:22:08.737555", | n | 78 | "metadata_modified": "2022-10-31T09:30:42.912579", |
79 | "name": "kampusareena-solar-power-plant-power-quality", | 79 | "name": "kampusareena-solar-power-plant-power-quality", | ||
80 | "notes": "Various electrical measurements from the solar power plant | 80 | "notes": "Various electrical measurements from the solar power plant | ||
81 | of Kampusareena whose maximum power is 57 kW. Includes basic | 81 | of Kampusareena whose maximum power is 57 kW. Includes basic | ||
82 | electrical measrurements such as power, current, voltage and | 82 | electrical measrurements such as power, current, voltage and | ||
83 | cumulative energy, but also advanced power quality measurements such | 83 | cumulative energy, but also advanced power quality measurements such | ||
84 | as symmetrical components of voltage, and voltage and current | 84 | as symmetrical components of voltage, and voltage and current | ||
85 | harmonics up to 40th order.\r\n\r\nSee the | 85 | harmonics up to 40th order.\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.", | 93 | group for general information about the building.", | ||
94 | "num_resources": 2, | 94 | "num_resources": 2, | ||
95 | "num_tags": 4, | 95 | "num_tags": 4, | ||
96 | "organization": { | 96 | "organization": { | ||
97 | "approval_status": "approved", | 97 | "approval_status": "approved", | ||
98 | "created": "2022-10-14T17:57:03.019118", | 98 | "created": "2022-10-14T17:57:03.019118", | ||
99 | "description": "The ProCem ([Social Energy - Prosumer Centric | 99 | "description": "The ProCem ([Social Energy - Prosumer Centric | ||
100 | Energy Ecosystem](http://www.senecc.fi/projects/procem-2)) and | 100 | Energy Ecosystem](http://www.senecc.fi/projects/procem-2)) and | ||
101 | ProCemPlus ([Prosumer Centric Energy Communities - towards Energy | 101 | ProCemPlus ([Prosumer Centric Energy Communities - towards Energy | ||
102 | Ecosystem](https://www.senecc.fi/projects/procemplus)) projects have | 102 | Ecosystem](https://www.senecc.fi/projects/procemplus)) projects have | ||
103 | collected energy and energy community related data from the | 103 | collected energy and energy community related data from the | ||
104 | [Kampusareena](https://ckan.energydata.rd.tuni.fi/group/kampusareena) | 104 | [Kampusareena](https://ckan.energydata.rd.tuni.fi/group/kampusareena) | ||
105 | building in the Hervanta campus, the | 105 | building in the Hervanta campus, the | ||
106 | [Marjam\u00e4ki](https://ckan.energydata.rd.tuni.fi/group/marjamaki) | 106 | [Marjam\u00e4ki](https://ckan.energydata.rd.tuni.fi/group/marjamaki) | ||
107 | micro-grid area in Lemp\u00e4\u00e4l\u00e4 and open data | 107 | micro-grid area in Lemp\u00e4\u00e4l\u00e4 and open data | ||
108 | sources.\r\n\r\nThe data for all of the datasets provided by ProCem | 108 | sources.\r\n\r\nThe data for all of the datasets provided by ProCem | ||
109 | have been collected using a custom data collection platform developed | 109 | have been collected using a custom data collection platform developed | ||
110 | as part of the projects. Thus all the data is stored in the same way | 110 | as part of the projects. Thus all the data is stored in the same way | ||
111 | and in the same format and accessing all the data happens in the same | 111 | and in the same format and accessing all the data happens in the same | ||
112 | way. If you are interested in learning more about the data collection | 112 | way. If you are interested in learning more about the data collection | ||
113 | platform, it has been described in a scientific article titled \"[A | 113 | platform, it has been described in a scientific article titled \"[A | ||
114 | Data Collection and Supplementary Control Platform of a Modern | 114 | Data Collection and Supplementary Control Platform of a Modern | ||
115 | Building for Smart Energy | 115 | Building for Smart Energy | ||
116 | ct.com/science/article/pii/S2352467722001734?via%3Dihub)\".\r\n\r\nThe | 116 | ct.com/science/article/pii/S2352467722001734?via%3Dihub)\".\r\n\r\nThe | ||
117 | data is stored in simple CSV files on a network drive where select | 117 | data is stored in simple CSV files on a network drive where select | ||
118 | project researchers have access to. All data from a measurement target | 118 | project researchers have access to. All data from a measurement target | ||
119 | (Kampusarreenao or Marjam\u00e4ki) for a day are stored in one file. | 119 | (Kampusarreenao or Marjam\u00e4ki) for a day are stored in one file. | ||
120 | One line of this CSV file contains these 3 items separated by a | 120 | One line of this CSV file contains these 3 items separated by a | ||
121 | tab:\r\n\r\n- id: Each measurement point has a unique id number. These | 121 | tab:\r\n\r\n- id: Each measurement point has a unique id number. These | ||
122 | are documented in each dataset.\r\n- value: The actual measurment | 122 | are documented in each dataset.\r\n- value: The actual measurment | ||
123 | value.\r\n- timestamp: Unix time in milliseconds i.e. milliseconds | 123 | value.\r\n- timestamp: Unix time in milliseconds i.e. milliseconds | ||
124 | since 1970-01-01 00:00 UTC time.\r\n\r\nIf you want to see a small | 124 | since 1970-01-01 00:00 UTC time.\r\n\r\nIf you want to see a small | ||
125 | example of how these files look like, you can check [this sample data | 125 | example of how these files look like, you can check [this sample data | ||
126 | dataset | 126 | dataset | ||
127 | ower-quality/resource/0abf89c6-bba6-4d5a-b45f-1f40fd9c5129).\r\n\r\nIf | 127 | ower-quality/resource/0abf89c6-bba6-4d5a-b45f-1f40fd9c5129).\r\n\r\nIf | ||
128 | you are interested in getting some data from the ProCem datasets, you | 128 | you are interested in getting some data from the ProCem datasets, you | ||
129 | can contact the person marked as the dataset maintainer. Since the raw | 129 | can contact the person marked as the dataset maintainer. Since the raw | ||
130 | data files are very large and contain data sensitive to the data | 130 | data files are very large and contain data sensitive to the data | ||
131 | owner, you will be provided filtered versions of the data files | 131 | owner, you will be provided filtered versions of the data files | ||
132 | containing only the data you require from the time period you want. So | 132 | containing only the data you require from the time period you want. So | ||
133 | if you already know precisely what data you want and from what time | 133 | if you already know precisely what data you want and from what time | ||
134 | period, you can provide the measurement ids of the measurements you | 134 | period, you can provide the measurement ids of the measurements you | ||
135 | want and a range of dates.\r\n\r\nNote: Though generally the data | 135 | want and a range of dates.\r\n\r\nNote: Though generally the data | ||
136 | collection has been continuous since the date marked as measurement | 136 | collection has been continuous since the date marked as measurement | ||
137 | start date, various issues with measurement devices, networking or the | 137 | start date, various issues with measurement devices, networking or the | ||
138 | collection system have caused breaks in data collection varying from | 138 | collection system have caused breaks in data collection varying from | ||
139 | minutes to days. So please take this into account when processing your | 139 | minutes to days. So please take this into account when processing your | ||
140 | data.", | 140 | data.", | ||
141 | "id": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | 141 | "id": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | ||
142 | "image_url": "", | 142 | "image_url": "", | ||
143 | "is_organization": true, | 143 | "is_organization": true, | ||
144 | "name": "procem", | 144 | "name": "procem", | ||
145 | "state": "active", | 145 | "state": "active", | ||
146 | "title": "ProCem", | 146 | "title": "ProCem", | ||
147 | "type": "organization" | 147 | "type": "organization" | ||
148 | }, | 148 | }, | ||
149 | "owner_org": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | 149 | "owner_org": "ec67e141-aa5e-46f7-b3ab-5a10c172e8e7", | ||
150 | "private": false, | 150 | "private": false, | ||
151 | "relationships_as_object": [], | 151 | "relationships_as_object": [], | ||
152 | "relationships_as_subject": [], | 152 | "relationships_as_subject": [], | ||
153 | "resources": [ | 153 | "resources": [ | ||
154 | { | 154 | { | ||
155 | "cache_last_updated": null, | 155 | "cache_last_updated": null, | ||
156 | "cache_url": null, | 156 | "cache_url": null, | ||
157 | "created": "2022-10-17T07:10:41.784458", | 157 | "created": "2022-10-17T07:10:41.784458", | ||
n | 158 | "datastore_active": false, | n | 158 | "datastore_active": true, |
159 | "description": "List of available measurements.", | 159 | "description": "List of available measurements.", | ||
160 | "format": "XLS", | 160 | "format": "XLS", | ||
161 | "hash": "", | 161 | "hash": "", | ||
162 | "id": "979dac23-1978-48db-a004-582920db7f4c", | 162 | "id": "979dac23-1978-48db-a004-582920db7f4c", | ||
163 | "last_modified": "2022-10-31T09:22:08.723382", | 163 | "last_modified": "2022-10-31T09:22:08.723382", | ||
n | 164 | "metadata_modified": "2022-10-31T09:22:08.747324", | n | 164 | "metadata_modified": "2022-10-31T09:30:42.919659", |
165 | "mimetype": "application/vnd.ms-excel", | 165 | "mimetype": "application/vnd.ms-excel", | ||
166 | "mimetype_inner": null, | 166 | "mimetype_inner": null, | ||
t | 167 | "name": "available_measurements.xlsx", | t | 167 | "name": "available_measurements.xls", |
168 | "package_id": "262e9cd6-3ae1-4586-b1ac-39c49a7addd3", | 168 | "package_id": "262e9cd6-3ae1-4586-b1ac-39c49a7addd3", | ||
169 | "position": 0, | 169 | "position": 0, | ||
170 | "resource_type": null, | 170 | "resource_type": null, | ||
171 | "size": 95232, | 171 | "size": 95232, | ||
172 | "state": "active", | 172 | "state": "active", | ||
173 | "url": | 173 | "url": | ||
174 | 0db7f4c/download/kampusareena_solar_plant_available_measurements.xls", | 174 | 0db7f4c/download/kampusareena_solar_plant_available_measurements.xls", | ||
175 | "url_type": "upload" | 175 | "url_type": "upload" | ||
176 | }, | 176 | }, | ||
177 | { | 177 | { | ||
178 | "cache_last_updated": null, | 178 | "cache_last_updated": null, | ||
179 | "cache_url": null, | 179 | "cache_url": null, | ||
180 | "created": "2022-10-26T13:42:57.888842", | 180 | "created": "2022-10-26T13:42:57.888842", | ||
181 | "datastore_active": true, | 181 | "datastore_active": true, | ||
182 | "description": "A small example data sample. Contains frequency | 182 | "description": "A small example data sample. Contains frequency | ||
183 | (id: 24001), active power (id: 24003) and cumulative power (id: 42444) | 183 | (id: 24001), active power (id: 24003) and cumulative power (id: 42444) | ||
184 | values from 24th of October 2022 between 12 PM and 13 PM local time.", | 184 | values from 24th of October 2022 between 12 PM and 13 PM local time.", | ||
185 | "format": "TSV", | 185 | "format": "TSV", | ||
186 | "hash": "", | 186 | "hash": "", | ||
187 | "id": "0abf89c6-bba6-4d5a-b45f-1f40fd9c5129", | 187 | "id": "0abf89c6-bba6-4d5a-b45f-1f40fd9c5129", | ||
188 | "last_modified": "2022-10-26T13:42:57.857887", | 188 | "last_modified": "2022-10-26T13:42:57.857887", | ||
189 | "metadata_modified": "2022-10-26T13:42:57.870383", | 189 | "metadata_modified": "2022-10-26T13:42:57.870383", | ||
190 | "mimetype": "text/tab-separated-values", | 190 | "mimetype": "text/tab-separated-values", | ||
191 | "mimetype_inner": null, | 191 | "mimetype_inner": null, | ||
192 | "name": "kampusareena_solar_plant_sample.tsv", | 192 | "name": "kampusareena_solar_plant_sample.tsv", | ||
193 | "package_id": "262e9cd6-3ae1-4586-b1ac-39c49a7addd3", | 193 | "package_id": "262e9cd6-3ae1-4586-b1ac-39c49a7addd3", | ||
194 | "position": 1, | 194 | "position": 1, | ||
195 | "resource_type": null, | 195 | "resource_type": null, | ||
196 | "size": 344998, | 196 | "size": 344998, | ||
197 | "state": "active", | 197 | "state": "active", | ||
198 | "url": | 198 | "url": | ||
199 | -4d5a-b45f-1f40fd9c5129/download/kampusareena_solar_plant_sample.tsv", | 199 | -4d5a-b45f-1f40fd9c5129/download/kampusareena_solar_plant_sample.tsv", | ||
200 | "url_type": "upload" | 200 | "url_type": "upload" | ||
201 | } | 201 | } | ||
202 | ], | 202 | ], | ||
203 | "state": "active", | 203 | "state": "active", | ||
204 | "tags": [ | 204 | "tags": [ | ||
205 | { | 205 | { | ||
206 | "display_name": "Kampusareena", | 206 | "display_name": "Kampusareena", | ||
207 | "id": "509dbd7e-76cf-40b1-801b-d8892486de87", | 207 | "id": "509dbd7e-76cf-40b1-801b-d8892486de87", | ||
208 | "name": "Kampusareena", | 208 | "name": "Kampusareena", | ||
209 | "state": "active", | 209 | "state": "active", | ||
210 | "vocabulary_id": null | 210 | "vocabulary_id": null | ||
211 | }, | 211 | }, | ||
212 | { | 212 | { | ||
213 | "display_name": "electricity", | 213 | "display_name": "electricity", | ||
214 | "id": "0c58cb6b-5845-4112-9871-6adda7eaac59", | 214 | "id": "0c58cb6b-5845-4112-9871-6adda7eaac59", | ||
215 | "name": "electricity", | 215 | "name": "electricity", | ||
216 | "state": "active", | 216 | "state": "active", | ||
217 | "vocabulary_id": null | 217 | "vocabulary_id": null | ||
218 | }, | 218 | }, | ||
219 | { | 219 | { | ||
220 | "display_name": "power quality", | 220 | "display_name": "power quality", | ||
221 | "id": "f75b4ff7-2ba6-44ba-8468-c1e9c3ba08e4", | 221 | "id": "f75b4ff7-2ba6-44ba-8468-c1e9c3ba08e4", | ||
222 | "name": "power quality", | 222 | "name": "power quality", | ||
223 | "state": "active", | 223 | "state": "active", | ||
224 | "vocabulary_id": null | 224 | "vocabulary_id": null | ||
225 | }, | 225 | }, | ||
226 | { | 226 | { | ||
227 | "display_name": "solar power", | 227 | "display_name": "solar power", | ||
228 | "id": "20afb7a2-23ce-4ac4-9771-11daa2964f88", | 228 | "id": "20afb7a2-23ce-4ac4-9771-11daa2964f88", | ||
229 | "name": "solar power", | 229 | "name": "solar power", | ||
230 | "state": "active", | 230 | "state": "active", | ||
231 | "vocabulary_id": null | 231 | "vocabulary_id": null | ||
232 | } | 232 | } | ||
233 | ], | 233 | ], | ||
234 | "title": "Kampusareena solar power plant energy production and power | 234 | "title": "Kampusareena solar power plant energy production and power | ||
235 | quality", | 235 | quality", | ||
236 | "type": "dataset", | 236 | "type": "dataset", | ||
237 | "url": "", | 237 | "url": "", | ||
238 | "version": "" | 238 | "version": "" | ||
239 | } | 239 | } |