描述

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

	对于无倾斜的栅格，提供Y列就足够了。对于倾斜栅格，地理参考坐标是ST_scaley和ST_skewy以及行和列的函数。如果只为倾斜的栅格提供Y行，则会引发错误。

已更改：2.1.0在以前的版本中，这称为ST_Raster2WorldCoordY

示例

-- non-skewed raster providing row is sufficient
SELECT rid, ST_RasterToWorldCoordY(rast,1) As y1coord,
    ST_RasterToWorldCoordY(rast,3) As y2coord,
    ST_ScaleY(rast) As pixely
FROM dummy_rast;

 rid | y1coord |  y2coord  | pixely
-----+---------+-----------+--------
   1 |     0.5 |       6.5 |      3
   2 | 5793244 | 5793243.9 |  -0.05
                

-- for fun lets skew it
SELECT rid, ST_RasterToWorldCoordY(rast,1,1) As y1coord,
    ST_RasterToWorldCoordY(rast,2,3) As y2coord,
    ST_ScaleY(rast) As pixely
FROM (SELECT rid, ST_SetSkew(rast,0,100.5) As rast FROM dummy_rast) As foo;

 rid | y1coord |  y2coord  | pixely
-----+---------+-----------+--------
   1 |     0.5 |       107 |      3
   2 | 5793244 | 5793344.4 |  -0.05
                

另请参阅

ST_ScaleY, ST_RasterToWorldCoordX, ST_SetSkew, ST_SkewY