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 power plants of Germany, Denmark, France and Poland
  • 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 accurancy and partly provide different power plant parameters. Therefore the lists are provided as separate 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.

4.5 Switzerland - CH

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.

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.

In [1]:
import pandas as pd
pd.read_csv('input/column_translation_list.csv')
Out[1]:
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 Netzbetreiber Name dso Name of distribution system operator DE 50Hertz / Amprion / TenneT / TransnetBW
4 NETZBETREIBER_NAME dso Name of distribution system operator DE 50Hertz / Amprion / TenneT / TransnetBW
5 Netzbetreiber Betriebsnummer dso_id Company number of dso DE 50Hertz / Amprion / TenneT / TransnetBW
6 NETZBETREIBER_BETRIEBSNUMMER dso_id Company number of dso DE 50Hertz / Amprion / TenneT / TransnetBW
7 ÜNB-Anlagenschlüssel eeg_id German EEG renumeration ID number DE 50Hertz / Amprion / TenneT / TransnetBW
8 ANLAGENSCHLUESSEL 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 Bundesland federal_state Federal state – administrative region NUTS1-level DE 50Hertz / Amprion / TenneT / TransnetBW
11 Bundelsand federal_state Federal state – administrative region NUTS1-level DE 50Hertz / Amprion / TenneT / TransnetBW
12 BUNDESLAND federal_state Federal state – administrative region NUTS1-level DE 50Hertz / Amprion / TenneT / TransnetBW
13 PLZ postcode Postcode or ZIP-code DE 50Hertz / Amprion / TenneT / TransnetBW
14 Installierte Leistung [kW] electrical_capacity_kW Installed electrical capacity in kW DE 50Hertz / Amprion / TenneT / TransnetBW
15 INST_LEISTUNG_KW electrical_capacity_kW Installed electrical capacity in kW DE 50Hertz / Amprion / TenneT / TransnetBW
16 installierte Leistung electrical_capacity_kW Installed electrical capacity in kW DE 50Hertz / Amprion / TenneT / TransnetBW
17 Einspeisespannungsebene voltage_level Grid connection/voltage level DE 50Hertz / Amprion / TenneT / TransnetBW
18 EINSPEISESPANNUNGSEBENE voltage_level Grid connection/voltage level DE 50Hertz / Amprion / TenneT / TransnetBW
19 Leistungsmessung power_measurement Indicates whether power measurement is impleme... DE 50Hertz / Amprion / TenneT / TransnetBW
20 LEISTUNGSGEMESSENE_ANLAGE power_measurement Indicates whether power measurement is impleme... DE 50Hertz / Amprion / TenneT / TransnetBW
21 Leistungsgemessene Anlage? power_measurement Indicates whether power measurement is impleme... DE 50Hertz / Amprion / TenneT / TransnetBW
22 Regelbarkeit controllability Indicates whether remote controllability is im... DE 50Hertz / Amprion / TenneT / TransnetBW
23 REGELBARKEIT controllability Indicates whether remote controllability is im... DE 50Hertz / Amprion / TenneT / TransnetBW
24 Energieträger energy_source_level_2 Type of energy source / generation DE 50Hertz / Amprion / TenneT / TransnetBW
25 Energietr�ger energy_source_level_2 Type of energy source / generation DE 50Hertz / Amprion / TenneT / TransnetBW
26 BEZEICHNUNG energy_source_level_2 Type of energy source / generation DE 50Hertz / Amprion / TenneT / TransnetBW
27 Inbetriebnahme commissioning_date NaN DE 50Hertz / Amprion / TenneT / TransnetBW
28 Zeitpunkt der Inbetriebnahme commissioning_date NaN DE 50Hertz / Amprion / TenneT / TransnetBW
29 ZEITPUNKT_INBETRIEBNAHME commissioning_date NaN DE 50Hertz / Amprion / TenneT / TransnetBW
... ... ... ... ... ...
82 Netområde Navn dso Name of distribution system operator DK Energinet.dk
83 Communes municipality NaN FR gouv.fr
84 Code officiel géographique municipality_code French municipality code (INSEE) FR gouv.fr
85 insee_com municipality_code French municipality code (INSEE) FR gouv.fr
86 Nombre d'installations number_of_installations Number of installed solar systems FR gouv.fr
87 Puissance installée (MW) electrical_capacity Installed electrical capacity in MW FR gouv.fr
88 technology energy_source_level_2 Type of energy source / generation Europe OPSD
89 capacity electrical_capacity Installed electrical capacity in MW Europe OPSD
90 source data_source NaN Europe OPSD
91 Country / Area country NaN Europe IRENA
92 Sub Technology technology NaN Europe IRENA
93 Year year NaN Europe IRENA
94 Value electrical_capacity NaN Europe IRENA
95 Anlage_\nEnergieträger energy_source_level_2 Type of energy source / generation CH BFE
96 Anlagentyp technology Type of used technology CH BFE
97 Leistung [kW] electrical_capacity Installed electrical capacity in MW CH BFE
98 Anlage_Inbetriebnahme-\ndatum commissioning_date NaN CH BFE
99 Anlage_PLZ municipality_code NaN CH BFE
100 Anlage_Ort municipality NaN CH BFE
101 Anlage_Projekt-Bezeichnung project_name name of the project/asset or company CH BFE
102 Produktion [kWh]** production production in kWh CH BFE
103 Vergütung 2016 [CHF] tariff tariff in CHF for 2016 CH BFE
104 Anmeldedatum notification_date date of data entriy at BFE CH BFE
105 Anlage_Vertragsende cantract_period_end end of the contract period CH BFE
106 Anlage_Strasse street name of the street CH BFE
107 Anlage_Kanton canton name of the cantones/ member states of the Swi... CH BFE
108 Produzent_Firma company name of the company CH BFE
109 Produzent_Anrede title titel of owner CH BFE
110 Produzent_Name surname family name of owner CH BFE
111 Produzent_\nVorname first_name given name of owner CH BFE

112 rows × 5 columns

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.

In [2]:
import pandas as pd
pd.read_csv('input/value_translation_list.csv')
Out[2]:
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 Geothermie Geothermal Geothermal DE BnetzA / TenneT / 50Hertz / Amprion
9 Windenergie Offshore Offshore Wind DE 50Hertz / TenneT
10 Solar Photovoltaics Solar DE TransnetBW / TenneT / 50Hertz / Amprion
11 Windenergie Onshore Wind DE TenneT / 50Hertz / Amprion
12 Windenergie an Land Onshore Wind DE TransnetBW
13 HS high voltage NaN DE BNetzA
14 HS/MS high voltage / medium voltage NaN DE BNetzA
15 HöS extra high voltage NaN DE BNetzA
16 HöS/HS high voltage / extra high voltage NaN DE BNetzA
17 MS Medium voltage NaN DE BNetzA
18 MS/NS Medium voltage / low voltage NaN DE BNetzA
19 NS Low voltage NaN DE BNetzA
20 TransnetBW GmbH TransnetBW NaN DE TransnetBW
21 TenneT TSO GmbH TenneT NaN DE TenneT
22 Amprion GmbH Amprion NaN DE Amprion
23 HAV Offshore Wind DK Energistyrelsen
24 LAND Onshore Wind DK Energistyrelsen
25 Land Onshore Wind DK Energistyrelsen
26 Biomasse Biomass and biogas Bioenergy FR gouv.fr
27 Eolien Wind Wind FR gouv.fr
28 Géothermie Geothermal Geothermal FR gouv.fr
29 Hydraulique Hydro Hydro FR gouv.fr
... ... ... ... ... ...
62 Denmark DK NaN Europe IRENA
63 France FR NaN Europe IRENA
64 Germany DE NaN Europe IRENA
65 Poland PL NaN Europe IRENA
66 Bioenergy and other renewale fuels Bioenergy and renewable waste Bioenergy Europe OPSD
67 Solar Solar NaN Europe OPSD
68 Wind Wind NaN Europe OPSD
69 Geothermal Geothermal NaN Europe OPSD
70 Differently categorized hydro Hydro NaN Europe OPSD
71 Tide, wave, and ocean Marine NaN Europe OPSD
72 Biomasse Biomass Bioenergy CH BFE
73 Wind Wind Wind CH BFE
74 Photovoltaik Photovoltaics Solar CH BFE
75 Wasserkraft Hydro Hydro CH BFE
76 Abwasserkraftwerk Waste water plant NaN CH BFE
77 Schlammverbrennungsanlage Biomass and biogas Bioenergy CH BFE
78 Kehrrichtverbrennungsanlage Biomass and biogas Bioenergy CH BFE
79 Integrierte Anlage Integrated unit NaN CH BFE
80 Angebaute Anlage Connected unit NaN CH BFE
81 Durchlaufkraftwerk Run-of-river NaN CH BFE
82 Freistehende Anlage Stand alone unit NaN CH BFE
83 Dotierwasserkraftwerk other Hydro NaN CH BFE
84 Klärgasanlage Biomass and biogas Bioenergy CH BFE
85 übrige Biomasse - übrige WKK-Anlage Biomass and biogas Bioenergy CH BFE
86 übrige Biomasse - Dampfprozess Biomass and biogas Bioenergy CH BFE
87 Ausleitkraftwerk Diversion plant Hydro CH BFE
88 Unbekannt Unknown NaN CH BFE
89 natürliche Person Natural person NaN CH BFE
90 juristische Person Legal entity NaN CH BFE
91 Trinkwasserkraftwerk Drinking water plant Hydro CH BFE

92 rows × 5 columns

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:

In [3]:
import pandas as pd
pd.read_csv('input/validation_marker.csv')
Out[3]:
Validation marker Short explanation Long explanation
0 R_1 data_source = BnetzA and commissioning_date < ... This powerplant is probably also represented b...
1 R_2 notification_reason other than „Inbetriebnahme... This powerplant is probably also represented b...
2 R_3 commissioning_date not specified NaN
3 R_4 electrical_capacity not specified NaN
4 R_5 decommissioned from the grid This powerplant is probably commissioned again...
5 R_6 decommissioned This powerplant is completely decommissioned.
6 R_7 not connected to the European grid This powerplant is located in regions belongin...

5.4 Energy source structure

OPSD-Tree

6. License

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