OpenEnergyPlatform / open-MaStR

A collaborative software to download the energy database Marktstammdatenregister (MaStR)
https://open-mastr.readthedocs.io/en/latest/
GNU Affero General Public License v3.0
87 stars 18 forks source link

Difference between storage and storage_units #586

Open kknappmann opened 1 day ago

kknappmann commented 1 day ago

Description of the issue

Hello, first of all I want to thank you for your great work in this repository. I was wondering if you have any documentation to the tables in the db, and the options for "data". Could you please point me to the documentation? I wan to know what the difference between storage and storage_units is. Thank you so much in advance.

Workflow checklist

nesnoj commented 1 day ago

Hey @kknappmann!

Hello, first of all I want to thank you for your great work in this repository.

Thank you!

I was wondering if you have any documentation to the tables in the db, and the options for "data". Could you please point me to the documentation? I wan to know what the difference between storage and storage_units is. Thank you so much in advance.

The right spot in the docs would be here in the table but I admit that the descriptions for those 2 tables are missing.

The distinction origins from the MaStR data export, see also PDF in "Beschreibung des Exports". I don't know why they were split into EinheitenStromSpeicher and AnlagenStromSpeicher, we just map this in the data model to storages_extended and storage_units, I assume because storages can contain multiple units.

You can join both tables.

For basic relations see also data model.

FlorianK13 commented 17 hours ago

Of course we are always happy about contributions @kknappmann So if you spend some time to understand the difference between the tables, you can tell us your findings so that we can include it in the documentation. Or you extend the documentation by yourself and create a Pull Request.