ST_AsImage

将栅格对象转化为影像格式二进制流。

SELECT
    encode(
        ST_AsImage (
            rast,
            '(140.025,60.025),(69.975,-0.025)' :: box
            0,
            '0',
            'jpeg',
            '{"strength": "ratio", "quality": 70}'
        ),
        'hex'
    )
FROM
    surf_hor_metadata
WHERE
    ele = 'PRE'

评论