1
|
|
|
from pathlib import Path |
2
|
|
|
import os |
3
|
|
|
|
4
|
|
|
from geoalchemy2 import Geometry |
5
|
|
|
from omi.dialects import get_dialect |
6
|
|
|
from sqlalchemy import MetaData, Table |
7
|
|
|
from sqlalchemy.dialects.postgresql.base import ischema_names |
8
|
|
|
|
9
|
|
|
from egon.data import db, logger |
10
|
|
|
from egon.data.datasets import Dataset |
11
|
|
|
from egon.data.db import engine |
12
|
|
|
from egon.data import __path__ as data_path |
13
|
|
|
|
14
|
|
|
def context(): |
15
|
|
|
""" |
16
|
|
|
Project context information for metadata |
17
|
|
|
|
18
|
|
|
Returns |
19
|
|
|
------- |
20
|
|
|
dict |
21
|
|
|
OEP metadata conform data license information |
22
|
|
|
""" |
23
|
|
|
|
24
|
|
|
return { |
25
|
|
|
"homepage": "https://ego-n.org/", |
26
|
|
|
"documentation": "https://egon-data.readthedocs.io/en/latest/", |
27
|
|
|
"sourceCode": "https://github.com/openego/eGon-data", |
28
|
|
|
"contact": "https://ego-n.org/partners/", |
29
|
|
|
"grantNo": "03EI1002", |
30
|
|
|
"fundingAgency": "Bundesministerium für Wirtschaft und Energie", |
31
|
|
|
"fundingAgencyLogo": "https://www.innovation-beratung-" |
32
|
|
|
"foerderung.de/INNO/Redaktion/DE/Bilder/" |
33
|
|
|
"Titelbilder/titel_foerderlogo_bmwi.jpg?" |
34
|
|
|
"__blob=normal&v=3", |
35
|
|
|
"publisherLogo": "https://ego-n.org/images/eGon_logo_" |
36
|
|
|
"noborder_transbg.svg", |
37
|
|
|
} |
38
|
|
|
|
39
|
|
|
|
40
|
|
|
def meta_metadata(): |
41
|
|
|
""" |
42
|
|
|
Meta data on metadata |
43
|
|
|
|
44
|
|
|
Returns |
45
|
|
|
------- |
46
|
|
|
dict |
47
|
|
|
OEP metadata conform metadata on metadata |
48
|
|
|
""" |
49
|
|
|
|
50
|
|
|
return { |
51
|
|
|
"metadataVersion": "OEP-1.4.1", |
52
|
|
|
"metadataLicense": { |
53
|
|
|
"name": "CC0-1.0", |
54
|
|
|
"title": "Creative Commons Zero v1.0 Universal", |
55
|
|
|
"path": ("https://creativecommons.org/publicdomain/zero/1.0/"), |
56
|
|
|
}, |
57
|
|
|
} |
58
|
|
|
|
59
|
|
|
|
60
|
|
|
def licenses_datenlizenz_deutschland(attribution): |
61
|
|
|
""" |
62
|
|
|
License information for Datenlizenz Deutschland |
63
|
|
|
|
64
|
|
|
Parameters |
65
|
|
|
---------- |
66
|
|
|
attribution : str |
67
|
|
|
Attribution for the dataset incl. © symbol, e.g. '© GeoBasis-DE / BKG' |
68
|
|
|
|
69
|
|
|
Returns |
70
|
|
|
------- |
71
|
|
|
dict |
72
|
|
|
OEP metadata conform data license information |
73
|
|
|
""" |
74
|
|
|
|
75
|
|
|
return { |
76
|
|
|
"name": "dl-by-de/2.0", |
77
|
|
|
"title": "Datenlizenz Deutschland – Namensnennung – Version 2.0", |
78
|
|
|
"path": "www.govdata.de/dl-de/by-2-0", |
79
|
|
|
"instruction": ( |
80
|
|
|
"Jede Nutzung ist unter den Bedingungen dieser „Datenlizenz " |
81
|
|
|
"Deutschland - Namensnennung - Version 2.0 zulässig.\nDie " |
82
|
|
|
"bereitgestellten Daten und Metadaten dürfen für die " |
83
|
|
|
"kommerzielle und nicht kommerzielle Nutzung insbesondere:" |
84
|
|
|
"(1) vervielfältigt, ausgedruckt, präsentiert, verändert, " |
85
|
|
|
"bearbeitet sowie an Dritte übermittelt werden;\n " |
86
|
|
|
"(2) mit eigenen Daten und Daten Anderer zusammengeführt und " |
87
|
|
|
"zu selbständigen neuen Datensätzen verbunden werden;\n " |
88
|
|
|
"(3) in interne und externe Geschäftsprozesse, Produkte und " |
89
|
|
|
"Anwendungen in öffentlichen und nicht öffentlichen " |
90
|
|
|
"elektronischen Netzwerken eingebunden werden.\n" |
91
|
|
|
"Bei der Nutzung ist sicherzustellen, dass folgende Angaben " |
92
|
|
|
"als Quellenvermerk enthalten sind:\n" |
93
|
|
|
"(1) Bezeichnung des Bereitstellers nach dessen Maßgabe,\n" |
94
|
|
|
"(2) der Vermerk Datenlizenz Deutschland – Namensnennung – " |
95
|
|
|
"Version 2.0 oder dl-de/by-2-0 mit Verweis auf den Lizenztext " |
96
|
|
|
"unter www.govdata.de/dl-de/by-2-0 sowie\n" |
97
|
|
|
"(3) einen Verweis auf den Datensatz (URI)." |
98
|
|
|
"Dies gilt nur soweit die datenhaltende Stelle die Angaben" |
99
|
|
|
"(1) bis (3) zum Quellenvermerk bereitstellt.\n" |
100
|
|
|
"Veränderungen, Bearbeitungen, neue Gestaltungen oder " |
101
|
|
|
"sonstige Abwandlungen sind im Quellenvermerk mit dem Hinweis " |
102
|
|
|
"zu versehen, dass die Daten geändert wurden." |
103
|
|
|
), |
104
|
|
|
"attribution": attribution, |
105
|
|
|
} |
106
|
|
|
|
107
|
|
|
|
108
|
|
|
def license_odbl(attribution): |
109
|
|
|
""" |
110
|
|
|
License information for Open Data Commons Open Database License (ODbL-1.0) |
111
|
|
|
|
112
|
|
|
Parameters |
113
|
|
|
---------- |
114
|
|
|
attribution : str |
115
|
|
|
Attribution for the dataset incl. © symbol, e.g. |
116
|
|
|
'© OpenStreetMap contributors' |
117
|
|
|
|
118
|
|
|
Returns |
119
|
|
|
------- |
120
|
|
|
dict |
121
|
|
|
OEP metadata conform data license information |
122
|
|
|
""" |
123
|
|
|
return { |
124
|
|
|
"name": "ODbL-1.0", |
125
|
|
|
"title": "Open Data Commons Open Database License 1.0", |
126
|
|
|
"path": "https://opendatacommons.org/licenses/odbl/1.0/index.html", |
127
|
|
|
"instruction": "You are free: To Share, To Create, To Adapt; " |
128
|
|
|
"As long as you: Attribute, Share-Alike, Keep open!", |
129
|
|
|
"attribution": attribution, |
130
|
|
|
} |
131
|
|
|
|
132
|
|
|
|
133
|
|
|
def license_ccby(attribution): |
134
|
|
|
""" |
135
|
|
|
License information for Creative Commons Attribution 4.0 International |
136
|
|
|
(CC-BY-4.0) |
137
|
|
|
|
138
|
|
|
Parameters |
139
|
|
|
---------- |
140
|
|
|
attribution : str |
141
|
|
|
Attribution for the dataset incl. © symbol, e.g. '© GeoBasis-DE / BKG' |
142
|
|
|
|
143
|
|
|
Returns |
144
|
|
|
------- |
145
|
|
|
dict |
146
|
|
|
OEP metadata conform data license information |
147
|
|
|
""" |
148
|
|
|
return { |
149
|
|
|
"name": "CC-BY-4.0", |
150
|
|
|
"title": "Creative Commons Attribution 4.0 International", |
151
|
|
|
"path": "https://creativecommons.org/licenses/by/4.0/legalcode", |
152
|
|
|
"instruction": "You are free: To Share, To Create, To Adapt; " |
153
|
|
|
"As long as you: Attribute.", |
154
|
|
|
"attribution": attribution, |
155
|
|
|
} |
156
|
|
|
|
157
|
|
|
|
158
|
|
|
def license_geonutzv(attribution): |
159
|
|
|
""" |
160
|
|
|
License information for GeoNutzV |
161
|
|
|
|
162
|
|
|
Parameters |
163
|
|
|
---------- |
164
|
|
|
attribution : str |
165
|
|
|
Attribution for the dataset incl. © symbol, e.g. '© GeoBasis-DE / BKG' |
166
|
|
|
|
167
|
|
|
Returns |
168
|
|
|
------- |
169
|
|
|
dict |
170
|
|
|
OEP metadata conform data license information |
171
|
|
|
""" |
172
|
|
|
return { |
173
|
|
|
"name": "geonutzv-de-2013-03-19", |
174
|
|
|
"title": "Verordnung zur Festlegung der Nutzungsbestimmungen für die " |
175
|
|
|
"Bereitstellung von Geodaten des Bundes", |
176
|
|
|
"path": "https://www.gesetze-im-internet.de/geonutzv/", |
177
|
|
|
"instruction": "Geodaten und Geodatendienste, einschließlich " |
178
|
|
|
"zugehöriger Metadaten, werden für alle derzeit " |
179
|
|
|
"bekannten sowie für alle zukünftig bekannten Zwecke " |
180
|
|
|
"kommerzieller und nicht kommerzieller Nutzung " |
181
|
|
|
"geldleistungsfrei zur Verfügung gestellt, soweit " |
182
|
|
|
"durch besondere Rechtsvorschrift nichts anderes " |
183
|
|
|
"bestimmt ist oder vertragliche oder gesetzliche " |
184
|
|
|
"Rechte Dritter dem nicht entgegenstehen.", |
185
|
|
|
"attribution": attribution, |
186
|
|
|
} |
187
|
|
|
|
188
|
|
|
|
189
|
|
|
def license_agpl(attribution): |
190
|
|
|
""" |
191
|
|
|
License information for GNU Affero General Public License v3.0 |
192
|
|
|
|
193
|
|
|
Parameters |
194
|
|
|
---------- |
195
|
|
|
attribution : str |
196
|
|
|
Attribution for the dataset incl. © symbol, e.g. '© GeoBasis-DE / BKG' |
197
|
|
|
|
198
|
|
|
Returns |
199
|
|
|
------- |
200
|
|
|
dict |
201
|
|
|
OEP metadata conform data license information |
202
|
|
|
""" |
203
|
|
|
return { |
204
|
|
|
"name": "AGPL-3.0 License", |
205
|
|
|
"title": "GNU Affero General Public License v3.0", |
206
|
|
|
"path": "https://www.gnu.org/licenses/agpl-3.0.de.html", |
207
|
|
|
"instruction": "Permissions of this strongest copyleft license are" |
208
|
|
|
"conditioned on making available complete source code of licensed " |
209
|
|
|
"works and modifications, which include larger works using a licensed" |
210
|
|
|
"work, under the same license. Copyright and license notices must be" |
211
|
|
|
"preserved. Contributors provide an express grant of patent rights." |
212
|
|
|
"When a modified version is used to provide a service over a network," |
213
|
|
|
"the complete source code of the modified version must be made " |
214
|
|
|
"available.", |
215
|
|
|
"attribution": attribution, |
216
|
|
|
} |
217
|
|
|
|
218
|
|
|
|
219
|
|
|
def license_dedl(attribution): |
220
|
|
|
""" |
221
|
|
|
License information for Data licence Germany – attribution – version 2.0 |
222
|
|
|
|
223
|
|
|
Parameters |
224
|
|
|
---------- |
225
|
|
|
attribution : str |
226
|
|
|
Attribution for the dataset incl. © symbol, e.g. '© GeoBasis-DE / BKG' |
227
|
|
|
|
228
|
|
|
Returns |
229
|
|
|
------- |
230
|
|
|
dict |
231
|
|
|
OEP metadata conform data license information |
232
|
|
|
""" |
233
|
|
|
return { |
234
|
|
|
"name": "DL-DE-BY-2.0", |
235
|
|
|
"title": "Data licence Germany – attribution – version 2.0", |
236
|
|
|
"path": "https://www.govdata.de/dl-de/by-2-0", |
237
|
|
|
"instruction": ( |
238
|
|
|
"Any use will be permitted provided it fulfils the requirements of" |
239
|
|
|
" this 'Data licence Germany – attribution – Version 2.0'. The " |
240
|
|
|
"data and meta-data provided may, for commercial and " |
241
|
|
|
"non-commercial use, in particular be copied, printed, presented, " |
242
|
|
|
"altered, processed and transmitted to third parties; be merged " |
243
|
|
|
"with own data and with the data of others and be combined to form" |
244
|
|
|
" new and independent datasets; be integrated in internal and " |
245
|
|
|
"external business processes, products and applications in public " |
246
|
|
|
"and non-public electronic networks. The user must ensure that the" |
247
|
|
|
" source note contains the following information: the name of the " |
248
|
|
|
"provider, the annotation 'Data licence Germany – attribution – " |
249
|
|
|
"Version 2.0' or 'dl-de/by-2-0' referring to the licence text " |
250
|
|
|
"available at www.govdata.de/dl-de/by-2-0, and a reference to the " |
251
|
|
|
"dataset (URI). This applies only if the entity keeping the data " |
252
|
|
|
"provides the pieces of information 1-3 for the source note. " |
253
|
|
|
"Changes, editing, new designs or other amendments must be marked " |
254
|
|
|
"as such in the source note." |
255
|
|
|
), |
256
|
|
|
"attribution": attribution, |
257
|
|
|
} |
258
|
|
|
|
259
|
|
|
|
260
|
|
|
def license_egon_data_odbl(): |
261
|
|
|
""" |
262
|
|
|
ODbL license with eGon data attribution |
263
|
|
|
|
264
|
|
|
Returns |
265
|
|
|
------- |
266
|
|
|
dict |
267
|
|
|
OEP metadata conform data license information for eGon tables |
268
|
|
|
""" |
269
|
|
|
return license_odbl("© eGon development team") |
270
|
|
|
|
271
|
|
|
|
272
|
|
|
def generate_resource_fields_from_sqla_model(model): |
273
|
|
|
"""Generate a template for the resource fields for metadata from a SQL |
274
|
|
|
Alchemy model. |
275
|
|
|
|
276
|
|
|
For details on the fields see field 14.6.1 of `Open Energy Metadata |
277
|
|
|
<https://github.com/OpenEnergyPlatform/ oemetadata/blob/develop/metadata/ |
278
|
|
|
v141/metadata_key_description.md>`_ standard. |
279
|
|
|
The fields `name` and `type` are automatically filled, the `description` |
280
|
|
|
and `unit` must be filled manually. |
281
|
|
|
|
282
|
|
|
Examples |
283
|
|
|
-------- |
284
|
|
|
>>> from egon.data.metadata import generate_resource_fields_from_sqla_model |
285
|
|
|
>>> from egon.data.datasets.zensus_vg250 import Vg250Sta |
286
|
|
|
>>> resources = generate_resource_fields_from_sqla_model(Vg250Sta) |
287
|
|
|
|
288
|
|
|
Parameters |
289
|
|
|
---------- |
290
|
|
|
model : sqlalchemy.ext.declarative.declarative_base() |
291
|
|
|
SQLA model |
292
|
|
|
|
293
|
|
|
Returns |
294
|
|
|
------- |
295
|
|
|
list of dict |
296
|
|
|
Resource fields |
297
|
|
|
""" |
298
|
|
|
|
299
|
|
|
return [ |
300
|
|
|
{ |
301
|
|
|
"name": col.name, |
302
|
|
|
"description": "", |
303
|
|
|
"type": str(col.type).lower(), |
304
|
|
|
"unit": "none", |
305
|
|
|
} |
306
|
|
|
for col in model.__table__.columns |
307
|
|
|
] |
308
|
|
|
|
309
|
|
|
|
310
|
|
|
def generate_resource_fields_from_db_table(schema, table, geom_columns=None): |
311
|
|
|
"""Generate a template for the resource fields for metadata from a |
312
|
|
|
database table. |
313
|
|
|
|
314
|
|
|
For details on the fields see field 14.6.1 of `Open Energy Metadata |
315
|
|
|
<https://github.com/OpenEnergyPlatform/ oemetadata/blob/develop/metadata/ |
316
|
|
|
v141/metadata_key_description.md>`_ standard. |
317
|
|
|
The fields `name` and `type` are automatically filled, the `description` |
318
|
|
|
and `unit` must be filled manually. |
319
|
|
|
|
320
|
|
|
Examples |
321
|
|
|
-------- |
322
|
|
|
>>> from egon.data.metadata import generate_resource_fields_from_db_table |
323
|
|
|
>>> resources = generate_resource_fields_from_db_table( |
324
|
|
|
... 'openstreetmap', 'osm_point', ['geom', 'geom_centroid'] |
325
|
|
|
... ) # doctest: +SKIP |
326
|
|
|
|
327
|
|
|
Parameters |
328
|
|
|
---------- |
329
|
|
|
schema : str |
330
|
|
|
The target table's database schema |
331
|
|
|
table : str |
332
|
|
|
Database table on which to put the given comment |
333
|
|
|
geom_columns : list of str |
334
|
|
|
Names of all geometry columns in the table. This is required to return |
335
|
|
|
Geometry data type for those columns as SQL Alchemy does not recognize |
336
|
|
|
them correctly. Defaults to ['geom']. |
337
|
|
|
|
338
|
|
|
Returns |
339
|
|
|
------- |
340
|
|
|
list of dict |
341
|
|
|
Resource fields |
342
|
|
|
""" |
343
|
|
|
|
344
|
|
|
# handle geometry columns |
345
|
|
|
if geom_columns is None: |
346
|
|
|
geom_columns = ["geom"] |
347
|
|
|
for col in geom_columns: |
348
|
|
|
ischema_names[col] = Geometry |
349
|
|
|
|
350
|
|
|
table = Table( |
351
|
|
|
table, MetaData(), schema=schema, autoload=True, autoload_with=engine() |
352
|
|
|
) |
353
|
|
|
|
354
|
|
|
return [ |
355
|
|
|
{ |
356
|
|
|
"name": col.name, |
357
|
|
|
"description": "", |
358
|
|
|
"type": str(col.type).lower(), |
359
|
|
|
"unit": "none", |
360
|
|
|
} |
361
|
|
|
for col in table.c |
362
|
|
|
] |
363
|
|
|
|
364
|
|
|
|
365
|
|
|
def sources(): |
366
|
|
|
return { |
367
|
|
|
"bgr_inspee": { |
368
|
|
|
"title": "Salt structures in Northern Germany", |
369
|
|
|
"description": 'The application "Information System Salt Structures" provides information about the ' |
370
|
|
|
"areal distribution of salt structures (stocks and pillows) in Northern Germany. With general structural " |
371
|
|
|
"describing information, such as depth, secondary thickness, types of use or state of exploration, queries " |
372
|
|
|
"can be conducted. Contours of the salt structures can be displayed at horizontal cross-sections at four " |
373
|
|
|
"different depths up to a maximum depth of 2000 m below NN. A data sheet with information and further " |
374
|
|
|
"reading is provided for every single salt structure. Taking into account the fact that this work was " |
375
|
|
|
"undertaken at a scale for providing an overview and not for investigation of single structures, the scale " |
376
|
|
|
"of display is limited to a minimum of 1:300.000. This web application is the product of a BMWi-funded " |
377
|
|
|
'research project "InSpEE" running from the year 2012 to 2015. The acronym stands for "Information system ' |
378
|
|
|
"salt structures: planning basis, selection criteria and estimation of the potential for the construction " |
379
|
|
|
'of salt caverns for the storage of renewable energies (hydrogen and compressed air)".', |
380
|
|
|
"path": "https://produktcenter.bgr.de/terraCatalog/DetailResult.do?fileIdentifier=338136ea-261a-4569-a2bf-92999d09bad2", |
381
|
|
|
"licenses": [license_geonutzv("© BGR, Hannover, 2015")], |
382
|
|
|
}, |
383
|
|
|
"bgr_inspeeds": { |
384
|
|
|
"title": "Flat layered salts in Germany", |
385
|
|
|
"description": "Which salt formations are suitable for storing hydrogen or compressed air? " |
386
|
|
|
"In the InSpEE-DS research project, scientists developed requirements and criteria for the assessment " |
387
|
|
|
"of suitable sites even if their exploration is still at an early stage and there is little knowledge of " |
388
|
|
|
"the salinaries' structures. Scientists at DEEP.KBB GmbH in Hanover, worked together with their project " |
389
|
|
|
"partners at the Federal Institute for Geosciences and Natural Resources and the Leibniz University " |
390
|
|
|
"Hanover, Institute for Geotechnics Hanover, to develop the planning basis for the site selection and for " |
391
|
|
|
"the construction of storage caverns in flat layered salt and multiple or double saliniferous formations. " |
392
|
|
|
"Such caverns could store renewable energy in the form of hydrogen or compressed air. While the previous " |
393
|
|
|
"project InSpEE was limited to salt formations of great thickness in Northern Germany, salt horizons of " |
394
|
|
|
"different ages have now been examined all over Germany. To estimate the potential, depth contour maps of " |
395
|
|
|
"the top and the base as well as thickness maps of the respective stratigraphic units and reference " |
396
|
|
|
"profiles were developed. Information on compressed air and hydrogen storage potential were given for the " |
397
|
|
|
"identified areas and for the individual federal states. The web service " |
398
|
|
|
'"Information system for flat layered salt" gives access to this data. The scale of display is limited ' |
399
|
|
|
"to a minimum of 1:300.000. This geographic information is product of a BMWi-funded research project " |
400
|
|
|
'"InSpEE-DS" running from the year 2015 to 2019. The acronym stands for "Information system salt: ' |
401
|
|
|
"planning basis, selection criteria and estimation of the potential for the construction of salt caverns " |
402
|
|
|
'for the storage of renewable energies (hydrogen and compressed air) - double saline and flat salt layers".', |
403
|
|
|
"path": "https://produktcenter.bgr.de/terraCatalog/DetailResult.do?fileIdentifier=630430b8-4025-4d6f-9a62-025b53bc8b3d", |
404
|
|
|
"licenses": [license_geonutzv("© BGR, Hannover, 2021")], |
405
|
|
|
}, |
406
|
|
|
"bgr_inspeeds_data_bundle": { |
407
|
|
|
"title": "Informationssystem Salz: Planungsgrundlagen, Auswahlkriterien und Potenzialabschätzung für die " |
408
|
|
|
"Errichtung von Salzkavernen zur Speicherung von Erneuerbaren Energien (Wasserstoff und Druckluft) – " |
409
|
|
|
"Doppelsalinare und flach lagernde Salzschichten. Teilprojekt Bewertungskriterien und Potenzialabschätzung", |
410
|
|
|
"description": "Shapefiles corresponding to the data provided in figure 7-1 " |
411
|
|
|
"(Donadei, S., et al., 2020, p. 7-5). The energy storage potential data are provided per federal state " |
412
|
|
|
" in table 7-1 (Donadei, S., et al., 2020, p. 7-4). Note: Please include all bgr data sources when using " |
413
|
|
|
"the data.", |
414
|
|
|
"path": "https://dx.doi.org/10.5281/zenodo.4896526", |
415
|
|
|
"licenses": [license_geonutzv("© BGR, Hannover, 2021")], |
416
|
|
|
}, |
417
|
|
|
"bgr_inspeeds_report": { |
418
|
|
|
"title": "Informationssystem Salz: Planungsgrundlagen, Auswahlkriterien und Potenzialabschätzung für die " |
419
|
|
|
"Errichtung von Salzkavernen zur Speicherung von Erneuerbaren Energien (Wasserstoff und Druckluft) – " |
420
|
|
|
"Doppelsalinare und flach lagernde Salzschichten. Teilprojekt Bewertungskriterien und Potenzialabschätzung", |
421
|
|
|
"description": "The report includes availability of saltstructures for energy storage and energy " |
422
|
|
|
"storage potential accumulated per federal state in Germany.", |
423
|
|
|
"path": "https://www.bgr.bund.de/DE/Themen/Nutzung_tieferer_Untergrund_CO2Speicherung/Downloads/InSpeeDS_TP_Bewertungskriterien.pdf?__blob=publicationFile&v=3", |
424
|
|
|
"licenses": [license_geonutzv("© BGR, Hannover, 2021")], |
425
|
|
|
}, |
426
|
|
|
"demandregio": { |
427
|
|
|
"title": "DemandRegio", |
428
|
|
|
"description": "Harmonisierung und Entwicklung von Verfahren zur regionalen und " |
429
|
|
|
"zeitlichen Auflösung von Energienachfragen", |
430
|
|
|
"path": "https://doi.org/10.34805/ffe-119-20", |
431
|
|
|
"licenses": [license_ccby("© FZJ, TUB, FfE")], |
432
|
|
|
}, |
433
|
|
|
"egon-data": { |
434
|
|
|
"title": "eGon-data", |
435
|
|
|
"description": "Workflow to download, process and generate data sets" |
436
|
|
|
"suitable for the further research conducted in the project eGon (https://ego-n.org/)", |
437
|
|
|
"path": "https://github.com/openego/eGon-data", |
438
|
|
|
"licenses": [license_agpl("© eGon development team")], |
439
|
|
|
}, |
440
|
|
|
"egon-data_bundle": { |
441
|
|
|
"title": "Data bundle for egon-data", |
442
|
|
|
"description": "Zenodo repository to provide several different input data sets for eGon-data", |
443
|
|
|
"path": "https://sandbox.zenodo.org/record/1167119", |
444
|
|
|
"licenses": [license_ccby("© eGon development team")], |
445
|
|
|
}, |
446
|
|
|
"Einspeiseatlas": { |
447
|
|
|
"title": "Einspeiseatlas", |
448
|
|
|
"description": "Im Einspeiseatlas finden sie sich die Informationen " |
449
|
|
|
"zu realisierten und geplanten Biomethanaufbereitungsanlagen - mit " |
450
|
|
|
"und ohne Einspeisung ins Gasnetz - in Deutschland und weltweit.", |
451
|
|
|
"path": "https://www.biogaspartner.de/einspeiseatlas/", |
452
|
|
|
"licenses": [ |
453
|
|
|
license_ccby("Deutsche Energie-Agentur (dena, 2021)") |
454
|
|
|
], |
455
|
|
|
}, |
456
|
|
|
"era5": { |
457
|
|
|
"title": "ERA5 global reanalysis", |
458
|
|
|
"description": "ERA5 is the fifth generation ECMWF reanalysis for the global climate " |
459
|
|
|
"and weather for the past 4 to 7 decades. Currently data is available from 1950, " |
460
|
|
|
"split into Climate Data Store entries for 1950-1978 (preliminary back extension) and f" |
461
|
|
|
"rom 1979 onwards (final release plus timely updates, this page). ERA5 replaces the ERA-Interim reanalysis. " |
462
|
|
|
"See the online ERA5 documentation " |
463
|
|
|
"(https://confluence.ecmwf.int/display/CKB/ERA5%3A+data+documentation#ERA5:datadocumentation-Dataupdatefrequency) " |
464
|
|
|
"for more information.", |
465
|
|
|
"path": "https://confluence.ecmwf.int/display/CKB/ERA5%3A+data+documentation#ERA5:datadocumentation-Dataupdatefrequency", |
466
|
|
|
"licenses": [ |
467
|
|
|
{ |
468
|
|
|
"name": "Licence to use Copernicus Products", |
469
|
|
|
"title": "Licence to use Copernicus Products", |
470
|
|
|
"path": "https://cds.climate.copernicus.eu/api/v2/terms/static/licence-to-use-copernicus-products.pdf", |
471
|
|
|
"instruction": "This Licence is free of charge, worldwide, non-exclusive, royalty free and perpetual. " |
472
|
|
|
"Access to Copernicus Products is given for any purpose in so far as it is lawful, whereas use " |
473
|
|
|
"may include, but is not limited to: reproduction; distribution; communication to the public; " |
474
|
|
|
"adaptation, modification and combination with other data and information; or any " |
475
|
|
|
"combination of the foregoing", |
476
|
|
|
"attribution": "Copernicus Climate Change Service (C3S) Climate Data Store", |
477
|
|
|
}, |
478
|
|
|
], |
479
|
|
|
}, |
480
|
|
|
"dsm-heitkoetter": { |
481
|
|
|
"title": "Assessment of the regionalised demand response potential " |
482
|
|
|
"in Germany using an open source tool and dataset", |
483
|
|
|
"description": "With the expansion of renewable energies in Germany, " |
484
|
|
|
"imminent grid congestion events occur more often. One approach for " |
485
|
|
|
"avoiding curtailment of renewable energies is to cover excess feed-in " |
486
|
|
|
"by demand response. As curtailment is often a local phenomenon, in " |
487
|
|
|
"this work we determine the regional demand response potential for " |
488
|
|
|
"the 401 German administrative districts with a temporal resolution " |
489
|
|
|
"of 15 min, including technical, socio-technical and economic " |
490
|
|
|
"restrictions.", |
491
|
|
|
"path": "https://doi.org/10.1016/j.adapen.2020.100001", |
492
|
|
|
"licenses": [ |
493
|
|
|
license_ccby( |
494
|
|
|
"© 2020 German Aerospace Center (DLR), " |
495
|
|
|
"Institute of Networked Energy Systems." |
496
|
|
|
) |
497
|
|
|
], |
498
|
|
|
}, |
499
|
|
|
"hotmaps_industrial_sites": { |
500
|
|
|
"titel": "industrial_sites_Industrial_Database", |
501
|
|
|
"description": "Georeferenced industrial sites of energy-intensive industry sectors in EU28", |
502
|
|
|
"path": "https://gitlab.com/hotmaps/industrial_sites/industrial_sites_Industrial_Database", |
503
|
|
|
"licenses": [ |
504
|
|
|
license_ccby("© 2016-2018: Pia Manz, Tobias Fleiter") |
505
|
|
|
], |
506
|
|
|
}, |
507
|
|
|
"hotmaps_scen_buildings": { |
508
|
|
|
"titel": "scen_current_building_demand", |
509
|
|
|
"description": "Energy demand scenarios in buidlings until the year 2050 - current policy scenario", |
510
|
|
|
"path": "https://gitlab.com/hotmaps/scen_current_building_demand", |
511
|
|
|
"licenses": [ |
512
|
|
|
license_ccby( |
513
|
|
|
"© 2016-2018: Michael Hartner, Lukas Kranzl, Sebastian Forthuber, Sara Fritz, Andreas Müller" |
514
|
|
|
) |
515
|
|
|
], |
516
|
|
|
}, |
517
|
|
|
"mastr": { |
518
|
|
|
"title": "open-MaStR power unit registry", |
519
|
|
|
"description": "Raw data download Marktstammdatenregister (MaStR) data " |
520
|
|
|
"using the webservice. All data from the Marktstammdatenregister is included." |
521
|
|
|
"There are duplicates included. For further information read in the documentation" |
522
|
|
|
"of the original data source: https://www.marktstammdatenregister.de/MaStRHilfe/subpages/statistik.html", |
523
|
|
|
"path": "https://sandbox.zenodo.org/record/808086", |
524
|
|
|
"licenses": [ |
525
|
|
|
licenses_datenlizenz_deutschland( |
526
|
|
|
"© 2021 Bundesnetzagentur für Elektrizität, Gas, Telekommunikation, Post und Eisenbahnen" |
527
|
|
|
) |
528
|
|
|
], |
529
|
|
|
}, |
530
|
|
|
"nep2021": { |
531
|
|
|
"title": "Netzentwicklungsplan Strom 2035, Version 2021, erster Entwurf", |
532
|
|
|
"description": "Die vier deutschen Übertragungsnetzbetreiber zeigen mit " |
533
|
|
|
"diesem ersten Entwurf des Netzentwicklungsplans 2035, Version 2021, den " |
534
|
|
|
"benötigten Netzausbau für die nächsten Jahre auf. Der NEP-Bericht beschreibt " |
535
|
|
|
"keine konkreten Trassenverläufe von Übertragungsleitungen, sondern er " |
536
|
|
|
"dokumentiert den notwendigen Übertragungsbedarf zwischen Netzknoten. " |
537
|
|
|
"Das heißt, es werden Anfangs- und Endpunkte von zukünftigen Leitungsverbindungen " |
538
|
|
|
"definiert sowie konkrete Empfehlungen für den Aus- und Neubau der Übertragungsnetze " |
539
|
|
|
"an Land und auf See in Deutschland gemäß den Detailanforderungen im § 12 EnWG gegeben.", |
540
|
|
|
"path": "https://zenodo.org/record/5743452#.YbCoz7so8go", |
541
|
|
|
"licenses": [license_ccby("© Übertragungsnetzbetreiber")], |
542
|
|
|
}, |
543
|
|
|
"openffe_gas": { |
544
|
|
|
"title": "Load Curves of the Industry Sector – eXtremOS solidEU Scenario (Europe NUTS-3)", |
545
|
|
|
"description": "Load Curves of the Industry Sector for the eXtremOS solidEU Scenario Scenario at NUTS-3-Level. " |
546
|
|
|
"More information at https://extremos.ffe.de/.", |
547
|
|
|
"path": "http://opendata.ffe.de/dataset/load-curves-of-the-industry-sector-extremos-solideu-scenario-europe-nuts-3/", |
548
|
|
|
"licenses": [license_ccby("© FfE, eXtremOS Project")], |
549
|
|
|
}, |
550
|
|
|
"openstreetmap": { |
551
|
|
|
"title": "OpenStreetMap Data Extracts (Geofabrik)", |
552
|
|
|
"description": "Full data extract of OpenStreetMap data for defined" |
553
|
|
|
"spatial extent at ''referenceDate''", |
554
|
|
|
"path": "https://download.geofabrik.de/europe/germany-210101.osm.pbf", |
555
|
|
|
"licenses": [license_odbl("© OpenStreetMap contributors")], |
556
|
|
|
}, |
557
|
|
|
"peta": { |
558
|
|
|
"title": "Pan-European Thermal Atlas, Peta version 5.0.1", |
559
|
|
|
"description": "Modelled Heat Demand distribution (in GJ per hectare grid cell) for residential and service " |
560
|
|
|
"heat demands for space heating and hot water for the year 2015 using HRE4 data and the combined " |
561
|
|
|
"top-down bottom-up approach of HRE4. " |
562
|
|
|
"National sector-specific heat demand data, derived by the FORECAST model in HRE4 for residential " |
563
|
|
|
"(delivered energy, for space heating and hot water) and service-sector (delivered energy, for space heating, hot " |
564
|
|
|
"water and process heat) buildings for the year 2015, were distributed using modelled, spatial " |
565
|
|
|
"statistics based floor areas in 100x100m grids and a population grid. " |
566
|
|
|
"For further information please see the documentation available on the Heat Roadmap Europe website, " |
567
|
|
|
"in particular D2.3 report: Methodologies and assumptions used in the mapping.", |
568
|
|
|
"path": "https://s-eenergies-open-data-euf.hub.arcgis.com/search", |
569
|
|
|
"licenses": [ |
570
|
|
|
license_ccby( |
571
|
|
|
"© Europa-Universität Flensburg, Halmstad University and Aalborg University" |
572
|
|
|
) |
573
|
|
|
], |
574
|
|
|
}, |
575
|
|
|
"pipeline_classification": { |
576
|
|
|
"title": "Technical pipeline characteristics for high pressure pipelines", |
577
|
|
|
"description": "Parameters for the classification of gas pipelines, " |
578
|
|
|
"the whole documentation could is available at: " |
579
|
|
|
"https://www.econstor.eu/bitstream/10419/173388/1/1011162628.pdf", |
580
|
|
|
"path": "https://zenodo.org/record/5743452", |
581
|
|
|
"licenses": [license_ccby("© DIW Berlin, 2017")], |
582
|
|
|
}, |
583
|
|
|
"schmidt": { |
584
|
|
|
"title": "Supplementary material to the masters thesis: " |
585
|
|
|
"NUTS-3 Regionalization of Industrial Load Shifting Potential in Germany using a Time-Resolved Model", |
586
|
|
|
"description": "Supplementary material to the named masters thesis, containing data on industrial processes" |
587
|
|
|
"for the estimation of NUTS-3 load shifting potential of suitable electrically powered industrial processes" |
588
|
|
|
"(cement milling, mechanical pulping, paper production, air separation).", |
589
|
|
|
"path": "https://zenodo.org/record/3613767", |
590
|
|
|
"licenses": [license_ccby("© 2019 Danielle Schmidt")], |
591
|
|
|
}, |
592
|
|
|
"SciGRID_gas": { |
593
|
|
|
"title": "SciGRID_gas IGGIELGN", |
594
|
|
|
"description": "The SciGRID_gas dataset represents the European " |
595
|
|
|
"gas transport network (pressure levels of 20 bars and higher) " |
596
|
|
|
"including the geo-referenced transport pipelines, compressor " |
597
|
|
|
"stations, LNG terminals, storage, production sites, gas power " |
598
|
|
|
"plants, border points, and demand time series. ", |
599
|
|
|
"path": "https://dx.doi.org/10.5281/zenodo.4896526", |
600
|
|
|
"licenses": [ |
601
|
|
|
license_ccby( |
602
|
|
|
"Jan Diettrich; Adam Pluta; Wided Medjroubi (DLR-VE)" |
603
|
|
|
), |
604
|
|
|
], |
605
|
|
|
}, |
606
|
|
|
"seenergies": { |
607
|
|
|
"title": "D5 1 Industry Dataset With Demand Data", |
608
|
|
|
"description": "Georeferenced EU28 industrial sites with quantified annual excess heat volumes and demand data" |
609
|
|
|
"within main sectors: Chemical industry, Iron and steel, Non-ferrous metals, Non-metallic minerals, Paper and printing, and Refineries.", |
610
|
|
|
"path": "https://s-eenergies-open-data-euf.hub.arcgis.com/datasets/5e36c0af918040ed936b4e4c101f611d_0/about", |
611
|
|
|
"licenses": [license_ccby("© Europa-Universität Flensburg")], |
612
|
|
|
}, |
613
|
|
|
"technology-data": { |
614
|
|
|
"titel": "Energy System Technology Data v0.3.0", |
615
|
|
|
"description": "This script compiles assumptions on energy system " |
616
|
|
|
"technologies (such as costs, efficiencies, lifetimes, etc.) for " |
617
|
|
|
"chosen years (e.g. [2020, 2030, 2050]) from a variety of sources " |
618
|
|
|
"into CSV files to be read by energy system modelling software. " |
619
|
|
|
"The merged outputs have standardized cost years, technology names, " |
620
|
|
|
"units and source information.", |
621
|
|
|
"path": "https://github.com/PyPSA/technology-data/tree/v0.3.0", |
622
|
|
|
"licenses": [ |
623
|
|
|
license_agpl( |
624
|
|
|
"© Marta Victoria (Aarhus University), Kun Zhu (Aarhus University), Elisabeth Zeyen (TUB), Tom Brown (TUB)" |
625
|
|
|
) |
626
|
|
|
], |
627
|
|
|
}, |
628
|
|
|
"tyndp": { |
629
|
|
|
"title": "Ten-Year Network Development Plan (TYNDP) 2020 Scenarios", |
630
|
|
|
"description": "ENTSOs’ TYNDP 2020 Scenario Report describes possible European energy futures up to 2050. " |
631
|
|
|
"Scenarios are not forecasts; they set out a range of possible futures used by the ENTSOs to test future " |
632
|
|
|
"electricity and gas infrastructure needs and projects. The scenarios are ambitious as they deliver " |
633
|
|
|
"a low carbon energy system for Europe by 2050. The ENTSOs have developed credible scenarios that are " |
634
|
|
|
"guided by technically sound pathways, while reflecting country by country specifics, so that a pan-European " |
635
|
|
|
"low carbon future is achieved.", |
636
|
|
|
"path": "https://tyndp.entsoe.eu/maps-data", |
637
|
|
|
"licenses": [license_ccby("© ENTSO-E and ENTSOG")], |
638
|
|
|
}, |
639
|
|
|
"vg250": { |
640
|
|
|
"title": "Verwaltungsgebiete 1:250 000 (Ebenen)", |
641
|
|
|
"description": "Der Datenbestand umfasst sämtliche Verwaltungseinheiten der " |
642
|
|
|
"hierarchischen Verwaltungsebenen vom Staat bis zu den Gemeinden " |
643
|
|
|
"mit ihren Grenzen, statistischen Schlüsselzahlen, Namen der " |
644
|
|
|
"Verwaltungseinheit sowie die spezifische Bezeichnung der " |
645
|
|
|
"Verwaltungsebene des jeweiligen Landes.", |
646
|
|
|
"path": "https://daten.gdz.bkg.bund.de/produkte/vg/vg250_ebenen_0101/2020/vg250_01-01.geo84.shape.ebenen.zip", |
647
|
|
|
"licenses": [ |
648
|
|
|
licenses_datenlizenz_deutschland( |
649
|
|
|
"© Bundesamt für Kartographie und Geodäsie " |
650
|
|
|
"2020 (Daten verändert)" |
651
|
|
|
) |
652
|
|
|
], |
653
|
|
|
}, |
654
|
|
|
"zensus": { |
655
|
|
|
"title": "Statistisches Bundesamt (Destatis) - Ergebnisse des Zensus 2011 zum Download", |
656
|
|
|
"description": "Als Download bieten wir Ihnen auf dieser Seite zusätzlich zur " |
657
|
|
|
"Zensusdatenbank CSV- und teilweise Excel-Tabellen mit umfassenden Personen-, Haushalts- " |
658
|
|
|
"und Familien- sowie Gebäude- und Wohnungsmerkmalen. Die Ergebnisse liegen auf Bundes-, " |
659
|
|
|
"Länder-, Kreis- und Gemeindeebene vor. Außerdem sind einzelne Ergebnisse für Gitterzellen verfügbar.", |
660
|
|
|
"path": "https://www.zensus2011.de/SharedDocs/Aktuelles/Ergebnisse/DemografischeGrunddaten.html;jsessionid=E0A2B4F894B258A3B22D20448F2E4A91.2_cid380?nn=3065474", |
661
|
|
|
"licenses": [ |
662
|
|
|
licenses_datenlizenz_deutschland( |
663
|
|
|
"© Statistische Ämter des Bundes und der Länder 2014" |
664
|
|
|
) |
665
|
|
|
], |
666
|
|
|
}, |
667
|
|
|
} |
668
|
|
|
|
669
|
|
|
|
670
|
|
|
def contributors(authorlist): |
671
|
|
|
contributors_dict = { |
672
|
|
|
"am": { |
673
|
|
|
"title": "Aadit Malla", |
674
|
|
|
"email": "https://github.com/aadit879", |
675
|
|
|
}, |
676
|
|
|
"an": { |
677
|
|
|
"title": "Amélia Nadal", |
678
|
|
|
"email": "https://github.com/AmeliaNadal", |
679
|
|
|
}, |
680
|
|
|
"cb": { |
681
|
|
|
"title": "Clara Büttner", |
682
|
|
|
"email": "https://github.com/ClaraBuettner", |
683
|
|
|
}, |
684
|
|
|
"ce": { |
685
|
|
|
"title": "Carlos Epia", |
686
|
|
|
"email": "https://github.com/CarlosEpia", |
687
|
|
|
}, |
688
|
|
|
"fw": { |
689
|
|
|
"title": "Francesco Witte", |
690
|
|
|
"email": "https://github.com/fwitte", |
691
|
|
|
}, |
692
|
|
|
"gp": { |
693
|
|
|
"title": "Guido Pleßmann", |
694
|
|
|
"email": "https://github.com/gplssm", |
695
|
|
|
}, |
696
|
|
|
"ic": { |
697
|
|
|
"title": "Ilka Cußmann", |
698
|
|
|
"email": "https://github.com/IlkaCu", |
699
|
|
|
}, |
700
|
|
|
"ja": { |
701
|
|
|
"title": "Jonathan Amme", |
702
|
|
|
"email": "https://github.com/nesnoj", |
703
|
|
|
}, |
704
|
|
|
"je": { |
705
|
|
|
"title": "Jane Doe", |
706
|
|
|
"email": "https://github.com/JaneDoe", |
707
|
|
|
}, |
708
|
|
|
"ke": { |
709
|
|
|
"title": "Katharina Esterl", |
710
|
|
|
"email": "https://github.com/KathiEsterl", |
711
|
|
|
}, |
712
|
|
|
"kh": { |
713
|
|
|
"title": "Kilian Helfenbein", |
714
|
|
|
"email": "https://github.com/khelfen", |
715
|
|
|
}, |
716
|
|
|
"sg": { |
717
|
|
|
"title": "Stephan Günther", |
718
|
|
|
"email": "https://github.com/gnn", |
719
|
|
|
}, |
720
|
|
|
"um": { |
721
|
|
|
"title": "Ulf Müller", |
722
|
|
|
"email": "https://github.com/ulfmueller", |
723
|
|
|
}, |
724
|
|
|
} |
725
|
|
|
return [ |
726
|
|
|
{key: value for key, value in contributors_dict[author].items()} |
727
|
|
|
for author in authorlist |
728
|
|
|
] |
729
|
|
|
|
730
|
|
|
|
731
|
|
|
def upload_json_metadata(): |
732
|
|
|
"""Upload json metadata into db from zenodo""" |
733
|
|
|
path = Path(data_path[0]) / "json_metadata" |
734
|
|
|
|
735
|
|
|
v = "oep-v1.4" |
736
|
|
|
|
737
|
|
|
for file in os.listdir(path=str(path)): |
738
|
|
|
|
739
|
|
|
if file.endswith(".json"): |
740
|
|
|
split = file.split(".") |
741
|
|
|
if len(split) != 3: |
742
|
|
|
continue |
743
|
|
|
schema = split[0] |
744
|
|
|
table = split[1] |
745
|
|
|
|
746
|
|
|
dialect = get_dialect(v)() |
747
|
|
|
|
748
|
|
|
with open(file, "r") as infile: |
749
|
|
|
obj = dialect.parse(infile.read()) |
750
|
|
|
|
751
|
|
|
meta_data_string = dialect.compile_and_render(obj) |
752
|
|
|
meta_json = "'" + meta_data_string + "'" |
753
|
|
|
db.submit_comment(meta_json, schema, table) |
754
|
|
|
logger.info(f"{schema}.{table} uploaded!") |
755
|
|
|
|
756
|
|
|
|
757
|
|
|
class Json_Metadata(Dataset): |
758
|
|
|
def __init__(self, dependencies): |
759
|
|
|
super().__init__( |
760
|
|
|
name="JsonMetadata", |
761
|
|
|
version="0.0.0", |
762
|
|
|
dependencies=dependencies, |
763
|
|
|
tasks={upload_json_metadata}, |
764
|
|
|
) |
765
|
|
|
|