(last updated: 2022-08-05)
Almost exactly 3 years back my colleague sharon had the fantastic idea to publish a blog post gathering all relevant online resources around Spatial Solutions from SAP. In the meantime the globe kept spinning and new functionalities and resources became available. Thus, this blog post is meant to continue the tradition and provide some useful resources specifically for SAP HANA Spatial (i.e. HANA's processing engine for spatial vector data). I will keep this post up-to-date based on the latest material. Additionally, you may check the corresponding community tags for SAP HANA Spatial.
In case you need a system for evaluating the spatial capabilities of SAP HANA, the quickest way to get started is a
free trial instance of SAP HANA Cloud. The spatial engine comes out of the box and is ready for usage without further configuration.
Overview & Business Value
High-level overview on spatial solutions from SAP
matthew.zenus, Global Vice President of Database Product and Solution Management, elaborates on the business value of geospatial data and the partnership with Esri in that sector.
Some of the key business questions that may be answered using Spatial Analysis as well as a couple starting points for your reading list.
This lecture from SAP TechEd 2020 gives an overview on SAP HANA Spatial and Spatial Services. It also comprises a demo of the integration with GeoServer.
Spatial Processing Basics
The documentation is your one-stop-shop for all technical details around SAP HANA Spatial. You can find a full list of all supported functions as well as information on the concepts, that are used.
The video series contains almost 3 hours of content and demos around Advanced Analytics, Spatial and Graph processing. Videos 2 - 7 are specifically referring to SAP HANA Spatial.
vitaliy.rudnytskiy is describing crisp and clear how to get your shapefiles into SAP HANA Cloud by using Database Explorer.
A blog covering usage of OSMnx with SAP HANA and doing some basic analysis on top.
Demo video showcasing the usage of In-database Voronoi computation for planning hospital locations.
An The use case of ST_PointOnSurface().
Developer Advocate vitaliy.rudnytskiy is publishing blogs around HANA Spatial using the tag #GeospatialTuesday. The blogs show dedicated spatial functions in action.
There are two tutorials covering the usage of Spatial Data Types (1) and Spatial Methods (2). Both can be followed with the free editions of SAP HANA.
Join this free openSAP course to learn how you can analyze spatial data for your business with SAP HANA.
Technical education videos that introduce a variety of spatial functions in detail.
This blog provides generic SQLScripts for doing k-Nearest Neighbour and Reverse k-Nearest Neighbour Searches.
Given a table with latitude and longitude values. Learn how to determine the respective country for each entry.
Spatial Data Science
The presentation, that was part of the Spatial Data Science Conference 2020, highlights the value of in-database Spatial Machine Learning.
Is the quantitative impact of geospatial features on machine learning models measurable? If yes, what is the measured impact? The article summarises some of the below linked blogs.
A generic approach to Spatial Machine Learning presented at Geomob Online.
Learn how to work with HANA Spatial, Jupyter Notebooks and Kepler.gl to predict the duration of taxi rides in the city of Porto.
A follow-up on 'Spatial Data Science powered by SAP HANA'. On top of predicting the duration of taxi rides, you can learn how to predict the target destination of a taxi ride.
The example of predicting housing prices in the city of Melbourne is used to quantify the value of geospatial features for the prediction.
Esri Integration
Documentation of database requirements and supported HANA/ArcGIS configurations
Esri+SAP alliance overview on the Esri Partner Network
A powerful ArcGIS Storymap showcasing the potential of integrating Esri ArcGIS with SAP HANA.
joshledbetter on breaking down silos with SAP HANA and Esri ArcGIS.
Well, the title says it all: Learn about the four main reasons for running ArcGIS on HANA. A blog by tom.turchioe
A technical walk-through on how to upload, visualize and process spatial data with ArcGIS Pro on HANA
In this blog post, alexis.fouquier describes the steps he followed to create a real-time reporting solution combining Geo spatial and Financial data. The data is federated from SAP S/4HANA® Flexible Real Estate Management (RE-FX), SAP Geographical Enablement Framework (SAP Geo Framework) and consumed using Esri ArcGIS (Pro or Insights).
tom.turchioe describes how an SAP customer used ABAP CDS views for consumption in ArcGIS.
shabana31 shows the steps to integrate SAP’s ERP like business data with GIS data using a simple scenario.
Open Source Integration
The Open Source GIS Client QGIS comes with a native database provider for SAP HANA since version 3.18.
No matter if you’re new to QGIS or if you’re new to SAP HANA – or even both. This blog has the goal to provide you with a working and free-of-cost playground in less than 30 minutes.
A step-by-step description on how to setup SAP HANA (express edition) with GeoServer and QGIS.
Connect the Open Source Database Management Studio DBeaver with SAP HANA for getting spatial visualizations of SQL result sets.
The official documentation of the GeoServer community module for SAP HANA.
remi.astier sample provides a GeoServer instance with the plugin for SAP HANA Connectivity. Geoserver exposes in a variety of formats spatial data hosted in SAP HANA.
vitaliy.rudnytskiy explains how to build GDAL with SAP HANA driver on MacOS.
vitaliy.rudnytskiy explains how to install GDAL with SAP HANA driver on Windows.
vitaliy.rudnytskiy show a usage example of GDAL with the SAP HANA driver.
Multi-model Processing
Get to know spatial and graph processing in SAP HANA Cloud, HANA database with nine hands-on exercises. Use your own (trial) database and our sample data to experience the advantages of intelligent multi-model data processing.
This blog show how to combine spatial processing with the anonymization concepts of SAP HANA Cloud. The approach is explained hands-on along an example.
In this blog post markus.fath describes how to calculate drive time distances and isochrones on street network data. Isochrones are areas reachable within a certain time threshold.
This blog provides generic SQLScripts for constructing a graph out of a given Voronoi tessellation.
The SAP HANA Python Client API for Machine Learning supports handling graph and spatial data while integrating with GeoPandas and NetworkX. This blog by markus.fath contains resources and a Jupyter Notebook that introduces the functionality.
Another great blog by markus.fath, where he will show how to use some basic SAP HANA Graph function to understand dependencies in a directed graph.
A blog series by vitaliy.rudnytskiy , which is going through the details of course DAT108 at SAP TechEd 2020. The example comprises Spatial and Graph analytics in SAP HANA orchestrated from within Python using the hana_ml client.
Using SAP HANA Spatial in ABAP on a runtime license? se38 explains how to technically consume spatial data without having direct access to the database. This blog is part of a series, that also covers other multi-model aspects such as the JSON Document Store and HANA's Graph engine.
The use case described by rafael.pacheco illustrates the power of combining HANA's Graph and Spatial engines for finding evacuation paths.
markus.fath walks through an end-to-end example based on Wellington’s stormwater network. He evaluates and visualizes the graph and shows how he can analyze problems that might occur in the network based on built in graph algorithms.
This session introduces attendees to the multi-model capabilities in SAP HANA Cloud. It will mainly work with data from the Automatic Identification System (AIS), which is basically observations in space and time.
Real-life Examples
Open Grid Europe (OGE) operates Germany’s largest natural gas pipeline network, totaling 12,000 kilometers. To future-proof their operations, OGE completely revamped their geospatial data capabilities to gain deep insights into the performance of their pipelines.
Part of what makes the City of San Diego such a great place to live is having a city government that understands how to use cutting-edge IT to make life better for residents.
Other
remi.astier came across a customer in the forest industry that needed to develop multiple S/4 extensions and therefore would use CAP. Read on to learn about the prototype.
In this blog post ian.henry shares how to create an SAP Analytics Cloud (SAC), Geo Map based on Calculation Views created within the WebIDE. These are Calc Views that reside within an HDI Container as Column Views.
In this blog post ian.henry describes how you can use the SAP Analytics Cloud choropleth layers to visualise HANA spatial clusters, such as grid, k-means or hexagons.
remi.astier explains how to color polygons in SAP Analytics Cloud. This is mostly interesting for line geometries in the transportation industry (roads, train lines), utilities and oil & gas.
Even though there is no official support from SAP for geospatial visualization in DWC yet, in this article boman.hwang shares a possible workaround on how to do it anyway and create geospatial data in DWC and use it in SAC.
In this write-up, jon.gooding is covering a scenario close to home for him, with also including some of the new SAP Business Technology Platform Features. If it was a point to point run, it would be going from the town of CSV, stopping in HANA Cloud for some persistence, then getting dressed in the Business Application Studio and doing the final showcase in the SAP Analytics Cloud.
Download a geo poster based on OSM data and assembled with ArcGIS Pro.
Learn how to use the Low-code/no-code platform SAP AppGyver to develop a simple mobile application making use of SAP HANA's spatial engine.