ST_MultiPolygon
Definition
Mit ST_MultiPolygon wird aus einem Well-known Text-Format ein Multipolygon-Feature erstellt.
Syntax
Oracle
sde.st_multipolygon (wkt clob, srid integer)
PostgreSQL
sde.st_multipolygon (wkt, srid integer) sde.st_multipolygon (esri_shape bytea, srid integer)
Rückgabetyp
ST_MultiPolygon
Beispiel
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)))
7/10/2012