#!/usr/bin/env python # coding: utf-8 # # # # #

# 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](http://open-power-system-data.org). 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: # - [Information on the project on our website](http://open-power-system-data.org) # - [Data and metadata on our data platform](http://data.open-power-system-data.org) # - [Data processing scripts on our GitHub page](https://github.com/Open-Power-System-Data) # # # 2. About Jupyter Notebooks and GitHub # This file is a [Jupyter Notebook](http://jupyter.org/). 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](https://github.com/), a platform for software development, and are publicly available. More information on our IT-concept can be found [here](http://open-power-system-data.org/it). See also our [step-by-step manual](http://open-power-system-data.org/step-by-step) how to use the dataplatform. # # # 3. About this Data Package # We provide data in different chunks, or [Data Packages](http://frictionlessdata.io/data-packages/). The one you are looking at right now, [Renewable power plants](http://data.open-power-system-data.org/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 # - [Netztransparenz.de](https://www.netztransparenz.de/de/Anlagenstammdaten.htm) - Information platform from the German TSOs # # >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](http://www.bundesnetzagentur.de/) - 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)](http://www.gesetze-im-internet.de/eeg_2014/) [(English)](http://www.res-legal.eu/search-by-country/germany/single/s/res-e/t/promotion/aid/feed-in-tariff-eeg-feed-in-tariff/lastp/135/). All power plants are listed in a new format: two separate MS-Excel and CSV files for roof-mounted PV power plants ["PV-Datenmeldungen"](http://www.bundesnetzagentur.de/cln_1422/DE/Sachgebiete/ElektrizitaetundGas/Unternehmen_Institutionen/ErneuerbareEnergien/Photovoltaik/DatenMeldgn_EEG-VergSaetze/DatenMeldgn_EEG-VergSaetze_node.html) and all other renewable power plants [" Anlagenregister"](http://www.bundesnetzagentur.de/cln_1412/DE/Sachgebiete/ElektrizitaetundGas/Unternehmen_Institutionen/ErneuerbareEnergien/Anlagenregister/Anlagenregister_Veroeffentlichung/Anlagenregister_Veroeffentlichungen_node.html). # # ## 4.2 Denmark - DK # # - [ens.dk](http://www.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. # # # - [Energinet.dk](http://www.energinet.dk/EN/Sider/default.aspx) - Transmission system Operator in Denmark # # >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 # - [Ministery of the Environment,Energy and the Sea France](http://www.developpement-durable.gouv.fr/) # # > The data is annual published on the france [website for statistics](http://www.statistiques.developpement-durable.gouv.fr/energie-climat/r/energies-renouvelables.html?tx_ttnews[tt_news]=20647) 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 # - [Urzad Regulacji Energetyki (URE)](http://www.ure.gov.pl/uremapoze/mapa.html) - Energy Regulatory Office of Poland # # > 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](http://data.open-power-system-data.org/renewable_power_plants/). 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](https://opensource.org/licenses/MIT).