ORIGINAL ARTICLE
Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in
the Poznań Metropolitan Area, Poland
1
Applied Geoinformatics Laboratory, Institute of Geoecology and Geoinformation, Faculty of Geographical and Geological Sciences, Adam Mickiewicz University, Krygowskiego 10, 61–680, Poznań, Poland
A - Research concept and design; B - Collection and/or assembly of data; C - Data analysis and interpretation; D - Writing the article; E - Critical revision of the article; F - Final approval of article
Submission date: 2024-02-29
Final revision date: 2024-07-12
Acceptance date: 2024-07-16
Publication date: 2024-08-30
Corresponding author
Robert Kostecki
Applied Geoinformatics Laboratory, Institute of Geoecology and Geoinformation, Faculty of Geographical and Geological Sciences, Adam Mickiewicz University, Krygowskiego 10, 61–680, Poznań, Poland
Applied Geoinformatics Laboratory, Institute of Geoecology and Geoinformation, Faculty of Geographical and Geological Sciences, Adam Mickiewicz University, Krygowskiego 10, 61–680, Poznań, Poland
Reports on Geodesy and Geoinformatics 2024;118:46-52
KEYWORDS
TOPICS
GIS development & algorithmsGIS applicationsGeospatial data analysisLand management & Spatial planning
ABSTRACT
The main aim of this paper is to introduce a solution for network analysis based on pgRouting to resolve the bicycle accessibility of forested green spaces. The proposed application uses open-source software tools such as PostgreSQL with PostGIS extension. The solution includes a complete description of how to perform network analysis using a spatial database with SQL and pgRouting. The implemented functionalities consist of solutions for finding the equidistance or isochrone area for any selected point location. The method is tested on case study data drawn from a total of 9,500 km of roads suitable for cyclists in the Poznań Metropolitan Area, located in western Poland. The results of the analysis were isochrones determining the bicycle accessibility of forested areas. The accessibility analysis was performed considering an urbanised residential area. As a result of the analysis, locations with the best and limited access to forested green areas were identified. Moreover, the described methodology is ready to be used to solve various accessibility problems.
ACKNOWLEDGEMENTS
The author is grateful to the reviewers for constructive comments that helped improve the quality of the manuscript.
FUNDING
The study was supported by the statutory funds of the Faculty of Geographical and Geological Sciences at Adam Mickiewicz University in Poznań, Poland.
REFERENCES (37)
1.
Achuthan Kamalasudhan, Titheridge Helena, Mackett Roger 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 Surya, Akbar Fajril, Hasanah Zikriya, Putra Hafid Yoza, others. (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 Abdullah Emin, Tas Inanc. (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 Hussein, Knaack Anna Lisa, Habib Badriah Mohammed. (2018). Assessing Spatial Equity and Accessibility of Public Green Spaces in Aleppo City, Syria. Forests. 9 (11): 706-706. doi:10.3390/f9110706.
5.
Amaguaya Freddy René Orozco, Hernández Jesús Rafael Hechavarría. (2020). Improvement of Public Transport Routes with ArcGIS Network Analyst. Case Study: Urban Center of Milagro, Ecuador. In: Advances in Human Factors in Architecture, Sustainable Urban Planning and Infrastructure. 31-36. Springer International Publishing. doi:10.1007/978-3-030-51566-9_5.
6.
Botha Tarryn Lee, Bamuza-Pemu Emomotimi, Roopnarain Ashira, Ncube Zibusiso, De Nysschen Gert, Ndaba Busiswa, Mokgalaka Ntebogeng, Bello-Akinosho Maryam, Adeleke Rasheed, Mushwana Akani, van der Laan Michael, Mphahlele Phedisho, Vilakazi Fanelesibonge, Jaca Penny, Ubomba-Jaswa Eunice. (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-e13007. doi:10.1016/j.heliyon.2023.e13007.
7.
Brinkhoff T., Kresse W. (2012). Springer Handbook of Geographic Information. Springer Berlin Heidelberg. doi:10.1007/978-3-540-72680-7.
8.
Campos-Sánchez Francisco Sergio, Valenzuela-Montes Luis Miguel, Abarca-Álvarez Francisco Javier. (2019). Evidence of Green Areas, Cycle Infrastructure and Attractive Destinations Working Together in Development on Urban Cycling. Sustainability. 11 (17): 4730-4730. doi:10.3390/su11174730.
9.
Choosumrong Sittichai, Humhong Chingchai, Raghavan Venkatesh, Fenoy Gérald. (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 Alexis, Brunsdon Chris, Green Edmund. (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 Anila, Mulangi Raviraj H, George Varghese. (2019). DEVELOPMENT OF A GIS-BASED COMPOSITE PUBLIC TRANSPORT ACCESSIBILITY INDEX. Journal of Urban and Environmental Engineering. : 235-245. doi:10.4090/juee.2019.v13n2.235245.
12.
Duarte Lia, Teodoro Ana Cláudia, Lobo Mariana, Viana João, Pinheiro Vera, Freitas Alberto. (2021). An Open Source GIS Application for Spatial Assessment of Health Care Quality Indicators. ISPRS International Journal of Geo-Information. 10 (4): 264-264. doi:10.3390/ijgi10040264.
13.
Escobar Diego, Garcia Francisco. (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 Alistair, Barr Stuart, Dawson Richard, James Philip. (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 Emilia, Wójcik Roman, Kędziora Wojciech, Janeczko Krzysztof, Woźnicka Małgorzata. (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-3961. doi:10.3390/ijerph16203961.
16.
Juba Salahaldin, Vannahme Achim, Volkov Andrey. (2015). Learning PostgreSQL: create, develop, and manage relational databases in real-world applications using PostgreSQL. Packt Publishing Ltd.
17.
Kabolizadeh Mostafa, Karimian Razieh, Rangzan Kazem, Alizadeh Bahram, Maroufi Khaled. (2023). Development of a geodatabase for retrieval of geochemical data from oil wells: A case study from the Gachsaran oilfield; SW Iran. Geoenergy Science and Engineering. 225: 211621-211621. doi:10.1016/j.geoen.2023.211621.
18.
Kaczynski Andrew T., Potwarka Luke R., Saelens Brian 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 Robert. (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 Iwona, Jankowska Patrycja. (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 Wei. (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 Jol, a, Verheij Robert A, Spreeuwenberg Peter, Groenewegen Peter 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 Cristina, Stoian Daniela, Merciu George, Saghin Irina. (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 Marjo, Sievänen Tuija, Tönnes Susan, Koskela Terhi. (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 Regina O, Hsu Leo S. (2021). PostGIS in Action, Third Edition. Manning Publications.
26.
Obe Regina O, Hsu Leo S, Sherman Gary E. (2017). pgRouting: A practical guide. Locate Press.
27.
O'Sullivan David, Morrison Alastair, Shearer John. (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.
31.
Połom Marcin, BEGER Michał, Topa Emilia. (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.P., Yadav R., 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 Jesús, Roll, José, Gómez María Luisa, Ocaña Carmen, Luque Ana. (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 Xiangrui, Zhao Chunrong, Yan Li, Fu Juanlin, Bao Ying, Liu Xiao. (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 Dyah Lestari. (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 Bimo Aji, Santosa Purnama Budi. (2021). Network Analysis to Determine the Optimal Route for Firefighters in Makassar City. IOP Conference Series: Earth and Environmental Science. 936 (1): 012005-012005. doi:10.1088/1755-1315/936/1/012005.
37.
Wysmułek Joanna, Hełdak Maria, Kucher Anatolii. (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-4492. doi:10.3390/ijerph17124492.
| eISSN: | 2391-8152 |
| ISSN: | 2391-8365 |
© 2006-2024 Journal hosting platform by Bentus
We process personal data collected when visiting the website. The function of obtaining information about users and their behavior is carried out by voluntarily entered information in forms and saving cookies in end devices. Data, including cookies, are used to provide services, improve the user experience and to analyze the traffic in accordance with the Privacy policy. Data are also collected and processed by Google Analytics tool (more).
You can change cookies settings in your browser. Restricted use of cookies in the browser configuration may affect some functionalities of the website.
You can change cookies settings in your browser. Restricted use of cookies in the browser configuration may affect some functionalities of the website.
