SDO_GEORASTER

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

CREATE TABLE georaster_table(
    georaster_column SDO_GEORASTER
);

Snowflake

Query

CREATE OR REPLACE TABLE PUBLIC.georaster_table(
-- ** MSC-ERROR - MSCEWI1028 - TYPE NOT SUPPORTED **
--geometry_column SDO_GEORASTER
                            );

Inserting data in SDO_GEORASTER Table

Oracle

Query

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

Snowflake

Query

INSERT INTO PUBLIC.georaster_table VALUES (null);

INSERT INTO PUBLIC.georaster_table VALUES (/*** MSC-WARNING - MSCEWI1049 - sdo_geor.init FUNCTION WAS NOT RECOGNIZED BY SNOWCONVERT ***/
PUBLIC.sdo_geor.init_UDF('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. MSCEWI1028: Type is not supported.

2. MSCEWI1049: Not recognized function