SAP + Esri Hackathon: Coding with a purpose
SAP and Esri, the global leader in geographic information systems (GIS) and spatial analytics, can look back on a long-standing partnership with the aim to further help companies leverage the power of location to uncover new insights from business, social, and sensor data. Just recently, we announced that Esri now supports SAP HANA as a certified enterprise geodatabase – an achievement both companies have been striving for. Make sure you check out this blog by Daniel Schneiss to learn more about how SAP and Esri are taking geospatial analytics to the next level.
As part of this, the first SAP + Esri Spatial Hackathon took place March 3-5. Immediately preceding the Esri Developer Summit, GIS Developers, Enterprise Architects, BI Developers, and students got together, accompanied by 10 technical experts from both SAP and Esri, for 40+ hours to solve three challenges:
- Spatial & Graph: Process and visualize topologies and networks. Combine the capabilities of SAP HANA and Esri for innovative approaches to network analytics.
- Sustain, create, optimize: Improve and optimize daily business using spatial analytics while also meeting sustainable development goals.
- Geo machine learning: Illustrate how AI and machine learning can benefit from the spatial dimension. How can we use machine learning in spatial analytics to solve major challenges?
Solving the toughest challenges
The SAP Co-Innovation Lab provided a robust infrastructure for the teams to use, and the results were simply amazing. One team was inspired by the response to the hurricanes in Puerto Rico. Although many aide items of food, water, and supplies were sent to Puerto Rico, it was very difficult to get these supplies to the people that needed them most. The team used SAP HANA’s spatial, graph and text capabilities with ArcGIS Pro and ArcGIS Enterprise to more effectively distribute goods given current travel conditions. Another team used ArcGIS and SAP HANA to suggest new traffic routes when inclement weather hit.
At the end, the race was so close that we had two teams exactly tied for finalists.
Finalist team Spatial Forces was comprised of students from University of California, Santa Barbara. Given their location in California, they were concerned with earthquakes. The team developed risk models for buildings in the Bay Area, and parameterized the result based on social norms (accounting for residences when people are at work, for example). Spatial Forces used Esri to classify building type and land use, access and visualize reclassified coverage, and enhanced this with living atlas. SAP HANA was used to store 3 million buildings for the city of San Francisco, and 216 simulated earthquakes. Finally, the intensity data was visualized using SAP Analytics Cloud.
Finalist team We’re Working on It was a corporate team from Southern California Edison (SCE), the primary electricity supply company for much of Southern California. This team developed a solution to predict grid usage for solar, using SAP HANA, ArcGIS Pro, and R to show which parts of the grid may need modernization to maintain reliability and support clean energy. The picture below shows the SAP HANA enterprise geodatabase data in ArcGIS Pro.
In addition to the two finalists, the Grand Prize winner team Brontosaurus (aka Safety of Water) brought a microscope and trained a machine learning model to recognize quality water. They were inspired by the water quality crisis in Flint, Michigan, and wanted to provide more real-time, automated water quality maps. Team Brontosaurus used tea water and clean water to train a machine learning model that could identify clean water. These results were stored in the SAP HANA enterprise geodatabase for Esri ArcGIS. Analytics were then published to SAP Analytics Cloud and ArcGIS Online.
For example, you can see analytics of safe water (identified by the machine learning model), and then show where this water is on a map.
SAP + Esri = Amazing
During the whole hackathon, participants were consistently surprised with SAP HANA as an Esri geodatabase. Most participants had little to none experience with SAP HANA prior to the event. Their initial perception of “complicated” and “heavy as a rock” was soon replaced by “this is amazing!” and “why didn’t anyone tell me how fast it is!”
For details on the SAP and Esri integration, check Tom Turchioe’s blog. Stay tuned to the #SAPEsri tag to hear about upcoming webinars and podcasts. Make sure you also visit the Esri booth at SAPPHIRE in June, and the SAP booth at the Esri User Conference in July.
Interested to get started now? Check out the ArcGIS Pro version for SAP HANA, Express Edition (HXE)— free trial edition and find out more, including new tutorials and content.
The COIL SV team is super proud to be part of such an amazing and worthwhile event. Our thanks to Tom Turchioe and David Korn from SAP NS2 who brought so many cool Hana geospatial projects into the lab in the past providing a foundation for us to enable new programs like this one.
All of this co-earning, rich tacit knowledge exchange and a hands in environment clearly compels some seriously cool results.
The event wrap up video is posted here: https://youtu.be/pd1WvDsJwSo