Oracle Cloud Infrastructure Documentation

Use Oracle Spatial with Autonomous AI Database

Oracle Spatial Database is included in Autonomous AI Database, allowing developers and analysts to get started easily with location intelligence analytics and mapping services.

Parent topic: Analyze

About Oracle Spatial with Autonomous AI Database

Oracle Spatial allows developers and analysts to use spatial analysis in every application from basic spatial search and analysis to advanced geospatial applications and Geographic Information Systems (GIS).

Organizations can manage different types of geospatial data, perform hundreds of spatial analytic operations, and use interactive map visualization tools with the spatial features in Oracle Autonomous AI Database and Oracle Database.

The spatial features provide a schema and functions that facilitate the storage, retrieval, update, and query of collections of spatial features in Autonomous AI Database. Spatial consists of the following:

  • A schema (MDSYS) that prescribes the storage, syntax, and semantics of supported geometric data types

  • A spatial indexing mechanism

  • Operators, functions, and procedures for performing area-of-interest queries, spatial join queries, and other spatial analysis operations

  • Utility functions and procedures for validating, loading, extracting, and working with spatial data

  • GeoRaster, a feature that lets you store, index, query, analyze, and deliver GeoRaster data, that is, raster image and gridded data and its associated metadata

  • Features for geocoding address data and for reverse geocoding longitude/latitude data to a street address:

    Note

    SDO_GCDR.ELOC_GEOCODE and SDO_GCDR.ELOC_GEOCODE_AS_GEOM functions are only available on Autonomous AI Database.
  • Spatial routing capabilities supported by the following subprograms:

See the following for more information:

Oracle Spatial Studio

Oracle Spatial Studio is a no‑code platform that enables you to visualize and analyze geospatial data stored in Oracle AI Databases, providing interactive mapping and spatial analysis without requiring programming skills.

Database roles must be set to use Spatial Studio on an Autonomous AI Database instance. Refer to Set Up Spatial Studio Users and Privileges for more information.

To connect Oracle Spatial Studio to your Autonomous AI Database perform these high-level steps:
  1. Sign in to Oracle Cloud and select an Autonomous AI Database Serverless instance.
  2. Select the Tool configuration tab on the Autonomous AI Database details page and copy the Public access URL for Spatial Studio.
  3. Paste the URL in your browser to launch the application, and the login screen opens.
  4. Enter your credentials and then click Sign In.

    You are now connected to Oracle Autonomous AI Database using Spatial Studio.

  5. To learn more about using Oracle Spatial Studio, refer to Using Oracle Spatial Studio on Autonomous AI DatabaseUsing Oracle Spatial Studio on Autonomous AI Database.

Oracle Spatial Limitations with Autonomous AI Database

Autonomous AI Database includes Oracle Spatial, with some limitations.

You can use the Oracle spatial features with Autonomous AI Database, with the following limitations: