spatial.wktToGeoJson

函数

将 WKT 转换为 GeoJson 结构

签名

spatial.wktToGeoJson(wkt :: STRING) :: ANY

输入参数

名称	类型	默认	描述
WKT	STRING	null	WKT 字符串

名称

类型

默认

描述

WKT

STRING

null

WKT 字符串

示例

1. 将 WKT POINT 转换

RETURN spatial.wktToGeoJson('POINT (30 10)') as json

表 1. 结果
json
`{ "coordinates" : [ 30.0, 10.0 ], "type" : "Point" }`

2. 将 WKT LINESTRING 转换

RETURN spatial.wktToGeoJson('LINESTRING (30 10, 10 30, 40 40)') as json

表 2. 结果
json
`{ "coordinates" : [ [ 30.0, 10.0 ], [ 10.0, 30.0 ], [ 40.0, 40.0 ] ], "type" : "LineString" }`

3. 将 WKT POLYGON 转换

RETURN spatial.wktToGeoJson('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))') as json

表 3. 结果
json
`{ "coordinates" : [ [ [ 30.0, 10.0 ], [ 40.0, 40.0 ], [ 20.0, 40.0 ], [ 10.0, 20.0 ], [ 30.0, 10.0 ] ] ], "type" : "Polygon" }`

4. 将带孔的 WKT POLYGON 转换

RETURN spatial.wktToGeoJson('POLYGON ((35 10, 45 45, 15 40, 10 20, 35 10), (20 30, 35 35, 30 20, 20 30))') as json

表 4. 结果
json
`{ "coordinates" : [ [ [ 35.0, 10.0 ], [ 45.0, 45.0 ], [ 15.0, 40.0 ], [ 10.0, 20.0 ], [ 35.0, 10.0 ] ], [ [ 20.0, 30.0 ], [ 35.0, 35.0 ], [ 30.0, 20.0 ], [ 20.0, 30.0 ] ] ], "type" : "Polygon" }`

5a. 将 WKT MULTIPOINT 转换

RETURN spatial.wktToGeoJson('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))') as json

表 5. 结果
json
`{ "coordinates" : [ [ 10.0, 40.0 ], [ 40.0, 30.0 ], [ 20.0, 20.0 ], [ 30.0, 10.0 ] ], "type" : "MultiPoint" }`

5b. 将 WKT MULTIPOINT 转换

RETURN spatial.wktToGeoJson('MULTIPOINT (10 40, 40 30, 20 20, 30 10)') as json

表 6. 结果
json
`{ "coordinates" : [ [ 10.0, 40.0 ], [ 40.0, 30.0 ], [ 20.0, 20.0 ], [ 30.0, 10.0 ] ], "type" : "MultiPoint" }`

6. 将 WKT MULTILINESTRING 转换

RETURN spatial.wktToGeoJson('MULTILINESTRING ((10 10, 20 20, 10 40), (40 40, 30 30, 40 20, 30 10))') as json

表 7. 结果
json
`{ "coordinates" : [ [ [ 10.0, 10.0 ], [ 20.0, 20.0 ], [ 10.0, 40.0 ] ], [ [ 40.0, 40.0 ], [ 30.0, 30.0 ], [ 40.0, 20.0 ], [ 30.0, 10.0 ] ] ], "type" : "MultiLineString" }`

7a. 将 WKT MULTIPOLYGON 转换

RETURN spatial.wktToGeoJson('MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)), ((15 5, 40 10, 10 20, 5 10, 15 5)))') as json

json

表 8. 结果
json
`{ "coordinates" : [ [ [ [ 30.0, 20.0 ], [ 45.0, 40.0 ], [ 10.0, 40.0 ], [ 30.0, 20.0 ] ] ], [ [ [ 15.0, 5.0 ], [ 40.0, 10.0 ], [ 10.0, 20.0 ], [ 5.0, 10.0 ], [ 15.0, 5.0 ] ] ] ], "type" : "MultiPolygon" }`

{
  "coordinates" : [ [ [ [ 30.0, 20.0 ], [ 45.0, 40.0 ], [ 10.0, 40.0 ], [ 30.0, 20.0 ] ] ], [ [ [ 15.0, 5.0 ], [ 40.0, 10.0 ], [ 10.0, 20.0 ], [ 5.0, 10.0 ], [ 15.0, 5.0 ] ] ] ],
  "type" : "MultiPolygon"
}

7b. 将 WKT MULTIPOLYGON 转换

RETURN spatial.wktToGeoJson('MULTIPOLYGON (((40 40, 20 45, 45 30, 40 40)), ((20 35, 10 30, 10 10, 30 5, 45 20, 20 35), (30 20, 20 15, 20 25, 30 20)))') as json

json

表 9. 结果
json
`{ "coordinates" : [ [ [ [ 40.0, 40.0 ], [ 20.0, 45.0 ], [ 45.0, 30.0 ], [ 40.0, 40.0 ] ] ], [ [ [ 20.0, 35.0 ], [ 10.0, 30.0 ], [ 10.0, 10.0 ], [ 30.0, 5.0 ], [ 45.0, 20.0 ], [ 20.0, 35.0 ] ], [ [ 30.0, 20.0 ], [ 20.0, 15.0 ], [ 20.0, 25.0 ], [ 30.0, 20.0 ] ] ] ], "type" : "MultiPolygon" }`

{
  "coordinates" : [ [ [ [ 40.0, 40.0 ], [ 20.0, 45.0 ], [ 45.0, 30.0 ], [ 40.0, 40.0 ] ] ], [ [ [ 20.0, 35.0 ], [ 10.0, 30.0 ], [ 10.0, 10.0 ], [ 30.0, 5.0 ], [ 45.0, 20.0 ], [ 20.0, 35.0 ] ], [ [ 30.0, 20.0 ], [ 20.0, 15.0 ], [ 20.0, 25.0 ], [ 30.0, 20.0 ] ] ] ],
  "type" : "MultiPolygon"
}

8. 将 WKT GEOMETRYCOLLECTION 转换

RETURN spatial.wktToGeoJson('GEOMETRYCOLLECTION (POINT (40 10), LINESTRING (10 10, 20 20, 10 40), POLYGON ((40 40, 20 45, 45 30, 40 40)))') as json

json

表 10. 结果
json
`{ "geometries" : [ { "coordinates" : [ 40.0, 10.0 ], "type" : "Point" }, { "coordinates" : [ [ 10.0, 10.0 ], [ 20.0, 20.0 ], [ 10.0, 40.0 ] ], "type" : "LineString" }, { "coordinates" : [ [ [ 40.0, 40.0 ], [ 20.0, 45.0 ], [ 45.0, 30.0 ], [ 40.0, 40.0 ] ] ], "type" : "Polygon" } ], "type" : "GeometryCollection" }`

{
  "geometries" : [ {
    "coordinates" : [ 40.0, 10.0 ],
    "type" : "Point"
  }, {
    "coordinates" : [ [ 10.0, 10.0 ], [ 20.0, 20.0 ], [ 10.0, 40.0 ] ],
    "type" : "LineString"
  }, {
    "coordinates" : [ [ [ 40.0, 40.0 ], [ 20.0, 45.0 ], [ 45.0, 30.0 ], [ 40.0, 40.0 ] ] ],
    "type" : "Polygon"
  } ],
  "type" : "GeometryCollection"
}