Geographical Data Analysis Using PostGIS: A Case Study of Bus Routes in the Municipality of Divinópolis-MG

• Rafael Henrique dos Santos Simão UFV
• Agadir José Dias Aquino UFV
• Raul Mata Diz Luz UFV
• Rafael Souza Tavares de Castro UFV
• John Kauan Oliveira Passos UFV
• Victor Felipe de Oliveira UFV
• Adriana Zanella Martinhago UFV

DOI: https://doi.org/10.5753/wsis.2025.15647

Abstract

Urban mobility is a growing challenge in mid-sized cities, requiring data-based solutions to optimize public transportation. This study presents a spatial analysis of the bus network in Divinópolis–MG, aiming to identify inefficiencies and underserved areas. The PostGIS platform was used to integrate and process geographic layers such as streets, neighborhoods, and administrative boundaries. With the GeOM library, complex spatial operations were applied to data from the local transit provider. The analysis revealed route redundancies and coverage gaps. As a result, BRT route implementation was proposed, along with an interactive web interface to support data visualization and decision-making.

References

Andrade, N. F., de Lima Junior, F. B., Soliani, R. D., de Souza Oliveira, P. R., de Oliveira, D. A., Siqueira, R. M., da Silva Nora, L. A. R., and Macêdo, J. (2023). Urban mobility: A review of challenges and innovations for sustainable transportation in brazil. Revista de Gestão Social e Ambiental, 17(3).

Caminha, C., Furtado, V., Pinheiro, A., and Ponte, I. (2016). The cost of public transport on the urban poor: Evidence from fortaleza, brazil. Acesso em 4 jul. 2025.

GeoServer Project (2024). Geoserver - open source server for geospatial data. Acesso em 4 jul. 2025.

Google (2024). Google maps e google earth pro. Acesso em 4 jul. 2025.

Instituto Brasileiro de Geografia e Estatística (2022). Censo demográfico 2022. Acesso em 4 jul. 2025.

Lobo, C., Cardoso, R., Lessa, D., and Miranda, J. (2020). Impactos da metropolização no transporte coletivo: Região metropolitana de goiânia. Acesso em 4 jul. 2025.

Matias, (2025). Mobilidade urbana no brasil. Acesso em 8 jul. 2025.

OpenStreetMap Contributors (2024). Openstreetmap. Acesso em 4 jul. 2025.

PostgreSQL Global Development Group (2024). Postgresql + postgis. Acesso em 4 jul. 2025.

Prefeitura Municipal de Divinópolis (2021a). Configuração territorial de divinópolis. Acesso em 4 jul. 2025.

Prefeitura Municipal de Divinópolis (2021b). Plano diretor participativo de divinópolis. Acesso em 4 jul. 2025.

Pumar, L., Nascimento, J., Rodrigues, F., and Batista, C. (2018). Structure and resilience of rio de janeiro’s public transport network. Acesso em 4 jul. 2025.

QGIS Development Team (2024). Qgis - a free and open source geographic information system. Acesso em 4 jul. 2025.

Trancid Transportes Urbanos (2024). Itinerário das linhas. Acesso em 4 jul. 2025.

United Nations Economic Commission for Europe (2020). Sustainable urban mobility and public transport. [link]. Acesso em 8 set. 2025.