Skip to content

pylovo-generation

The pylovo-generation tool creates synthetic low-voltage grid data based on the infdb-basedata.

Data Sources

Mainly builds upon the following open data sources:

Features

Method

  • Synthetic low-voltage grids with transformers and radial multi-feeder structure
  • Greenfield and brownfield transformer placement with different clustering methods
  • Dimensioning with coincidence factors on building, feeder and transformer level to replicate grid planner dimensioning heuristics.

Tool

  • Availability: Based on available open data only
  • Geospatial Processing: Utilizes PostgreSQL databases with PostGIS with prebuilt graph algorithms for efficient geodata processing
  • Power System Integration: Provides grid models in the format of existing simulation frameworks (pandapower (default), OpenDSS)
  • Adoption: Integrated into infdb ecosystem for seamless tool integration

Usage

If you want to run the tool, first run the basedata and afterward execute: 

bash tools/pylovo-generation/run.sh

Configuration

The available regions selection is taken from the imported regions listed in the scope table from opendata. Detailed generation configurations can be adjusted under 'tools/pylovo-generation/configs/config-pylovo-generation.yml'.

Output Data

The main output of the tool is:

  • Grid models for simulation (pandapower/OpenDSS)
  • Grid geometries for visualization
  • Grid metrics for analysis

The output datasets are stored in the pylovo schema of the infDB PostgreSQL database. The most important tables are:

  • version: Tracks a dataset version incl. comment, creation timestamp, and serialized parameters used for a run.
  • equipment_data: Versioned catalog of electrical equipment (e.g. transformers/cables) with technical parameters and costs.
  • grid_result: Core output per generated grid/cluster (identified by version_id, kcid, bcid, plz) incl. transformer selection, model status, and the full grid serialized as JSON.
  • ways_result: Versioned ways linestrings for a given plz
  • buildings_result: Per-building results (geometry, category/type, load, households, connection info) linked to a specific grid and version.
  • lines_result: Line geometry and attributes per generated grid incl. endpoints, type, and length.
  • plz_parameters: Aggregated per-postcode JSON summaries (e.g. transformer count, cable length, load/bus counts, distance stats) per (version_id, plz).
  • clustering_parameters: Derived characteristic grid metrics per grid for further analysis.
  • transformer_positions: Greenfield & Brownfield transformer position per grid with optional OSM reference.

Further information