• Sessions appear in the color of their primary track
  • Sessions can be filtered using Products on the right
  • Use the Search bar for more flexibility
See this link for hints on how to search the schedule or sign up for sessions
Back To Schedule
Thursday, March 22 • 3:40pm - 4:05pm
Using GeoJSON in the Oracle Database
Feedback form is now closed.
Location and other geographical information is traditionally stored in Oracle databases using specialized data types, such as the SDO_GEOMETRY type. That data type is powerful and flexible, but can be difficult to use. A modern alternative is to use a JSON-based encoding, called GeoJSON instead. GeoJSON is a lightweight format suited to data exchange and transfer, popular for reading and publishing spatial data on the Web, in Big Data, and for the Internet of Things.

This session will explain the way GeoJSON encodes a variety of geographical objects, from simple points to complex multi-polygonal structures. It will also explain how those structures can be indexesd, and how they can be used in spatial analytics, in isolation or in conjunction with classic SDO_GEOMETRY types.
Finally we will show how the GeoJSON objects can be displayed on a map.

avatar for Albert Godfrind

Albert Godfrind

Spatial and Graph Solutions Architect, Oracle
Albert Godfrind has over 25 years of experience in designing, developing, and deploying IT applications. His interest and enthusiasm for spatial information and geographical information systems started at Oracle when he started using the spatial extensions of the Oracle database in... Read More →

Thursday March 22, 2018 3:40pm - 4:05pm PDT
3-Rm 103