Name

ST_FromGDALRaster — 从受支持的 GDAL 栅格文件返回栅格。

Synopsis

raster ST_FromGDALRaster(bytea gdaldata, integer srid=NULL);

描述

从受支持的 GDAL 栅格文件返回栅格。 gdaldata 是 bytea 类型,应该是 GDAL 栅格文件的内容。

如果 srid 为 NULL,该函数将尝试自动从 GDAL 栅格分配 SRID。 如果提供了 srid,则提供的值将覆盖任何自动分配的 SRID。

可用性:2.1.0

示例

WITH foo AS (
    SELECT ST_AsPNG(ST_AddBand(ST_AddBand(ST_AddBand(ST_MakeEmptyRaster(2, 2, 0, 0, 0.1, -0.1, 0, 0, 4326), 1, '8BUI', 1, 0), 2, '8BUI', 2, 0), 3, '8BUI', 3, 0)) AS png
),
bar AS (
    SELECT 1 AS rid, ST_FromGDALRaster(png) AS rast FROM foo
    UNION ALL
    SELECT 2 AS rid, ST_FromGDALRaster(png, 3310) AS rast FROM foo
)
SELECT
    rid,
    ST_Metadata(rast) AS metadata,
    ST_SummaryStats(rast, 1) AS stats1,
    ST_SummaryStats(rast, 2) AS stats2,
    ST_SummaryStats(rast, 3) AS stats3
FROM bar
ORDER BY rid;

 rid |         metadata          |    stats1     |    stats2     |     stats3
-----+---------------------------+---------------+---------------+----------------
   1 | (0,0,2,2,1,-1,0,0,0,3)    | (4,4,1,0,1,1) | (4,8,2,0,2,2) | (4,12,3,0,3,3)
   2 | (0,0,2,2,1,-1,0,0,3310,3) | (4,4,1,0,1,1) | (4,8,2,0,2,2) | (4,12,3,0,3,3)
(2 rows)
                

相关信息

ST_AsGDALRaster