oeplatform icon indicating copy to clipboard operation
oeplatform copied to clipboard

Missing Schema Description

Open johannwagner opened this issue 5 years ago • 28 comments

We needed the schema description for some more schemas, which are not listed within the wiki. (https://wiki.openmod-initiative.org/wiki/Database_schema)

  • emission
  • openstreetmap

johannwagner avatar Feb 11 '20 08:02 johannwagner

According to the related Redmine ticket @han-f can contribute to this.

jh-RLI avatar Mar 03 '20 13:03 jh-RLI

She's not available right now. I added the description in the wiki.

jh-RLI avatar Mar 03 '20 13:03 jh-RLI

Should I still do something here? I can review the descriptions on toep?

han-f avatar Mar 16 '20 13:03 han-f

Should I still do something here? I can review the descriptions on toep?

Yes, in my opinion the descriptions need some work, but this is not essential for the release of v0.6.0

MGlauer avatar Mar 18 '20 10:03 MGlauer

OK, I can work on all of them at some point. Should I simply make suggestions here in this issue? That would be easiest for me as I can then take one by one when I have some time in between also.

han-f avatar Mar 18 '20 11:03 han-f

suggestion for scenario: scenario data in the broadest sense. Includes input and output data from models that project scenarios into the future. Example inputs: assumptions made about future developments of key parameters such as energy prices and GDP. Example outputs: projected electricity transmission, projected greenhouse gas emissions. Note that inputs to one model could be an output of another model and the other way around.

han-f avatar Mar 19 '20 09:03 han-f

suggestion for economy: data related to economic activities. Examples: sectoral value added, sectoral inputs and outputs, GDP, prices of commodities etc.

han-f avatar Mar 19 '20 11:03 han-f

suggestion for emission: data on emissions. Examples: total greenhouse gas emissions, CO2-emissions, energy-related CO2-emissions, methane emissions etc.

han-f avatar Mar 19 '20 11:03 han-f

suggestion for model_draft: unfinished data of any kind. Note: there is no version control and data is still volatile.

han-f avatar Mar 19 '20 11:03 han-f

suggestion for society: demographic data such as population statistics and projections, fertility, mortality etc.

han-f avatar Mar 19 '20 11:03 han-f

suggestion for policy data on policies and measures. This could, for example, include a list of renewable energy policies per European Member State. It could also be a list of climate related policies and measures in a specific country.

han-f avatar Mar 19 '20 12:03 han-f

suggestion for boundaries: data that depicts boundaries, such as geographic, administrative or political boundaries. Such data comes as polygons.

han-f avatar Mar 19 '20 12:03 han-f

suggestion for climate: data related to climate and weather. This includes, for example, precipitation, temperature, cloud cover and atmospheric conditions.

han-f avatar Mar 19 '20 12:03 han-f

suggestion for demand: data on demand. Demand can relate to commodities but also to services.

han-f avatar Mar 19 '20 12:03 han-f

suggestion for supply: data on supply. Supply can relate to commodities but also to services.

han-f avatar Mar 19 '20 12:03 han-f

Writing these suggestions here I think many of the current schemas may have overlaps and could include the same things. Demand and supply for example could also be seen as inputs and outputs to economic sectors if viewed from an economic angle. And I also think the type of model data that the OEP is open to spans also beyond a very strict definition of energy system model.

han-f avatar Mar 19 '20 12:03 han-f

@l-emele done for the moment. I think these sugestions are far from perfect, but they may give a better sense to the user what could be put or find where.

han-f avatar Mar 19 '20 12:03 han-f

Looks good. Just one minor suggestions for changes:

suggestion for emission: data on emissions. Examples: total greenhouse gas emissions, CO2-emissions, energy-related CO2-emissions, methane emissions, air pollutants etc.

l-emele avatar Mar 20 '20 11:03 l-emele

@han-f Are those descriptions reads to be transfered?

MGlauer avatar Mar 20 '20 13:03 MGlauer

From my point of view yes - we can still make them prettier in a future release, correct?

han-f avatar Mar 20 '20 13:03 han-f

Yes, of course.

MGlauer avatar Mar 20 '20 13:03 MGlauer

And some more suggestions, for the missing updates:

environment: data that has to do with the environment in the broadest sense. This could relate, for example, to mapping of environmental resources, land cover, protected areas etc.

han-f avatar Mar 30 '20 12:03 han-f

grid: data that relates to infrastructure, such as power lines, pipelines etc.

han-f avatar Mar 30 '20 12:03 han-f

grid: data that relates to infrastructure, such as power lines, pipelines etc.

I think this does not necessarily only relate to energy infrastructure. Some models may make use of other infrastructure such as railways, roads etc. This could also fall under grid? Or would that be a net? Or would a better term for grid be net?

han-f avatar Mar 30 '20 12:03 han-f

reference: data that serves as reference, such as literature, data sources, etc.

han-f avatar Mar 30 '20 12:03 han-f

reference: data that serves as reference, such as literature, data sources, etc.

@l-emele @wingechr: may this instead be the current target schema for our conversion and GWP tables? While writing the definition I thought that these actually are some kind of reference. If you agree, then I would rephrase the definition to:

reference: data that serves as reference, such as literature, data sources, but also converters and lists of abbreviations etc.

han-f avatar Mar 30 '20 12:03 han-f

reference: data that serves as reference, such as literature, data sources, etc.

@l-emele @wingechr: may this instead be the current target schema for our conversion and GWP tables? While writing the definition I thought that these actually are some kind of reference. If you agree, then I would rephrase the definition to:

reference: data that serves as reference, such as literature, data sources, but also converters and lists of abbreviations etc.

My understanding is that the reference scheme only contains tables that are related to the abandoned literature collection. So it is not the place for converters and lists of abbreviations.

l-emele avatar Mar 30 '20 13:03 l-emele

Is this issue still relevant or has it been addressed?

christian-rli avatar Dec 01 '21 13:12 christian-rli