PostGIS 合并几何

PostGIS 合并几何。~~~sql SELECT

使用 PostGIS 将多个 Polygon 合并成一个 MultiPolygon

将 Geometry 和并成一个 MultiPolygon

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
SELECT
	province,
	city,
	county AS ,
	st_asgeojson ( st_multi ( ST_Union ( geom ) ), 11, 1 ) AS wkt 
FROM
	project 
WHERE
	"county" IN ( '' ) 
GROUP BY
	province,
	city,
	county
1
2
3
4
5
6
>>>
安徽省	合肥市	长丰县	{"type":"MultiPolygon","bbox":[116.97310500000,32.01819200000...
安徽省	阜阳市	太和县	{"type":"MultiPolygon","bbox":[115.38896500000,33.07625600000...
山东省	青岛市	平度市	{"type":"MultiPolygon","bbox":[119.57859700000,36.49524900000...
江苏省	淮安市	金湖县	{"type":"MultiPolygon","bbox":[118.80907300000,32.84325700000,0.00000000000...
河南省	南阳市	邓州市	{"type":"MultiPolygon","bbox":[111.69895100000,32.37915800000,0.00000000000...
Licensed under CC BY-NC-SA 4.0
Gear(夕照)的博客。记录开发、生活,以及一些不足为道的思考……