ArcGIS Desktop

  • Documentation
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

ST_Raster.getInterpolationType

  • Definition
  • Syntax
  • Returns
  • Parameters
  • Examples

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.

Note:

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

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal