ST_Raster.getInterleaveType

定义

ST_Raster.getInterleaveType 函数用于返回 ST_Raster 的像素交叉属性。有效值包括以下内容：

• sequential - 波段顺序 (BSQ)；对于多波段数据，像素存储在单独的波段中。
• contiguous - 波段按像素交叉 (BIP)；对于多波段数据，像素以像素交叉格式存储。此存储类型只能应用于常用三波段 8 位数据。

语法

Oracle

getInterleaveType()

PostgreSQL

getInterleaveType(raster IN ST_RASTER)

SQL Server

getInterleaveType()

返回值

Oracle

VARCHAR2

PostgreSQL

文本

SQL Server

NVARCHAR

参数

无

示例

以下查询返回表中各个栅格的交叉类型：

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