Skip to Main Content

Spatial for DBAs, Analysts and Developers Office Hours

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

Header container

March 28, 2023

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

Built-in address geocoding with Oracle technologies
Geocoding is the process of deriving a geographic location from addresses and place names. Addresses and/or place names are commonly the only reference to a location in source datasets. Therefore, geocoding is essential to leverage the power of location-based analysis (i.e., proximity, containment, etc.).
The Oracle Spatial Database platform includes geocoding support. However, reference data acquisition and loading are required.
Fortunately, several Oracle technologies also provide turn-key geocoding leveraging an Oracle-hosted geocoding web service. These include Oracle Spatial Studio, Oracle APEX, and the new SQL API for Oracle Autonomous Database.
David Lapp outlined and demonstrated the different geocoding features in this session so that after watching the recording, you can leverage them in your organization. Here's a quick guide to the highlights:
08:58 - Introduction to geocoding
22:10 - In-database geocoding
24:20 - SQL API for Autonomous Database
26:36 - Demo
37:40 - Geocoding with Spatial Studio
39:36 - Demo
47:08 - Geocoding in Apex
49:44 - Demo
55:41 - Outlook and Summary
Catch up on the recording for our last session!
Don't miss our next live session!
This session: https://asktom.oracle.com/pls/apex/asktom.search?oh=20482

Session Resources

Your Experts

  • #SELECTION#
    Hans Viehmann

    Hans Viehmann   

    Hans Viehmann works for Oracle as Product Manager for spatial and graph technologies on both the Database and Big Data platforms. He holds a degree in Physics from Hamburg University and started his career in Research before joining Oracle over twenty-five years ago. After various positions in Presales and Business Development, he joined the Product Management Team in 2011. He is responsible for the outbound product managers on the Oracle spatial and graph team. With his team, he looks after strategic projects and partnerships, marketing activities, as well as internal awareness around Oracle's spatial and graph technologies worldwide. He works closely with various Oracle User Groups and helped establish Spatial and Graph Special Interest Groups in several countries. He is a regular speaker at conferences and user group events and serves on the advisory board of InGeoForum, Germany.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    David Lapp

    David Lapp

    David Lapp is a Senior Principal Product Manager at Oracle Corporation. His responsibilities include strategy and planning for Oracle's Spatial and Graph technologies and cloud services, and their use across the Oracle Cloud including database, big data and analytics.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Jayant.Sharma

    Jayant.Sharma

    Dr. Jayant Sharma is Director, Spatial Product Management at Oracle . He has over twenty years experience in databases and spatial information systems. He is currently focused on the product strategy, and design, of spatial components for Oracle's database and middleware products, and on applications using these components.
    #MISC#
    #ACTIONS#

All Sessions

Resources