Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in the Poznań Metropolitan Area, Poland-Reference-Cited by-同舟云学术

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

Published:2024-08-31 Issue:1 Volume:118 Page:46-52
ISSN:2391-8152
Container-title:Reports on Geodesy and Geoinformatics
language:en
Short-container-title:

Author:

Kostecki Robert¹^ORCID

Affiliation:

1. 1 Applied Geoinformatics Laboratory, Institute of Geoecology and Geoinformation, Faculty of Geographical and Geological Sciences , Adam Mickiewicz University , Krygowskiego 10 , , Poznań , Poland

Abstract

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.

Publisher

Walter de Gruyter GmbH

Link

https://www.sciendo.com/pdf/10.2478/rgg-2024-0014

Reference37 articles.

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.