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

1. 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:

2. 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.

3. 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-based power plants of Germany, Denmark, France and Poland
  • daily time series of cumulated installed capacity per energy source type for Germany.

Due to different data availability, the power plant lists are of different accurancy and partly provide different power plant parameter. Due to that, the lists are provided as seperate csv-files per country and as separate sheets in the excel file.

  • Germany: More than 1.7 million power plant entries, all renewable energy plants supported by the German Renewable Energy Law (EEG)
  • Denmark: Wind and phovoltaic power plants with a high level of detail
  • France: Summed capacity and number of installations per energy source per municipality (Commune)
  • Poland: Summed capacity and number of installations per energy source per municipality (Powiat)

4. Data sources

This Data Package uses the following main data sources.

4.1 Germany - DE

In Germany historically all data has been published mandatorily by the four TSOs (50Hertz, Amprion, Tennet, TransnetBW). This obligation expired in August 2014, nonetheless the TSO reported until the end of 2014 and issued another update in August 2016 for plants commissioned until end of 2015 (which is used in this script).

  • 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".

4.2 Denmark - DK

  • ens.dk - Energy Agency Denmark

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, published from Energinet, includes information about location, year of implementing, installed capacity and number of systems. There is an additional overview of the number of plants and installed capacity per postcode. The publication an Excel file and dates of publication are not entirely clear.

4.3 France - FR

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.

4.4 Poland - PL

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

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.

5. Naming Conventions

5.1 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.

original_name opsd_name description country data_source
ÜNB tso Name of transmission system operator DE 50Hertz / Amprion / TenneT / TransnetBW
Netzbetreiber Name dso Name of distribution system operator DE 50Hertz / Amprion / TenneT / TransnetBW
Netzbetreiber Betriebsnummer dso_id Company number of dso DE 50Hertz / Amprion / TenneT / TransnetBW
ÜNB-Anlagenschlüssel eeg_id German EEG renumeration ID number DE 50Hertz / Amprion / TenneT / TransnetBW
Bundesland federal_state Federal state – administrative region NUTS1-level DE 54Hertz / Amprion / TenneT
Bundelsand federal_state Federal state – administrative region NUTS1-level DE TransnetBW
PLZ postcode Postcode or ZIP-code DE 50Hertz / Amprion / TenneT / TransnetBW
Installierte Leistung [kW] electrical_capacity_kW Installed electrical capacity in kW DE 50Hertz / Amprion / TenneT / TransnetBW
Einspeisespannungsebene voltage_level Grid connection/voltage level DE 50Hertz / Amprion / TenneT / TransnetBW
Leistungsmessung power_measurement Indicates whether power measurement is implemented DE 50Hertz / Amprion / TenneT / TransnetBW
Regelbarkeit controllability Indicates whether remote controllability is implemented DE 50Hertz / Amprion / TenneT / TransnetBW
Energieträger energy_source_level_2 Type of energy source / generation DE 50Hertz / Amprion / TenneT / TransnetBW
Inbetriebnahme commissioning_date
DE 50Hertz / Amprion / TenneT / TransnetBW
Außerbetriebnahme decommissioning_date
DE 50Hertz / Amprion / TenneT / TransnetBW
Netzzugang grid_commissioning_date Date the power plant changed from the dso DE 50Hertz / Amprion / TenneT / TransnetBW
Netzabgang grid_decommissioning_date Date the power plant changed to the dso DE 50Hertz / Amprion / TenneT / TransnetBW
Meldegrund notification_reason Reason for data entry in the BnetzA list DE BNetzA
Anlagennummer bnetza_id Power plant identification number by BnetzA (Germany) DE BNetzA
1.8 EEG-Anlagenschlüssel eeg_id German EEG renumeration ID number DE BNetzA
4.1 Energieträger energy_source_level_2 Type of energy source / generation DE BNetzA
4.2 Installierte Leistung [kW] electrical_capacity_kW Installed electrical capacity in kW DE BNetzA
4.3 Tatsächliche Inbetrieb-nahme commissioning_date
DE BNetzA
4.5 Stilllegungs-datum decommissioning_date
DE BNetzA
4.7 Strasse bzw. Flurstück address Street name or name of land parcel DE BNetzA
4.8 Haus-nummer address_number House number or number of land parcel DE BNetzA
4.9 Postleit-zahl postcode Postcode or ZIP-code DE BNetzA
4.10 Ort bzw. Gemarkung municipality Name of city or village or municipality DE BNetzA
Gemeinde-schlüssel municipality_code German municipality code DE BNetzA
4.11 Bundesland federal_state Federal state – administrative region NUTS1-level DE BNetzA
UTM-Zonenwert utm_zone Universal Transverse Mercator zone value DE BNetzA
UTM-East utm_east Coordinate in Universal Transverse Mercator (east) DE BNetzA
UTM-North utm_north Coordinate in Universal Transverse Mercator (north) DE BNetzA
4.14 Spannungsebene voltage_level Grid connection/voltage level DE BNetzA
4.16 Name des Netzbetreibers dso Name of distribution system operator DE BNetzA
6.2 Thermische Leistung [kW] thermal_capacity_kW Installed thermal capacity in kW DE BNetzA
Meldungsdatum notification_date Date of data entry in the BnetzA list DE BNetzA_PV
Anlage
Straße oder Flurstück *)
address Street name and house number or name of land parcel DE BNetzA_PV
Anlage
PLZ
postcode Postcode or ZIP-code DE BNetzA_PV
Anlage
Ort oder Gemarkung
municipality Name of city or village or municipality DE BNetzA_PV
Anlage
Bundesland
federal_state Federal state – administrative region NUTS1-level DE BNetzA_PV
Inbetriebnahmedatum **) commissioning_date
DE BNetzA_PV
Installierte
Nennleistung [kWp]
electrical_capacity_kW Installed electrical capacity in kW DE BNetzA_PV
Møllenummer (GSRN) gsrn_id Turbine identifier (GSRN) DK Energistyrelsen
Dato for oprindelig nettilslutning commissioning_date
DK Energistyrelsen
Kapacitet (kW) electrical_capacity_kW Installed electrical capacity in kW DK Energistyrelsen
Rotor-diameter (m) rotor_diameter Rotor diameter in m DK Energistyrelsen
Navhøjde (m) hub_height Hub heigth in m DK Energistyrelsen
Fabrikat manufacturer Company that has built the turbine DK Energistyrelsen
Model model Wind turbine model DK Energistyrelsen
Kommune-nr. municipality_code Danish municipality code DK Energistyrelsen
Kommune municipality Name of city or village or municipality DK Energistyrelsen
Type af placering technology Type of location: on- or offshore DK Energistyrelsen
Ejerlav address Street name or name of land parcel DK Energistyrelsen
Matrikel-nummer address_number House number or number of land parcel DK Energistyrelsen
X (øst) koordinat
UTM 32 Euref89
utm_east Coordinate in Universal Transverse Mercator (east) DK Energistyrelsen
Y (nord) koordinat
UTM 32 Euref89
utm_north Coordinate in Universal Transverse Mercator (north) DK Energistyrelsen
Værk Idrift commissioning_date
DK Energinet.dk
kW electrical_capacity_kW Installed electrical capacity in kW DK Energinet.dk
Postnr postcode Postcode or ZIP-code DK Energinet.dk
Netområde Navn dso Name of distribution system operator DK Energinet.dk
Communes municipality
FR gouv.fr
Code officiel géographique municipality_code French municipality code (INSEE) FR gouv.fr
insee_com municipality_code French municipality code (INSEE) FR gouv.fr
Nombre d'installations number_of_installations Number of installed solar systems FR gouv.fr
Puissance installée (MW) electrical_capacity Installed electrical capacity in MW FR gouv.fr
technology energy_source_level_2
Europe OPSD
capacity electrical_capacity
Europe OPSD
source data_source
Europe OPSD
Country / Area country
Europe IRENA
Sub Technology technology
Europe IRENA
Year year
Europe IRENA
Value electrical_capacity
Europe IRENA

5.2 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.

original_name opsd_name energy_source_level_2 country data_source
Wind Land Onshore Wind DE BNetzA
Wind See Offshore Wind DE BNetzA
Klärgas Sewage and landfill gas Bioenergy DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
Grubengas Other fossil fuels Other fossil fuels DE BnetzA/ Amprion
Freifläche PV Photovoltaics ground Solar DE BNetzA
Deponiegas Sewage and landfill gas Bioenergy DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
Biomasse Biomass and biogas Bioenergy DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
Wasserkraft Run-of-river Hydro DE BNetzA / TransnetBW / TenneT / 50Hertz / Amprion
Geothermie Geothermal Geothermal DE BnetzA / TenneT / 50Hertz / Amprion
Windenergie Offshore Offshore Wind DE 50Hertz / TenneT
Solar Photovoltaics Solar DE TransnetBW / TenneT / 50Hertz / Amprion
Windenergie Onshore Wind DE TenneT / 50Hertz / Amprion
Windenergie an Land Onshore Wind DE TransnetBW
HS high voltage
DE BNetzA
HS/MS high voltage / medium voltage
DE BNetzA
HöS extra high voltage
DE BNetzA
HöS/HS high voltage / extra high voltage
DE BNetzA
MS medium voltage
DE BNetzA
MS/NS medium voltage / low voltage
DE BNetzA
NS low voltage
DE BNetzA
TransnetBW GmbH TransnetBW
DE TransnetBW
TenneT TSO GmbH TenneT
DE TenneT
Amprion GmbH Amprion
DE Amprion
HAV Offshore Wind DK Energistyrelsen
LAND Onshore Wind DK Energistyrelsen
Land Onshore Wind DK Energistyrelsen
Biomasse Biomass and biogas Bioenergy FR gouv.fr
Eolien Wind Wind FR gouv.fr
Géothermie Geothermal Geothermal FR gouv.fr
Hydraulique Hydro Hydro FR gouv.fr
Solaire photovoltaïque Photovoltaics Solar FR gouv.fr
s <3
FR gouv.fr
agricultural biogas power-stations Biomass and biogas Bioenergy PL Urzad Regulacji Energetyki
biomass power-stations fired forest, agricultural, garden waste Biomass and biogas Bioenergy PL Urzad Regulacji Energetyki
biomass power-stations fired wood-derivatives and pulp-paper industry production waste Biomass and biogas Bioenergy PL Urzad Regulacji Energetyki
biomass power-stations mixed biomass-fired Biomass and biogas Bioenergy PL Urzad Regulacji Energetyki
co-fired technology (fossil fuel and biogas) Biomass and biogas Bioenergy PL Urzad Regulacji Energetyki
co-fired technology (fossil fuel and biomass) Biomass and biogas Bioenergy PL Urzad Regulacji Energetyki
dump biogas power-stations Sewage and landfill gas Bioenergy PL Urzad Regulacji Energetyki
hydro-electric power-station capacity over 10 MW Hydro Hydro PL Urzad Regulacji Energetyki
hydro-electric power-station capacity up to 0,3 MW Hydro Hydro PL Urzad Regulacji Energetyki
hydro-electric power-station capacity up to 1 MW Hydro Hydro PL Urzad Regulacji Energetyki
hydro-electric power-station capacity up to 10 MW Hydro Hydro PL Urzad Regulacji Energetyki
hydro-electric power-station capacity up to 5 MW Hydro Hydro PL Urzad Regulacji Energetyki
mixed biogas power-stations Biomass and biogas Bioenergy PL Urzad Regulacji Energetyki
onshore wind power-station Onshore Wind PL Urzad Regulacji Energetyki
photovoltaic power-stations Photovoltaics Solar PL Urzad Regulacji Energetyki
sewage treatment plant biogas power-stations Sewage and landfill gas Bioenergy PL Urzad Regulacji Energetyki
pumped-storage power station or flow hydro-electric power station with pump part Hydro Hydro PL Urzad Regulacji Energetyki
Biogas Biomass and biogas Bioenergy Europe IRENA
Concentrated Solar Power Concentrated solar power Solar Europe IRENA
Geothermal Energy Geothermal Geothermal Europe IRENA
Large Hydropower Hydro Hydro Europe IRENA
Liquid Biofuels Biomass and biogas Bioenergy Europe IRENA
Marine Marine Marine Europe IRENA
Medium Hydropower Hydro Hydro Europe IRENA
Offshore Wind Offshore Wind Europe IRENA
Onshore Wind Onshore Wind Europe IRENA
Pumped storage and mixed plants Hydro Hydro Europe IRENA
Small Hydropower Hydro Hydro Europe IRENA
Solar Photovoltaic Photovoltaics Solar Europe IRENA
Solid Biomass Biomass and biogas Bioenergy Europe IRENA
Denmark DK
Europe IRENA
France FR
Europe IRENA
Germany DE
Europe IRENA
Poland PL
Europe IRENA
Bioenergy and other renewale fuels Bioenergy and renewable waste Bioenergy Europe OPSD
Solar Solar
Europe OPSD
Wind Wind
Europe OPSD
Geothermal Geothermal
Europe OPSD
Differently categorized hydro Hydro
Europe OPSD
Tide, wave, and ocean Marine
Europe OPSD

5.3 Validation marker

Validation markers are used in comments column in order to mark units for which we identified one of the following issues:

Validation marker Short explanation Long explanation
R_1 data_source = BnetzA and commissioning_date < 2016-12-31 This powerplant is probably also represented by an entry from the TSO data and should therefore be filtered out.
R_2 notification_reason other than „Inbetriebnahme“ (commissioning) This powerplant is probably also represented by an entry from the TSO data and should therefore be filtered out.
R_3 commissioning_date not specified
R_4 electrical_capacity not specified
R_5 decommissioned from the grid This powerplant is probably commissioned again to the grid of another grid operator and therefore this doubled entry should be filtered out.
R_6 decommissioned This powerplant is completely decommissioned.
R_7 not connected to the European grid This powerplant is located in regions belonging to France but not located in Europe (e.g. Guadeloupe).

5.4 Energy source structure

6. License

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