ArcGIS Server Banner

ST_MultiSurface

ST_MultiSurface

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

NOTE: Spatial type for Oracle only

Definition

ST_MultiSurface constructs a multisurface feature from a well-known text representation.

Syntax

sde.st_multisurface (wkt clob, srid integer)

Return type

ST_MultiSurface

Example

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

INSERT INTO msurf_test VALUES (
1110,
sde.st_multisurface ('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_SURFACE
FROM msurf_test
WHERE id = 1110; 

     ID    MULTI_SURFACE

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

See Also

  • An overview of SQL functions used with ST_Geometry types