postgis函数

SELECT (st_union(geom)) FROM lands WHERE 1=1;

SELECT  ST_AsGeoJSON(st_transform(geom , 4326)) as geojson FROM farms WHERE 2=2 LIMIT 1;

SELECT st_asgeojson(st_envelope(ST_Union(st_transform(geom,4326))))  from xxx WHERE 1=1

 

posted @ 2017-10-26 18:13  阿愿的笔记本  阅读(155)  评论(0编辑  收藏  举报