About the Geometry Data Type

Oracle Analytics automatically recognizes geometry columns from Oracle databases and CSV files, so you can easily import and connect to spatial data.

A geometry data type in Oracle Analytics can represent a wide range of spatial shapes, including points, polygons, and lines, enabling detailed and dynamic geographic visualizations. You can use Geometry data types for visualizing data on maps or as inputs for advanced spatial calculations, enabling detailed spatial analysis.

Geometry columns are special first-class objects in Oracle Analytics that you can use for the following operations:

• To create map visualizations
• In custom calculations for spatial measurements and correlations (either on a canvas or in a data flow)
• As part of custom SQL sourcing (meaning that you can create a dataset using Spatial SQL defined through the Manual SQL query mode)

When you use a geometry column many other operations are disabled or extremely limited. You can't use geometry columns as filters in a workbook or as components (visualization definition grammar) in any visualizations other than maps. You can’t set the geometry data type manually on a data column, it must be recognized as a geometry data type when importing as a dataset.