ST_RasterUtil.initialize

Definition

The ST_RasterUtil.initialize function activates the ST_Raster data tables for the specified ST_Raster column in a user table. It also stores the ST_Raster column's optional spatial reference information in the system metadata table. A user table containing the ST_Raster column must first be initialized with this procedure before any other ST_Raster functions or procedures can be called on it.

Syntax

Oracle

sde.ST_RasterUtil.initialize (tableName VARCHAR2,  
                              columnName VARCHAR2, 
                              projectionID NUMBER,
                              keyword VARCHAR2)

sde.ST_RasterUtil.initialize (tableName VARCHAR2, 
                              columnName VARCHAR2, 
                              projectionFile VARCHAR2, 
                              keyword VARCHAR2)

sde.ST_RasterUtil.initialize (tableName VARCHAR2, 
                              columnName VARCHAR2, 
                              projectionID NUMBER)

sde.ST_RasterUtil.initialize (tableName VARCHAR2, 
                              columnName VARCHAR2, 
                              projectionFile VARCHAR2)

sde.ST_RasterUtil.initialize (tableName VARCHAR2, 
                              columnName VARCHAR2)

PostgreSQL

st_raster_util_initialize (tableName TEXT,  
                           columnName TEXT, 
                           projectionID INT,
                           keyword TEXT)

st_raster_util_initialize (tableName TEXT, 
                           columnName TEXT, 
                           projectionFile TEXT, 
                           keyword TEXT)

st_raster_util_initialize (tableName TEXT, 
                           columnName TEXT, 
                           projectionID INT)

st_raster_util_initialize (tableName TEXT, 
                           columnName TEXT, 
                           projectionFile TEXT)

st_raster_util_initialize (tableName TEXT, 
                           columnName TEXT)

SQL Server

st_raster_util_initialize (databaseName NVARCHAR,
                           ownerName NVARCHAR, 
                           tableName NVARCHAR, 
                           columnName NVARCHAR, 
                           projectionID INTEGER,
                           projectionFile NVARCHAR, 
                           keyword NVARCHAR

Returns

None

Parameters

Parameter

Description

databaseName

The name of the database (SQL Server only)

ownerName

The owner of the table (SQL Server only)

tableName

The name of the user table

columnName

The name of the ST_Raster column in the user table

projectionID

A predefined number that represents an existing projection

projectionFile

The name of the projection file that contains the full text description of the given projection

keyword

The DBTUNE configuration keyword; the corresponding storage clause used when creating ST_Raster data tables or related indexes

Example

This example initializes the ST_Raster column image in the user table, boar, and stores the spatial reference that corresponds to the projection ID 4326 (WGS84) in the system metadata.

Oracle

BEGIN sde.ST_RasterUtil.initialize ('boar','image',4326,'DEFAULTS'); 
END; 
/

PostgreSQL

SELECT sde.st_raster_util_initialize ('boar','image',4326,'DEFAULTS');

SQL Server

EXEC <function_owner>.st_raster_util_initialize 'sde94','bobby','boar','image',4326,NULL,'DEFAULTS'

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

6/19/2015