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

April 29, 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

Maps and Spatial Databases: How To Use Them
What spatial and mapping features are in Oracle Database, and how do you use them? Siva Ravada of Oracle explains.

01:04 Intro to Oracle’s spatial platform
07:25 Typical applications for spatial technologies (transportation, land management, web maps for business applications…)
09:42 Spatial datatype and SQL queries native to Oracle Database
17:55 GeoJSON support, spatial operators and functions, spatial and maps in Oracle applications, tools, BI (eg Apex, SQL Developer)
21:02 Components for map visualization – web map server and APIs
23:33 Georaster data type (satellite imagery, aerial photos, sensor data)
26:00 Network data model, routing and geocoding engines
30:00 3D point clouds / Lidar, Berlin city modeling example
31:17 Spatial Studio – self-service spatial analytics tool for fast and easy maps (no coding)
35:15 Performance and scalability – addresses the toughest spatial data management challenges
37:15 APIs for spatial development – SQL, Java, REST, Python/node.js integration, web services
40:15 Spatial on Big Data platforms (Hadoop, Spark, Big Data Cloud Service)
44:15 Summary, Q & A highlights (with Dan Geringer)
Boost performance with spatial vector acceleration parameter, how to ingest different spatial data formats into the database, JSON/GeoJSON/Oracle REST Data Services
51:05 Helpful links and resources

Resources

LiveSQL spatial tutorial: bit.ly/LiveSQLSpatial
Slides from this session: oracle.com/goto/spatial
Sign up for future AskTOM Spatial and Maps in Oracle Database Office Hours sessions: bit.ly/AskTOMSpatial
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=7921

Your Experts

  • #SELECTION#
    Siva Ravada

    Siva Ravada

    Spatial and Graph Development Oracle Maps Cloud Service Spatial Studio
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Jean Ihm

    Jean Ihm   

    Jean Ihm is a product manager for Oracle's spatial and graph technologies for database, big data, and cloud platforms. She interacts with customers and partners worldwide, works on product release activities, engages with presales, and helps organize user events. She serves as Oracle liaison to the Spatial and Graph SIG user group, and is a member of the BIWA conference committee. She received a bachelor's degree from MIT, and a law degree from the University of California, Berkeley. She is based at Oracle HQ in Redwood Shores, California.
    #MISC#
    #ACTIONS#

All Sessions

Resources