Vol. 6 No. 6 (2024): Ranah Research : Journal Of Multidisciplinary Research and Development (September 2024 - Oktober 2024)

Geographic Information System Using Postgre SQL-QGIS for Slum Squatter Distribnution Mapping in North Jakarta

##plugins.themes.academic_pro.article.sidebar##

Download
PDF
Statistic

Downloads

Download data is not yet available.

##plugins.themes.academic_pro.article.main##

Ghefra Rizkan Gaffara
Survey and Mapping Department, Engineering Faculty, Esa Unggul University, Jakarta
Jerry Maratis
Physiotherapy Department, Physiotherapy Faculty, Esa Unggul University, Jakarta
Laras Sitoayu
Nutritional Science Department, Health Sciences Faculty, Esa Unggul University, Jakarta
Rian Adi Pamungkas
Nursing Science Department, Health Sciences Faculty, Esa Unggul University, Jakarta
Ummanah Ummanah
Communication Science Department, Communication Science Faculty, Esa Unggul University, Jakarta

Published

Oct 9, 2024

DOI

https://doi.org/10.38035/rrj.v6i6.1173

Abstract

This research aim to build a geographic information system that displays a mapping of slum building distribution in North Jakarta. One of spatial software was developed using a method is the Rational Unified Process (RUP) method. This research aim to build a geographic information system that displays a mapping of building distribution in North Jakarta. This system was built using Postgre SQL and QGIS to build map. The research finding in the research is that there is a tendency for built-up areas to grow in slum areas due to the absence of rental fees, land and building costs, but the feasibility conditions of these areas are very unsuitable. This research is limited to implementing the use of Postgre SQL and QGIS software. Because the rendering process for the visual display is very difficult. I hope that in the future this research will be developed interesting 3D visualization accompanied by charts. The implication of this research is to make it easier to see the distribution of dense and slum areas and become a step for the government in making policies. The originality of this research is that there is still no one who combines the two software in mapping analysis.

##plugins.themes.academic_pro.article.details##

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Hak Cipta :

Penulis yang mempublikasikan manuskripnya di jurnal ini menyetujui ketentuan berikut:

  1. Hak cipta pada setiap artikel adalah milik penulis.
  2. Penulis mengakui bahwa Ranah Research : Journal of Multidisciplinary Research and Development berhak menjadi yang pertama menerbitkan dengan lisensi Creative Commons Attribution 4.0 International (Attribution 4.0 International CC BY 4.0) .
  3. Penulis dapat mengirimkan artikel secara terpisah, mengatur distribusi non-eksklusif manuskrip yang telah diterbitkan dalam jurnal ini ke versi lain (misalnya, dikirim ke repositori institusi penulis, publikasi ke dalam buku, dll.), dengan mengakui bahwa manuskrip telah diterbitkan pertama kali di Ranah Research.
How to Cite
Rizkan Gaffara, G., Maratis, J., Sitoayu, L., Adi Pamungkas, R. and Ummanah, U. (2024) “Geographic Information System Using Postgre SQL-QGIS for Slum Squatter Distribnution Mapping in North Jakarta”, Ranah Research : Journal of Multidisciplinary Research and Development, 6(6), pp. 2734-2738. doi: 10.38035/rrj.v6i6.1173.

References

Afnarius, S. (n.d.). PERANCANGAN SISTEM VISUALISASI DATA KEPENGUNGSIAN MENGGUNAKAN DATABASE SPATIAL POSTGIS.
Aji Bayu Prasetyo, D., & Alfa Susetyo, Y. (2022). Implementasi Information Schema Database Pada Postgre SQL Untuk Pembuatan Tabel Informasi Dengan Menggunakan Python Di PT XYZ (Vol. 9, Issue 3). http://jurnal.mdp.ac.id
Christiono, K., & Sama, H. (n.d.). STUDI KOMPARASI DATABASE MANAGEMENT SYSTEM ANTARA MARIA DB DAN POSTGRESQL TERHADAP EFISIENSI PENGGUNAAN SUMBER DAYA KOMPUTER (Vol. 1). http://journal.uib.ac.id/index.php/cbssit
Connect to PostgreSQL from ArcGIS ArcGIS 11.2 (Windows) Help archive. (n.d.). https://enterprise.arcgis.com/en/server/latest/manage-data/windows/connect-postgresql.htm
Creating a GeoDatabase with PostgreSQL_PostGIS and Connecting to QGIS _ by Elii Skeans _ Medium. (n.d.).
Dwi Praba, A., & Safitri, M. (n.d.). STUDI PERBANDINGAN PERFORMANSI ANTARA MYSQL DAN POSTGRESQL. VIII(2). https://www.adminer.org/.
Engineering Blog. (n.d.). https://engineering.zalando.com/posts/2021/12/maps-with-postgresql-and-postgis.html
Markieta, M. (n.d.). View of Using OpenStreetMap Data with Open-Source GIS | Cartographic Perspectives Using OpenStreetMap Data with Open-Source GIS. https://cartographicperspectives.org/index.php/journal/article/view/cp71-markieta/html
pg_journal _ PostgreSQL Extension Network. (n.d.).
Rahmad Akbar, A. (n.d.). Peningkatan Kinerja Server Aplikasi Web GIS Berbasis PostgreSQL dan MapServer Performance Improvement of Web GIS Application Server Based on PostgreSQL and MapServer. http://journal.ipb.ac.id/index.php.jika
Ruslan Rainis, dan. (2013). A PostgreSQL/PostGIS Implementation for the Sightseeing Tour Planning Problem. In Jurnal Rekayasa Elektrika (Vol. 10, Issue 3).
Stonebraker, M., Rowe, L. A., & Hirohama, M. (1990). The Implementation of POSTGRES. IEEE Transactions on Knowledge and Data Engineering, 2(1), 125–142. https://doi.org/10.1109/69.50912
Talipova, L., Morozova, E., Pestova, D., & Skhvediani, A. (2023). Methodology for Creating a Geographic Information System for Transport Infrastructure Facilities. International Journal of Technology, 14(8), 1831–1840. https://doi.org/10.14716/ijtech.v14i8.6849
The Past, Present and Future of GIS_ PostGIS 2.0 Is Here! _ Linux Journal. (n.d.).
Zhou, L., Chen, N., Chen, Z., & Xing, C. (2016). ROSCC: An Efficient Remote Sensing Observation-Sharing Method Based on Cloud Computing for Soil Moisture Mapping in Precision Agriculture. IEEE Journal of Selected Topics in Applied Earth Observations and Remote Sensing, 9(12), 5588–5598. https://doi.org/10.1109/JSTARS.2016.2574810