PostGIS常用语句备忘
目录
查询栅格数据的坐标系
select st_srid(rast) from raster_table_name
导出指定地理范围的tiff
SELECT ST_AsTIFF(rast, 'LZW') FROM ( SELECT ST_Union(ST_Clip(rast,geom)) AS rast FROM sjy CROSS JOIN (select geom from xingzheng where gid = '24') As geom WHERE ST_Intersects(rast,geom) ) AS rasttiff;
栅格统计
转载自：https://blog.csdn.net/weixin_34197488/article/details/87275201
