Prepare Geometry Columns for Visualizing Maps

You can prepare and connect to geometry data types in Oracle Analytics from either an Oracle database, using the Spatial Data Object Geometry data type (SDO.Geometry), or a CSV file.

The CSV source data must include geometry data in the Well-Known Text (WKT) format to be recognized by Oracle Analytics. For data sourcing from an Oracle database, you use a direct connection or through a semantic model. The value stored in geometry columns appears as [GEOMETRY] Geometry column and can only be used in map visualizations or custom calculations.
  1. On your home page, click Create and then click Dataset.
  2. In the Create Dataset dialog, select an already configured connection to an Oracle database which has the SDO.Geometry column, or select a CSV file with a WKT column.

    Description of maps_geodatatype_geom_col.png follows
    Description of the illustration maps_geodatatype_geom_col.png


    Description of maps_geodatatype_wkt_col.png follows
    Description of the illustration maps_geodatatype_wkt_col.png

    Joins between geometry columns from two different datasets aren’t supported. For use cases where you need to relate between the geometry columns, you must create and establish a distinct join using existing columns.