You can use the database's Structured Query Language (SQL) to work with ST_Raster data stored in a geodatabase using specific functions installed with the ST_Raster type.
SQL is a standardized language used to select and manipulate data stored in a database management system (DBMS). When you install the ST_Raster type in a geodatabase in Oracle, PostgreSQL, or Microsoft SQL Server, specific SQL functions and types are created in the geodatabase administrator's schema. You can use SQL and these functions and types to query and edit data.
The names of the functions vary depending on the DBMS implementation. In Oracle and SQL Server, the functions are member methods of the ST_Raster or ST_PixelData object. In PostgreSQL, they are SQL functions implemented at the PL/SQL package level. Be aware that you must use the case shown when using the functions with SQL Server. When used with Oracle or PostgreSQL, whether you use all lowercase, all uppercase, or mixed case does not matter.
When using ST_Raster functions in all databases, you must qualify the function with the geodatabase administrator's schema. In most cases, this is sde. However, in SQL Server databases, it may be dbo.
Equivalent functions are shown in the table at the end of this topic. Links in the table take you to specific ST_Raster SQL function reference topics, which are structured as follows:
- Definition
A description of the function
- Syntax
The proper syntax to use the function
- Return type
The type of data that is returned when the function is issued
- Parameters
A variable value or list of values that can be specified as part of the function argument
- Example
Samples that use the specific function
ST_Raster functions
| Oracle and SQL Server functions | PostgreSQL functions |
|---|---|
ST_PixelData.getValueByLoc (SQL Server only) | |
| setvalue | |
ST_Raster.getValueByLoc (SQL Server only) | |
| ST_Raster_Util.checkLibraryVersion (Oracle only) | |
ST_Raster_Util.getLibraryVersion (Oracle only) | |