为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:centos7
【CPU】:
【问题描述】*:使用ST_AsGEOJSON转化multipolygon类型为geojson。转化结果不是标准的json格式。
sql语句:SELECT dmgeo. ST_AsGEOJSON(dmgeo.ST_MPolyFromText('multipolygon (((1 1, 1 2, 2 2, 2 1, 1 1)),((3 3, 3
4, 4 4, 4 3, 3 3)))' , 0));
获得的geojson数据(格式错误):
{
"type": "MultiPolygon",
"coordinates": [
[
1.000000000000000,
1.000000000000000
],
[
1.000000000000000,
2.000000000000000
],
[
2.000000000000000,
2.000000000000000
],
[
2.000000000000000,
1.000000000000000
],
[
1.000000000000000,
1.000000000000000
]
]
},
[
3.000000000000000,
3.000000000000000
],
[
3.000000000000000,
4.000000000000000
],
[
4.000000000000000,
4.000000000000000
],
[
4.000000000000000,
3.000000000000000
],
[
3.000000000000000,
3.000000000000000
]
]
}
]
}