SDO_GEORASTER

Some parts in the output code are omitted for clarity reasons.

Description

In the GeoRaster object-relational model, a raster grid or image object is stored in a single row, in a single column of object type SDO_GEORASTER in a user-defined table. (Oracle SQL Language Reference SDO_GEORASTER Data Type).

Definition of SDO_GEORASTER object:

CREATE TYPE SDO_GEORASTER AS OBJECT
  (rasterType         NUMBER,
   spatialExtent      SDO_GEOMETRY,
   rasterDataTable    VARCHAR2(32),
   rasterID           NUMBER,
   metadata           XMLType);
/

SDO_GEORASTER is disabled by default, to enable its usage, follow the steps described in this section of Oracle documentation.

The SDO_GEORASTER object is not supported in Snowflake.

Sample Source Patterns

SDO_GEORASTER in Create Table

Oracle

Query

IN -> Oracle_01.sql

CREATE TABLE georaster_table(
    georaster_column SDO_GEORASTER
);

Snowflake

Query

OUT -> Oracle_01.sql

CREATE OR REPLACE TABLE georaster_table (
    !!!RESOLVE EWI!!! /*** SSC-EWI-0028 - TYPE NOT SUPPORTED BY SNOWFLAKE ***/!!!
        georaster_column SDO_GEORASTER
    )
    COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"oracle"}}'
    ;

Inserting data in SDO_GEORASTER Table

Oracle

Query

IN -> Oracle_02.sql

INSERT INTO georaster_table VALUES (null);
INSERT INTO georaster_table VALUES (sdo_geor.init('RDT_11', 1));

Snowflake

Query

OUT -> Oracle_02.sql

INSERT INTO georaster_table
VALUES (null);

INSERT INTO georaster_table
VALUES (
        !!!RESOLVE EWI!!! /*** SSC-EWI-OR0076 - TRANSLATION FOR BUILT-IN PACKAGE 'sdo_geor.init' IS NOT CURRENTLY SUPPORTED. ***/!!!sdo_geor.init('RDT_11', 1));

Known Issues

1. SDO_GEORASTER Data Type not transformed

SDO_GEORASTER Data Type is not being transformed by SnowConvert.

Related EWIs

1. SSC-EWI-0028: Type not supported.

2. SSC-EWI-OR0076: Built In Package Not Supported.