ST_PolyFromGeoJSON

ST_PolyFromGeoJSON takes a string column and returns a polygon column. The input string column must contain the GeoJSON representation of polygon geometries. You can optionally specify a spatial reference for the result polygon column. The sr parameter value must be a valid SRID or WKT string. If a polygon cannot be created from the input string the function will return null.

Function	Syntax
Python	`poly_from_geojson(json_str,sr=None)`
SQL	`ST_PolyFromGeoJson(json_str,sr)`

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

Examples

Python

SQL

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

poly_geojson = '{"type":"Polygon","coordinates":[[[20,30],[22,35],[18,28],[20,30]]],"crs":null}'

df = spark.createDataFrame([(poly_geojson, )], ["geojson"])

df.select(ST.poly_from_geojson("geojson", sr=4326).alias("poly_from_geojson")).show(truncate=False)

Result
Use dark colors for code blocksCopy
+---------------------------------------------+
|poly_from_geojson                            |
+---------------------------------------------+
|{"rings":[[[20,30],[18,28],[22,35],[20,30]]]}|
+---------------------------------------------+

Version table

Release	Notes
1.0.0	Function introduced

ST_PolyFromGeoJSON

Examples

Version table

Related topics