Skip to Main Content

APEX Office Hours

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

Header container

May 21

14: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.


Scalable, spatially-accurate Contact Tracing with APEX!
If you have the need to do contact tracing based on GPS tracks (or other coordinates) now you can!

This Oracle APEX Office Hours session shows how to use Oracle Database spatial features to build an APEX application for contact tracing. Based on a real-world customer use case, the spatial analysis discovers how to find all people that came within a specified distance of a given person during a selected time period. It also shows how long they were in close proximity. The results can be displayed using maps, reports or other APEX visualizations.

Your Experts

Joel Kallman
Joel Kallman, Vice President of Software Development    
Joel is the Vice President of Software Development at Oracle America, Inc., managing the development and product management of Application Express (APEX). He started working with Oracle Database in 1992 and joined Oracle in 1996. Joel's passion is to make customers extraordinarily successful with the Oracle Database, SQL and Oracle Application Express (APEX). He is a proud alumnus of The Ohio State University, College of Engineering, with a Bachelor's degree in Computer Engineering.
Dan Geringer
Dan Geringer, Spatial Solutions Specialist
Dan Geringer is Spatial Solutions Specialist at Oracle, working with Oracle's largest global customers and partners to solve challenging spatial requirements in a scalable manner. Dan started working with Oracle’s spatial database technologies in 1994, and joined Oracle in 1995 as a key member of Oracle’s spatial development team. Dan's innovative solutions center on the blending of Oracle's spatial data processing with Database features for scalability, performance, security, and availability. He presents regularly at Analytics and Data Summit and Oracle OpenWorld conferences. Dan is based near Reston, VA
Carsten Czarski
Carsten Czarski, Consulting Member of Technical Staff    
Carsten Czarski is a member of the Oracle APEX development team, focusing on REST-related features, data loading and the Calendar component. He's also a pro on Oracle Spatial, Oracle Text, and JSON and XML functionality in the database.