Renewable power plants: Main notebook
This notebook is part of the Renewable power plants Data Package of Open Power System Data.

About Open Power System Data

This Notebook is part of the project Open Power System Data. Open Power System Data develops a platform for free and open data for electricity system modeling. We collect, check, process, document, and provide data that are publicly available but currently inconvenient to use. More info on Open Power System Data:

About Jupyter Notebooks and GitHub

This file is a Jupyter Notebook. A Jupyter Notebook is a file that combines executable programming code with visualizations and comments in markdown format, allowing for an intuitive documentation of the code. We use Jupyter Notebooks for combined coding and documentation. We use Python 3 as programming language. All Notebooks are stored on GitHub, a platform for software development, and are publicly available. More information on our IT-concept can be found here. See also our step-by-step manual how to use the dataplatform.

About this Data Package

We provide data in different chunks, or Data Packages. The one you are looking at right now, Renewable power plants, contains

  • lists of renewable energy power plants of selected countries in Europe
  • daily time series of cumulated installed capacity per energy source type for Germany.

Due to differing data availability, the power plant lists are of variable accuracy and partly provide different power plant parameters. Therefore the lists are provided in addition to the overall European list also as separate CSV files per country and as separate sheets in the Excel file, which contain more information than the European list.

Data sources

This Data Package uses the following main data sources.

Germany - DE

Individual power plants, all renewable energy plants supported by the German Renewable Energy Law (EEG)

In Germany, the four TSOs (50Hertz, Amprion, Tennet, TransnetBW) publish individual plant-level data on renewable power plants on their joint platform Netztransparenz.de. Since they are only updated once per year (usually in August) for the past year, their data is often a bit outdated. We therefore complement their data with data from BNetzA, which has more recent data.

  • BNetzA - The German Federal Network Agency for Electricity, Gas, Telecommunications, Posts and Railway

Since August 2014 the BNetzA is responsible to publish the renewable power plants register. The legal framework for the register is specified in the EEG 2014 (German) (English). All power plants are listed in a new format: two separate MS-Excel and CSV files for roof-mounted PV power plants "PV-Datenmeldungen" and all other renewable power plants " Anlagenregister".

From the beginning of 2019, BNetzA has switched to the Marktstammdatenregister (MaStR, central register for installation data). This is, however, not used yet for OPSD data. We will change to using the MaStR most likely for the 2020 version of the OPSD data package.

Denmark - DK

Wind and phovoltaic power plants with a high level of detail

The Danish Energy Agency publishes a national master data register for wind turbines which was created in collaboration with the transmission system operators. The publication is monthly as an Excel file. The data set includes all electricity-generating wind turbines with information about technical data, location data and production data.

The photovoltaic statistic used to be published from Energinet, included information about location, year of implementing, installed capacity and number of systems. Since Energinet stopped publishing this, and the Danish Energy Agency, which has taken over the job of keeping that register has not published a register yet, we revert to old data for Danish solar from our previous OPSD data package version.

France - FR

Summed capacity and number of installations per energy source per municipality (Commune)

The data is annual published on the france website for statistics as an Excel file. The Excel chart includes number and installed capacity of the different renewable source for every municipality in France. It is limited to the plants which are covered by article 10 of february 2000 by an agreement to a purchase commitment.

Poland - PL

Summed capacity and number of installations per energy source per municipality (Powiat)

Number of installations and installed capacity per energy source of renewable energy, summed per powiat (districts) is illustrated on the page and can be downloaded as rtf-file. However, the file is no longer available. Therefore we use an old version from OPSD.

Switzerland - CH

All renewable energy power plants supported by the feed-in-tariff KEV.

Data of all renewable power plants receiving "Kostendeckende Einspeisevergütung" (KEV) which is the Swiss feed in tarif for renewable power plants. Geodata is based on municipality codes.

A complete list of data sources is provided on the Data Package information website. They are also contained in the JSON file that contains all metadata.

Naming Conventions

Column translation list

This list provides all internal translations of column original names to the OPSD standard names in order to achieve common data structure for data of all implemented countries as well as the other data packages.

In [7]:
import pandas as pd
pd.read_csv('input/column_translation_list.csv')
Out[7]:
original_name opsd_name description country data_source
0 ÜNB tso Name of transmission system operator DE 50Hertz / Amprion / TenneT / TransnetBW
1 REGELZONE tso Name of transmission system operator DE 50Hertz / Amprion / TenneT / TransnetBW
2 Regelzonenbezeichnung tso Name of transmission system operator DE 50Hertz / Amprion / TenneT / TransnetBW
3 REGELZONENBEZEICHNUNG tso Name of transmission system operator DE 50Hertz / Amprion / TenneT / TransnetBW
4 Netzbetreiber Name dso Name of distribution system operator DE 50Hertz / Amprion / TenneT / TransnetBW
5 NETZBETREIBER_NAME dso Name of distribution system operator DE 50Hertz / Amprion / TenneT / TransnetBW
6 Netzbetreiber Betriebsnummer dso_id Company number of dso DE 50Hertz / Amprion / TenneT / TransnetBW
7 NETZBETREIBER_BETRIEBSNUMMER dso_id Company number of dso DE 50Hertz / Amprion / TenneT / TransnetBW
8 ÜNB-Anlagenschlüssel eeg_id German EEG renumeration ID number DE 50Hertz / Amprion / TenneT / TransnetBW
9 ÜNB-Anlagennummer eeg_id German EEG renumeration ID number DE 50Hertz / Amprion / TenneT / TransnetBW
10 EEG-Anlagenschlüssel eeg_id German EEG renumeration ID number DE 50Hertz / Amprion / TenneT / TransnetBW
11 ANLAGENNUMMER eeg_id German EEG renumeration ID number DE 50Hertz / Amprion / TenneT / TransnetBW
12 ANLAGENSCHLUESSEL eeg_id German EEG renumeration ID number DE 50Hertz / Amprion / TenneT / TransnetBW
13 Bundesland federal_state Federal state – administrative region NUTS1-level DE 50Hertz / Amprion / TenneT / TransnetBW
14 Bundelsand federal_state Federal state – administrative region NUTS1-level DE 50Hertz / Amprion / TenneT / TransnetBW
15 BUNDESLAND federal_state Federal state – administrative region NUTS1-level DE 50Hertz / Amprion / TenneT / TransnetBW
16 PLZ postcode Postcode or ZIP-code DE 50Hertz / Amprion / TenneT / TransnetBW
17 ORT municipality Street name or name of land parcel DE 50Hertz / Amprion / TenneT / TransnetBW
18 Ort / Gemarkung municipality Street name or name of land parcel DE 50Hertz / Amprion / TenneT / TransnetBW
19 STRASSE_FLURSTUECK address Name of city or village or municipality DE 50Hertz / Amprion / TenneT / TransnetBW
20 Straße / Flurstück address Name of city or village or municipality DE 50Hertz / Amprion / TenneT / TransnetBW
21 Gemeindeschlüssel municipality_code German municipality code DE 50Hertz / Amprion / TenneT / TransnetBW
22 Installierte Leistung [kW] electrical_capacity_kW Installed electrical capacity in kW DE 50Hertz / Amprion / TenneT / TransnetBW
23 INST_LEISTUNG_KW electrical_capacity_kW Installed electrical capacity in kW DE 50Hertz / Amprion / TenneT / TransnetBW
24 installierte Leistung electrical_capacity_kW Installed electrical capacity in kW DE 50Hertz / Amprion / TenneT / TransnetBW
25 Installierte Leistung electrical_capacity_kW Installed electrical capacity in kW DE 50Hertz / Amprion / TenneT / TransnetBW
26 Einspeisespannungsebene voltage_level Grid connection/voltage level DE 50Hertz / Amprion / TenneT / TransnetBW
27 Spannungsebene voltage_level Grid connection/voltage level DE 50Hertz / Amprion / TenneT / TransnetBW
28 SPANNUNGSEBENE voltage_level Grid connection/voltage level DE 50Hertz / Amprion / TenneT / TransnetBW
29 EINSPEISESPANNUNGSEBENE voltage_level Grid connection/voltage level DE 50Hertz / Amprion / TenneT / TransnetBW
... ... ... ... ... ...
117 Produktion [kWh]** production production in kWh CH BFE
118 Vergütung 2016 [CHF] tariff tariff in CHF for 2016 CH BFE
119 Vergütung 2017 [CHF] tariff tariff in CHF for 2017 CH BFE
120 Anmeldedatum notification_date date of data entriy at BFE CH BFE
121 Anlage_Vertragsende contract_period_end end of the contract period CH BFE
122 Anlage_Strasse street name of the street CH BFE
123 Anlage_Kanton canton name of the cantones/ member states of the Swi... CH BFE
124 Produzent_Firma company name of the company CH BFE
125 Produzent_Anrede title titel of owner CH BFE
126 Produzent_Name surname family name of owner CH BFE
127 Produzent_Vorname first_name given name of owner CH BFE
128 Ref ID uk_beis_id NaN UK BEIS
129 Operator (or Applicant) operator NaN UK BEIS
130 Site Name site_name NaN UK BEIS
131 Installed Capacity (MWelec) electrical_capacity NaN UK BEIS
132 CHP Enabled chp NaN UK BEIS
133 RO Banding (ROC/MWh) support_robranding NaN UK BEIS
134 FiT Tariff (p/kWh) support_fit NaN UK BEIS
135 CfD Capacity (MW) support_cfd NaN UK BEIS
136 Turbine Capacity (MW) capacity_individual_turbine NaN UK BEIS
137 No. of Turbines number_of_turbines NaN UK BEIS
138 Mounting Type for Solar solar_mounting_type NaN UK BEIS
139 Development Status (short) status NaN UK BEIS
140 Address address NaN UK BEIS
141 County municipality NaN UK BEIS
142 Region region NaN UK BEIS
143 Country country NaN UK BEIS
144 Post Code postcode NaN UK BEIS
145 Operational commissioning_date NaN UK BEIS
146 Technology Type energy_source_level_3 NaN UK BEIS

147 rows × 5 columns

Value translation list

This list provides all internal translations of original value names to the OPSD standard names in order to achieve common data structure for data of all implemented countries as well as the other data packages.

In [8]:
import pandas as pd
pd.read_csv('input/value_translation_list.csv')
Out[8]:
original_name opsd_name energy_source_level_2 country data_source
0 Wind Land Onshore Wind DE BNetzA
1 Wind See Offshore Wind DE BNetzA
2 Klärgas Sewage and landfill gas Bioenergy DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
3 Grubengas Other fossil fuels Other fossil fuels DE BnetzA/ Amprion
4 Freifläche PV Photovoltaics ground Solar DE BNetzA
5 Deponiegas Sewage and landfill gas Bioenergy DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
6 Biomasse Biomass and biogas Bioenergy DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
7 Wasserkraft Run-of-river Hydro DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
8 Wasser Run-of-river Hydro DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
9 Wind an Land Onshore Wind DE TransnetBW / TenneT / 50Hertz / Amprion
10 Wind auf See Offshore Wind DE 50Hertz/TenneT
11 Windenergie auf See Offshore Wind DE 50Hertz/TenneT
12 Geothermie Geothermal Geothermal DE BnetzA / TenneT / 50Hertz / Amprion
13 Windenergie Offshore Offshore Wind DE 50Hertz / TenneT
14 Solar Photovoltaics Solar DE TransnetBW / TenneT / 50Hertz / Amprion
15 Speicher Storage Storage DE BNetzA
16 Windenergie Onshore Wind DE TenneT / 50Hertz / Amprion
17 Windenergie an Land Onshore Wind DE TransnetBW
18 NS low voltage NaN DE BNetzA
19 MS/NS low voltage / medium voltage NaN DE BNetzA
20 MS medium voltage NaN DE BNetzA
21 HS/MS medium voltage / high voltage NaN DE BNetzA
22 HS high voltage NaN DE BNetzA
23 HöS extra high voltage NaN DE BNetzA
24 HöS/HS high voltage / extra high voltage NaN DE BNetzA
25 Hös/HS high voltage / extra high voltage NaN DE BNetzA
26 50hertz Transmission GmbH 50Hertz NaN DE 50Hertz
27 TransnetBW GmbH TransnetBW NaN DE TransnetBW
28 TenneT TSO GmbH TenneT NaN DE TenneT
29 Amprion GmbH Amprion NaN DE Amprion
... ... ... ... ... ...
108 MV Mecklenburg-Vorpommern NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
109 NI Niedersachsen NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
110 NW Nordrhein-Westfalen NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
111 RP Rheinland-Pfalz NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
112 SL Saarland NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
113 SN Sachsen NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
114 ST Sachsen-Anhalt NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
115 SH Schleswig-Holstein NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
116 TH Thüringen NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
117 AWZ German exclusive economic zone (off-shore) NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
118 nw Nordrhein-Westfalen NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
119 Rp Rheinland-Pfalz NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
120 Ausschließliche Wirtschaftszone (Wind See) German exclusive economic zone (off-shore) NaN DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
121 Biomass (co-firing) Biomass and Biogas Bioenergy UK BEIS
122 EfW Incineration Other bioenergy and renewable waste Bioenergy UK BEIS
123 Biomass (dedicated) Biomass and Biogas Bioenergy UK BEIS
124 Advanced Conversion Technologies Biomass and Biogas Bioenergy UK BEIS
125 Anaerobic Digestion Biomass and Biogas Bioenergy UK BEIS
126 Large Hydro NaN Hydro UK BEIS
127 Small Hydro NaN Hydro UK BEIS
128 Landfill Gas Sewage and landfill gas Bioenergy UK BEIS
129 Solar Photovoltaics NaN Solar UK BEIS
130 Sewage Sludge Digestion Sewage and landfill gas Bioenergy UK BEIS
131 Tidal Barrage and Tidal Stream NaN Marine UK BEIS
132 Shoreline Wave NaN Marine UK BEIS
133 Wind Offshore NaN Wind UK BEIS
134 Wind Onshore NaN Wind UK BEIS
135 Hot Dry Rocks (HDR) NaN Geothermal UK BEIS
136 Flywheels NaN Wind UK BEIS
137 Pumped Storage Hydroelectricity NaN Hydro UK BEIS

138 rows × 5 columns

Energy source structure

OPSD-Tree

License

This Jupyter Notebook as well as all other documents in this repository is published under the MIT License.