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.getInterleaveType

  • Definition
  • Syntax
  • Returns
  • Parameters
  • Example

Definition

The ST_Raster.getInterleaveType function returns the pixel interleave property of the ST_Raster. Valid values include the following:

  • sequential—Band sequential (BSQ); for multiband data, pixels are stored in separate bands.
  • contiguous—Band interleaved by pixel (BIP); for multiband data, pixels are stored in pixel interleaved format. This type of storage can only be applied to the common three-band, 8-bit data.

Syntax

Oracle

getInterleaveType()

PostgreSQL

getInterleaveType(raster IN ST_RASTER)

SQL Server

getInterleaveType()

Returns

Oracle

VARCHAR2

PostgreSQL

Text

SQL Server

NVARCHAR

Parameters

None

Example

The following query returns the interleave type for each raster in the table:

Oracle

PostgreSQL

Oracle

SELECT image.raster_id, image.getInterleaveType()
FROM FOO t;

T.IMAGE.RASTER_ID T.IMAGE.GETINTERLEAVETYPE()
--------------- -------------------------
              2 SEQUENTIAL
              3 SEQUENTIAL
             23 SEQUENTIAL
             24 SEQUENTIAL 
             42 SEQUENTIAL
             43 SEQUENTIAL

PostgreSQL

SELECT raster_id(image), getInterleaveType(image)
FROM foo;

RASTER_ID(IMAGE) GETINTERLEAVETYPE(IMAGE)
---------------- ------------------------
               2 SEQUENTIAL
               3 SEQUENTIAL
              23 SEQUENTIAL
              24 SEQUENTIAL 
              42 SEQUENTIAL
              43 SEQUENTIAL

SQL Server

SELECT image.raster_id, image.getInterleaveType()
FROM foo;

IMAGE.RASTER_ID IMAGE.GETINTERLEAVETYPE()
--------------- -------------------------
              2 SEQUENTIAL
              3 SEQUENTIAL
             23 SEQUENTIAL
             24 SEQUENTIAL 
             42 SEQUENTIAL
             43 SEQUENTIAL

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