Skip to Main Content

Spatial and Maps in Oracle Database Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

October 20

15:00 UTC   Start Times Around the World


Create Drive Time Areas and Perform Drive Time Distance Analysis
Want to find the nearest pizza place, check if all homes in the city can be reached by fire stations within 10 minutes, or understand the market areas covered by store locations? Drive time/drive distance analysis can answer these and many more business planning questions. For example, defining a trade area requires accurate estimations of travel time and distance of customers to-and-from business location(s).

In this session, you'll learn how to conduct large-scale drive distance/drive time analysis using the Network Data Model (NDM), a part of Oracle Database spatial features. We'll show how to generate network buffers from NDM data models and how to perform queries on them. We'll discuss some use cases of network buffers on trade area analysis and geofencing. We'll also talk about finding the nearest point of interest (a restaurant, a convenience store, or a gas station) in a location-based service and discuss vehicle deviation detection in fleet management to ensure a driver follows a planned route.

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.

Your Experts

Jack Wang
Jack Wang, Director of Software Development - Spatial and Graph
Jack Wang is a Director of Software Development for Spatial and Graph technologies at Oracle Corporation. He has been with Oracle Spatial and Graph team for over twenty years. He received his Master's and Ph.D. degrees from the School of Computer Science, Carnegie Mellon University.
Xiangtai Hou
Xiangtai Hou, Senior Member of Technical Staff
Oracle Spatial and Graph
Carol Palmer
Carol Palmer, Senior Principal Product Manager
Oracle Spatial and Graph Product Management, Oracle liaison to the Spatial and Graph SIG user group