Implement bandwidths and m:n relations

OpenEnergyPlatform / oedatamodel

A common open energy data model (oedatamodel) and datapackage format for energy and scenario data

Creative Commons Zero v1.0 Universal

7 stars 3 forks source link

Implement bandwidths and m:n relations #53

Closed henhuy closed 2 years ago

henhuy commented 2 years ago

Is related to #51

[x] Include bandwidths
[x] Include m:n relations for scalars and timeseries
[x] Update metadata versions
[x] Update ERM
[x] Update ERM PDFs with colors (not working on my maschine)

jh-RLI commented 2 years ago

I will try to create the colored pdf files. I think it would also be nice if the ID key was marked as the primary key by an underline, as it was in the "old" pdfs. I think that will be there automatically in the "colored PDFS".

jh-RLI commented 2 years ago

I think it is not clear so far how we should use the bandwidth columns and what value should be inserted in the value column of the scalar_instance table. Also, as far as I understand, there are several concepts for using bandwidths (max, min value, median... and so on - im not to familiar with this kind of data). Can you provide a clearer description of how the columns for bandwidths and bandwidths type are used and what value will be used in the scalar_instance table.

jh-RLI commented 2 years ago

Assuming the user wants to upload data to the oed v1.1.2, can we create a mapping that generates the bandwidth values from the provided data package (in concrete format) since there is no column in concrete for this. This question could be solved when I have a better understanding of the above questions.