美文网首页OpenGIS开源
PostGIS常用语句备忘

PostGIS常用语句备忘

作者: 王顼 | 来源:发表于2018-12-29 15:55 被阅读30次

查询栅格数据的坐标系

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;

栅格统计

相关文章

网友评论

    本文标题:PostGIS常用语句备忘

    本文链接:https://www.haomeiwen.com/subject/cpcplqtx.html