Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in the Poznań Metropolitan Area, Poland
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 descriptio...
Saved in:
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Sciendo
2024-12-01
|
| Series: | Reports on Geodesy and Geoinformatics |
| Subjects: | |
| Online Access: | https://doi.org/10.2478/rgg-2024-0014 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1850108206455455744 |
|---|---|
| author | Kostecki Robert |
| author_facet | Kostecki Robert |
| author_sort | Kostecki Robert |
| collection | DOAJ |
| description | 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. |
| format | Article |
| id | doaj-art-01c8d39d48e24acfab954662234dfba8 |
| institution | OA Journals |
| issn | 2391-8152 |
| language | English |
| publishDate | 2024-12-01 |
| publisher | Sciendo |
| record_format | Article |
| series | Reports on Geodesy and Geoinformatics |
| spelling | doaj-art-01c8d39d48e24acfab954662234dfba82025-08-20T02:38:26ZengSciendoReports on Geodesy and Geoinformatics2391-81522024-12-01118110.2478/rgg-2024-0014Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in the Poznań Metropolitan Area, PolandKostecki Robert01Applied Geoinformatics Laboratory, Institute of Geoecology and Geoinformation, Faculty of Geographical and Geological Sciences, Adam Mickiewicz University, Krygowskiego 10, 61–680, Poznań, PolandThe 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.https://doi.org/10.2478/rgg-2024-0014network analysispgroutingpostgisdijkstra algorithmspatial databaseaccessibility |
| spellingShingle | Kostecki Robert Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in the Poznań Metropolitan Area, Poland Reports on Geodesy and Geoinformatics network analysis pgrouting postgis dijkstra algorithm spatial database accessibility |
| title | Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in the Poznań Metropolitan Area, Poland |
| title_full | Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in the Poznań Metropolitan Area, Poland |
| title_fullStr | Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in the Poznań Metropolitan Area, Poland |
| title_full_unstemmed | Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in the Poznań Metropolitan Area, Poland |
| title_short | Spatial database applications for network analysis: Case study of bicycle accessibility of forested areas in the Poznań Metropolitan Area, Poland |
| title_sort | spatial database applications for network analysis case study of bicycle accessibility of forested areas in the poznan metropolitan area poland |
| topic | network analysis pgrouting postgis dijkstra algorithm spatial database accessibility |
| url | https://doi.org/10.2478/rgg-2024-0014 |
| work_keys_str_mv | AT kosteckirobert spatialdatabaseapplicationsfornetworkanalysiscasestudyofbicycleaccessibilityofforestedareasinthepoznanmetropolitanareapoland |