Analysis Platform for OpenStreetMap

Bolliger, Philipp and Scherrer, Marc (2020) Analysis Platform for OpenStreetMap. Other thesis, OST Ostschweizer Fachhochschule.

[thumbnail of HS 2020 2021-SA-EP-Bolliger-Scherrer-Eine Analyse-Plattform für OpenStreetMap mit Datenbank und V.pdf] Text
HS 2020 2021-SA-EP-Bolliger-Scherrer-Eine Analyse-Plattform für OpenStreetMap mit Datenbank und V.pdf - Supplemental Material

Download (6MB)


Big Data analysis and especially geospatial data analysis can reveal useful information about geographical phenomena and its own composition. One of the most commonly used source in open source data science is OSM.
There are numerous community tools to handle OSM data and to use it for an analytical approach. The EOSMDBOne offers up-to-date OSM data from Switzerland and Liechtenstein. It uses tools that are no longer maintained and has a sub optimal schema. The purpose of this project, is to create a newer version of EOSMDBOne with an additional GraphQL API and a SQL web frontend application.

First the domain of GIS, OSM and some OSM tools were researched and evaluated. Subsequently a prototype was created for the core functionality. Then the GraphQL API was created and tuned to work with the database. For the web application a design concept in the form of wireframes and a proof of concept was created. The remaining time was dedicated to increase the performance of the database itself. The developement of the SQL web frontend application was continued outside of the project scope.

The resulting solution consists of a database with up-to-date OSM data called EOSMDBTwo and a GraphQL API with a custom function, which allow users to make some case specific queries.

The EOSMDBTwo in conjunction with the SQL web frontend application is ready to replace the EOSMDBOne, although for reliability purposes, a query limit should be added. The GraphQL interface offers a template for custom functions to add in the future.

Item Type: Thesis (Other)
Subjects: Area of Application > Web based
Area of Application > GIS > OpenStreetMap
Technologies > Programming Languages > Python
Technologies > Programming Languages > Java Script
Technologies > Databases > PostgreSQL
Metatags > IFS (Institute for Software)
Divisions: Bachelor of Science FHO in Informatik > Student Research Project
Depositing User: HSR Deposit User
Thesis advisor
Keller, Stefan
Date Deposited: 19 Mar 2021 09:47
Last Modified: 19 Mar 2021 09:47

Actions (login required)

View Item
View Item