ST_PointFromText

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

Function	Syntax
Python	`point_from_text(wkt,sr=None)`
SQL	`ST_PointFromText(wkt,sr)`

For more details, go to the GeoAnalytics Engine API reference for point_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

df = spark.createDataFrame([('POINT (-72.047 -49.292)',)], ["wkt"])

df.select(ST.point_from_text("wkt", srid=4326).alias("point_from_text")).show(truncate=False)

Result
Use dark colors for code blocksCopy
+-------------------------+
|point_from_text          |
+-------------------------+
|{"x":-72.047,"y":-49.292}|
+-------------------------+

Version table

Release	Notes
1.0.0	Function introduced

ST_PointFromText

Examples

Version table

Related topics