Projects

The LinkML SQL Validator is a generator I recently contributed to LinkML. It takes a LinkML schema and compiles its constraints (cardinality, value ranges, enumerations, pattern matching, etc.) into plain SQL queries, which can then be run against any relational database to find rows that violate the schema — without needing to load the data into a specific validation framework first. The idea for this project is to put that generator to use for the Common Information Model (CIM), the data model used across the electric utility industry to describe power grids. By expressing the relevant parts of CIM as a LinkML schema and running the SQL Validator against it, invalid or inconsistent grid model data can be detected directly in the database with plain SQL — making it easy to integrate validation into existing pipelines without extra tooling. ...

openpv.de started as a hobby project of some friends and myself. It now turned into a publicly funded open-source website. Basics The website openpv.de offers users a comprehensive analysis of the solar energy potential of your buildings. By using openly available 3D building data, known as LOD2 data, OpenPV provides yield estimations for rooftop and balcony photovoltaic (PV) systems. The site’s primary goal is to promote the installation of PV systems — an affordable and economically viable source of electricity in most locations today. ...

The MaStR dataset is one of the most important data sources for the german energy system and crucial for controlling and understanding the ongoing transformation. It contains a huge amount of valuable and high-quality information. Some parts of the data contain errors, which is analyzed in the dashboard. Links Paper Dashboard

The @bundestagpetitionen10k is a bot, that posts petitions from https://epetitionen.bundestag.de/ that have exceeded the threshold of 10,000 signatures. It visits the website of bundestag once per day to see if new petitions have reached this threshold. The bot is open-source and its code is on github.

The Python Package open-mastr provides an interface for accessing and cleaning the German Energy Unit dataset called Marktstammdatenregister (MaStR). The MaStR is a central registry with detailed information about renewable and conventional power plants in the German energy system. open-mastr enables the creation and updating of a local database of the entire registry, as well as processing the data for further evaluation. Ultimately, the package offers methods to reduce the registry’s parsing time and thus enables energy system researchers to start working with the entire dataset right away. ...