This project aims to extend the information contained in the Ten Year Network Development Plans (TYNDPs) made by ENTSO-E in order to incorporate it into the energy system model PyPSA-Eur) Most notably this includes adding the substation coordinates as well as making general corrections to the data based on official project descriptions. So far, only the TYNDP 2020 has been extended.
TYNDP data in form of excel files: https://tyndp.entsoe.eu/maps-data/
The excel file for TYNDP 20XY can be found in folder 20XY/
. Some notes about the data:
- Each file has a different structure and uses different column names
- The project descriptions in the files may contain different information than the project descriptions on the TYNDP website
- Only the substation's names are included, but not their coordinates
- Some projects are not specified correctly: For example, the file contains an entry for a line between substations
A
andC
, but the project description indicates that there are actually two lines connectingA
andC
viaB
. Such information is sometimes included in the description, on the TYNDP website, or in official documents for the project. - It can contain multiple upgrades of the same asset with different commissioning years.
Coordinates of substations: https://www.openstreetmap.org
Most substations can be found in Openstreetmap, and often their names match those in the TYNDP.
Coordinates of Finnish substations: https://www.businessfinland.fi/globalassets/international-customers/data-center-assets/substations.kmz
Openstreetmap does not contain many Finnish substations or does not include their names. This obscure file can be opened with Google Earth and contains the coordinates of the most important substations in Finland.
Folder 'entsoegridkit': https://github.com/PyPSA/pypsa-eur/tree/master/data/entsoegridkit
Contains a representation of the ENTSO-E network topology programatically extracted from the ENTSO-E interactive grid map, which PyPSA-Eur is based on. The data is used here to prepare the extended TYNDP for its integration into PyPSA-Eur.
Due to the poor data quality of the TYNDP excel files mentioned above, it is almost impossible to extend the TYNDPs without manual work. Hence, the following procedure was used:
- Use
prepare_tyndp_data()
fromutils.py
to read in and process the excel file. This includes:- Conversion of data to consistent format. Semantics of column names need to be specified by user, see
manual_utils.ipynb
for examples. - Adding empty columns for substation coordinates and line capacities (mostly used for HVDC lines)
- 'Guessing' of line voltage and length from the
description
column by looking for<number>kV
patterns - Adding hyperlinks to the respective TYNDP project website, if available
⚠️ Transformation of commissioning dates to years, which sometimes involves rounding up.
- Conversion of data to consistent format. Semantics of column names need to be specified by user, see
- Correct data if information in 'description' column differs from rest of the row.
- Manually search for substation in Openstreetmap in order to find coordinates
The module tyndp_to_pypsa.py
takes the extended TYNDP data and merges it with the PyPSA-Eur grid topology using the PyPSA-Eur gridextract.
This includes:
- Splitting assets into buses, lines and links
- Classifying assets as 'new' or 'upgraded' with respect to the gridextract by trying to perform coordinate-based matching of TYNDP assets to PyPSA-Eur assets (approach taken from PyPSA-Eur's
base_network.py
, where some TYNDP2018 links are already integrated)- 'Upgraded' assets: Adopt bus coordinates and IDs from gridextract, take larger values of significant fields (e.g. voltage) to ensure that nothing is accidentaly downgraded
- Converting the data to the gridextract format e.g. by renaming columns, moving columns to a PostgreSQL hstore-formatted 'tags' field
Execute python tyndp_to_pypsa.py 2020/tyndp_2020.csv
from the command line.
The output can be found in the directory 2020/pypsa_ready/
.