A Story about Contributing SAP HANA Support to QGIS

Tl;dr QGIS 3.18 comes with support for SAP HANA. Contributing took a little while. Get a free trial instance of SAP HANA Cloud and download the QGIS nightly build.

Image for post
Image for post
Photo by Christian Perner on Unsplash

About the author: Mathias works as a development manager for SAP and is responsible for SAP HANA’s Spatial engine. This article may be biased and reflects personal views, but be assured that it’s based on a true story 😊

In the field of GIS (Geographic Information Systems) the open-source software packages are rather feature rich and mature, so that for many companies these are a valid enhancement or even alternative to…

Showing the advantages of multi-model data processing based on a real-life example

Image for post
Image for post
Photo by Eric Nopanen on Unsplash

In my recent story I used the SAP HANA Spatial Engine and the SAP HANA Automated Predictive Library to predict how long a taxi ride in the city of Porto is going to take based on historical ride data. Technically I leveraged Jupyter Notebooks as well as the free SAP HANA Express Edition to push down all operations (Geospatial + Machine Learning) to the database level instead of moving the data (and the calculations) to the client.

Today, I would like to go one step further and even predict the destination of a taxi based on the starting point, time…

About the value-add of location data for your machine learning models

Image for post
Image for post
Predicting ice cream sales without seasonal pattern? No way! (Photo by Lanju Fotografie on Unsplash)

Imagine predicting the sales of ice cream while ignoring the proper handling of the time dimension: While predicting on an aggregated level (e.g. yearly) may still yield good results, you will quickly hit the ground when going into the seasonal details.

The same is true for location data. When dealing with geo-referenced data, the disregard of the location dimension will lead to predictive models, that are not able to explain the observations that have been made, which will ultimately lead to imprecise and less robust models. Same as for the time dimension, your model may still look ok on the…

Learn how to load, prepare and analyze spatial data in SAP HANA

Image for post
Image for post
Taxi trajectories visualized by kepler.gl

In the field of Data Science, spatial data gets more and more relevant. Thus, (Geo-)Spatial Data Science or Advanced (Geo-)Spatial Analytics is expected to be one of the trending topics in 2020. Due to its seamless integration of multi-model data with embedded machine learning, SAP HANA is the platform of choice for this evolving discipline.

To enable Data Scientists in their daily work, SAP HANA has been offering Python integration for quite a while. The SAP HANA Python Client API for Machine Learning Algorithms even enables the in-database ML algorithms to be called from Python. …

Mathias Kemeter

Spatial, Data Science and other math stuff @SAP @math1ask https://about.me/mkemeter

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store