ST_MetaData — 返回有关栅格对象的基本元数据,如像素大小、旋转(倾斜)、左上角、左下角等。
record
ST_MetaData
(
raster
rast
)
;
返回有关栅格对象的基本元数据,如像素大小、旋转(倾斜)、左上角、左下角等。返回的列: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 | 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