Analysis Platform for OpenStreetMap

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.