Renewable power plants: Main Notebook
This Notebook is part of the Renewable power plants Data Package of 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:
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.
We provide data in different chunks, or Data Packages. The one you are looking at right now, Renewable power plants, contains
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.
This Data Package uses the following main data sources.
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).
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".
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.
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.
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.
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 |
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 |
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). |
This Jupyter Notebook as well as all other documents in this repository is published under the MIT License.