Have a personal or library account? Click to login
Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in the Poznań Metropolitan Area, Poland Cover

Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in the Poznań Metropolitan Area, Poland

By: Robert Kostecki  
Open Access
|Aug 2024

References

  1. Achuthan, K., Titheridge, H., and Mackett, R. L. (2010). Mapping accessibility differences for the whole journey and for socially excluded groups of people. Journal of Maps, 6(1):220–229, doi:10.4113/jom.2010.1077.
  2. Afnarius, S., Akbar, F., Hasanah, Z., Putra, H. Y., et al. (2023). Development of GIS-based Rumah Gadang Tools as a tourism data integrator for Halal Tourist Villages in West Sumatra, Indonesia. International Journal on Advanced Science, Engineering & Information Technology, 13(1):34–41, doi:10.18517/ijaseit.13.1.16714.
  3. Akay, A. E. and Tas, I. (2020). Using GIS techniques for assessment of accessible forest lands by firefighting teams considering fire risk degrees. European Journal of Forest Engineering, 6(2):87–95, doi:10.33904/ejfe.843889.
  4. Almohamad, H., Knaack, A. L., and Habib, B. M. (2018). Assessing spatial equity and accessibility of public green spaces in Aleppo City, Syria. Forests, 9(11):706, doi:10.3390/f9110706.
  5. Amaguaya, F. R. O. and Hernández, J. R. H. (2020). Improvement of Public Transport Routes with ArcGIS Network Analyst. Case Study: Urban Center of Milagro, Ecuador, pages 31–36. Springer International Publishing, doi:10.1007/978-3-030-51566-9_5.
  6. Botha, T. L., Bamuza-Pemu, E., Roopnarain, A., Ncube, Z., De Nysschen, G., Ndaba, B., Mokgalaka, N., Bello-Akinosho, M., Adeleke, R., Mushwana, A., van der Laan, M., Mphahlele, P., Vilakazi, F., Jaca, P., and Ubomba-Jaswa, E. (2023). Development of a GIS-based knowledge hub for contaminants of emerging concern in South African water resources using open-source software: Lessons learnt. Heliyon, 9(1):e13007, doi:10.1016/j.heliyon.2023.e13007.
  7. Brinkhoff, T. and Kresse, W. (2012). Springer Handbook of Geographic Information. Springer Berlin Heidelberg, doi:10.1007/978-3-540-72680-7.
  8. Campos-Sánchez, F. S., Valenzuela-Montes, L. M., and Abarca-Álvarez, F. J. (2019). Evidence of green areas, cycle infrastructure and attractive destinations working together in development on urban cycling. Sustainability, 11(17):4730, doi:10.3390/su11174730.
  9. Choosumrong, S., Humhong, C., Raghavan, V., and Fenoy, G. (2019). Development of optimal routing service for emergency scenarios using pgRouting and FOSS4G. Spatial Information Research, 27(4):465–474, doi:10.1007/s41324-019-00248-2.
  10. Comber, A., Brunsdon, C., and Green, E. (2008). Using a GIS-based network analysis to determine urban greenspace accessibility for different ethnic and religious groups. Landscape and Urban Planning, 86(1):103–114, doi:10.1016/j.landurbplan.2008.01.002.
  11. Cyril, A., Mulangi, R. H., and George, V. (2019). Development of a GIS-based composite public transport accessibility index. Journal of Urban and Environmental Engineering, pages 235–245, doi:10.4090/juee.2019.v13n2.235245.
  12. Duarte, L., Teodoro, A. C., Lobo, M., Viana, J., Pinheiro, V., and Freitas, A. (2021). An open source GIS application for spatial assessment of health care quality indicators. ISPRS International Journal of Geo-Information, 10(4):264, doi:10.3390/ijgi10040264.
  13. Escobar, D. and Garcia, F. (2012). Territorial accessibility analysis as a key variable for diagnosis of urban mobility: A case study Manizales (Colombia). Procedia - Social and Behavioral Sciences, 48:1385–1394, doi:10.1016/j.sbspro.2012.06.1114.
  14. Ford, A., Barr, S., Dawson, R., and James, P. (2015). Transport accessibility analysis using GIS: Assessing sustainable transport in London. ISPRS International Journal of Geo-Information, 4(1):124–149, doi:10.3390/ijgi4010124.
  15. Janeczko, E., Wójcik, R., Kędziora, W., Janeczko, K., and Woźnicka, M. (2019). Organised physical activity in the forests of the Warsaw and Tricity agglomerations, Poland. International Journal of Environmental Research and Public Health, 16(20):3961, doi:10.3390/ijerph16203961.
  16. Juba, S., Vannahme, A., and Volkov, A. (2015). Learning PostgreSQL: create, develop, and manage relational databases in real-world applications using PostgreSQL. Packt Publishing Ltd.
  17. Kabolizadeh, M., Karimian, R., Rangzan, K., Alizadeh, B., and Maroufi, K. (2023). Development of a geodatabase for retrieval of geochemical data from oil wells: A case study from the Gach-saran oilfield; SW Iran. Geoenergy Science and Engineering, 225:211621, doi:10.1016/j.geoen.2023.211621.
  18. Kaczynski, A. T., Potwarka, L. R., and Saelens, B. E. (2008). Association of park size, distance, and features with physical activity in neighborhood parks. American Journal of Public Health, 98(8):1451–1456, doi:10.2105/ajph.2007.129064.
  19. Kostecki, R. (2018). Application of the spatial database for shoreline change analysis and visualisation: Example from the Western Polish Coast, Southern Baltic Sea. Quaestiones Geographicae, 37(3):25–34, doi:10.2478/quageo-2018-0023.
  20. Krzywnicka, I. and Jankowska, P. (2021). Accessibility of public urban green space. A case study of Białystok city. Acta Scientiarum Polonorum Administratio Locorum, 20(3):203–214, doi:10.31648/aspal.6794.
  21. Luo, W. (2004). Using a GIS-based floating catchment method to assess areas with shortage of physicians. Health and Place, 10(1):1–11, doi:10.1016/s1353-8292(02)00067-9.
  22. Maas, J., Verheij, R. A., Spreeuwenberg, P., and Groenewegen, P. P. (2008). Physical activity as a possible mechanism behind the relationship between green space and health: A multilevel analysis. BMC Public Health, 8(1), doi:10.1186/1471-2458-8-206.
  23. Merciu, C., Stoian, D., Merciu, G., and Saghin, I. (2013). Using GIS for calculating the accessibility to hospitals in the city of Bucharest and its metropolitan area (Romania). Geographica Pannonica, 17(4):106–113.
  24. Neuvonen, M., Sievänen, T., Tönnes, S., and Koskela, T. (2007). Access to green areas and the frequency of visits – A case study in Helsinki. Urban Forestry and Urban Greening, 6(4):235–247, doi:10.1016/j.ufug.2007.05.003.
  25. Obe, R. O. and Hsu, L. S. (2021). PostGIS in Action, Third Edition. Manning Publications.
  26. Obe, R. O., Hsu, L. S., and Sherman, G. E. (2017). pgRouting: A practical guide. Locate Press.
  27. O’Sullivan, D., Morrison, A., and Shearer, J. (2000). Using desktop GIS for the investigation of accessibility by public transport: An isochrone approach. International Journal of Geographical Information Science, 14(1):85–104, doi:10.1080/136588100240976.
  28. pgRouting (2024). pgRouting Documentation. https://docs.pgrouting.org/.
  29. PostGIS (2024). PostGIS Documentation. https://postgis.net/documentation/.
  30. PostgreSQL (2024). PostgreSQL Documentation. https://www.postgresql.org/docs/.
  31. Połom, M., BEGER, M., and Topa, E. (2017). Research of the walking availability and the public transport to urban parks on the example of GdaŃsk. Studia Miejskie, (27):25–38, doi:10.25167/sm2017.027.02.
  32. Sarmah, S., Yadav, R., and Rathore, P. (2019). Development of vehicle routing model in urban solid waste management system under periodic variation: A case study. IFAC-PapersOnLine, 52(13):1961–1965, doi:10.1016/j.ifacol.2019.11.490.
  33. Vías, J., Rolland, J., Gómez, M. L., Ocaña, C., and Luque, A. (2018). Recommendation system to determine suitable and viable hiking routes: A prototype application in Sierra de las Nieves Nature Reserve (southern Spain). Journal of Geographical Systems, 20(3):275–294, doi:10.1007/s10109-018-0271-8.
  34. Wei, X., Zhao, C., Yan, L., Fu, J., Bao, Y., and Liu, X. (2022). Spatial accessibility analysis of green space from a health-benefit perspective: Implications for healthy urban development. Frontiers in Ecology and Evolution, 10, doi:10.3389/fevo.2022.1083563.
  35. Widaningrum, D. L. (2015). A GIS-based approach for catchment area analysis of convenience store. Procedia Computer Science, 72:511–518, doi:10.1016/j.procs.2015.12.158.
  36. Widyantoro, B. A. and Santosa, P. B. (2021). Network analysis to determine the optimal route for firefighters in Makassar City. IOP Conference Series: Earth and Environmental Science, 936(1):012005, doi:10.1088/1755-1315/936/1/012005.
  37. Wysmułek, J., Hełdak, M., and Kucher, A. (2020). The analysis of green areas’ accessibility in comparison with statistical data in Poland. International Journal of Environmental Research and Public Health, 17(12):4492, doi:10.3390/ijerph17124492.
DOI: https://doi.org/10.2478/rgg-2024-0014 | Journal eISSN: 2391-8152 | Journal ISSN: 0867-3179
Language: English
Submitted on: Feb 29, 2024
Accepted on: Jul 16, 2024
Published on: Aug 31, 2024
Published by: Warsaw University of Technology
In partnership with: Paradigm Publishing Services
Publication frequency: 2 issues per year

© 2024 Robert Kostecki, published by Warsaw University of Technology
This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 License.