ST_MPointFromText

ST_MPointFromText takes a string column and returns a multipoint column. The string column must contain the well-known text (WKT) representation of multipoint geometries. You can optionally specify a spatial reference for the result multipoint column. The sr parameter value must be a valid SRID or WKT string.

Function	Syntax
Python	`mpoint_from_text(wkt,sr=None)`
SQL	`ST_MPointFromText(wkt,sr)`

For more details, go to the GeoAnalytics Engine API reference for mpoint_from_text.

This function implements the OpenGIS Simple Features Implementation Specification for SQL 1.2.1.

Examples

Python

SQL

Use dark colors for code blocksCopy
from geoanalytics.sql import functions as ST

mpoint_wkt = 'MULTIPOINT (-72.047 -49.292, -72.654 -49.136, -71.921 -49.124, -72.445 -49.026)'

df = spark.createDataFrame([(mpoint_wkt,)], ["wkt"])

df.select(ST.mpoint_from_text("wkt", sr=4326).alias("mpoint_from_text")).show(truncate=False)

Result
Use dark colors for code blocksCopy
+------------------------------------------------------------------------------------+
|mpoint_from_text                                                                    |
+------------------------------------------------------------------------------------+
|{"points":[[-72.047,-49.292],[-72.654,-49.136],[-71.921,-49.124],[-72.445,-49.026]]}|
+------------------------------------------------------------------------------------+

Version table

Release	Notes
1.0.0	Function introduced

ST_MPointFromText

Examples

Version table

Related topics