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
Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Header container

April 29

15:00 UTC   Start Times Around the World

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

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

Experts

Your Experts
Siva Ravada
Siva Ravada, Senior Director of Development
Spatial and Graph Development Oracle Maps Cloud Service Spatial Studio
Jean Ihm
Jean Ihm, Product Manager    
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.