ST_PolyFromText

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

Function	Syntax
Python	`poly_from_text(wkt,sr=None)`
SQL	`ST_PolyFromText(wkt,sr)`

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

polygon_text = 'POLYGON ((-117.271 34.059, -117.225 33.919, -116.963 33.662, -116.668 33.712))'

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

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

Result
Use dark colors for code blocksCopy
+-------------------------------------------------------------------------------------------------------+
|poly_from_text                                                                                         |
+-------------------------------------------------------------------------------------------------------+
|{"rings":[[[-117.271,34.059],[-116.668,33.712],[-116.963,33.662],[-117.225,33.919],[-117.271,34.059]]]}|
+-------------------------------------------------------------------------------------------------------+

Version table

Release	Notes
1.0.0	Function introduced

ST_PolyFromText

Examples

Version table

Related topics