Missing data in solar_extended "Lage" columns

[Ortimis]

I noticed that in current dumps, the "Lage" is NULL for all entries of units in solar_extended. It worked as expected in older dumps, which I happened to have laying around, with values like Bauliche Anlagen (Hausdach, Gebäude und Fassade).

Steps to Reproduce

1. get the sqlite
2. inspect the solar_extended table
3. select distinct lage from solar_extended --> NULL

Context and Environment

• Version used: 0.16.0
• Operating system: MacOS

Workflow checklist

• I have checked the documentation and confirmed this issue is not already addressed there.
• I am aware of the workflow in CONTRIBUTING.md

[Ortimis]

I just checked some of the XML files, and the attribute seems to be missing there already. So thats perhaps an issue with the Netzagentur.

[nesnoj]

Thanks for reporting @Ortimis ! The entire site seems to be under maintenance now..

[nesnoj]

I tested download and Lage is still missing in today's data.

[Ortimis]

Looking at their release schedule, this might not get fixed until January 8th
https://www.marktstammdatenregister.de/MaStRHilfe/files/webdienst/Release-Termine.pdf

[nesnoj]

Update:

This is not a bug but "Lage" has been renamed in v25.1.158 according to the release notes and is not an attribute anymore:
Portal/Webdienst/Gesamtdatenexport: Aufteilung "Lage der Einheit" für Wind und Solar - neu "Art der Solaranlage" und "Wind an Land oder auf See"

The column "Lage" is contained in the table as it is still part of the DB model which apparently did not receive an update (orm.py). We're heading towards a more adaptive model in #684.

[Ortimis]

Ah good to know! Just to confirm, this means that in the current open-mastr tables there is no information on the Lage or Art at all, right?

[Ortimis]

Let me know if I can be of help. Kind of depending on this data and a stable schema. (also fyi @FlorianK13 )

I could for instance submit a hotfix for as long as the #684 isnt merged

[nesnoj]

Thanks for the offer!
I think this is not necessary right now as the data is included: New columns (i.e. columns that do not exist in our model) are automatically added. So you can find Lage in ArtDerSolaranlage / WindAnLandOderAufSee.

Can you work with this?
If so, please close this issue..

---

[Ortimis]

Thanks completely overlooked that column...