ST_RasterUtil.describe

Definition

ST_RasterUtil.describe returns the description of raster column properties. If no arguments or only the verbose parameter is provided, the ST_RasterUtil.describe stored procedure returns a list of all raster columns within the database. Otherwise, the description of the raster column is returned if a table and column is entered.

Syntax

Oracle

sde.ST_RasterUtil.describe () RETURN CLOB

sde.ST_RasterUtil.describe (param IN VARCHAR2) RETURN CLOB

sde.ST_RasterUtil.describe (tableName IN VARCHAR2,
                            columnName IN VARCHAR2) RETURN CLOB

sde.ST_RasterUtil.describe (tableName IN VARCHAR2,
                            columnName IN VARCHAR2,
                            param IN VARCHAR2) RETURN CLOB

PostgreSQL

st_raster_util_describe () RETURN TEXT

st_raster_util_describe (parameter IN TEXT) RETURN TEXT

st_raster_util_describe (tableName IN TEXT, 
                         columnName IN TEXT) RETURN TEXT

st_raster_util_describe (tableName IN TEXT, 
                         columnName IN TEXT, 
                         parameter IN TEXT) RETURN TEXT

SQL Server

st_raster_util_describe (databaseName IN NVARCHAR, 
                         tableName IN NVARCHAR, 
                         columnName IN NVARCHAR, 
                         parameter IN NVARCHAR) RETURN NVARCHAR

Returns

Oracle

CLOB

PostgreSQL

Text

SQL Server

NVARCHAR

Parameters

Parameters

Description

tableName

The name of the user table

columnName

The name of the ST_Raster column in the user table

verbose

Shows projection string

Example

The following example returns the description of raster column sat.image:

Oracle

SELECT sde.ST_RasterUtil.descibe('sat','image')
FROM dual;

Raster Column ID ............: 125
Table Name ..................: SAT
Raster Column ...............: IMAGE
Storage Type ................: ST_RASTER
Configuration Keyword .......: DEFAULTS
Coordinate System ...........: 4326
Permission ..................: Full
Created .....................: Mon Apr 14 14:49:24 2008

PostgreSQL

SELECT sde.st_raster_util_describe('sat','image');

Raster Column ID ............: 125
Table Name ..................: SAT
Raster Column ...............: IMAGE
Storage Type ................: ST_RASTER
Configuration Keyword .......: DEFAULTS
Coordinate System ...........: 4326
Permission ..................: Full
Created .....................: Mon Apr 14 14:49:24 2008

SQL Server

SELECT <function_owner>.st_raster_util_describe 
('sde94','bobby', 'sat','image',null);

Raster Column ID ............: 125
Database ....................: SDE94
Owner .......................: BOBBY
Table Name ..................: SAT
Raster Column ...............: IMAGE
Storage Type ................: ST_RASTER
Configuration Keyword .......: DEFAULTS
Coordinate System ...........: 4326
Permission ..................: Full
Created .....................: Mon Apr 14 14:49:24 2008

The function owner is either sde or dbo, depending on the schema where the geodatabase system tables, functions and procedures are stored.


11/18/2013