PostGIS

ST_MPointFromText

Prev

8.8.1. Well-Known Text (WKT)

Next

Name

ST_MPointFromText — Makes a Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0.

Synopsis

+geometry +ST_MPointFromText(+`text `+WKT, integer srid`)`;

+geometry +ST_MPointFromText(+`text `+WKT`)`;

Description

Makes a Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0.

OGC SPEC 3.2.6.2 - option SRID is from the conformance suite

Returns null if the WKT is not a MULTIPOINT

Note

If you are absolutely sure all your WKT geometries are points, don’t use this function. It is slower than ST_GeomFromText since it adds an additional validation step.

check This method implements the SQL/MM specification. SQL-MM 3: 9.2.4

Examples

SELECT ST_MPointFromText('MULTIPOINT((1 2),(3 4))');
SELECT ST_MPointFromText('MULTIPOINT((-70.9590 42.1180),(-70.9611 42.1223))', 4326);

See Also

Prev

Up

Next

ST_MLineFromText

Home

ST_MPolyFromText