Name
ST_MPointFromText — Constructs a MultiPoint object given its Well-known text Representation
Synopsis
geometry ST_MPointFromText(varchar WKT);
geometry ST_MPointFromText(varchar WKT, integer
SRID);
Description
Constructs a MultiPoint object given its Well-known text Representation. If the SRID is not provided it defaults to -1.
Returns Null when the WKT is not a MultiPoint or MultiPointM.
Coordinate Dimensions
| 2D | 3D | M |
|---|---|---|
 | | |
Spatial Standards Support
| OGC SFS for SQL. 1.1 (1999) | OGC SFS for SQL. 1.1.0 (2005) | OGC SFS for SQL. 1.2.0 (2006) | SQL-MM Part 3 |
|---|---|---|---|
| 3.2.6.2 | 7.2.6.1 | - | 9.2.4 |
Examples
SELECT ST_Asewkt(ST_MPointFromText('MULTIPOINT(5 5 10, 8 10 15, 12 10 20)'));
--Result
MULTIPOINT (5 5 10, 8 10 15, 12 10 20)
--Returns the EWKT Representation of a 4D MultiLineString.
SELECT ST_Asewkt(MPointFromText('MULTIPOINT(5 5 10 -20, 8 10 15 -4, 12 10 20 -6)',25830));
--Result
SRID=25830;MULTIPOINT (5 5 10 -20, 8 10 15 -4, 12 10 20 -6)