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, 2020

15:00 UTC   Start Times Around the World

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.

Description

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.

Your Experts

  • #SELECTION#
    Jack Wang

    Jack Wang

    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.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Xiangtai Hou

    Xiangtai Hou

    Oracle Spatial and Graph
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Carol Palmer

    Carol Palmer

    Oracle Spatial and Graph Product Management, Oracle liaison to the Spatial and Graph SIG user group
    #MISC#
    #ACTIONS#