ST_MetaData — 返回有关栅格对象的基本元数据,如像素大小、旋转(倾斜)、左上角、左下角等。
记录 ST_MetaData(
栅格 rast)
;
返回有关栅格对象的基本元数据,如像素大小、旋转(倾斜)、左上角、左下角等。返回的列:upperleftx | upperlefty | width | height | scalex | scaley | skewx | skewy | srid | numbands
SELECT rid, (foo.md).* FROM (SELECT rid, ST_MetaData(rast) As md FROM dummy_rast) As foo; rid | upperleftx | upperlefty | width | height | scalex | scaley | skewx | skewy | srid | numbands ----+------------+------------+-------+--------+--------+-----------+-------+-------+------+------- 1 | 0.5 | 0.5 | 10 | 20 | 2 | 3 | 0 | 0 | 0 | 0 2 | 3427927.75 | 5793244 | 5 | 5 | 0.05 | -0.05 | 0 | 0 | 0 | 3