Development of WebGIS for Street Light Mapping Using Geospatial Tools
DOI:
https://doi.org/10.52436/1.jutif.2025.6.4.4777Keywords:
Geoserver, Spatial Data Management, Street light, WebGISAbstract
Padang City, as one of the cities the largest on the west coast of Sumatra Island, plays a strategic role in the economy and government. One of the vital infrastructures that supports public activities is the street lighting system. However, the monitoring and maintenance of streetlights still face obstacles, especially in North Padang District, which is the busiest area due to the presence of numerous educational facilities, government offices, and economic centers. This research aims to develop a WebGIS application that facilitates the monitoring and management of street lighting more efficiently. Our research contributes by introducing a new approach to spatial-based streetlight management strategies. This approach is based on a methodology for field data collection and spatial database development to manage all stages of streetlight infrastructure management. This application integrates geospatial technology by utilizing GeoServer, QGIS, and PostgreSQL for visualization and spatial data management. With this system, information about the location and condition of streetlights can be accessed in real-time, thereby facilitating better planning and maintenance of street lighting infrastructure. The result of this study is a WebGIS application capable of mapping and monitoring streetlight points interactively. The implementation of this system is expected to assist relevant authorities in improving the effectiveness of street lighting management in Padang City and contribute to the development of geospatial technology-based solutions for urban infrastructure.
Downloads
References
U. Wisha, R. Dhiauddin, K. Ondara, W. Gemilang, and G. Rahmawan, “Assessing Urban Development Impacts in the Padang Coastline City, West Sumatra Indonesia; Coastline Changes and Coastal Vulnerability,” Geoplanning Journal of Geomatics and Planning, vol. 9, pp. 73–88, Nov. 2022, doi: https://doi.org/10.14710/geoplanning.9.2.73-88
Western Indian Ocean Marine Science Association, Coastal Cities of the Western Indian Ocean Region and the Blue Economy: Status Report. Available: https://www.wiomsa.org/publications/coastal-cities-of-the-western-indian-ocean-region-and-the-blue-economy-status-report/. (Accessed: Mar. 04, 2025)
B. Apriyano, Z. Abidin Zainuddin, A. Hasnimy Mohd Hashim, S. Mohammed Sayyd, and A. Naqkiah Mazlan, “Physical fitness levels of junior high school students in different regions: Highlands, lowlands, and islands,” JPES, vol. 23, no. 12, Dec. 2023, doi: https://doi.org/10.7752/jpes.2023.12387
Central Bureau of Statistics, “Jumlah Penduduk Menurut Jenis Kelamin di Kota Padang (Jiwa), 2022”, (Number of Populations by Sex (People), 2022), Jul. 12, 2023. Available: https://padangkota.bps.go.id/id/statistics-table/2/MzEjMg==/jumlah-penduduk-menurut-jenis-kelamin-di-kota-padang.html. (Accessed: Jan. 20, 2025)
Zusmelia, Ansofino, Irwan, and J. Ronald, “The Social Network of Creative Economy Actors in the Padang City Tourism Destination Area, West Sumatra,” International Journal of Social Science and Business, vol. 7, pp. 994–1003, Nov. 2023, doi: https://doi.org/10.23887/ijssb.v7i4.52668
F. Colombijn, “The Colonial Municipal Council in Padang (Sumatra) as Political Arena,” Journal of Southeast Asian Studies, vol. 26, no. 2, pp. 263–288, Aug. 2009, doi: https://doi.org/10.1017/S0022463400007104
A. Rina Herawati, . M., and R. Sunu Astuti, “Network Governance in the Tourism Policy: The Case of Padang, West Sumatra,” KSS, Mar. 2024, doi: https://doi.org/10.18502/kss.v9i7.15464. Available: https://knepublishing.com/index.php/KnE-Social/article/view/15464. (Accessed: Feb. 08, 2025)
Y. Yenita, “Fostering Sustainability: Green Tourism Policy in Padang City, Indonesia,” Otoritas : Jurnal Ilmu Pemerintahan, vol. 14, no. 2, Art. no. 2, Aug. 2024, doi: https://doi.org/10.26618/ojip.v14i2.12031
“Gambaran Umum Kota Padang,” Pemerintah Kota Padang, Jan. 01, 2020. Available: https://padang.go.id/gambaran-umum-kota-padang. (Accessed: May 10, 2024)
“IGES Centre Collaborating with UNEP on Environmental Technologies (CCET): Miho Hayashi, Dr. Rajeev Kumar Singh, Dr. Eng. Sudarmanto Budi Nugroho. ‘Study on Integrated Solid Waste Management: Padang City, Indonesia.’” Available: https://www.iges.or.jp/en/publication_documents/pub/researchreport/en/12562/Padang+City+study+report_web.pdf. (Accessed: Feb. 08, 2025)
P. Padang, “Peninjauan Kembali Rencana Tata Ruang Wilayah Kota Padang Tahun 2010-2030,” Bappeda Kota Padang, Dec. 12, 2019. Available: https://bappeda.padang.go.id/peninjauan-kembali-rencana-tata-ruang-wilayah-kota-padang-tahun-2010-2030. (Accessed: Feb. 11, 2025)
M. Liu et al., “Evaluating Street Lighting Quality in Residential Areas by Combining Remote Sensing Tools and a Survey on Pedestrians’ Perceptions of Safety and Visual Comfort,” Remote Sensing, vol. 14, no. 4, Feb. 2022, doi: https://doi.org/10.3390/rs14040826
Kusnadi, “Padang Transportation Agency Carries Out Repairs on Public Street Lights,” Portal Berita InfoPublik, 2023. Available: https://infopublik.id/kategori/nusantara/740138/dishub-padang-perbaiki-lampu-penerangan-jalan-umum. (Accessed: Feb. 08, 2025)
F. Pardo-Bosch, A. Blanco, E. Sesé, F. Ezcurra, and P. Pujadas, “Sustainable Strategy for The Implementation of Energy Efficient Smart Public Lighting in Urban Areas: Case Study in San Sebastian,” Sustainable Cities and Society, vol. 76, p. 103454, Jan. 2022, doi: https://doi.org/10.1016/j.scs.2021.103454
S. Khemakhem and L. Krichen, “A Comprehensive Survey on An IoT-Based Smart Public Street Lighting System Application for Smart Cities,” Franklin Open, vol. 8, p. 100142, Sep. 2024, doi: https://doi.org/10.1016/j.fraope.2024.100142
D. Moretz, “Internet GIS,” in Encyclopedia of GIS, S. Shekhar and H. Xiong, Eds., Boston, MA: Springer US, 2008, pp. 591–596. doi: 10.1007/978-0-387-35973-1_648. Available: https://doi.org/10.1007/978-0-387-35973-1_648. (Accessed: Feb. 09, 2025)
J. Vinueza-Martinez, M. Correa-Peralta, R. Ramirez-Anormaliza, O. Franco Arias, and D. Vera Paredes, “Geographic Information Systems (GISs) Based on WebGIS Architecture: Bibliometric Analysis of the Current Status and Research Trends,” Sustainability, vol. 16, no. 15, Art. no. 15, Jan. 2024, doi: https://doi.org/10.3390/su16156439
Y.-S. Chang and H.-D. Park, “Development of A Web-Based Geographic Information System for The Management of Borehole and Geological Data,” Computers & Geosciences, vol. 30, no. 8, pp. 887–897, Oct. 2004, doi: https://doi.org/10.1016/j.cageo.2004.07.006
M. Kulawiak, N. Kulawiak, M. Sulima, and K. Sikorska, “A Novel Architecture of Web-GIS for Mapping and Analysis of Echinococcosis in Poland,” Appl Geomat, vol. 14, no. 2, pp. 181–198, Jun. 2022, doi: https://doi.org/10.1007/s12518-022-00424-4
A. G. Mohamed, F. K. Alqahtani, E. R. Ismail, and M. Nabawy, “Synergizing GIS and Genetic Algorithms to Enhance Road Management and Fund Allocation with A Comprehensive Case Study Approach,” Sci Rep, vol. 15, no. 1, p. 4634, Feb. 2025, doi: https://doi.org/10.1038/s41598-025-88760-4
R. McIvor, M. McHugh, and C. Cadden, “Internet Technologies: Supporting Transparency in The Public Sector,” International Journal of Public Sector Management, vol. 15, no. 3, pp. 170–187, Jan. 2002, doi: 10.1108/09513550210423352
H. Suhendar, J. Iskandar, D. Kurniadi, and Y. Septiana, “ASSET MANAGEMENT SYSTEM DESIGN OF VILLAGE BASED ON GEOGRAPHIC INFORMATION SYSTEM,” J. Tek. Inform. (JUTIF), vol. 3, no. 4, pp. 815–819, Aug. 2022, doi: 10.20884/1.jutif.2022.3.4.299
X. Feng and A. T. Murray, “Spatial Analytics for Enhancing Street Light Coverage of Public Spaces,” LEUKOS, vol. 14, no. 1, pp. 13–23, Jan. 2018, doi: https://doi.org/10.1080/15502724.2017.1321486
R. Carli, M. Dotoli, and E. Cianci, “An Optimization Tool for Energy Efficiency of Street Lighting Systems in Smart Cities,” IFAC-PapersOnLine, vol. 50, no. 1, pp. 14460–14464, Jul. 2017, doi: https://doi.org/10.1016/j.ifacol.2017.08.2292
A. N. Mazhindu and H. K. Madamombe, “Design and Implementation of a Web-GIS for The Management of Road Infrastructure in Zimbabwe,” South African Journal of Geomatics, vol. 11, no. 1, 2022, doi: https:/doi.org/10.4314/sajg.v11i1.5
L. Cui, W. Li, X. Wang, and X. Niu, “Design and Implementation of Open-Source WebGIS System for Orchard Land Management,” Adv. Comput. Signals Syst, vol. 6, pp. 26–34, 2022, doi: https://doi.org/10.23977/acss.2022.060304
W. Shaohua et al., “Research on Visual Management system of Power Transmission Line based on two-dimensional GIS,” in Journal of Physics: Conference Series, IOP Publishing, 2021, pp. 12233–12233. doi: https://doi.org/10.1088/1742-6596/2005/1/012233
A. Rodrigues Da Silva et al., “A Web GIS Platform to Modeling, Simulate and Analyze Flood Events: The RiverCure Portal,” IJGI, vol. 12, no. 7, p. 268, Jul. 2023, doi: https://doi.org/10.3390/ijgi12070268
B. Grigory, P. Anton, O. Anastasia, G. S. A, R. Alena, and K. Anna, “Application of Geoportal’s Web-Technologies in GIS, Case Study: Interactive Geology Atlas,” Russian Journal of Earth Sciences, vol. 22, no. 3, pp. 1–9, Jul. 2022, doi: https://doi.org/10.2205/2022ES000794
G. I. Zagrebin, S. A. Krylov, and O. I. Kotova, “Creating Interactive Web Maps for The City,” Interexpo GEO-Siberia, vol. 1, pp. 169–177, May 2021, doi: https://doi.org/10.33764/2618-981X-2021-1-169-177
S. Chaudhuri, N. Ray, S. Chaudhuri, and N. Ray, Geospatial Mashups in Web GIS for Tourism Infrastructure: Internet-Based Channel Perspective Promotional Measures. IGI Global Scientific Publishing Platform, 2019.
G. Ghiani, F. Paternò, L. D. Spano, and G. Pintori, “An environment for End-User Development of Web mashups,” International Journal of Human-Computer Studies, vol. 87, pp. 38–64, Mar. 2016, doi: https://doi.org/10.1016/j.ijhcs.2015.10.008
J. F. Germinian and T. E. W. S.T., “Utilizing PostGIS Extension to Process Spatial Data Stored in Neo4j Database,” in 2023 IEEE International Conference on Data and Software Engineering (ICoDSE), Sep. 2023, pp. 250–255. doi: https://doi.org/10.1109/ICoDSE59534.2023.10291400. Available: https://ieeexplore.ieee.org/document/10291400. (Accessed: Feb. 11, 2025)
A. Da Silva Mano, B. C. Silva, P. Mocho, and F. Ortega, “Location-Based Management of Paleontological Collections using Open Source GIS Software,” Geoheritage, vol. 16, no. 2, p. 38, Jun. 2024, doi: https://doi.org/10.1007/s12371-024-00941-1
D. Haynes, M. Ahmadkhani, and J. Numainville, “The next generation of dashboards: a spatial online analytical processing (SOLAP) platform for COVID-19,” Journal of Maps, vol. 20, no. 1, p. 2276763, Dec. 2024, doi: https://doi.org/10.1080/17445647.2023.2276763
“Web archive — GeoServer 2.27.x User Manual.” Available: https://docs.geoserver.org/main/en/user/installation/war.html. (Accessed: Feb. 24, 2025)
A. F. Sveen, “Efficient Storage of Heterogeneous Geospatial Data in Spatial Databases,” Journal of Big Data, vol. 6, Nov. 2019, doi: https://doi.org/10.1186/s40537-019-0262-8
J. B. Cabral Júnior, H. J. F. D. Silva, and J. S. D. Reis, “PostGIS-T: Toward A Spatiotemporal PostgreSQL Database Extension,” Rev. Bras. Geog. Fis., vol. 15, no. 6, pp. 2704–2714, Dec. 2022, doi: https://doi.org/10.26848/rbgf.v15.6.p2704-2714
“SRID, SRS ID: Spatial Reference System Identifiers.” Available: https://www.bostongis.com/?content_name=srid#82. (Accessed: Feb. 11, 2025)
P. M. Jacob and M. Prasanna, “A Comparative analysis on Black box testing strategies,” in 2016 International Conference on Information Science (ICIS), Aug. 2016, pp. 1–6. doi: https://doi.org/10.1109/INFOSCI.2016.7845290. Available: https://ieeexplore.ieee.org/document/7845290. (Accessed: Feb. 11, 2025)
Additional Files
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Anisya, Fajrin, Indra warman, Minarni, Anna Syahrani, Fajar Nugroho
This work is licensed under a Creative Commons Attribution 4.0 International License.
