What is the ST_Raster storage type?
ST_Raster is a user-defined data type. It is stored in a single row, in a single column of object type ST_Raster in a user-defined table. ST_Raster provides full geodatabase support as well as SQL access to raster data. This enables you to write SQL applications using your database management system (DBMS) that can access and use raster operations and queries.
ST_Raster is supported in Oracle, Microsoft SQL Server, and PostgreSQL databases. It is not supported in SQL Server Express.
To use the ST_Raster type, you must configure it in the DBMS. See Installing the ST_Raster type in Oracle, Installing the ST_Raster type in PostgreSQL, or Installing the ST_Raster type in SQL Server for instructions.
The ST_Raster object type is defined as follows:
CREATE TYPE ST_Raster AS OBJECT ( raster_id INTEGER, type INTEGER, extent SE_EXTENT, properties SE_RASTERPROPERTY_LIST, rasterband_list ST_RASTERBAND_LIST data ST_PIXELDATA);
Attribute |
Descriptions |
---|---|
raster_id |
Uniquely identifies each raster within a table column defined as ST_Raster |
type |
Currently reserved for internal use only |
extent |
An optional attribute that stores the search extent |
properties |
Used to store various attributes associated with the raster but not individual raster bands |
rasterband_list |
A collection of raster bands that store band specific attributes |
data |
Reserved field |
The ST_Raster object is made up of several subobjects.
ST_RASTERBAND and ST_RASTERBAND_LIST
The ST_RASTERBAND_LIST type is defined as follows:
CREATE TYPE st_rasterband_list AS VARRAY(4096) OF ST_RASTERBAND;
The ST_RASTERBAND type is defined as follows:
CREATE TYPE st_rasterband AS OBJECT ( rasterband_id INTEGER, sequence INTEGER, types INTEGER, width INTEGER, height INTEGER, extent SE_EXTENT, block_origin SE_COORD, block_width INTEGER, block_height INTEGER, flags INTEGER);
Attribute |
Description |
---|---|
rasterband_id |
Uniquely identifies each raster band within the ST_Raster type column |
sequence |
Maintains sequence of each band within the raster band collection; for a given raster band collection, the sequence value for each band within the collection must be unique. |
types |
A bitmask used to store various raster band metadata; individual attributes contained in the bitmask can be assessed and assigned through SQL functions. The value of this attribute should not be modified directly. |
width |
Defines the pixel width of the raster band |
height |
Defines the pixel height of the raster band |
extent |
The geographic extent of the raster band |
block_origin |
Maintains the geographic coordinate of the block origin |
block_width |
Defines the pixel width of the raster band tile |
block_height |
Defines the pixel height of the raster band tile |
flags |
Holds a bitmask of raster band metadata; individual attributes contained in the bitmask can be accessed and assigned by SQL functions. This value of this attribute should not be modified directly. |
SE_RASTERPROPERTY and SE_RASTERPROPERTY_LIST
The SE_RASTERPROPERTY_LIST type is defined as:
CREATE TYPE se_rasterproperty_list AS VARRAY(1048576) OF SE_RASTERPROPERTY;
The SE_RASTERPROPERTY type is defined as follows:
CREATE TYPE se_rasterproperty AS OBJECT ( name VARCHAR2(65), intvalue INTEGER, strvalue VARCHAR2(160));
Attribute |
Description |
---|---|
name |
The name of the raster property |
intvalue |
Stores the integer value of the raster property |
strvalue |
Stores the string value of the raster property |
SE_EXTENT
The SE_EXTENT type is defined as follows:
CREATE TYPE se_extent AS OBJECT ( minx FLOAT(64), miny FLOAT(64), maxx FLOAT(64), maxy FLOAT(64));
Attribute |
Description |
---|---|
minx |
The minimum X-coordinate value |
miny |
The minimum Y-coordinate value |
maxx |
The maximum X-coordinate value |
maxy |
The maximum Y-coordinate value |
SE_COORD
The SE_COORD type is defined as follows:
CREATE TYPE se_coord AS OBJECT ( x FLOAT(64), y FLOAT(64));
Attribute |
Description |
---|---|
x |
The X-coordinate value |
y |
The Y-coordinate value |
ST_PIXELDATA
The ST_PIXELDATA type is defined as:
CREATE TYPE st_pixeldata AS OBJECT ( width INTEGER, height INTEGER, numbands INTEGER, extent SE_EXTENT, types INTEGER, data BLOB, mask BLOB);
Attribute |
Description |
---|---|
width |
The pixel width of the object |
height |
The pixel height of the object |
numbands |
Defines the number of bands of the object |
extent |
The geographic extent of object |
types |
A bitmask used to store various raster metadata; individual attributes contained in the bitmask can be assessed and assigned through SQL functions. The value of this attribute should not be modified directly. |
data |
The array of pixel values of the object |
mask |
The NoData bitmask array of the object |