ST_MPointFromText

Note:

ST_Geometry for Oracle only

Definition

ST_MPointFromText takes a well-known text (WKT) representation of type ST_MultiPoint and a spatial reference ID and creates an ST_Multipoint.

Syntax

sde.st_mpointfromtext (wkt clob, srid integer)

Return type

ST_MultiPoint

Example

The multipoint_test table is created with the single ST_MultiPoint mpt1 column.

CREATE TABLE multipoint_test (mpt1 sde.st_geometry);

The INSERT statement inserts a multipoint into the mpt1 column using the ST_MpointFromText function.

INSERT INTO MULTIPOINT_TEST VALUES (
sde.st_mpointfromtext ('multipoint (10.01 20.03, 10.52 40.11, 30.29 41.56,
31.78 10.74)', 0));