Cleansing and Transforming Solarmanpv Datasets for Visually Interactive Disclosure of Covert Information of Solar Power Plants Worldwide

New Renewable Energy (NRE) has become a buzzword. The sun is the most widely available source of NRE as its energy is so abundant and not restricted to a single dominating country, unlike fossil fuel sources such as oil and coal. In Indonesia solar power plants (SPP), also known as PLTS, is a growing opportunity as well as an increasing challenge for various stakeholders. The main question is how to grab and convey information on the development of rooftops SPP worldwide to boost their interest in the use of SPP. The purpose of this study is to gather and provide meaningful information in the form of Map Visualization of the distribution of rooftops SPP that have been installed throughout the world, ranked from the level of continents, countries, cities, down to the location. In particular, an interactive map visualization with drilldown (zoom in) and rollup (zoom out) capabilities to enable users to reveal interesting hidden information on global maps with pop-up details. Data processing, analysis and presentation involve data extraction, cleansing, transformation, exploration, and map visualization with folium, as well as additional map visualization using Google Earth Pro. Disclosure of key findings visually improve the quality of information delivery for ease of comparison and evaluation. In conclusion it is proven that the objective of providing map visualization with interactive zoom in and zoom out to drilldown and rollup for revealing relevant finding in the form of pop-up windows at selected points is achieved.

I. Introduction

Indonesia has been in the era of NRE (New Renewable Energy) where the production of electrical energy in many power plants has utilized many NRE sources[1]2[]. The use of NRE, especially solar energy, is virtually unlimited by geographic locations because almost the entire surface of the earth, both land and water, is illuminated by the sun with a relatively long span of time from 6 am to 6 pm. The penetration of solar power plants into the electric power system now and in the future will provide several opportunities as well as challenges[3][4] to various stakeholders, both to the community as a prosumer, the government as a regulator, to the state Power Grid Company as the owner of the Indonesian electric power system. Key stakeholders here are namely the rooftop SPP community as a prosumer, PLN (Perusahaan Listrik Negara or Indonesian Power Grid Company) as a single provider of state electricity networks, and the government as a regulator.