A quick tour of using SQL with the ST_Raster type

You can install the ST_Raster type in your enterprise geodatabase in Oracle, PostgreSQL, or Microsoft SQL Server. Once installed, the ST_Raster type and the functions needed to access it are stored in the schema of the geodatabase administrator (usually the sde user). The installed functions provide operations that work on and return information about rasters. The ST_Raster data type can be used within the geodatabase; plus, it provides Structured Query Language (SQL) access to raster data for third-party applications.

Two different categories of ST_Raster functions are used to access the ST_Raster type using SQL:

Related Topics

6/19/2015