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...