To Create a Feature of Type GeoRaster
-
Create the table with one geometry column and one ID.
CREATE TABLE TORONTO (ID NUMBER PRIMARY KEY, ImageName VARCHAR2(256), Raster SDO_GEORASTER);
-
Create the raster data table.
CREATE TABLE TORONTO_RDT OF SDO_RASTER (PRIMARY KEY(RasterID, PyramidLevel, BandBlockNumber, RowBlockNumber, ColumnBlockNumber);
- Import the raster data.
-
Insert the table metadata in the Oracle Spatial metadata.
INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES ('TORONTO', 'Raster.SpatialExtent, MDSYS.SDO_DIM_ARRAY ( MDSYS.SDO_DIM_ELEMENT('X', 310630.031200000, 314302.525626524, 0.000000050), MDYS.SDO_DIM_ELEMENT('Y', 4832370.186944857, 4835182.257600000, 0.000000050) ), 2019);
-
Create the spatial index of type multipolygon to use model multi-geometry objects.
CREATE INDEX TORONTO_IDX ON TORONTO (Raster.SpatialExtent) INDEXTYPE IS MDSYS.SPATIAL_INDEX_V2;