VISUALISATION OF URBAN SPRAWL WITHIN THE CITY USING TABLEAU

Abstract

The urban sprawl still happening today is causing an imbalance in development between urban and rural areas. Issues such as non-optimal land use, land use development dispersal, land use conversion to municipal use, and reducing forest and agricultural areas need help in effective governance and enforcement. Furthermore, the condition of the village-in-the-city is increasingly threatened due to the urban sprawl. Currently, the existing visualisations are limited to only categorising the city and village boundaries. It cannot show the boundaries of a village-in-the-city area. The vague boundary categorisation caused by the village boundary area in the city cannot be determined clearly when the existing data provide only the city boundary and the village boundary. This study introduced a structured visualisation of village boundaries in the city using TABLEAU to assist agencies in making decisions in formulating development plans, especially for rural areas in the city. Focus Group Discussions (FGD) among the stakeholders are then used to evaluate the effectiveness of the developed visualisation. The visualisation will be based on dashboard development using Tableau software, including statistical information and urban, rural and village-in-the-city boundary information. The existing raw data in shapefiles, excel, and comma-separated values (CSV) formats are processed and integrated before the dashboard can be developed. This paper presented a pilot study for only two states: Negeri Sembilan and Melaka. The results of this study have been able to prove the existence of village-in-the-city visually, which previously could not be confirmed in the form of graphic maps. In addition, the results from the FGD can be concluded that the developed visualisations are promising and could provide the necessary information. Besides helping the agency management make better and more accurate decisions, this study will also benefit the public living within the city's village boundary area. On the other hand, from a scientific point of view, this study can be further explored to visualise the urban sprawl and apply predictive analysis to determine the needs of educational and health facilities in the area.