gplssm

Use SqlServerContainer with pyodbc driver

6

In https://github.com/testcontainers/testcontainers-python/commit/fc5f2df4ba8157d21ecbf3a9a90cd45a61049f90#diff-313a71bf8d0b95ccd84a98f198294e10a7c7086c527efb513d9c6619a12086ee the default driver of `SqlServerContainer` was changed to pymssql. Currently, I use the pyodbc driver to communicate with MSSQL databases. This is not possible anymore since then. I've...

Missing technology (electricity generation) - GSGK - Nuclear - Storage

In particular this addresses columns of CSV exported tables - Columns that are empty for all instances - Duplicate columns

In postprocessing the same queries are explicitly written for each technology including hard-coded table names - Apply DRY by converting these SQL parts to SQLAlchemy ORM code - Make table...

Split postprocessing into data cleansing and enrichment

1

Data cleansing - Unplausible nominal power correction - Filtering duplicates (expects raw data including all StatistikFlag A and B units) Enrichment - Add geom column and fill with data from...

**Tasks** - [ ] Replace column renaming in `MaStRDownload.download_power_plants()` by renaming pattern used in `MaStRMirror.to_csv` - [ ] Adapt documentation `postprocessing.rst` and remove warning about data from `MaStRDownload.download_power_plants()`

Create a Jupyter notebook that the raw MaStR power plant data (`_raw.csv`) and reports on the quality and completeness of the data. ### Number of units with/ completeness of -...

Allow to use dialect mssql+pyodbc

1

Closes #244

Stable grids results from Ding0

1

This issue coordinates subtasks to achieve stable grids resulting from a Ding0. "Stable" refers to grids that do not exceed their hosting capacity and do not violate operational constraints like...

Correct calculation of S (apparent power) to assess critical lines

2

Currently, we calculate maximum allow apparent power for lines by S = sqrt(3) * I_max_th * U_N. We take this value to assess if a line's current carrying capacity is...