Greenpeace Spain hired me via my company Scifabric to look about the awareness ofsolar energy. Greenpeace Spain wanted to demand to the Spanish goverment that it promotes and uses green energies among its citizens.
For achieving this goal, I designed a crowdsourcing project where we mapped the public buildings of Spain (via the transparent data portal), and we ask volunteers from all over the world to confirm the location of the buildings as well as measuring the square meters of the roofs.
For building the platform we used: PYBOSSA and NuxtJS. I build a Progressive Web Application that can be used from phones, tablets and desktops.
The project uses the real-time data analysis features of PYBOSSA, and the next sections explain the methodology that I developed for the client.
To create this project we needed a database with all the public buildings belonging to the Central Public Administration.
The Spanish National Treasury has a web portal which we have used to obtain the list of public buildings used to build this project.
The data provided by the Spanish Government for each building is:
The relevant data to us is the location, we want to measure the building’s rooftop area.
With the postal address of each building, we went to Google Maps and searched their coordinates (latitude and longitude) to place every building on a map.
Of the 9959 buildings displayed in the transparency portal, Google only has results for 5253 of these. This is mainly due to the fact that the provided addresses are badly formatted or simply wrong. This is why in only 5253 public buildings can be analysed in this first phase.
With the geolocated buildings, we then move on to the web project. For this project, we are using PYBOSSA, a technology that allows for each building to be analysed by several people at one time to then later statistically analyse all of the participants´ contributions to generate valid results for every building.
The steps to follow in this project are:
By default each building is studied by 3 people. When the third person submits his/her analysis, the system statistically analyses the contributions and provides a result.
In order to avoid participants who wish to send wrongful data, the system validates the data as follows:
This way we can eliminate those contributions that are not good allowing us to focus on the data that we need
Once that the extension for each of the Central Government´s rooftops has been measured, the potential of photovoltaic electricity that could be generated in each one of those rooftops is calculated, as well as the CO2 emissions that could be avoided alongside with the financial savings that would mean for the Central Government and, therefore, for the citizens.
We believe that the electricity that could be produced in the measured roof could be instantly used up in the same building and therefore saving money generated by the installation, which would be the difference between the electricity that the Central Government no longer has to buy to the electric company (€ 0.139 + VAT 21% and 5.11269% electricity tax) and the investment required to carry out the photovoltaic installation (€ 1.45 / W) - a lifetime of 25 years is considered per installation.
If the available roof area surface is less than 60m2 (<10kW) we consider that, what is known in Spain as, the Sun Tax (for a 3.0 A connection point) is not applicable as well as are the cases of the Canary Islands, Melilla, Ceuta, Ibiza, and Formentera.
In the other cases, the Sun Tax that should be paid for by the Administration on self-consumed electricity is instantly introduced (transitory charge for self-consumed energy for a 3.0 A connection point as established by the Government
To calculate the amount of greenhouse gas emissions that each installation would avoid from occurring, the production of renewable electricity is multiplied by the emission factor of the electrical system of the Spanish region in which the building is located according to the data provided by Red Eléctrica Española for the year 2017
Mainland Spain: 0.269 kg CO2 / kWh Balearic Islands: 0,714 kg CO2 / kWh Ceuta and Melilla: 0,745 kg CO2 / kWh Canary Islands: 0,775 kg CO2/kWh
To calculate the necessary equivalences to make the data provided more understandable, the following information has been considered:
For the analysis, the statistical package Pandas is used, as well as the algorithm DBSCAN to generate the clusters.
The rest is PYBOSSA and NuxtJS.