Skip to content

Create database models for IEA data  #2

@V3lop5

Description

@V3lop5

Feature request
The application should be able to handle IEA data.

The following datasets should be translated into models:

  • world energy valances
  • world energy statistics
  • indicators
  • NASA GISS
  • electricity information
    • Capacities
    • ...

Describe the solution you'd like
The following tables are needed:

Table name Description Columns
Regions Identifier for every country/region. ID, name, optional parent region
EnergySources Identifies possible sources of energy. ID, name, optional description
EnergyStorages Identifies possible storages of energy. ID, name, optional description
EnergySinks Identifies possible sinks/consumption of energy. ID, name, optional description
EnergyConversions Identifies possible conversion of energy. ID, name, optional description
Capacities TS Maximum installed capacities for each region/source/year. Ref_Region, Ref_Source, Year, Quantitiy
Generations TS Generated energy for each region/source/year. Ref_Region, Ref_Source, Year, Quantitiy
Consumptions TS Consumed energy for each region/source/sink/year. Ref_Region, Ref_Source, Ref_Sink, Year, Quantitiy

Additional context
TODO: Provide example IEA data.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requesthelp wantedExtra attention is needed

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions