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 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.
This Data Package uses the following main data sources.
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.
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.
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.
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.
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.
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.
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.
import pandas as pd
pd.read_csv('input/column_translation_list.csv')
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
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.
import pandas as pd
pd.read_csv('input/value_translation_list.csv')
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
This Jupyter Notebook as well as all other documents in this repository is published under the MIT License.