栅格存取函数

ST_GeoReference

ST_GeoReference — 将几何列添加到现有属性表。 默认情况下使用类型修饰符来定义而不是约束。

可以传递一个false逻辑值给use_typmod参数来获取基于老的约束条件方式。

语法

st_georeference ::=

st_georeference ::=
    ST_GEOREFERENCE ( rast, format  )

参数

rast

raster 类型

format

text 类型，默认值GDAL

返回值

返回地理配准元数据，包括GDAL或ESRI格式的回车，通常在 世界文件 。如果未指定类型，则默认为GDAL。类型为字符串‘GDAL’或‘ESRI’。

示例

SELECT rid, ST_SkewX(rast) As skewx, ST_SkewY(rast) As skewy, ST_GeoReference(rast) as georef FROM dummy_rast;
RID(int)      |SKEWX(double precision)      |SKEWY(double precision)      |GEOREF(text)      |
------------------------------------------------------------------------------------------
1             |0                            |0                            |2
0
0
3
0.5
0.5
  |
------------------------------------------------------------------------------------------
2             |0                            |0                            |0.05
0
0
-0.05
342|
              |                             |                             |7927.75
5793244
  |
总数目：2

ST_Height

ST_Height — 返回以像素为单位的栅格高度。

语法

st_height ::=

st_height ::=
    ST_HEIGHT ( rast )

参数

rast

raster 类型

返回值

返回栅格的高度。

示例

SELECT rid, ST_Height(rast) As rastheight FROM dummy_rast;
RID(int)      |RASTHEIGHT(int)      |
-----------------------------------
1             |20                   |
-----------------------------------
2             |5                    |
总数目：2

ST_IsEmpty

ST_IsEmpty — 如果栅格为空(宽度=0，高度=0)，则返回TRUE。否则，返回FALSE。

语法

st_isempty ::=

st_isempty ::=
    ST_ISEMPTY ( rast )

参数

rast

raster 类型

返回值

如果栅格为空(宽度=0，高度=0)，则返回TRUE。否则，返回FALSE。

示例

SELECT ST_IsEmpty(ST_MakeEmptyRaster(100, 100, 0, 0, 0, 0, 0, 0));
ST_ISEMPTY(boolean)      |
-------------------------
false                    |
总数目：1

SELECT ST_IsEmpty(ST_MakeEmptyRaster(0, 0, 0, 0, 0, 0, 0, 0));
ST_ISEMPTY(boolean)      |
-------------------------
true                     |
总数目：1

ST_MemSize

ST_MemSize — 返回栅格占用的空间量(以字节为单位)。

语法

st_memsize ::=

st_memsize ::=
    ST_MEMSIZE ( rast )

参数

rast

raster 类型

返回值

返回栅格占用的空间量(以字节为单位)。

示例

SELECT 'ms1', ST_MemSize(ST_MakeEmptyRaster(10, 10, 0, 0, 1, -1, 0, 0, 0));
?COLUMN?(varchar)      |ST_MEMSIZE(int)      |
--------------------------------------------
ms1                    |64                   |
总数目：1

ST_MetaData

ST_MetaData — 返回有关栅格对象的基本元数据，如像素大小、旋转(倾斜)、左上角、左下角等。

语法

st_metadata ::=

st_metadata ::=
    ST_METADATA ( rast )

参数

rast

raster 类型

返回值

返回有关栅格对象的基本元数据，如像素大小、旋转(倾斜)、左上角、左下角等。返回的列：upperleftx|upperlefty|idth|Height|scalex|scaley|skewx|skewy|sRID|Numband

示例

SELECT rid, (foo.md) FROM (SELECT rid, ST_MetaData(rast) As md FROM dummy_rast) As foo;
RID(int)      |MD(METADATA)      |
--------------------------------
1             |(0.5,0.5,10,20,2,3|
              |,0,0,0,0)         |
--------------------------------
2             |(3427927.75,579324|
              |4,5,5,0.05,-0.05,|
              |0,0,0,3)          |
总数目：2

ST_NumBands

ST_NumBands — 返回栅格对象中的波段数。

语法

st_numbands ::=

st_numbands ::=
    ST_NUMBANDS ( rast )

参数

rast

raster 类型

返回值

返回栅格对象中的波段数。

示例

SELECT rid, ST_NumBands(rast) As numbands FROM dummy_rast;
RID(int)      |NUMBANDS(int)      |
---------------------------------
1             |0                  |
---------------------------------
2             |3                  |
总数目：2

ST_PixelHeight

ST_PixelHeight — 返回以空间参考系的几何单位表示的像素高度。

语法

st_pixelheight ::=

st_pixelheight ::=
    ST_PIXELHEIGHT ( rast )

参数

rast

raster 类型

返回值

返回以空间参考系的几何单位表示的像素高度。在没有倾斜的常见情况下，像素高度只是几何坐标和栅格像素之间的比例。

示例

SELECT ST_Height(rast) As rastheight, ST_PixelHeight(rast) As pixheight,
ST_ScaleX(rast) As scalex, ST_ScaleY(rast) As scaley, ST_SkewX(rast) As skewx,
ST_SkewY(rast) As skewy
FROM dummy_rast;
RASTHEIGHT(int)      |PIXHEIGHT(double precision)      |SCALEX(double precision)      |SCALEY(double precision)      |SKEWX(double precision)      |SKEWY(double precision)      |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
20                   |3                                |2                             |3                             |0                            |0                            |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5                    |0.05                             |0.05                          |-0.05                         |0                            |0                            |
总数目：2

ST_PixelWidth

ST_PixelWidth — 返回以空间参考系的几何单位表示的像素宽度。

语法

st_pixelwidth ::=

st_pixelwidth ::=
    ST_PIXELWIDTH ( rast )

参数

rast

raster 类型

返回值

返回以空间参考系的几何单位表示的像素宽度。在没有倾斜的常见情况下，像素宽度只是几何坐标和栅格像素之间的比例。

示例

SELECT ST_Width(rast) As rastwidth, ST_PixelWidth(rast) As pixwidth,
ST_ScaleX(rast) As scalex, ST_ScaleY(rast) As scaley, ST_SkewX(rast) As skewx,
ST_SkewY(rast) As skewy
FROM dummy_rast;
RASTWIDTH(int)      |PIXWIDTH(double precision)      |SCALEX(double precision)      |SCALEY(double precision)      |SKEWX(double precision)      |SKEWY(double precision)      |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
10                  |2                               |2                             |3                             |0                            |0                            |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5                   |0.05                            |0.05                          |-0.05                         |0                            |0                            |
总数目：2

ST_ScaleX

ST_ScaleX — 以坐标参考系为单位返回像素宽度的X分量。

语法

st_scalex ::=

st_scalex ::=
    ST_SCALEX ( rast )

参数

rast

raster 类型

返回值

以坐标参考系为单位返回像素宽度的X分量。

示例

SELECT ST_Width(rast) As rastwidth, ST_PixelWidth(rast) As pixwidth,
ST_ScaleX(rast) As scalex, ST_ScaleY(rast) As scaley, ST_SkewX(rast) As skewx,
ST_SkewY(rast) As skewy
FROM dummy_rast;
RASTWIDTH(int)      |PIXWIDTH(double precision)      |SCALEX(double precision)      |SCALEY(double precision)      |SKEWX(double precision)      |SKEWY(double precision)      |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
10                  |2                               |2                             |3                             |0                            |0                            |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5                   |0.05                            |0.05                          |-0.05                         |0                            |0                            |
总数目：2

ST_ScaleY

ST_ScaleY — 以坐标参考系为单位返回像素高度的Y分量。

语法

st_scaley ::=

st_scaley ::=
    ST_SCALEY ( rast )

参数

rast

raster 类型

返回值

以坐标参考系为单位返回像素高度的Y分量。

示例

SELECT ST_Width(rast) As rastwidth, ST_PixelWidth(rast) As pixwidth,
ST_ScaleX(rast) As scalex, ST_ScaleY(rast) As scaley, ST_SkewX(rast) As skewx,
ST_SkewY(rast) As skewy
FROM dummy_rast;
RASTWIDTH(int)      |PIXWIDTH(double precision)      |SCALEX(double precision)      |SCALEY(double precision)      |SKEWX(double precision)      |SKEWY(double precision)      |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
10                  |2                               |2                             |3                             |0                            |0                            |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5                   |0.05                            |0.05                          |-0.05                         |0                            |0                            |
总数目：2

ST_RasterToWorldCoord

ST_RasterToWorldCoord — 在给定列和行的情况下，以几何X和Y(经度和纬度)形式返回栅格的左上角。列和行从1开始。

语法

st_rastertoworldcoord ::=

st_rastertoworldcoord ::=
    ST_RASTERTOWORLDCOORD ( rast , xcolumn, yrow )

参数

rast

raster 类型

xcolumn

int 类型

yrow

int 类型

返回值

在给定列和行的情况下，以几何X和Y(经度和纬度)形式返回左上角。返回的X和Y以地理参考栅格的几何单位表示。列和行的编号从1开始，但如果传递给任一参数的是零、负数或大于栅格各自维度的数字，则它将返回栅格外部的坐标，假定栅格的网格适用于栅格边界之外。

示例

SELECT rid, (ST_RasterToWorldCoord(rast,1, 1)), (ST_RasterToWorldCoord(rast,2, 2)) FROM dummy_rast;
RID(int)      |ST_RASTERTOWORLDCOORD(RASTERTOWORLDCOORD)      |ST_RASTERTOWORLDCOORD(RASTERTOWORLDCOORD)      |
------------------------------------------------------------------------------------------------------------
1             |(0.5,0.5)                                      |(2.5,3.5)                                      |
------------------------------------------------------------------------------------------------------------
2             |(3427927.75,5793244)                           |(3427927.8,5793243.95)                         |
总数目：2

SELECT rid, ST_RasterToWorldCoordX(rast,1) As x1coord, ST_RasterToWorldCoordX(rast,2) As x2coord, ST_ScaleX(rast) As pixelx FROM dummy_rast;
RID(int)      |X1COORD(double precision)      |X2COORD(double precision)      |PIXELX(double precision)      |
----------------------------------------------------------------------------------------------------------
1             |0.5                            |2.5                            |2                             |
----------------------------------------------------------------------------------------------------------
2             |3427927.75                     |3427927.8                      |0.05                          |
总数目：2

SELECT rid, ST_RasterToWorldCoordY(rast,1) As y1coord, ST_RasterToWorldCoordY(rast,3) As y2coord, ST_ScaleY(rast) As pixely FROM dummy_rast;
RID(int)      |Y1COORD(double precision)      |Y2COORD(double precision)      |PIXELY(double precision)      |
----------------------------------------------------------------------------------------------------------
1             |0.5                            |6.5                            |3                             |
----------------------------------------------------------------------------------------------------------
2             |5793244                        |5793243.9                      |-0.05                         |
总数目：2

ST_RasterToWorldCoordX

ST_RasterToWorldCoordX — 返回栅格、列和行的左上角几何X坐标。列和行的编号从1开始。

语法

st_rastertoworldcoordx ::=

st_rastertoworldcoordx ::=
    ST_RASTERTOWORLDCOORDX ( rast, xcolumn | rast, xcolumn, yrow )

参数

rast

raster 类型

xcolumn

int 类型

yrow

int 类型

返回值

以地理参考栅格的几何单位返回栅格列行的左上角X坐标。列数和行数从1开始，但如果传入的是负数或大于栅格中列数的数值，则会在假定倾斜和像素大小与所选栅格相同的情况下，将栅格文件外部的坐标向左或向右提供。

示例

SELECT rid, (ST_RasterToWorldCoord(rast,1, 1)), (ST_RasterToWorldCoord(rast,2, 2)) FROM dummy_rast;
RID(int)      |ST_RASTERTOWORLDCOORD(RASTERTOWORLDCOORD)      |ST_RASTERTOWORLDCOORD(RASTERTOWORLDCOORD)      |
------------------------------------------------------------------------------------------------------------
1             |(0.5,0.5)                                      |(2.5,3.5)                                      |
------------------------------------------------------------------------------------------------------------
2             |(3427927.75,5793244)                           |(3427927.8,5793243.95)                         |
总数目：2

SELECT rid, ST_RasterToWorldCoordX(rast,1) As x1coord, ST_RasterToWorldCoordX(rast,2) As x2coord, ST_ScaleX(rast) As pixelx FROM dummy_rast;
RID(int)      |X1COORD(double precision)      |X2COORD(double precision)      |PIXELX(double precision)      |
----------------------------------------------------------------------------------------------------------
1             |0.5                            |2.5                            |2                             |
----------------------------------------------------------------------------------------------------------
2             |3427927.75                     |3427927.8                      |0.05                          |
总数目：2

SELECT rid, ST_RasterToWorldCoordY(rast,1) As y1coord, ST_RasterToWorldCoordY(rast,3) As y2coord, ST_ScaleY(rast) As pixely FROM dummy_rast;
RID(int)      |Y1COORD(double precision)      |Y2COORD(double precision)      |PIXELY(double precision)      |
----------------------------------------------------------------------------------------------------------
1             |0.5                            |6.5                            |3                             |
----------------------------------------------------------------------------------------------------------
2             |5793244                        |5793243.9                      |-0.05                         |
总数目：2

ST_RasterToWorldCoordY

ST_RasterToWorldCoordY — 返回栅格、列和行的几何Y坐标左上角。列和行的编号从1开始。

语法

st_rastertoworldcoordy ::=

st_rastertoworldcoordy ::=
    ST_RASTERTOWORLDCOORDY ( rast, xcolumn | rast, xcolumn, yrow )

参数

rast

raster 类型

xcolumn

int 类型

yrow

int 类型

返回值

以地理参考栅格的几何单位返回栅格列行的左上角Y坐标。列数和行数从1开始，但如果传入的是负数或大于栅格中的列数/行数的数，则会在假定倾斜和像素大小与选定的栅格平铺相同的情况下，将栅格文件外部的坐标向左或向右提供。

示例

SELECT rid, (ST_RasterToWorldCoord(rast,1, 1)), (ST_RasterToWorldCoord(rast,2, 2)) FROM dummy_rast;
RID(int)      |ST_RASTERTOWORLDCOORD(RASTERTOWORLDCOORD)      |ST_RASTERTOWORLDCOORD(RASTERTOWORLDCOORD)      |
------------------------------------------------------------------------------------------------------------
1             |(0.5,0.5)                                      |(2.5,3.5)                                      |
------------------------------------------------------------------------------------------------------------
2             |(3427927.75,5793244)                           |(3427927.8,5793243.95)                         |
总数目：2

SELECT rid, ST_RasterToWorldCoordX(rast,1) As x1coord, ST_RasterToWorldCoordX(rast,2) As x2coord, ST_ScaleX(rast) As pixelx FROM dummy_rast;
RID(int)      |X1COORD(double precision)      |X2COORD(double precision)      |PIXELX(double precision)      |
----------------------------------------------------------------------------------------------------------
1             |0.5                            |2.5                            |2                             |
----------------------------------------------------------------------------------------------------------
2             |3427927.75                     |3427927.8                      |0.05                          |
总数目：2

SELECT rid, ST_RasterToWorldCoordY(rast,1) As y1coord, ST_RasterToWorldCoordY(rast,3) As y2coord, ST_ScaleY(rast) As pixely FROM dummy_rast;
RID(int)      |Y1COORD(double precision)      |Y2COORD(double precision)      |PIXELY(double precision)      |
----------------------------------------------------------------------------------------------------------
1             |0.5                            |6.5                            |3                             |
----------------------------------------------------------------------------------------------------------
2             |5793244                        |5793243.9                      |-0.05                         |
总数目：2

ST_Rotation

ST_Rotation — 返回栅格以弧度为单位的旋转。

语法

st_rotation ::=

st_rotation ::=
    ST_ROTATION ( rast )

参数

rast

raster 类型

返回值

返回栅格以弧度为单位的均匀旋转。如果栅格没有均匀旋转，则返回NaN。

示例

SELECT rid, ST_Rotation(ST_SetScale(ST_SetSkew(rast, sqrt(2)), sqrt(2))) as rot FROM dummy_rast;
RID(int)      |ROT(double precision)      |
-----------------------------------------
1             |-0.785398163397448         |
-----------------------------------------
2             |-0.785398163397448         |
总数目：2

SELECT rid, ST_SkewX(rast) As skewx, ST_SkewY(rast) As skewy, ST_GeoReference(rast) as georef FROM dummy_rast;
RID(int)      |SKEWX(double precision)      |SKEWY(double precision)      |GEOREF(text)      |
------------------------------------------------------------------------------------------
1             |0                            |0                            |2
0
0
3
0.5
0.5
  |
------------------------------------------------------------------------------------------
2             |0                            |0                            |0.05
0
0
-0.05
342|
              |                             |                             |7927.75
5793244
  |
总数目：2

SELECT ST_SRID(rast) As srid FROM dummy_rast;
SRID(int)      |
---------------
0              |
---------------
0              |
总数目：2

ST_SkewX

ST_SkewX — 返回地理参考X倾斜(或旋转参数)。

语法

st_skewx ::=

st_skewx ::=
    ST_SKEWX ( rast )

参数

rast

raster 类型

返回值

返回地理参考X倾斜(或旋转参数)。

示例

SELECT rid, ST_Rotation(ST_SetScale(ST_SetSkew(rast, sqrt(2)), sqrt(2))) as rot FROM dummy_rast;
RID(int)      |ROT(double precision)      |
-----------------------------------------
1             |-0.785398163397448         |
-----------------------------------------
2             |-0.785398163397448         |
总数目：2

SELECT rid, ST_SkewX(rast) As skewx, ST_SkewY(rast) As skewy, ST_GeoReference(rast) as georef FROM dummy_rast;
RID(int)      |SKEWX(double precision)      |SKEWY(double precision)      |GEOREF(text)      |
------------------------------------------------------------------------------------------
1             |0                            |0                            |2
0
0
3
0.5
0.5
  |
------------------------------------------------------------------------------------------
2             |0                            |0                            |0.05
0
0
-0.05
342|
              |                             |                             |7927.75
5793244
  |
总数目：2

SELECT ST_SRID(rast) As srid FROM dummy_rast;
SRID(int)      |
---------------
0              |
---------------
0              |
总数目：2

ST_SkewY

ST_SkewY — 返回地理参考Y倾斜(或旋转参数)。

语法

st_skewy ::=

st_skewy ::=
    ST_SKEWY ( rast )

参数

rast

raster 类型

返回值

返回地理参考Y倾斜(或旋转参数)。

示例

SELECT rid, ST_Rotation(ST_SetScale(ST_SetSkew(rast, sqrt(2)), sqrt(2))) as rot FROM dummy_rast;
RID(int)      |ROT(double precision)      |
-----------------------------------------
1             |-0.785398163397448         |
-----------------------------------------
2             |-0.785398163397448         |
总数目：2

SELECT rid, ST_SkewX(rast) As skewx, ST_SkewY(rast) As skewy, ST_GeoReference(rast) as georef FROM dummy_rast;
RID(int)      |SKEWX(double precision)      |SKEWY(double precision)      |GEOREF(text)      |
------------------------------------------------------------------------------------------
1             |0                            |0                            |2
0
0
3
0.5
0.5
  |
------------------------------------------------------------------------------------------
2             |0                            |0                            |0.05
0
0
-0.05
342|
              |                             |                             |7927.75
5793244
  |
总数目：2

SELECT ST_SRID(rast) As srid FROM dummy_rast;
SRID(int)      |
---------------
0              |
---------------
0              |
总数目：2

ST_SRID

ST_SRID — 返回在SPATIAL_REF_SYS表中定义的栅格的空间参考标识符。

语法

st_srid ::=

st_srid ::=
    ST_SRID ( rast )

参数

rast

raster 类型

返回值

返回在space_ref_sys表中定义的栅格对象的空间参考标识符。

示例

SELECT rid, ST_Rotation(ST_SetScale(ST_SetSkew(rast, sqrt(2)), sqrt(2))) as rot FROM dummy_rast;
RID(int)      |ROT(double precision)      |
-----------------------------------------
1             |-0.785398163397448         |
-----------------------------------------
2             |-0.785398163397448         |
总数目：2

SELECT rid, ST_SkewX(rast) As skewx, ST_SkewY(rast) As skewy, ST_GeoReference(rast) as georef FROM dummy_rast;
RID(int)      |SKEWX(double precision)      |SKEWY(double precision)      |GEOREF(text)      |
------------------------------------------------------------------------------------------
1             |0                            |0                            |2
0
0
3
0.5
0.5
  |
------------------------------------------------------------------------------------------
2             |0                            |0                            |0.05
0
0
-0.05
342|
              |                             |                             |7927.75
5793244
  |
总数目：2

SELECT ST_SRID(rast) As srid FROM dummy_rast;
SRID(int)      |
---------------
0              |
---------------
0              |
总数目：2

ST_Summary

ST_Summary — 返回栅格内容的文本摘要。

语法

st_summary ::=

st_summary ::=
    ST_SUMMARY ( rast )

参数

rast

raster 类型

返回值

返回栅格内容的文本摘要。

示例

SELECT ST_Summary(
ST_AddBand(
ST_AddBand(
ST_AddBand(
ST_MakeEmptyRaster(10, 10, 0, 0, 1, -1, 0, 0, 0)
, 1, '8BUI', 1, 0)
, 2, '32BF', 0, -9999)
, 3, '16BSI', 0, NULL)
);
ST_SUMMARY(text)      |
----------------------
Raster of 10x10 pixels|
 has 3 bands and exte|
nt of BOX(0 -10,10 0)|
\n    band 1 of pixty|
pe 8BUI is in-db with|
 NODATA value of 0\n |
   band 2 of pixtype |
32BF is in-db with NO|
DATA value of -9999\n|
    band 3 of pixtype|
 16BSI is in-db with |
no NODATA value       |
总数目：1

ST_UpperLeftX

ST_UpperLeftX — 返回投影空间参考中栅格的左上角X坐标。

语法

st_upperleftx ::=

st_upperleftx ::=
    ST_UPPERLEFTX ( rast )

参数

rast

raster 类型

返回值

返回投影空间参考中栅格的左上角Y坐标。

示例

SELECt rid, ST_UpperLeftX(rast) As ulx FROM dummy_rast;
RID(int)      |ULX(double precision)      |
-----------------------------------------
1             |0.5                        |
-----------------------------------------
2             |3427927.75                 |
总数目：2

SELECT rid, ST_UpperLeftY(rast) As uly FROM dummy_rast;
RID(int)      |ULY(double precision)      |
-----------------------------------------
1             |0.5                        |
-----------------------------------------
2             |5793244                    |
总数目：2

SELECT ST_Width(rast) As rastwidth FROM dummy_rast;
RASTWIDTH(int)      |
--------------------
10                  |
--------------------
5                   |
总数目：2

ST_UpperLeftY

ST_UpperLeftY — 返回投影空间参考中栅格的左上角Y坐标。

语法

st_upperlefty ::=

st_upperlefty ::=
    ST_UPPERLEFTY ( rast )

参数

rast

raster 类型

返回值

返回投影空间参考中栅格的左上角Y坐标。

示例

SELECt rid, ST_UpperLeftX(rast) As ulx FROM dummy_rast;
RID(int)      |ULX(double precision)      |
-----------------------------------------
1             |0.5                        |
-----------------------------------------
2             |3427927.75                 |
总数目：2

SELECT rid, ST_UpperLeftY(rast) As uly FROM dummy_rast;
RID(int)      |ULY(double precision)      |
-----------------------------------------
1             |0.5                        |
-----------------------------------------
2             |5793244                    |
总数目：2

SELECT ST_Width(rast) As rastwidth FROM dummy_rast;
RASTWIDTH(int)      |
--------------------
10                  |
--------------------
5                   |
总数目：2

ST_Width

ST_Width — 返回以像素为单位的栅格宽度

语法

st_width ::=

st_width ::=
    ST_WIDTH ( rast )

参数

rast

raster 类型

返回值

返回以像素为单位的栅格宽度。

示例

SELECt rid, ST_UpperLeftX(rast) As ulx FROM dummy_rast;
RID(int)      |ULX(double precision)      |
-----------------------------------------
1             |0.5                        |
-----------------------------------------
2             |3427927.75                 |
总数目：2

SELECT rid, ST_UpperLeftY(rast) As uly FROM dummy_rast;
RID(int)      |ULY(double precision)      |
-----------------------------------------
1             |0.5                        |
-----------------------------------------
2             |5793244                    |
总数目：2

SELECT ST_Width(rast) As rastwidth FROM dummy_rast;
RASTWIDTH(int)      |
--------------------
10                  |
--------------------
5                   |
总数目：2

ST_WorldToRasterCoord

ST_WorldToRasterCoord — 在给定几何X和Y(经度和纬度)或以栅格的空间参考坐标系表示的点几何图形的情况下，将左上角返回为列和行。

语法

st_worldtorastercoord ::=

st_worldtorastercoord ::=
    ST_WORLDTORASTERCOORD ( rast, pt | rast, longitude, latitude )

参数

rast

raster 类型

pt

geometry 类型

longitude

float8 类型

latitude

float8 类型

返回值

在给定几何X和Y(经度和纬度)或点几何图形的情况下，将左上角作为列和行返回。无论几何X和Y几何图形或点几何图形是否在栅格范围之外，此函数都有效。几何X和Y必须在栅格的空间参考坐标系中表示。

示例

SELECT rid, (ST_WorldToRasterCoord(rast,3427927.8,20.5)), (ST_WorldToRasterCoord(rast,ST_GeomFromText('POINT(3427927.8 20.5)',ST_SRID(rast)))) FROM dummy_rast order by rid, (ST_WorldToRasterCoord(rast,3427927.8,20.5));
RID(int)      |ST_WORLDTORASTERCOORD(WORLDTORASTERCOORD)      |ST_WORLDTORASTERCOORD(WORLDTORASTERCOORD)      |
------------------------------------------------------------------------------------------------------------
1             |(1713964,7)                                    |(1713964,7)                                    |
------------------------------------------------------------------------------------------------------------
2             |(2,115864471)                                  |(2,115864471)                                  |
总数目：2


SELECT rid, ST_WorldToRasterCoordX(rast,3427927.8) As xcoord,
ST_WorldToRasterCoordX(rast,3427927.8,20.5) As xcoord_xwyw,
ST_WorldToRasterCoordX(rast,ST_GeomFromText('POINT(3427927.8 20.5)',ST_SRID(rast))) As ptxcoord
FROM dummy_rast;
RID(int)      |XCOORD(int)      |XCOORD_XWYW(int)      |PTXCOORD(int)      |
------------------------------------------------------------------------
1             |1713964          |1713964               |1713964            |
------------------------------------------------------------------------
2             |2                |2                     |2                  |
总数目：2


SELECT rid, ST_WorldToRasterCoordY(rast,20.5) As ycoord, ST_WorldToRasterCoordY(rast,3427927.8,20.5) As ycoord_xwyw,
ST_WorldToRasterCoordY(rast,ST_GeomFromText('POINT(3427927.8 20.5)',ST_SRID(rast))) As ptycoord FROM dummy_rast;
RID(int)      |YCOORD(int)      |YCOORD_XWYW(int)      |PTYCOORD(int)      |
------------------------------------------------------------------------
1             |7                |7                     |7                  |
------------------------------------------------------------------------
2             |115864471        |115864471             |115864471          |
总数目：2

ST_WorldToRasterCoordX

ST_WorldToRasterCoordX — 返回点几何图形的栅格中的列(Pt)或在栅格的世界空间参考系中表示的X和Y世界坐标(xw，yw)。

语法

st_worldtorastercoordx ::=

st_worldtorastercoordx ::=
    ST_WORLDTORASTERCOORDX ( rast, pt | rast, xw | rast, xw, yw )

参数

rast

raster 类型

pt

geometry 类型

xw

float8 类型

yw

float8 类型

返回值

返回点几何图形的栅格中的列(Pt)或X和Y世界坐标(xw，yw)。点，或(如果栅格倾斜，则需要xw和yw世界坐标)。如果栅格没有倾斜，那么XW就足够了。世界坐标位于栅格的空间参考坐标系中。

示例

SELECT rid, (ST_WorldToRasterCoord(rast,3427927.8,20.5)), (ST_WorldToRasterCoord(rast,ST_GeomFromText('POINT(3427927.8 20.5)',ST_SRID(rast)))) FROM dummy_rast order by rid, (ST_WorldToRasterCoord(rast,3427927.8,20.5));
RID(int)      |ST_WORLDTORASTERCOORD(WORLDTORASTERCOORD)      |ST_WORLDTORASTERCOORD(WORLDTORASTERCOORD)      |
------------------------------------------------------------------------------------------------------------
1             |(1713964,7)                                    |(1713964,7)                                    |
------------------------------------------------------------------------------------------------------------
2             |(2,115864471)                                  |(2,115864471)                                  |
总数目：2


SELECT rid, ST_WorldToRasterCoordX(rast,3427927.8) As xcoord,
ST_WorldToRasterCoordX(rast,3427927.8,20.5) As xcoord_xwyw,
ST_WorldToRasterCoordX(rast,ST_GeomFromText('POINT(3427927.8 20.5)',ST_SRID(rast))) As ptxcoord
FROM dummy_rast;
RID(int)      |XCOORD(int)      |XCOORD_XWYW(int)      |PTXCOORD(int)      |
------------------------------------------------------------------------
1             |1713964          |1713964               |1713964            |
------------------------------------------------------------------------
2             |2                |2                     |2                  |
总数目：2


SELECT rid, ST_WorldToRasterCoordY(rast,20.5) As ycoord, ST_WorldToRasterCoordY(rast,3427927.8,20.5) As ycoord_xwyw,
ST_WorldToRasterCoordY(rast,ST_GeomFromText('POINT(3427927.8 20.5)',ST_SRID(rast))) As ptycoord FROM dummy_rast;
RID(int)      |YCOORD(int)      |YCOORD_XWYW(int)      |PTYCOORD(int)      |
------------------------------------------------------------------------
1             |7                |7                     |7                  |
------------------------------------------------------------------------
2             |115864471        |115864471             |115864471          |
总数目：2

ST_WorldToRasterCoordY

ST_WorldToRasterCoordY — 返回点几何图形的栅格中的行(Pt)或在栅格的世界空间参考系中表示的X和Y世界坐标(xw，yw)。

语法

st_worldtorastercoordy ::=

st_worldtorastercoordy ::=
    ST_WORLDTORASTERCOORDY ( rast, pt | rast, xw | rast, xw, yw )

参数

rast

raster 类型

pt

geometry 类型

xw

float8 类型

yw

float8 类型

返回值

返回点几何图形的栅格中的行(Pt)或X和Y世界坐标(xw，yw)。点，或(如果栅格倾斜，则需要xw和yw世界坐标)。如果栅格没有倾斜，那么XW就足够了。世界坐标位于栅格的空间参考坐标系中。

示例

SELECT rid, (ST_WorldToRasterCoord(rast,3427927.8,20.5)), (ST_WorldToRasterCoord(rast,ST_GeomFromText('POINT(3427927.8 20.5)',ST_SRID(rast)))) FROM dummy_rast order by rid, (ST_WorldToRasterCoord(rast,3427927.8,20.5));
RID(int)      |ST_WORLDTORASTERCOORD(WORLDTORASTERCOORD)      |ST_WORLDTORASTERCOORD(WORLDTORASTERCOORD)      |
------------------------------------------------------------------------------------------------------------
1             |(1713964,7)                                    |(1713964,7)                                    |
------------------------------------------------------------------------------------------------------------
2             |(2,115864471)                                  |(2,115864471)                                  |
总数目：2


SELECT rid, ST_WorldToRasterCoordX(rast,3427927.8) As xcoord,
ST_WorldToRasterCoordX(rast,3427927.8,20.5) As xcoord_xwyw,
ST_WorldToRasterCoordX(rast,ST_GeomFromText('POINT(3427927.8 20.5)',ST_SRID(rast))) As ptxcoord
FROM dummy_rast;
RID(int)      |XCOORD(int)      |XCOORD_XWYW(int)      |PTXCOORD(int)      |
------------------------------------------------------------------------
1             |1713964          |1713964               |1713964            |
------------------------------------------------------------------------
2             |2                |2                     |2                  |
总数目：2


SELECT rid, ST_WorldToRasterCoordY(rast,20.5) As ycoord, ST_WorldToRasterCoordY(rast,3427927.8,20.5) As ycoord_xwyw,
ST_WorldToRasterCoordY(rast,ST_GeomFromText('POINT(3427927.8 20.5)',ST_SRID(rast))) As ptycoord FROM dummy_rast;
RID(int)      |YCOORD(int)      |YCOORD_XWYW(int)      |PTYCOORD(int)      |
------------------------------------------------------------------------
1             |7                |7                     |7                  |
------------------------------------------------------------------------
2             |115864471        |115864471             |115864471          |
总数目：2