ST_MultiPolygon

Definición

ST_MultiPolygon construye una entidad de multipolígono de una representación de texto conocida.

Sintaxis

Oracle

sde.st_multipolygon (wkt clob, srid integer)

PostgreSQL

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

Tipo de devolución

ST_MultiPolygon

Ejemplo

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

3/6/2012