ST_Raster.getInterpolationType
Definition
The ST_Raster.getInterpolationType function returns the pyramid interpolation property used to build the pyramid of the ST_Raster. Valid return values are as follows:
- null—This value indicates that the pyramids have not been built.
- NEAREST—Nearest neighbor interpolation assigns the pyramid pixel a value of one of the lower pyramid pixel values.
- BILINEAR—Bilinear interpolation computes the pyramid pixel value from 4 of the lower-level pixel values.
- BICUBIC—Bicubic interpolation computes the pyramid pixel value from 8 of the lower-level pixel values.
Syntax
Oracle
getInterpolationType()
PostgreSQL
getInterpolationType(raster IN ST_RASTER)
SQL Server
getInterpolationType()
Returns
Oracle
VARCHAR2
PostgreSQL
Text
SQL Server
NVARCHAR
Parameters
raster—The ST_Raster object to be tested
Examples
The following statements return the pyramid interpolation property for each raster in the table.

The pyramid interpolation property is only defined for the first two rows; the rest of them are empty. This is because they do not have pyramids built, so the pyramid interpolation property is not defined.
Oracle
SELECT image.raster_id, image.getInterpolationType()
FROM FOO t;
T.IMAGE.RASTER_ID T.IMAGE.GETINTERPOLATIONTYPE()
--------------- ------------------------------
2 BILINEAR
3 BILINEAR
23
24
42
43
PostgreSQL
SELECT raster_id(image), getInterpolationType(image)
FROM foo t;
RASTER_ID(IMAGE) GETINTERPOLATIONTYPE(IMAGE)
---------------- ---------------------------
2 BILINEAR
3 BILINEAR
23
24
42
43
SQL Server
SELECT image.raster_id, image.getInterpolationType()
FROM foo;
IMAGE.RASTER_ID IMAGE.GETINTERPOLATIONTYPE()
--------------- ------------------------------
2 BILINEAR
3 BILINEAR
23
24
42
43
6/19/2015