ST_MultiPolygon

定义

ST_MultiPolygon 通过熟知文本表示构造多面要素。

语法

Oracle

sde.st_multipolygon (wkt clob, srid integer)

PostgreSQL

sde.st_multipolygon (wkt, srid integer)
sde.st_multipolygon (esri_shape bytea, srid integer)

返回类型

ST_MultiPolygon

示例

Oracle

CREATE TABLE mpoly_test (id integer, geometry sde.st_geometry);

INSERT INTO MPOLY_TEST VALUES (
1110,
sde.st_multipolygon ('multipolygon (((3 3, 4 6, 5 3, 3 3),(8 24, 9 25, 1 28, 8 24), (13 33, 7 36, 1 40, 10 43, 13 33)))', 0)
);

SELECT id, sde.st_astext (geometry) MULTI_POLYGON
FROM MPOLY_TEST
WHERE id = 1110; 

ID      MULTI_POLYGON

1110    MULTIPOLYGON (((13.00000000 33.00000000, 10.00000000 43.00000000,
        1.00000000 40.00000000, 7.00000000 36.00000000,
        13.00000000 33.00000000)),((8.00000000 24.00000000, 9.00000000 
        25.00000000, 1.00000000 28.0000000, 8.00000000 24.00000000)),
        ((3.00000000 3.00000000, 5.00000000 3.00000000,
        4.00000000 6.00000000, 3.00000000 3.00000000)))

PostgreSQL

CREATE TABLE mpoly_test (id integer, geometry sde.st_geometry);

INSERT INTO mpoly_test VALUES (
1110,
sde.st_multipolygon ('multipolygon (((3 3, 4 6, 5 3, 3 3), (8 24, 9 25, 1 28, 8 24), (13 33, 7 36, 1 40, 10 43, 13 33)))', 0)
);

SELECT id, sde.st_astext (geometry) 
AS MULTI_POLYGON
FROM mpoly_test
WHERE id = 1110; 

id      multi_polygon

1110    MULTIPOLYGON (((13 33, 10 43, 1 40, 7 36, 13 33)),
((8 24, 9 25, 1 28, 8 24)), ((3 3, 5 3, 4 6, 6 6)))